Skip to main content

Business Intelligence Analyst

L5

phoenix groupMundelein, ILtoday
Job Description
Role Overview: The Business Intelligence Analyst will own the development and maintenance of curated datasets, dimensional data models, dashboards, reports, and self-service analytics solutions across financial and operational workflows. This role partners with business stakeholders, Data Engineers, Data Architects, and Business Analysts to translate requirements into reliable, accurate, and scalable data products using Snowflake, Sigma Computing, and SQL.
Key Responsibilities: Design, develop, and maintain scalable data models, curated datasets, dashboards, reports, and analytical applications. Build interactive Sigma Computing workbooks that support KPI monitoring, variance analysis, ad hoc reporting, and self-service data exploration. Develop reusable reporting components and analytical data models in Snowflake and Sigma using dimensional modeling practices. Design and maintain fact tables, dimension tables, views, semantic models, and curated analytical data layers. Define data grain, table relationships, hierarchies, calculated fields, standardized metrics, and reporting logic. Translate business requirements into logical and physical data models, datasets, visualizations, dashboards, and analytical solutions. Develop and maintain Sigma formulas, calculations, parameters, controls, and data transformations. Write, optimize, and maintain SQL queries using joins, aggregations, subqueries, common table expressions (CTEs), and window functions. Partner with Data Engineering and Data Architecture teams to understand source systems, data pipelines, transformation logic, warehouse structures, and downstream dependencies. Contribute to data architecture patterns connecting source applications, Snowflake, and business intelligence platforms. Perform data validation, reconciliation, variance analysis, and troubleshooting across source systems, warehouse models, and reporting applications. Develop data-quality checks, reporting controls, testing procedures, and validation processes to improve data accuracy and reliability. Support analytics solution deployment, documentation, access management, maintenance, and ongoing production enhancements. Monitor data model, SQL query, dashboard, and workbook performance; identify opportunities to improve scalability, efficiency, and usability. Support data governance initiatives involving access controls, certified datasets, documentation, data lineage, and standardized metric definitions. Participate in technical reviews, solution design sessions, architecture discussions, and cross-functional planning. Establish and maintain development standards for naming conventions, reusable logic, documentation, testing, and quality assurance. Support reporting and analytics related to financing activity, debt structures, credit facilities, capital allocation, liquidity, portfolio exposure, financial performance, and management reporting. Core Qualifications & Requirements1–3 years of professional experience in analytics engineering, business intelligence, data analytics, or a related discipline. Hands-on experience developing data models, dashboards, reports, or analytical applications using Sigma Computing or a comparable modern BI platform. Experience with Snowflake or another cloud-based data warehouse. Strong SQL skills, including joins, aggregations, subqueries, common table expressions (CTEs), and window functions. Understanding of dimensional data modeling, including fact tables, dimension tables, data grain, star schemas, relationships, and reporting layers. Foundational knowledge of data architecture, including source systems, transformation layers, curated datasets, semantic models, and downstream reporting. Ability to convert business requirements into clearly defined metrics, data models, visualizations, dashboards, and analytical products. Experience partnering with Data Engineering or Data Architecture teams to understand source data, resolve data-quality issues, and support end-to-end data solutions. Strong analytical, critical-thinking, troubleshooting, and problem-solving skills, particularly when investigating data discrepancies and reporting inconsistencies. Exceptional attention to detail and commitment to data accuracy, consistency, and reliability. Strong written and verbal communication skills, with the ability to explain technical concepts to technical and non-technical audiences. Ability to manage competing priorities and collaborate effectively in a cross-functional environment. Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Finance, or a related discipline, or equivalent practical experience.
Apply now (opens in a new tab)
Apply now (opens in a new tab)

Level

SeniorL5

Location

Mundelein, IL

Occupation

Business Intelligence Analysts

Industry

Portfolio Management and Investment Advice

Posted

today

To get sharper similar jobs, create your profile using the link below.

Create profile