Logo
The Nycor Group

Senior Data Platform Engineer (Edina)

The Nycor Group, Edina, Minnesota, United States

Save Job

Data Platform Engineer Position Overview As a Data Platform Engineer, you will be responsible for the ingestion, transformation, and maintenance of enterprise data used to serve analytics needs for the business. Working closely with Business Analysts and Data Architects, you will use your technical skills to understand and execute business requirements. This role requires strong fundamentals in data engineering and a collaborative, business-process-oriented mindset. Essential Job Functions Data Preparation (70% time allocation) Use DBT to move data through a medallion architecture in Snowflake. Apply standardization and resolve conflicts in raw layer data (cleansing). Use cleansed data and dimensional modeling techniques (Kimball) to create facts and dimensions in the data warehouse. Create curated, highly consumable data products that fulfill business needs. Represent business processes digitally in data models, ensuring accurate reflection of underlying processes. Quality Assurance (15% time allocation) Validate data outputs against Business Analyst provided test cases. Ensure quality of data pipelines via analysis and unit tests (standardization, completeness, grain, redundancy, etc). Team Development (10% time allocation) Set development standards and lead code reviews. Mentor other team members to develop their skills and abilities. Research technologies to improve processes. Collaborate with a team of 9 reporting to the BI Manager, including engineers, a Data Scientist, a Data Architect, and Business Analysts. Data Ingestion (5% time allocation) Use Fivetran/HVR to create data connections from source systems to Snowflake. Knowledge, Skills, and Abilities Minimum of 5-7 years of in-depth work experience in data warehousing or data engineering. Manufacturing industry experience required. Expertise in DBT and Snowflake (must-have). Strong fundamentals: Kimball Dimensional Modeling, Normalization vs. Denormalization, Type 1 vs. Type 2 dimensions, Cardinality, Data granularity and Aggregation, Hierarchies etc. Experience in ELT and data analysis with SQL and at least one programming language (Python preferred). Conceptual knowledge of data and analytics, including dimensional modeling, ELT, reporting tools, data governance, structured and unstructured data. Experience and/or knowledge of CI/CD practices using GitHub or Azure repos. Familiarity with ERP systems (D365 experience is a plus). Ability to design and build systems that handle data, including cleaning messy data and building real-time pipelines. Collaborative, optimistic personality with integrity; able to pivot quickly and work closely with business teams. Education / Experience Bachelor's degree in Business Information Systems, Computer Science, or equivalent. Related work experience in a manufacturing setting is preferred. Minimum of 5-7 years in data engineering roles. Additional Notes Ideal candidates understand the fundamentals of data engineering and can articulate their experience designing and building data systems. They should be collaborative, positive, and business-process oriented, avoiding rigid enforcement approaches. Flexibility and adaptability are key.

Please note: Unfortunately, No Visa Sponsorship or Transfers will be available for this position.