CrossCountry Consulting Logo

CrossCountry Consulting

Business Intelligence Engineer

Posted 15 Days Ago
Hybrid
Chicago, IL, USA
130K-185K Annually
Senior level
Hybrid
Chicago, IL, USA
130K-185K Annually
Senior level
Build and maintain a Snowflake-based BI platform, including transformation layers, dimensional data models, semantic models, dashboards, data quality controls, and performance optimization. Translate business requirements into trusted metrics and reporting, develop dbt models, manage access and costs, and support AI-enabled analytics using Snowflake Cortex Analyst. Collaborate with integrations, finance, sales, and operations teams while establishing engineering standards, mentoring stakeholders, and contributing to Power BI development.
The summary above was generated by AI

CrossCountry Consulting is the transformation partner for the Office of the CFO. As a trusted advisor to Fortune 500 companies, emerging growth market leaders, and private equity sponsors, we combine deep domain expertise with the power of data, AI, and technology to modernize workflows, drive human-centered change, and maximize transaction value. Grounded in our Core Values, we are committed to solving today's most complex challenges while delivering a better experience for our clients, our people, and our communities. When you join CrossCountry, you become part of a team that believes in collaboration, generosity, and the drive to help our clients work smarter, build resiliency, and prepare for the future.


We’re building a modern enterprise data warehouse on Snowflake and need a BI Engineer who will serve as our in-house data engineering expert for the BI platform. You’ll build and maintain the transformation layer, data models, and Snowflake environment behind our reporting, working alongside the integrations team that handles sourcing and landing. You’ll partner with finance, sales, and operations leaders to define metrics and deliver trusted reporting end to end. And, as a member of the Data and Business Intelligence team, you’ll also help build the Power BI dashboards when the work calls for it.

What You'll Do:

  • 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.

What You'll Bring:

  • 5+ years in data engineering, analytics engineering, or BI engineering 

  • Bachelor’s degree in Finance, IT, Information Systems, Engineering, or a related field (or equivalent experience) 

  • 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 

  • Git and CI/CD experience for analytics code 

  • Working fluency with AI tools in analytics or engineering work, with sound judgment about their limits, including inaccurate or ungrounded answers 

  • Clear communication with technical and non-technical audiences, and the ability to translate business needs into technical requirements and carry them through to deployment with strong attention to detail

Preferred Qualifications:

  • Experience building ELT pipelines and data ingestion (Fivetran or similar, including API-based sources) 

  • Python for scripting and automation 

  • Experience with orchestration tools (Airflow, Dagster, or similar) 

  • Infrastructure-as-code experience (Terraform or similar) for Snowflake 

  • Hands-on experience with Snowflake Cortex Analyst, semantic views, or similar natural-language-to-SQL tools 

  • Familiarity with data governance, cataloging, and lineage tooling 

  • Background in finance, FP&A, or sales analytics 

  • Exposure to Tableau or other BI tools

CrossCountry Consulting is required to include an estimate of the compensation range for this role. The following range takes into account a wide range of factors including but not limited to, skills, experience, education, licenses, certifications, business needs, and internal equity. An estimate of the current range is $130,000 - $185,000 per year + annual bonus + additional benefits. 
 
#LI-AJ1

Benefits Summary
The CrossCountry total rewards package includes comprehensive healthcare options, including medical, dental, and vision coverage; flexible spending accounts; and a 401(k) with company matching. Additionally, employees can take advantage of generous parental and maternity leave policies, technology stipends, and wellness reimbursement programs, all designed to support both professional growth and personal well-being. For detailed information about benefits at CrossCountry, please visit our dedicated benefits site: https://www.crosscountry-consulting.com/careers/benefits/.
 
Equal Employment Opportunity (EEO)
CrossCountry provides equal employment opportunities (EEO) to all employees and applicants for employment and believes that respect and fair treatment are critical to creating a productive and inclusive workplace. 
 
As an equal opportunity employer, CrossCountry is fully committed to comply with all federal, state, and local laws and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability, pregnancy, genetics, sexual orientation, veteran status, gender identity or expression or any other protected characteristic. The company also complies with pay transparency and labor laws applicable to all terms and conditions of employment.
  

CrossCountry Consulting Addison, Illinois, USA Office

15851 Dallas Parkway, Suite 1250, Addison, United States, 75001

CrossCountry Consulting Chicago, Illinois, USA Office

225 West Washington Street, Suite 400, Chicago, United States, 60606

Similar Jobs

Junior
Healthtech
Develops and supports business intelligence solutions, including reports, dashboards, analytics, database queries, and data warehouse components. Gathers business and technical requirements, analyzes healthcare data, tests and troubleshoots BI solutions, and partners with clinical, financial, operational, and IT stakeholders. The role supports Epic-based analytics and requires ongoing monitoring, maintenance, and 24/7 pager or telephone availability.
Top Skills: Analytics CatalogAzureCaboodle Data ModelClarity Data ModelCrystal ReportsData WarehousingEpic CogitoMicrosoft BiMultidimensional DatabasesPythonRRadar DashboardsRadar Sql MetricsRelational DatabasesReporting WorkbenchSap BusinessobjectsSASSlicerdicerSnowflakeSQLTableauTibco SpotfireWorkday
2 Days Ago
In-Office or Remote
US
125K-140K Annually
Mid level
125K-140K Annually
Mid level
Insurance
Develops governed analytical datasets, semantic models, data sources, reports, and dashboards using insurance data. The role supports self-service analytics, AI-driven decision intelligence, data quality, anomaly detection, forecasting, and strategic initiatives across the organization. It requires collaboration with stakeholders and IT, cloud and BI technology expertise, and promotion of data literacy.
Top Skills: AWSAws RedshiftAzureBusiness Intelligence ToolsETLKnowledge GraphsMicrosoft FabricPower BISQL
2 Days Ago
Hybrid
90K-109K Annually
Mid level
90K-109K Annually
Mid level
AdTech • eCommerce • Marketing Tech
Designs and supports enterprise business intelligence, data engineering, warehousing, semantic modeling, reporting, dashboards, and AI-enabled analytics. The role develops SQL Server and SSAS solutions, ETL/ELT pipelines, Power BI assets, KPI frameworks, forecasting models, and data governance processes. It partners with operations, IT, vendors, and executives to translate business needs into actionable insights, modernize reporting through automation and AI, ensure data quality, and support strategic and operational decision-making.
Top Skills: AWSAzureAzure SqlCi/CdDaxGCPGitJavaScriptJSONLarge Language Models (Llms)MdxMicrosoft CopilotMicrosoft FabricPower BIPowershellPythonRest ApisSnowflakeSQLSQL ServerSql Server Analysis Services (Ssas)SsrsTableauXML

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account