BI Reporting Engineer

• 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 Dev Ops CI/CD pipelines, ensuring all reporting code and schema changes pass review before deployment.

• 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 Dev Ops preferred).
• Experience using AI coding tools (e.g., Claude Code, Git Hub 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.

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.

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

• 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

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

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

• Azure SQL
• Azure Synapse Analytics
• Azure Dev Ops
• Apache ECharts
• Tableau
• Power BI
• Sigma