BI Reporting Engineer

Data Society•Washington, DC

1d•Hybrid

About The Position

The BI / Reporting Engineer works under the direction of the BI / Reporting Lead to build and validate the platform's reporting semantic layer and dashboard outputs. This role focuses on hands-on implementation by translating report specifications into production-ready SQL views, aggregations, and report builds, while working closely with offshore BI Engineers and validating all outputs against ERP source data before stakeholder review. This role is work-from-home (remote) though must be able to commute to client offices in Falls Church, VA as needed (estimated every 2 weeks). This is a full-time W2 employment position with full benefits. Please note that the role is tied to a client contract and is structured as an initial 9-month position. Opportunities for extension or long-term placement are highly likely based on client renewal and project performance.

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.

Nice To Haves

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.

Responsibilities

Build and maintain Azure SQL reporting views, aggregations, and semantic layer structures under the direction of the BI / Reporting Lead.
Implement star schema dimensional models within the enterprise reporting platform (Azure Synapse Analytics, Microsoft Fabric, or Databricks).
Translate documented business requirements and report specifications into production-ready report and dashboard outputs.
Validate report outputs against ERP source data, reconciling figures line-by-line to confirm accuracy before stakeholder review.
Coordinate with and review work from offshore BI Engineers by providing guidance, feedback, and ensuring consistent implementation quality across deliverables.
Support report UAT sessions by working directly with business users to validate outputs, capture feedback, and resolve discrepancies.
Support post-launch dashboard enhancements during hypercare.
Work within Azure DevOps CI/CD pipelines, ensuring all reporting code and schema changes pass review before deployment.