Senior Data Engineer

Job description

The Sr. Data Engineer at PremiStar is responsible for building and optimizing the company’s data infrastructure in support of Project Mosaic and the Enterprise Data Unification initiatives. Project Mosaic is PremiStar’s enterprise-wide ERP transformation built on Microsoft Dynamics 365 – aimed at unifying systems, standardizing processes, and improving real-time data visibility across all business units. In this role, The Sr. Data Engineer will develop and maintain robust data pipelines and unified data repositories (data lake and data warehouse) that consolidate information from Dynamics 365 and various legacy systems into a single source of truth. RESPONSIBILITIES: - Design, build, and maintain ETL/ELT processes that ingest and transform data from multiple sources (including D365 (Mosaic ERP) and legacy systems) into PremiStar’s Azure Synapse data lake and data warehouse. - Implement data cleansing, validation rules, and quality checks so that disparate data (from various business units and systems) is accurate, consistent, and ready for unified analysis. - Contribute to the design and expansion of enterprise data models and schema (e.g. star schema in the enterprise data warehou...