Business Intelligence Engineer
About The Position
CrossCountry Consulting is seeking a Business Intelligence Engineer to serve as the in-house data engineering expert for its BI platform as the company builds a modern enterprise data warehouse on Snowflake. The role builds and maintains the transformation layer, data models, and Snowflake environment that support reporting, working alongside the integrations team responsible for sourcing and landing data. The engineer partners with finance, sales, and operations leaders to define metrics and deliver trusted reporting end to end, and contributes to Power BI dashboard development when needed. The role encompasses administration and optimization of the BI Snowflake environment, development of dbt models and Power BI semantic models, data quality ownership, and establishment of analytics engineering standards. It also includes piloting AI-enabled analytics and configuring Snowflake Cortex Analyst and Semantic Views for natural-language questions. The position is part of the Data and Business Intelligence team.
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.
- Experience with Git and CI/CD for analytics code.
- Working fluency with AI tools in analytics or engineering work, with sound judgment about their limitations, 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 deployment with strong attention to detail.
Nice To Haves
- Experience building ELT pipelines and data ingestion, such as Fivetran or similar, 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 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.
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 explanations.
- 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.
- Additional benefits.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
