Title: Sr. Data Analytics Engineer(Night Shift)
Location: Remote
Duration: 6+ Months
- Very strong SQL
- Experience in ETL and complex data transformations
- Strong attention to sematic modeling
- Experience in 3-tier/medallion architectures
- Understanding of warehouse modeling - fact and dimensions, star/snowflake schemas
- Experience in BI tooling (understanding the data requirements for BI development and how data is sourced for BI)
- Experience in Snowflake, Databricks, or similar cloud-native data warehouse
About the Role
This role focuses on designing, building, and maintaining business-ready data products within the Medallion Architecture, specifically the Gold and Semantic layers.
The position is responsible for transforming curated data into business-ready models, defining KPIs, business logic, and semantic structures, and delivering trusted, analytics-ready datasets and insights.
Key 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.
EoE