Business Intelligence Engineer

CrossCountry Consulting • New York, NY

1d

About The Position

CrossCountry Consulting is seeking a Business Intelligence Engineer to serve as the in-house data engineering expert for its BI platform. The role will support a modern enterprise data warehouse on Snowflake, building and maintaining its transformation layer, data models, and Snowflake environment. The engineer will work with the integrations team, which handles sourcing and landing data, and partner with finance, sales, and operations leaders to define metrics and deliver trusted reporting end to end. As part of the Data and Business Intelligence team, the role will also contribute to Power BI dashboards as needed.

The position includes maintaining Snowflake schemas, roles, access, performance, warehouse sizing, and costs; developing dbt models and high-performing SQL transformations; and building and optimizing Power BI semantic models and dashboards. The engineer will own transformation-layer data quality, establish engineering standards, advise stakeholders on data models and self-service, and pilot AI-enabled analytics, including Snowflake Cortex Analyst and semantic views.

The estimated compensation range is $130,000–$185,000 per year, plus annual bonus and additional benefits.

Requirements

• At least 5 years of experience 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 skills, 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, and sound judgment about their limitations, including inaccurate or ungrounded answers.
• Clear communication with technical and non-technical audiences; ability to translate business needs into technical requirements and carry them through deployment; and strong attention to detail.

Nice To Haves

• Experience building ELT pipelines and data ingestion using Fivetran or similar tools, including API-based sources.
• Python for scripting and automation.
• Experience with orchestration tools such as Airflow, Dagster, or similar.
• Infrastructure-as-code experience, such as Terraform, 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.

Responsibilities

• Maintain the BI Snowflake environment, including schemas, roles and access, performance tuning, warehouse sizing, and cost monitoring.
• Build and optimize Power BI semantic models and dashboards, including star schemas, DAX measures, and row-level security; tune 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 BI platform requirements for landed data and resolve upstream issues.
• Own data quality in the transformation layer through testing, monitoring, reconciliation, and root-cause analysis.
• Write complex, performant SQL to model, transform, and validate data.
• Develop and maintain dbt staging, intermediate, and mart models 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, including natural-language querying over semantic models, AI-generated commentary, and automated variance explanation.
• Mentor analysts and stakeholders on data models and self-service.
• Build Power BI reports and dashboards when needed.

Benefits

• Comprehensive healthcare options, including medical, dental, and vision coverage.
• Flexible spending accounts.
• 401(k) with company matching.
• Generous parental and maternity leave policies.
• Technology stipends.
• Wellness reimbursement programs.
• Annual bonus.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior