BI Reporting Engineer
HybridWashington, District of Columbia, United States or Washington, United States
Job Summary
Build and maintain Azure SQL reporting views, aggregations, and semantic layer structures under the direction of the BI Reporting Lead. Translate documented business requirements into production-ready dashboard outputs and validate all results against ERP source data before stakeholder review. Coordinate with offshore BI Engineers to ensure consistent implementation quality and support UAT sessions by resolving discrepancies with business users. Manage CI/CD pipelines within Azure DevOps to ensure schema changes pass review prior to deployment. This full-time W2 remote role requires commuting to client offices in Falls Church, VA every two weeks and includes an initial 9-month contract.
Required Qualifications
- 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
- 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
- Must be able to commute to client offices in Falls Church, VA as needed (estimated every 2 weeks)
- Must be available for weekend shifts
Desired Qualifications
- Prior experience building reporting layers on top of Oracle Fusion Cloud data (PPM, Financials, SCM, HCM)
- Familiarity with lakehouse or medallion architecture patterns (Bronze/Silver/Gold/Semantic layers)
- Experience with Apache ECharts embedded in React applications
- Experience delivering financial reporting for construction, real estate, or project-based industries
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.