Business Intelligence Engineer

CrossCountry Consulting
McLean, VA
Hybrid

Who this role is best for

Aimed at mid-to-senior level BI engineers who can manage complex data environments and bridge business and technical needs.

Best fit for

  • Candidates with 5+ years of BI engineering experience in finance or FP&A domains
    — “Background in finance, FP&A, or sales analytics”
  • Professionals skilled in translating business needs into technical deliverables
    — “Translate business requirements, KPIs, and metric definitions into technical designs”
  • Individuals with a strong grasp of Snowflake and Power BI for end-to-end analytics solutions
    — “Deep hands-on Snowflake experience, including performance tuning, access control, and cost management”

Things to consider

  • Candidates must be fluent in AI tools but also understand their limitations
    — “Working fluency with AI tools in analytics or engineering work, with sound judgment about their limits”
  • The role requires strong attention to detail for data quality and validation
    — “Own data quality in the transformation layer: testing, monitoring, reconciliation, and root-cause analysis”

How to stand out

  • Highlight experience with dbt models and semantic layer development in resume and interviews
    — “Develop and maintain dbt models (staging, intermediate, marts) with tests, documentation, and version control”
  • Emphasize your ability to mentor and guide others in self-service analytics
    — “Mentor analysts and stakeholders on data models and self-service”
  • Demonstrate your ability to optimize both Power BI and Snowflake environments
    — “Build and optimize Power BI semantic models and dashboards (star schemas, DAX measures, row-level security), tuning DirectQuery and Import models against Snowflake”
Pace · SteadyCollaboration · HighAutonomy · MediumDecision Impact · Team

Derived from job-description analysis by Serendipath's career intelligence engine.

What success looks like

  • maintain BI Snowflake environment
  • build and optimize Power BI semantic models
  • translate business requirements into technical designs
  • set engineering standards
  • own data quality in the transformation layer
Typical background
data engineeringanalytics engineeringBI engineering

Skills & requirements

Required

SnowflakePower BIDAXdbtSQLCI/CDData WarehousingDimensional Modeling

Preferred

PythonAirflowTerraformSnowflake Cortex AnalystTableau

Stack & domain

SnowflakePower BIDAXSQLdbtGitCI/CDAI ToolsData GovernanceTableauCommunication SkillsData EngineeringAnalytics EngineeringBI Engineering

About the role

Original posting from CrossCountry Consulting via Lever

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.

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 

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.

What You'll Bring::

5+ years 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, 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, with sound judgment about their limits, 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 to deployment with strong attention to detail

Preferred Qualifications::

Experience building ELT pipelines and data ingestion (Fivetran or similar, including API-based sources) 

Python for scripting and automation 

Experience with orchestration tools (Airflow, Dagster, or similar) 

Infrastructure-as-code experience (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

Benefits Summary

The CrossCountry total rewards package includes comprehensive healthcare options, including medical, dental, and vision coverage; flexible spending accounts; and a 401(k) with company matching. Additionally, employees can take advantage of generous parental and maternity leave policies, technology stipends, and wellness reimbursement programs, all designed to support both professional growth and personal well-being. For detailed information about benefits at CrossCountry, please visit our dedicated benefits site: https://www.crosscountry-consulting.com/careers/benefits/.

Equal Employment Opportunity (EEO)

CrossCountry provides equal employment opportunities (EEO) to all employees and applicants for employment and believes that respect and fair treatment are critical to creating a productive and inclusive workplace. 

As an equal opportunity employer, CrossCountry is fully committed to comply with all federal, state, and local laws and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability, pregnancy, genetics, sexual orientation, veteran status, gender identity or expression or any other protected characteristic. The company also complies with pay transparency and labor laws applicable to all terms and conditions of employment.

Source: CrossCountry Consulting careers (Lever)

Similar roles

More roles at CrossCountry Consulting