Brief Description
What Matters at Magid? YOU do!
"The number one key to growth is having good people and that’s what has driven us at every stage of the game." - Greg Cohen, CEO
At Magid we are
passionate about keeping workers
safe and proud of the innovative and collaborative environment we’ve created where diversity is celebrated, and growth never stops.
We are currently seeking an experienced Senior ETL Developer / Data Engineer to join the team. In this role, you will use your knowledge of data warehousing and architecture to develop data pipelines and help automate our data extraction, transformation, and loading processes. You will design, develop, and implement ETL processes for enterprise-wide data warehouses supporting our Power BI user community. You will serve as our technical lead for large, complex data integration projects. You will also collaborate with stakeholders to determine the data requirements that are necessary to support our business processes. If you are an active problem solver, who is not satisfied until the solution meets your high standards, then we are looking for you.
PLEASE NOTE: Applicants must be authorized to work for ANY employer in the U.S. At this time, Magid is unable to sponsor or take over sponsorship of an employment Visa.
Responsibilities Include:
- Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations.
- Creates, executes, and documents unit test plans for ETL and data integration processes and programs.
- Work with the data analysis team to assess and troubleshoot potential data quality issues at key intake points such as validating control totals at intake.
- Perform problem assessment, resolution, and documentation in existing ETL packages, mapping, and workflows in production.
- Documents ETL data mappings, data dictionaries, processes, programs, and solutions as per established standards for data governance.
- Integrates ETL development with existing projects to maximize object reuse.
- Experience moving data between disparate database systems (DB2, MS SQL)
- Experience with MS SQL Server Management Studio
- Ability to read / modify / create SSIS integration packages.
- Experience with Microsoft Gateway Services
- Experience with data modeling and analysis
- Ability to use Microsoft Office Suite
#IND1
Requirements
- A degree in engineering, computer science, or a related field.
- 6+ years designing, developing, testing and implementing enterprise ETL solutions
- Excellent Data Analytics skills.
- Experience with data visualization using PowerBI or Congos.
- Attention to detail.
- Excellent computer literacy skills.
- Ability to problem-solve under pressure.
- Excellent interpersonal and communications skills.
- Experience with Master Data Domains like PLM, PIM, CRM, is desirable.
This position is working in our Romeoville (IL) corporate office, working a hybrid work week of 3 days a week in office, 2 remote.
Magid does not offer relocation assistance.
Summary
Magid is an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.