Data Warehouse Engineer

Full Time
Chicago, IL 60601
Posted Today
Job description

Title: Azure Data Developer

Date: May 15, 2023
Location: Chicago, IL, US, 60601
Company: simsmetalm
3257

Sims Metal (Sims) is a global leader in metal recycling. With facilities across the globe, Sims plays an intrinsic role in the circular economy by making resources available for future use. As a responsible corporate citizen, we continuously seek new ways to broaden our participation in the environmental sector, ensuring that our future is as bright, safe, and secure as at any time in our long history.


Sims is proud to be an equal opportunity employer. We value the diversity of all of our employees, and we are committed to creating a working environment that is built on a foundation of respect and inclusion where everyone can contribute, advance on merit, and realize their full potential.


Role scope & responsibilities

Join Sims Limited and start creating a more prosperous future – for your community, for the planet and for yourself. From the moment you come aboard, you’ll find endless opportunities to pursue your passions, take on new challenges and explore the diverse business of a global player. And with the support of great managers, mentors and colleagues, you’ll be able to achieve everything you ever dreamed of and more. At Sims, your tomorrow starts today.


Sims Global IT Team is looking for a motivated Azure Data Developer to build modern data pipelines to ingest, process, transform, and model data into Sim’s Data. The developer will be a member of a team and be responsible for designing and engineering ETL pipelines from various applications using a combination of Azure Data Factory, Azure Data Lake, Azure SQL Server, and Azure Synapse Analytics.


  • Maintain current Azure Data Lake and improve upon it.
  • Maintain existing pipelines and create new pipelines using Azure Data Factory.
  • Maintain existing data flows and create new data flows using Azure Data Factory.
  • Connect to various cloud and on-prem data sources to perform ETL or ELT in an effort to organize business data into one Data Platform.
  • Diagnose and correct pipeline errors.
  • Work with different levels of the organization to identify new data and create plans to integrate the data into the Data Platform.
  • Collaborate with the Global Business Intelligence Director on the Azure costing and provide recommendations to improve performance or drive down costs.

QUALIFICATIONS & SELECTION CRITERIA

The ideal candidate should have:

  • 4 years of demonstrated Azure Data experience
  • General knowledge of the manufacturing industry and the data involved
  • Detailed knowledge of Azure data tools to include Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure SQL Server
  • Exposure with reporting and visualization tools like Power BI, SQL Server Reporting Services, Tableau or equivalent
  • Ability to communicate with IT and Business leadership, to discuss business issues and solutions
  • Experience connecting to API data
  • Use of DevOps for version control
  • Comfortable with standard SQL Server objects: tables, views, stored procedure, and functions
  • Experience with the Agile development style
  • Strong written, verbal communication, and presentation skills; the ability to get the message across and relate to the audience
  • Ability to effectively manage professional relationships, listening, encouraging discussion and promoting two-way communication
  • Experience with other ETL tools is preferred, especially BODS for SAP and SSIS
  • Experience with Data Warehousing techniques is preferred

Must have experience in the following technologies:


  • Azure
  • Azure Data Factory
  • Azure Data Lake gen2
  • Azure Synapse Analytics
  • Azure SQL Server
  • Azure SQL Serverless Pools
  • APIs
  • DevOps

Any exposure to the following areas is desirable:

  • BODS for SAP and any SAP data structure knowledge
  • Power BI or other visualization tools
  • Data Warehousing
  • SQL Server On-prem
  • Databricks
  • Industry knowledge to include Manufacturing, Logistics, or Recycling

With a promote-from-within philosophy and a variety of programs available to support continuous learning, Sims offers the opportunity for a rewarding career. We are committed to the ecologically sound and sustainable use of resources and strive to operate in a manner that minimizes waste and protects the environment.


A career with Sims provides you with the opportunity to work with an organization whose goal is to be the world’s safest and most responsible recycling company. Our people achieve this by creating a zero-harm workplace, being exemplary members of the communities in which we operate, and being responsible stewards of the environment. We also offer competitive pay and a range of attractive benefits.


Find Out More…

Please visit www.simsltd.com for more information on Sims and its commitment to sustainability.

SIMS LIMITED IS PROUD TO BE AN EQUAL OPPORTUNITY EMPLOYER. WE VALUE THE DIVERSITY OF ALL OF OUR EMPLOYEES AND ARE COMMITTED TO CREATING AN INCLUSIVE WORKING ENVIRONMENT WHERE EVERYONE CAN CONTRIBUTE, ADVANCE ON MERIT, AND REALIZE THEIR FULL POTENTIAL. SIMS LIMITED IS AN EQUAL OPPORTUNITY EMPLOYER. THE COMPANY DOES NOT DISCRIMINATE WITH REGARD TO RACE, SEX, RELIGION, COLOR, NATIONAL ORIGIN, CITIZENSHIP STATUS, DISABILITY, AGE, MARITAL OR FAMILIAL STATUS, SEXUAL ORIENTATION, GENDER IDENTITY, GENDER EXPRESSION, VETERAN STATUS, HOUSING STATUS, SOURCE OF INCOME, OR ANY OTHER STATUS PROTECTED BY FEDERAL, STATE, OR LOCAL LAWS. THIS APPLIES TO ANY EMPLOYMENT DECISION, INCLUDING RECRUITING, HIRING, PLACEMENT, PROMOTION, TERMINATION, LAYOFF, RECALL, TRANSFER, LEAVES OF ABSENCE, COMPENSATION, AND TRAINING. QUALIFIED APPLICANTS WITH A DISABILITY IN NEED OF A REASONABLE ACCOMMODATION MAY REQUEST SUCH WITHOUT FEAR OF REPRISAL OR DISCRIMINATION.



Nearest Major Market: Chicago

jjbodyshop.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jjbodyshop.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jjbodyshop.com is the ideal place to find your next job.

Intrested in this job?

Related Jobs

All Related Listed jobs