Company Name: Nycor Technical
Job Location: Edina
Job Type: Full-time
Work Type: Hybrid
Full job description
The Data Engineer is responsible for designing, building, and maintaining scalable data pipelines that support enterprise analytics and reporting needs. This role involves close collaboration with Business Analysts and Data Architects to translate business requirements into reliable, high-quality data solutions. No Visa Sponsorship is Available and no Relocation is available at this time.
Key Responsibilities
- Develop and maintain data pipelines using DBT within a Snowflake environment, following a medallion architecture.
- Cleanse and standardize raw data to ensure consistency and accuracy across systems.
- Apply dimensional modeling techniques to build fact and dimension tables for the enterprise data warehouse.
- Deliver curated datasets that are optimized for business consumption and reporting.
- Validate data outputs against business-defined test cases and ensure data quality through unit testing and analysis.
- Establish development standards, lead code reviews, and mentor team members to promote best practices.
- Research and recommend new tools or technologies to improve data engineering workflows.
- Integrate data from various source systems into Snowflake using tools such as Fivetran or HVR.
Qualifications
Required
- Bachelor’s degree in Computer Science, Information Systems, or a related field.
- Minimum of 5 years of hands-on experience in data engineering or data warehousing.
- Proficiency in SQL and at least one programming language (Python preferred).
- Strong understanding of ETL processes, data modeling, and analytics concepts.
- Experience with CI/CD practices using GitHub or Azure Repos.
- Familiarity with DBT and workflow orchestration tools.
- Experience with BI platforms such as Power BI, Tableau, or Qlik.
Preferred
- Background in manufacturing or industrial environments.
- Knowledge of data governance, structured/unstructured data, and reporting frameworks.


