Azure BI Reporting Engineer: Data Modeling & Dashboards

Jobtailor; Falls Church (VA); On-site; USD 90,000 - 130,000; Full time

Job summary

Jobtailor is seeking a BI/Data Engineer in the Falls Church, VA area to build and maintain Azure SQL reporting views, data models, and semantic layers under the guidance of the BI/Reporting Lead.

You will translate business requirements into production reports and dashboards, validate outputs against ERP data, coordinate with offshore engineers, support UAT sessions, and ensure code quality through Azure DevOps pipelines in a fast-paced enterprise environment.

Qualifications

• 4–7 years of BI or data engineering experience, with a hands-on focus on reporting and analytics delivery.
• Strong SQL skills, including complex query writing, view design, aggregation logic, and performance tuning on Azure SQL or Synapse Analytics for large enterprise datasets.
• Experience implementing semantic layers, reporting data models, and dimensional modeling concepts (star schemas, fact/dimension tables) on Azure SQL or Synapse.
• Experience preparing reporting datasets from operational systems using SQL-based transformation techniques.
• Experience working with data visualization and BI tools (e.g., Tableau, Power BI, Sigma, or similar Azure-native tools).
• Proven experience validating report outputs against source system data for detailed reconciliation.
• Comfortable working within CI/CD pipelines and version-controlled SQL schema management (Azure DevOps preferred).
• Experience using AI coding tools to assist with query generation, data modeling, and report specification implementation.

Responsibilities

• Build and maintain Azure SQL reporting views, aggregations, and semantic layer structures under BI Lead guidance.
• Translate documented business requirements into production-ready report and dashboard outputs.
• Validate report outputs against ERP source data, reconciling figures before stakeholder review.
• Coordinate with offshore BI Engineers to ensure consistent implementation quality.
• Support report UAT sessions by working with business users to validate outputs and resolve discrepancies.
• Work within Azure DevOps CI/CD pipelines to ensure reporting code and schema changes pass review.

Skills

SQL

Azure SQL

Azure Synapse Analytics

ETL/Data Transformation

Dimensional Modeling

Data Modeling

BI Tools

CI/CD

Offshore Coordination

UAT

Tools

Azure DevOps

Apache ECharts

Tableau

Power BI

Sigma

Job description

Jobtailor is seeking a BI/Data Engineer in the Falls Church, VA area to build and maintain Azure SQL reporting views, data models, and semantic layers under the guidance of the BI/Reporting Lead.

You will translate business requirements into production reports and dashboards, validate outputs against ERP data, coordinate with offshore engineers, support UAT sessions, and ensure code quality through Azure DevOps pipelines in a fast-paced enterprise environment.