ETL/Data Warehousing N chicago, IL

Executive Staff Recruiters / ESR Healthcare; North Chicago (IL); On-site; USD 110,000 - 140,000; Full time

Job summary

ETL/Data Warehousing N Chicago, IL position focused on design, coding, testing and documentation of reusable objects using Snowflake and IICS. Lead end-to-end data warehousing and integration projects from requirements through deployment.

Collaborate with the Data Engineering team to implement solutions that meet business needs, while optimizing infrastructure and reducing data platform costs. Implement operational improvements, including controls, processes, and code reviews.

Qualifications

• Bachelor's or foreign education equivalent in Engineering, Computer Science or Biotechnology, or foreign education equivalent with 4 years of experience as a data architect or related field.
• 4 years in data integration, data warehousing, cloud initiatives, and development/implementation of data solutions; 3 years applying architecture patterns and data integration design principles; experience with data warehousing technologies and ETL.
• Experience partnering with vendors or implementation partners to optimize service delivery and leading end-to-end data engineering and data modelling activities.

Responsibilities

• Design, code, test and document reusable objects using Snowflake and IICS.
• Lead full lifecycle data warehousing and integration projects from requirements to deployment.
• Collaborate with Data Engineering team to implement solutions aligned with business needs.
• Optimize infrastructure and reduce data platform costs.
• Implement operational improvements, including processes, controls, and code reviews.

Skills

Snowflake

IICS

Data warehousing

ETL

SQL queries

Data modelling

Vendor management

Education

Bachelor's degree in Engineering/ Computer Science / Biotechnology

Tools

Clik

PowerBI

Job description

ETL/Data Warehousing N chicago, IL

• Design, code, test, & document reusable objects using Snowflake & IICS.
• Lead full lifecycle Data Warehousing & integration projects from requirements to deployment.
• Collaborate with Data Engineering team to implement solutions aligned with business needs.
• Optimize infrastructure & reduce Data platform costs.
• Implement operational improvements, including processes, controls, & code reviews.

Qualifications Education & Experience

Must have a Bachelor's or foreign education equivalent in Engineering, Computer Science or Biotechnology, or foreign education equivalent & 4 years of experience as a data architect or in related field.

• Of experience required, must have 4 years: (i) working in data integration, data warehousing, cloud-related initiatives, & development & implementation of data solutions; (ii) writing complex SQL queries; (iii) partnering with external vendors or implementation partners to optimize service delivery; (iv) working with data warehousing, data technologies, & ETL solutions; & (v) leading end-to-end data engineering & data modelling activities, including design, implementation, testing, deployment, & support; & Of experience required, must have 3 years: (i) applying architecture patterns & data integration design principles; (ii) working in a matrix organization, balancing customer needs against organizational goals; (iii) identifying & recommending appropriate product/service offerings to meet functional needs; (iv) executing project delivery & client relationship management within a technology environment; & (v) preparing data visualizations using Clik & PowerBI.