Job Description
Responsibilities
- Build and maintain business-ready data products and semantic models that translate curated enterprise data into accessible structures for analytics and reporting.
- Design, develop, and maintain semantic layer datasets (e.g., models, views, tabular models) aligned with business logic, KPIs, and reporting standards.
- Perform data transformations, aggregations, and modeling within the Gold/Presentation layer, applying business rules while maintaining data integrity and compliance.
- Write and optimize complex SQL queries to support analytics, reporting performance, and data model efficiency.
- Collaborate with enterprise data and governance teams to refine layer datasets, ensuring alignment between technical data structures and business requirements.
- Identify and resolve data quality, performance, and model alignment issues in partnership with enterprise data and governance teams.
- Resolve complex conflicts between business definitions, KPIs, and data models while ensuring consistency with enterprise standards.
- Document data models, semantic layers, and analytics solutions, including business definitions, mappings, and technical specifications.
- Contribute to the creation, maintenance, and evolution of Data Contracts, contextual data layers, and business ontologies, including:
- Defining and documenting data meaning, lineage, and ownership
- Aligning datasets to business domains, entities, and standardized definitions
- Supporting the development of a context layer that enables consistent interpretation and reuse of data products across teams
- Collaborate with cross-functional teams to deliver scalable and governed data products.
- Ensure adherence to data governance, security, and regulatory compliance through validation, documentation, and alignment with enterprise standards.
Minimum Qualifications (Knowledge, Skills & Abilities)
- Strong proficiency in SQL for data transformation, aggregation, and analysis.
- Experience with Business Intelligence tools (e.g., Power BI) and semantic modeling.
- Understanding of data modeling concepts, including star schema and dimensional modeling.
- Experience working with curated datasets in the Gold/Presentation layer and analytics-ready data products.
- Familiarity with data governance, data quality, and metadata management concepts.
- Ability to translate business requirements into data models, KPIs, and analytics solutions.
- Experience with modern cloud data platforms such as Snowflake, Azure, Databricks, or similar technologies.
- Familiarity with version control and collaborative development practices (e.g., Git, GitHub, pull/merge request workflows).
- Experience with CI/CD workflows and collaborative development methodologies.
- Exposure to performance optimization within semantic models and reporting layers.
- Strong analytical thinking, problem-solving, and stakeholder management skills
Are you interested in this position?
Apply by clicking on the “Apply Now” button below!
#GraphicDesignJobsOnline
#WebDesignRemoteJobs
#FreelanceGraphicDesigner
#WorkFromHomeDesignJobs
#OnlineWebDesignWork
#RemoteDesignOpportunities
#HireGraphicDesigners
#DigitalDesignCareers
# Dynamicbrand guru