Senior Data Engineer

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 warehouse) to support new reporting needs and Mosaic's unified process definitions.
• Work closely with the Analytics and BI consulting partners to enable self-service reporting and advanced analytics.
• Prepare curated data sets for Power BI dashboards by writing efficient SQL queries or creating new pipeline components as needed.
• Collaborate with cross-functional teams - including business analysts, data scientists, and ERP specialists - to understand data requirements arising from Project Mosaic deployments and other business initiatives.
• Follow and promote software development best practices in analytics projects (version control, code review, documentation, etc.) and optimize existing data processes.

EDUCATION

• Undergraduate degree or equivalent in Computer Science, Information Systems, or a related field required.

EXPERIENCE

• 3-5 years of hands-on experience in the design, development, and support of data pipelines (ETL/ELT processes)
• 3-5 years of experience writing and optimizing SQL (T-SQL) queries and working with Microsoft SQL Server or similar relational databases
• 1-3 years of experience in data modeling and database design
• Prior experience in private equity backed industrial or multi-business-unit companies is a plus

SKILL REQUIREMENTS

• Strong SQL programming skills, particularly with Microsoft SQL Server, including the ability to write efficient T-SQL queries, create stored procedures, and perform performance tuning on database operations.
• Hands-on experience with Azure Synapse Analytics or similar cloud data warehousing technologies, including using Synapse (or Azure Data Factory) to create and orchestrate data pipelines, transform data at scale, and manage data lakes/warehouses.
• Familiarity with Microsoft D365 (Dynamics 365 Finance & Operations, and/or Customer Engagement) - or similar ERP/CRM systems.
• Proficient in Microsoft Power BI or comparable BI visualization tools, including an understanding how Power BI datasets and dataflows work.
• Knowledge of DAX and Power BI performance tuning is a plus, as is experience with SSRS or other Microsoft BI stack components (e.g. SSIS/SSAS).
• Strong understanding of data modeling concepts and tools.
• Experience with master data management or data cataloging in a unified data environment.
• Familiarity with data quality and profiling tools (i.e. using SQL or Python to implement data validation).
• Comfort with a programming or scripting language (e.g., Python, PySpark, or SQL scripts) to transform and manipulate data within pipelines.

PHYSICAL DEMANDS

• The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

WORK ENVIRONMENT:

This job operates in both an office and a field environment. Must be able to sit and/or stand for extended periods of time.

REASONABLE ACCOMODATION:

Reasonable accommodation will be made to enable individuals with disabilities to perform the essential job functions unless doing so presents an undue hardship on the Company's business operations.

OTHER DUTIES:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. Employees understand the above job description and agree to comply with and be subject to its conditions. Employee further agrees this job description does not alter his/her at-will employment status. Employees understand the Company reserves the right to delegate, remove, expand or change all responsibilities. Employees acknowledge that he/she can fulfill the above duties with or without reasonable accommodation.