Data Engineer

Job Title: Data Engineers 

Job Location: Various and unanticipated worksites throughout the U.S. (HQ: Chicago, IL)

Job Type: Full Time

Reference ID:

JOB DESCRIPTION:  

Data Engineers for various and unanticipated worksites throughout the U.S. (HQ: Chicago, IL). Design and implement software solutions using database technologies in big data environments and develop data driven, analytical applications. Design, develop, and maintain ETL/ELT processes and Azure Data Factories to transform data. Use advanced software patterns and designs to code and implement data pipelines and setup systems. Develop scripts, tools, and methodologies for streamlining and automation modeling practices. Work with DBAs to monitor SQL query performance and optimize low performing SQL queries. Coordinate with cross-functional operational teams for managing delivery and deployment of database solutions. Troubleshoot and resolve data-related software production issues and analyze existing systems to provide recommendations for improvement. Monitor system performance, perform predictive maintenance, and perform system risk and reliability analysis. Assess new technologies before adoption and implementation. Work with operations to understand data needs and requirements and adopt Agile methodologies to develop and release software.  Participate in project planning meetings to help prioritize various features, determine feasibility and complexity of features, and provide timelines for completion of these features. Create use-cases and scenarios for functional, integration, and system testing. Participate in code review and optimization sessions with the development teams. Coordinate with cross-functional operational teams for managing delivery and deployment of software solutions, and work with global distributed teams. Provide guidance and support on various database architecture and design areas in data modeling and ETL/ELT solutions. Mentor data engineers. Technical Environment: Database technologies (Oracle, MySQL, PostgreSQL, SQL Server, Cosmos DB); Azure SQL; cloud based on-premises solutions; data modeling, ETL processes; Stored procedures, Functions, Triggers, Views and jobs; SQL; cloud based ETL and data integration services (Azure Data Factories (ADF)), pipelines on Azure Cloud; Unix, Unix Shell Scripting & Cron Job to generate flat files & scheduling jobs; Web API for interfaces; Web API for Web Scraping.

JOB REQUIREMENTS:  

Bachelor’s degree in Computer Science/Applications or Information Systems or Computer Engineering or related field plus 5 years of progressive experience in software development or database architecture or as a programmer/analyst required. Required skills: cloud based on-premises solutions; experience with databases (Oracle, MySQL, PostgreSQL), SQL Server, Azure SQL; data modeling and ETL processes; Stored procedures, Functions, Triggers, Views and jobs; expertise with SQL; cloud based ETL and data integration services, building ADF pipelines on Azure Cloud; Unix, Unix Shell Scripting & Cron Job to generate flat files & scheduling jobs; Web API for interfaces; working in big data environments and developing data driven, analytical applications; experience working with global distributed teams. Telecommuting permitted. 

The below range reflects the range of possible compensation for this role at the time of this posting. This range may be modified in the future.  An employee’s position within the salary range will be based on several factors including, but not limited to, relevant education, qualifications, certifications, experience, skills, seniority, geographic location, performance, shift, travel requirements, sales or revenue-based metrics, any collective bargaining agreements, and business or organizational needs. The salary range for this role is $147,472 - $147,472.

This job is also eligible for [bonus/incentive/commissions/equity] pay.  
We offer a comprehensive package of benefits including paid time off, medical/dental/vision insurance and 401(k) to eligible employees.  
 
An offer of employment may be conditional upon successful completion of a background check in accordance with local legislation and our candidate privacy notice. Your current employer will not be contacted without your permission.  
 
You can apply for this role through the Circana careers website or Intranet site for internal candidates.  The anticipated application deadline for this position is XX  
#LI-DNI