Business Intelligence Consultant delivering analytical capabilities and visual analytics for global specialty insurance. Collaborating with business partners to enhance data - driven decision - making.
About the role
- BI Developer interpreting and analyzing datasets to provide actionable insights for business decisions. Collaborating with teams to develop data-driven strategies at Committee for Children.
Responsibilities
- Develop and maintain datasets, data models, and data visualizations to support business decisions
- Develop different data warehouse designs like star schema, snowflake schema, and dimensional modeling
- Identify data sources, definitions, and timelines appropriate for analysis
- Write, optimize and maintain complex SQL queries to support data analysis and reporting needs
- Develop and generate ad hoc reports based on stakeholder requirements to support decision making processes in various departments
- Work with Fabric to connect to various data sources such as databases, cloud storage, or APIs
- Integrate data warehouse with business intelligence tools to create reports and dashboards
- Design and build interactive reports using Power BI to present findings and identify trends to stakeholders
- Ensure data quality and integrity by identifying and resolving data issues
- Perform root cause analysis and uncover core issues using data, then assist the organization to improve
- Analyze and interpret various sources of internal data and external data sources to support business decision-making
- Design, build and maintain automated workflows using Power Automate to streamline business processes
- Identify opportunities for process improvement and develop solutions to reduce manual effort.
Requirements
- Advanced database and business applications skills: 5+ years’ experience working with relational database systems
- 5+ years’ experience performing business and financial analysis
- 3+ years’ experience working with Power BI to develop reports and dashboards
- Advanced proficiency in Power BI (Power Query M, DAX), Power Automate, Excel, SQL, and Microsoft Fabric Analytics
- Experience with ETL processes, data warehousing, subscription business models, and SaaS KPIs
- Experience with ERP systems (NetSuite preferred)
- Experience with different data warehouse designs
- Ability to prioritize tasks and manage work efficiently maintaining a high level of productivity
- Demonstrated ability to navigate and articulate the workflow between data warehousing, data transformation, and reporting tools to ensure accuracy and relevance of insights generated
- Experience working independently and in a team-oriented, collaborative environment
- Strong critical thinking, analytical, and problem-solving skills
- Sound decision making, discretion, and confidentiality.
Benefits
- We cover 100% of your premiums for medical, dental and vision coverage and 50% for your dependent’s medical and dental premiums
- Retirement plan + company match up to 3%; CFC also may make an annual discretionary non-elective contribution on your behalf at the end of the year!
- A flexible work subsidy: $100 per month that you can use on things like phone and internet costs, office supplies, or even commuting costs
- 16 paid holidays (including winter break and 1 floating holiday), 3 weeks' vacation in your first year, and separate sick leave accrual
- Other great benefits include: monthly contribution to childcare and/or dependent expenses, FSA account, parental leave, sabbatical leave, employee assistance program, annual wellness reimbursement, growth and development opportunities, disability and life insurance.
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Business Intelligence Analyst providing business intelligence support for MercyCare’s Actuarial and Underwriting department. Handling data collection, reconciliation, reporting, and analysis for informed decision - making.
Entry - Level Power BI Analyst at Mitsubishi Power supporting development and maintenance of Power BI reports. Collaborating with teams to ensure reporting consistency and data quality standards.
Senior Business Intelligence Analyst at Clio creating data solutions for better decision - making. Collaborating with stakeholders and enhancing business intelligence in a hybrid work environment.
SR BI ANALYST in an international insurance company analyzing and visualizing data. Collaborating with Finance and Operations areas to meet information needs.
Senior Specialized BI Analyst creating advanced business intelligence insights for Memorial Hermann's analytics team. Responsible for supporting critical business decisions across various organizational domains.
Business Intelligence Developer working on reporting and dashboard solutions for 32BJ Benefit Funds. Collaborating with senior developers to advance business insights through data analytics.
Intern supporting Business Intelligence Developer tasks while collaborating with professionals at Uline's corporate headquarters. Focusing on data integrations and analytics for business solutions.
BI Developer reviewing data and metrics on insider and cyber risks for SMBC at a hybrid workplace. Building visualizations and reports to foster security within the organization.
Senior Manager driving business intelligence initiatives for Snap’s Small & Mid - sized Clients business. Leading analytics team to transform insights into data - driven actions across Go - To - Market and Sales strategies.