C

CrossCountry Consulting

CFO-focused financial advisory, ESG, digital transformation

Business Intelligence Engineer

Business IntelligenceConfirmed live in the last 24 hours
Full-time

About the Job

Requirements

  • At least 5 years of experience in data engineering, analytics engineering, or BI engineering.
  • A 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.
  • Ability to communicate with technical and non-technical audiences and translate business needs into technical requirements through deployment, with strong attention to detail.

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 using star schemas, DAX measures, and row-level security, and 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 the BI platform's needs from 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 models across staging, intermediate, and marts layers, including 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.

Desired Qualifications

  • Experience building ELT pipelines and data ingestion using Fivetran or similar tools, including API-based sources.
  • Python skills for scripting and automation.
  • Experience with orchestration tools such as Airflow, Dagster, or similar.
  • Infrastructure-as-code experience using Terraform or similar tools 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.
  • A background in finance, FP&A, or sales analytics.
  • Exposure to Tableau or other BI tools.

About the Company

CrossCountry Consulting

CFO-focused financial advisory, ESG, digital transformation

CrossCountry Consulting provides tailored advisory services for finance leaders, primarily the office of the CFO, private equity sponsors, and other corporate executives. Its offerings cover digital transformation, transaction management, and ESG standards, delivered through bespoke consulting engagements that align with each client's long-term objectives. The firm works by partnering closely with client teams to diagnose issues, design strategies, and implement solutions, using a hands-on, collaborative approach. Compared with other financial consultancies, CrossCountry stands out through highly customized engagements, a people-first culture, and a clear focus on aligning work with the client's strategic goals. The goal is to help mid-sized and large enterprises navigate financial change, improve performance, and achieve their strategic targets.

Company size
1,001-5,000
Company stage
Early VC
Total funding
$1.5M
Headquarters
Tysons, VA
Founded
2011

Recently Posted Jobs

Explore more opportunities at CrossCountry Consulting

See more jobs