Senior BI Engineer: Snowflake, Power BI & AI Analytics

CrossCountry Consulting LLC; Chicago (IL); On-site; USD 130,000 - 185,000; Full time

Benefits offered by this job

Healthcare package including medical,d

401(k) with company matching

Parental and maternity leave policies

Technology stipends

Wellness reimbursement

Job summary

CrossCountry Consulting is seeking a BI Engineer to serve as our in-house data engineering expert for the BI platform. You will build the transformation layer, data models, and Snowflake environment behind reporting, partnering with finance, sales, and operations leaders to define metrics and deliver trusted reporting end to end.

You will also help build Power BI dashboards, set engineering standards, and mentor analysts on data models and self-service.

Qualifications

• 5+ years in data engineering, analytics engineering, or BI engineering.
• Advanced SQL and dbt, with a solid grasp of dimensional modeling and data warehousing concepts.
• Deep hands-on Snowflake experience, including performance tuning, access control, and cost management.
• Strong Power BI skills, including DAX, data modeling, and publishing and managing workspaces.

Responsibilities

• Maintain the BI Snowflake environment: schemas, roles and access, performance tuning, warehouse sizing, and cost monitoring.
• Build and optimize Power BI semantic models and dashboards (star schemas, DAX measures, row-level security), tuning DirectQuery and Import models against Snowflake.
• Translate business requirements, KPIs, and metric definitions into technical designs.
• Set engineering standards for naming, code review, CI/CD, and documentation.
• Partner with the integrations team to define what the BI platform needs from landed data and resolve upstream issues.
• Own data quality in the transformation layer: testing, monitoring, reconciliation, and root-cause analysis.
• Write complex, performant SQL to model, transform, and validate data.
• Develop and maintain dbt models (staging, intermediate, marts) with tests, documentation, and version control.
• Set up and tune Snowflake Cortex Analyst and Semantic Views so natural-language questions return accurate answers.
• Evaluate, test, and pilot AI-enabled analytics, such as natural language querying over semantic models, AI-generated commentary, and automated variance explanation.
• Mentor analysts and stakeholders on data models and self-service.
• Pitch in with PowerBI report and dashboard builds when needed.

Skills

Advanced SQL

Data modeling

Communication

Mentoring

Education

Bachelor’s degree in Finance, IT, Information Systems, Engineering, or related field

Tools

Snowflake

dbt

Power BI

Git

CI/CD

Python

Airflow

Dagster

Terraform

Tableau

Job description

CrossCountry Consulting is seeking a BI Engineer to serve as our in-house data engineering expert for the BI platform. You will build the transformation layer, data models, and Snowflake environment behind reporting, partnering with finance, sales, and operations leaders to define metrics and deliver trusted reporting end to end.

You will also help build Power BI dashboards, set engineering standards, and mentor analysts on data models and self-service.