Skip to main content
Loading
loadingbar
Loading, Please wait..!!

Business Intelligence Engineer

  • Business Intelligence Engineer job type Posted on: Nov 18, 2026
  • Business Intelligence Engineer experience level The Phoenix Group
  • Business Intelligence Engineer employment type Mundelein, Illinois
  • Business Intelligence Engineer employment type Onsite
  • Business Intelligence Engineer salary Full-time

Point Apply Here APPLY LATER

Curious about compensation?

Explore the historical salary trends, average pay, and estimated compensation for Business Intelligence Engineer roles in Illinois.

View Salary Guide →

Job Title :

Business Intelligence Engineer

Job Type :

Full-Time

Job Location :

Mundelein Illinois United States

Remote :

No

Jobcon Logo Job Description :

Job Description

Key Responsibilities

\n
    \n
  • Design, develop, and optimize data models, datasets, dashboards, and reports supporting monthly and quarterly fund performance and operational reporting cycles.
  • \n
  • Transform raw source data into high-quality, reusable, and structured datasets for analytics and business intelligence purposes.
  • \n
  • Utilize dimensional modeling principles to create and maintain fact and dimension tables, star schemas, and business metrics aligned with fund valuation and reporting needs.
  • \n
  • Write, test, and maintain complex SQL queries, stored procedures, and data transformations involving joins, aggregations, window functions, and subqueries across multiple systems.
  • \n
  • Develop analytics solutions using BI platforms such as Power BI, Sigma Computing, and Snowflake, including dashboard and report creation.
  • \n
  • Collaborate with Data Engineers to understand source system architecture, establish reliable data pipelines, resolve data-quality issues, and support end-to-end data workflows.
  • \n
  • Partner with Business Analysts and stakeholders, including fund managers and portfolio leads, to translate business requirements into effective data models, KPIs, and report deliverables.
  • \n
  • Validate data accuracy, reconcile discrepancies, and troubleshoot data issues across multiple systems and models.
  • \n
  • Implement and execute data quality tests, unit tests, and validation procedures to ensure the integrity of analytics outputs.
  • \n
  • Document data lineage, business logic, metrics definitions, and reporting processes thoroughly.
  • \n
  • Support deployment, monitoring, and maintenance of analytics solutions, ensuring continued performance and accuracy.
  • \n
  • Participate in code reviews, contribute to best practices, and help develop standards for analytics engineering within the organization.
  • \n
\n

Core Qualifications & Requirements

\n
    \n
  • 1 to 3 years of relevant experience in data analytics, data engineering, or reporting roles within finance, asset management, or private equity.
  • \n
  • Strong proficiency in SQL, including joins, aggregations, subqueries, window functions, and CTEs.
  • \n
  • Solid understanding of dimensional data modeling concepts such as fact/dimension tables, star schemas, and data relationships.
  • \n
  • Hands-on experience developing dashboards and reports using Power BI, Sigma Computing, Snowflake, or similar BI tools.
  • \n
  • Familiarity with data transformation frameworks like dbt or equivalent.
  • \n
  • Knowledge of source system integration, data pipeline development, and data quality assurance practices.
  • \n
  • Experience working with cloud data platforms such as Snowflake and AWS.
  • \n
  • Ability to collaborate effectively with Data Engineers on data pipelines and source system issues.
  • \n
  • Strong attention to detail, data validation, and troubleshooting skills.
  • \n
  • Excellent written and verbal communication, capable of translating technical concepts for stakeholders.
  • \n
  • Bachelor’s degree in Computer Science, Data Analytics, Finance, or related field, or equivalent practical experience.
  • \n
\n

Nice-to-Have Qualifications

\n
    \n
  • Exposure to Sigma Computing, Power BI, and Snowflake.
  • \n
  • Experience with data orchestration tools like Airflow or DataHub.
  • \n
  • Familiarity with data quality automation and lineage documentation.
  • \n
  • Knowledge of finance, private equity, or real estate operational processes.
  • \n
  • Understanding of software development best practices such as modular design, version control, and deployment workflows.
  • \n
  • Comfortable working within Agile project methodologies.
  • \n
\n

Core Technical Skills

\n
    \n
  • SQL (joins, filters, aggregations, CTEs, window functions)
  • \n
  • Dimensional data modeling (fact/dimension tables, star schemas)
  • \n
  • Business Intelligence tools (Power BI, Sigma Computing)
  • \n
  • Cloud data platforms (Snowflake, AWS)
  • \n
  • Data pipeline/tools (dbt, Airflow, DataHub)
  • \n
  • Data testing and validation practices
  • \n
  • Version control (Git)
  • \n
