Deliver real-time, consistent data solutions to manufacturing users while advancing analytics capabilities through AWS cloud migration.
Requirements
- Experience with SSIS, SSAS, and data analytics/transformation.
- Proven data engineering skills: ETL, data warehousing, real-time streaming, metadata, workflow management.
- Proficient in SQL, .Net, Python, and/or SSAS programming.
- Strong experience in data modeling, building ETL pipelines, and working with complex enterprise datasets.
- 2+ years working with AWS cloud databases (RDS, Redshift, Aurora, Postgres, Microsoft SQL).
- Familiarity with cloud BI deployments and AWS ecosystem.
- Experience with analytics tools: Hana, SSRS, Tableau, Alteryx, PowerBI.
Responsibilities
- Develop OLAP cubes and data transformation solutions.
- Build and automate data feeds from source systems (MES, PI, historians) into a data lake.
- Monitor and support ELT jobs for data transformation and aggregation.
- Document requirements, system specs, and code.
- Collaborate with stakeholders to analyze needs and deliver reports and metrics.
- Write secure, efficient SQL code (stored procedures, functions).
- Maintain high-quality code adhering to standards.
Other
- Bachelor's degree in Computer Science or Engineering and 4+ years IT experience.
- Communicate effectively with users, technical teams, and management.
- Identify critical manufacturing applications, dependencies, and business continuity requirements.
- Support month-end closing and standard IT procedures.
- Master's Degree in related field or industry.
