BI Reporting Engineer

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

• Semantic Layer & Data Modeling: Build and maintain Azure SQL reporting views, aggregations, and semantic layer structures under the direction of the BI / Reporting Lead.
• Report & Dashboard Implementation: Translate documented business requirements and report specifications into production-ready report and dashboard outputs.
• Data Validation & Quality Assurance: Validate report outputs against ERP source data, reconciling figures line-by-line to confirm accuracy before stakeholder review.
• Offshore Coordination: Coordinate with and review work from offshore BI Engineers by providing guidance, feedback, and ensuring consistent implementation quality across deliverables.
• Stakeholder Support & UAT: Support report UAT sessions by working directly with business users to validate outputs, capture feedback, and resolve discrepancies.
• CI/CD & Pipeline Standards: Work within Azure DevOps CI/CD pipelines, ensuring all reporting code and schema changes pass review before deployment.

Requirements

• 4–7 years of BI or data engineering experience, with a focused background in hands‑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 Azure Synapse Analytics.
• Experience preparing reporting datasets from operational systems using SQL‑based transformation techniques.
• Experience working with data visualization and BI tools (e.g., Apache ECharts, Tableau, Power BI, Sigma, or similar Azure‑native/compatible 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 (e.g., Claude Code, GitHub Copilot) to assist with query generation, data modeling, and report specification implementation.
• Strong written and verbal communication skills with the ability to participate in UAT sessions with business stakeholders and collaborate effectively with offshore teams.

Core Competencies

Demonstrates expertise in SQL query writing, data modeling, and report validation, with a strong focus on Azure SQL and BI tools. Proven ability to coordinate offshore teams and support stakeholder engagement during UAT sessions.

Highest-signal resume keywords

• Strong SQL Skills
• Data Validation & Quality Assurance
• Azure SQL Reporting & Data Modeling
• CI/CD Pipeline Management
• Experience with BI Tools

ATS Optimization Keywords

Hard Skills

• SQL Query Writing
• View Design
• Aggregation Logic
• Performance Tuning
• Semantic Layer Implementation
• Dimensional Modeling
• Data Transformation Techniques
• Report Specification Implementation
• Data Reconciliation
• AI Coding Tools

Soft Skills

• Strong Written Communication
• Strong Verbal Communication
• Collaboration with Offshore Teams

Industry Keywords

• Business Intelligence
• Data Engineering
• Reporting
• Analytics Delivery
• UAT Sessions

Tools & Technologies

• Azure SQL
• Azure Synapse Analytics
• Azure DevOps
• Apache ECharts
• Tableau
• Power BI
• Sigma