\n
  • \n


Jobcon Logo Position Details

Posted:

Nov 18, 2026

Reference Number:

71f7f641d2fc9f08

Employment:

Full-time

City:

Mundelein

Job Origin:

ziprecruiter

Share this job:

  • linkedin

Jobcon Logo
A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Business Intelligence Engineer    Apply

Click on the below icons to share this job to Linkedin, Twitter!

Job Description

Key Responsibilities

\n
    \n
  • Design, develop, and optimize data models, datasets, dashboards, and reports supporting monthly and quarterly fund performance and operational reporting cycles.
  • \n
  • Transform raw source data into high-quality, reusable, and structured datasets for analytics and business intelligence purposes.
  • \n
  • Utilize dimensional modeling principles to create and maintain fact and dimension tables, star schemas, and business metrics aligned with fund valuation and reporting needs.
  • \n
  • Write, test, and maintain complex SQL queries, stored procedures, and data transformations involving joins, aggregations, window functions, and subqueries across multiple systems.
  • \n
  • Develop analytics solutions using BI platforms such as Power BI, Sigma Computing, and Snowflake, including dashboard and report creation.
  • \n
  • Collaborate with Data Engineers to understand source system architecture, establish reliable data pipelines, resolve data-quality issues, and support end-to-end data workflows.
  • \n
  • Partner with Business Analysts and stakeholders, including fund managers and portfolio leads, to translate business requirements into effective data models, KPIs, and report deliverables.
  • \n
  • Validate data accuracy, reconcile discrepancies, and troubleshoot data issues across multiple systems and models.
  • \n
  • Implement and execute data quality tests, unit tests, and validation procedures to ensure the integrity of analytics outputs.
  • \n
  • Document data lineage, business logic, metrics definitions, and reporting processes thoroughly.
  • \n
  • Support deployment, monitoring, and maintenance of analytics solutions, ensuring continued performance and accuracy.
  • \n
  • Participate in code reviews, contribute to best practices, and help develop standards for analytics engineering within the organization.
  • \n
\n

Core Qualifications & Requirements

\n
    \n
  • 1 to 3 years of relevant experience in data analytics, data engineering, or reporting roles within finance, asset management, or private equity.
  • \n
  • Strong proficiency in SQL, including joins, aggregations, subqueries, window functions, and CTEs.
  • \n
  • Solid understanding of dimensional data modeling concepts such as fact/dimension tables, star schemas, and data relationships.
  • \n
  • Hands-on experience developing dashboards and reports using Power BI, Sigma Computing, Snowflake, or similar BI tools.
  • \n
  • Familiarity with data transformation frameworks like dbt or equivalent.
  • \n
  • Knowledge of source system integration, data pipeline development, and data quality assurance practices.
  • \n
  • Experience working with cloud data platforms such as Snowflake and AWS.
  • \n
  • Ability to collaborate effectively with Data Engineers on data pipelines and source system issues.
  • \n
  • Strong attention to detail, data validation, and troubleshooting skills.
  • \n
  • Excellent written and verbal communication, capable of translating technical concepts for stakeholders.
  • \n
  • Bachelor’s degree in Computer Science, Data Analytics, Finance, or related field, or equivalent practical experience.
  • \n
\n

Nice-to-Have Qualifications

\n
    \n
  • Exposure to Sigma Computing, Power BI, and Snowflake.
  • \n
  • Experience with data orchestration tools like Airflow or DataHub.
  • \n
  • Familiarity with data quality automation and lineage documentation.
  • \n
  • Knowledge of finance, private equity, or real estate operational processes.
  • \n
  • Understanding of software development best practices such as modular design, version control, and deployment workflows.
  • \n
  • Comfortable working within Agile project methodologies.
  • \n
\n

Core Technical Skills

\n
    \n
  • SQL (joins, filters, aggregations, CTEs, window functions)
  • \n
  • Dimensional data modeling (fact/dimension tables, star schemas)
  • \n
  • Business Intelligence tools (Power BI, Sigma Computing)
  • \n
  • Cloud data platforms (Snowflake, AWS)
  • \n
  • Data pipeline/tools (dbt, Airflow, DataHub)
  • \n
  • Data testing and validation practices
  • \n
  • Version control (Git)
  • \n
\n
  • \n


Loading
Please wait..!!