BI Reporting Engineer

About Data Society Group
At Data Society Group we provide the highest quality leading-edge industry-tailored data and AI training and solutions for Fortune 1000 companies and federal state and local governmental organizations. We partner with our clients to educate equip and empower their workforces with the skills they need to achieve their goals and expand their impact. Our portfolio of brands and services sits at the intersection of people data and AI and consists of:

• CDO Magazine the trusted voice of global data and AI leadership
• The Data Lodge a pioneer in data literacy and cultural transformation
• Data Society delivering applied AI education and custom-built solutions
• InspiredMinds! a convening force behind the worlds most inclusive AI community

We are working to empower the workforces of the future; if youre as passionate about transforming workplaces with the power of Data & AI as we are wed love to hear from you!

About the Role
The BI / Reporting Engineer works under the direction of the BI / Reporting Lead to build and validate the platforms 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.

Responsibilities
As the BI / Reporting Engineer you will be responsible for hands-on reporting execution semantic layer builds and data validation. Your primary duties include:

• Semantic Layer & Data Modeling: 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).
• 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. Support post-launch dashboard enhancements during hypercare.
• CI/CD & Pipeline Standards: Work within Azure DevOps CI/CD pipelines ensuring all reporting code and schema changes pass review before deployment.

Required Skills & Experience

• 47 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.

Preferred 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.