Senior BI Engineer: Snowflake, Power BI & Analytics

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

Benefits offered by this job

Healthcare coverage

401(k) with company matching

Parental and maternity leave

Technology stipends

Wellness reimbursement

Job summary

CrossCountry Consulting is seeking a BI Engineer to own the BI platform, build the transformation layer, and deliver trusted reporting end-to-end. You’ll work with finance, sales, and operations to define metrics and create Power BI dashboards on Snowflake-backed data.

You’ll optimize the Snowflake environment, implement dbt models with tests, and contribute to AI-enabled analytics while mentoring analysts and stakeholders in data modeling and self-service.

Qualifications

• Bachelor’s degree or equivalent in a relevant field.
• Strong SQL and dbt skills with data warehousing concepts.
• Hands-on Snowflake experience including performance tuning and access control.
• Strong Power BI skills including DAX and data modeling.

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

dbt

Snowflake

Power BI

DAX

Git & CI/CD

AI tools in analytics

Education

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

Tools

Fivetran

Airflow

Dagster

Terraform

Snowflake Cortex Analyst

Tableau

Job description

CrossCountry Consulting is seeking a BI Engineer to own the BI platform, build the transformation layer, and deliver trusted reporting end-to-end. You’ll work with finance, sales, and operations to define metrics and create Power BI dashboards on Snowflake-backed data.

You’ll optimize the Snowflake environment, implement dbt models with tests, and contribute to AI-enabled analytics while mentoring analysts and stakeholders in data modeling and self-service.