BI Reporting Engineer

Data Society; Washington (District of Columbia); Hybrid; USD 95,000 - 130,000; Full time

Benefits offered by this job

Full benefits

Remote-friendly

Job summary

Data Society Group is seeking a BI/Reporting Engineer to build and validate the platform's semantic layer and dashboards. You will translate report specs into production-ready SQL views, work closely with offshore BI engineers, and validate outputs against ERP data before review.

The role is remote, with biweekly commutes to Falls Church, VA. It is a full-time W2 position with benefits, tied to a client contract for an initial 9 months, with potential extension based on performance.

Qualifications

• 4–7 years of BI or data engineering experience focusing on hands‑on reporting.
• Strong SQL skills and complex query writing for large enterprise data.
• Experience with semantic layers, data models, and dimensional modeling (star schema).
• Experience preparing reporting datasets from operational systems via SQL-based transformations.
• Experience with BI tools (Tableau, Power BI, Apache ECharts) and Azure-native tools.
• Proven data validation against source systems and reconciliation.
• Comfort with CI/CD and version-controlled SQL schemas (Azure DevOps).
• Experience using AI coding tools to assist with queries and modeling.
• Strong written and verbal communication for stakeholder/UAT sessions.

Responsibilities

• Build and validate the platform's reporting semantic layer and dashboards.
• Translate report specifications into production-ready SQL views and aggregations.
• Validate outputs against ERP source data before stakeholder review.
• Coordinate with offshore BI Engineers to ensure consistent implementation quality.
• Support UAT sessions, capture feedback, and drive post-launch dashboard enhancements.
• Work within Azure DevOps CI/CD pipelines and ensure code changes pass reviews.

Skills

SQL querying

Azure SQL / Synapse

Data modeling

Dashboard reporting

CI/CD pipelines

Azure DevOps

Communication

AI coding tools usage

Tools

Azure DevOps

Azure Synapse Analytics

Databricks

Tableau / Power BI

Apache ECharts

Job description

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 1,000 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 world’s most inclusive AI community

We are working to empower the workforces of the future; if you’re as passionate about transforming workplaces with the power of Data & AI as we are, we’d 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 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.

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

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

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.