Location: Des Plaines,IL, USA
Pay Transparency Statement:
The compensation philosophy reflects the Company's reasonable expectation at the time of posting. We consider a number of factors when making individual compensation decisions including, but not limited to, skill sets, experience and training, and other business needs. ?This role may also be eligible to participate in a discretionary incentive program, subject to the rule governing the program.
Position Summary:
The ETL Architect is responsible for designing, developing, and supporting data ingestion and transformation solutions that will be utilized in reporting, analytics, or within other applications. The position will also perform data analysis, construct technical designs, communicate with team members and business stakeholders, and support existing data ingestion and transformation pipelines. This position will also coordinate and review the work activities of offshore development and support resources.
Position Responsibilities may include, but not limited to:
* Responsible for the design, development, and support of data ingestion and transformation solutions
* Perform data analysis and create data models for peer review
* Provide guidance and direction to offshore support/development resources
* Communicate with other BI team members, offshore team members, and cross-IT staff on support and project activities
* Assist with task identification and effort estimates for ETL development
* Assist with risk and issue identification
* Provide off-hour/weekend support (on a rotating basis)
* Other projects or duties as assigned
Required Skills and Experience:
* Bachelor's Degree in Computer Science, Information Systems, or in a related discipline
* 4+ years of ETL development experience
* 2+ years of ETL design experience
* Design and development experience utilizing scheduling/automation tools preferably in the Azure environment
* Strong communication skills, including written and verbal communication skills
* Strong problem solving and analytical skills
* Strong ETL design skills
* Excellent ETL development skills utilizing an ETL tool, preferably utilizing Azure Data Factory
* Excellent SQL skills
* Strong understanding of Dimensional Modeling and other modeling techniques
* Strong understanding of SDLC best practices with an emphasis on DW/BI/Analytics practices
* This position must pass a post-offer background and drug test
Preferred Skills and Experience:
* Experience with orchestration in the Azure environment
* Snowflake data warehouse experience
* Azure DevOps experience
* GitHub experience
* MS Power BI experience
* Azure Blob Storage / ADLS experience with Data Storage, Analysis
* Data modeling experience
* Experience working with both structured and semi-structured data sources
* JavaScript and Python for stored procedures and scripting
* Experience leading offshore resources
* Microsoft Azure, Snowflake, and other relevant certifications
Physical Demands and Work Environment:
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Due to the nature of our business in regard to such things as delivery schedules, order inputs, selection, and Department of Transportation Hours of Service, overtime, attendance and punctuality are essential job functions. Should an individual in this classification not be able to adhere to this requirement due to a disability, they should contact their Human Resources department to see what, if any, reasonable accommodation may be made.