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.
Skills Required
- 4-7 years of BI or data engineering experience focused on reporting and analytics delivery
- Strong SQL skills including complex queries, view design, aggregation logic, and performance tuning on Azure SQL or Synapse
- Experience implementing semantic layers and dimensional modeling (star schema, fact/dimension tables) on Azure SQL or Azure Synapse Analytics
- Experience preparing reporting datasets from operational systems using SQL-based transformation techniques
- Experience with BI and data visualization tools (Power BI, Tableau, Sigma, Apache ECharts, or similar)
- Proven experience validating report outputs against ERP/source system data with detailed reconciliation
- Experience working within CI/CD pipelines and version-controlled SQL/schema management (Azure DevOps preferred)
- Experience using AI coding tools to assist query generation and data modeling (e.g., GitHub Copilot, Claude Code)
- Strong written and verbal communication skills; able to participate in UAT and collaborate with offshore teams
- Ability to commute to client offices in Falls Church, VA approximately every two weeks
- Prior experience building reporting layers on Oracle Fusion Cloud (PPM, Financials, SCM, HCM)
- Familiarity with lakehouse or medallion architecture patterns (Bronze/Silver/Gold/Semantic)
- Experience with Apache ECharts embedded in React applications
- Experience delivering financial reporting for construction, real estate, or project-based industries
What We Do
WHO WE ARE: Data Society provides industry-tailored, high-quality data science training and advisory services for corporations and government agencies with a desire to make data driven decisions. We believe that modern organizations need to be equipped to make data driven decisions that significantly amplify the effects of existing subject matter expertise. These skills result in increased efficiency and more accurate analyses for research and operations. In order for organizations to become more data driven, they must develop a common data vocabulary across leadership, analysts and generalists. They must also empower their managers and technical staff with appropriate data science skills. Data Society solves both of these needs through customized data science workshops and online learning that help organizations stay competitive and accomplish their missions. OUR VISION: We are passionate about increasing data literacy on a global scale so that organizations and their employees can be smarter about data. We've seen how data analysis can solve problems and provide insights that lead to better business and policy decisions. We are dedicated to giving others the tools to approach problems strategically and building a community in which we answer the question "How can data science change the world?". OUR SOLUTIONS: Our expert data scientists and engineers work alongside your teams to make more informed decisions, automate time-consuming manual processes, solve your most complex data challenges, and build data systems to ensure the enduring impact of your work. OUR TRAINING: We teach data science in an intuitive, engaging, and applicable way so that you can apply the methods you learn in class right back in the workplace. We provide training through a combination of in-person, virtual, and online instruction with supplemental coaching and support. We don't just provide data science courses - we create communities of professionals who think about data differently.
.png)
