CrossCountry Consulting · posted · checked
Business Intelligence Engineer
dbtPower biSnowflakeSQL$130k – $185kOn-site · Boston, Chicago and New York
Who can apply
On-site · Boston, Chicago and New York
Location: Boston, MA / Chicago, IL / Dallas, TX / McLean, VA / New York, NY
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