Associate Manager, Data Engineer
Racine, Wisconsin
Information Technology Job ID: 29806SC JOHNSON IS A FIFTH-GENERATION FAMILY COMPANY BUILT ON THE SPIRIT OF OUR PEOPLE. We have been leading with purpose for over 130 years, building iconic brands that win the hearts and minds of consumers – such as Raid®, Glade®, Ziploc® and more, in virtually every country around the world. Together, we are creating a better future – for the planet, for future generations and for every SCJ team member. Join our winning team of Wave Makers and Go Getters and help us write the next chapter in the SCJ story.
The Data and Analytics team at SC Johnson is looking to add an Associate Manager Data Engineer to its team to meet the growing need for data and analytics services and products. In this role, you will have the opportunity to work with process owners, product owners, business users and data scientists to deliver analytics and new data products projects.
This is an onsite role in Racine, WI.
KEY RESPONSIBILITIES
Build scalable and sustainable data pipelines from internal and external sources using Azure, Informatica, SQL and python to load data into data warehouse/data lake in support of new and existing data products.
Work with the project teams to capture business requirements for data and build appropriate data models and pipelines.
Lead discussions and interactions with various business functions to capture analytical requirements, use cases, create prototypes, and iterate on design with a product mindset.
Collaborate with business users, self-service analyst, and data scientist to drive solutioning and POC discussions.
Work with data and solution architects to ensure solution meets enterprise and data standards.
Work with data scientist and ML Operations to deploy data science models in production.
Define and own automation and monitoring frameworks for data pipeline quality and performance.
Partner with Platform engineers and administrators to ensure data pipelines meet performance and scalability requirements.
Define and maintain best practice guidelines for data engineering and modeling.
As the subject matter expert, provide guidance and mentorship on best practices, industry trends and research new capabilities and methodologies.
REQUIRED EXPERIENCE YOU’LL BRING
Bachelor’s Degree in Computer Science, Information Technology, Engineering, or related field and 5+ years of relevant experience or advanced degree with 3+ years of relevant experience. Military experience considered in lieu of education requirement.
5+ years of strong demonstrable experience with data integration tools like Azure Data Factory, Informatica, DataBricks etc.
2+ years of strong understanding of data modeling fundamentals – normalized, dimensional and data vault techniques
3+ years of using Advanced SQL knowledge for modifying and transforming data on MPP platforms like Teradata, Microsoft Azure SQL
Qualified candidates must be legally authorized to work in the United States
PREFERRED EXPERIENCES AND SKILLS
Knowledge of python for data transformation.
Experience with Microsoft Azure platform specifically around Data factory/ Azure Synapse/Azure Databricks and Azure AI and ML Studio.
Knowledge of data virtualization architecture.
Ability to quickly synthesize data from multiple sources and visualize results, skilled at data exploration and data analysis.
Partner and collaborate effectively across multiple team members in multiple time zones.
Ability to ask questions effectively with our business partners that lead to deeper understanding of the business problem.
Able to negotiate and adapt to changing situations and audiences.
JOB REQUIREMENTS
Full time on site in Racine, WI
0- 5% travel
Remote work is available once per week for eligible employees
Not eligible for domestic relocation
BENEFITS AND PERKS
SC Johnson’s total compensation packages are at or above industry levels. In addition to salary, total packages may include bonuses, long-term incentives, matching 401(k) contributions and profit sharing based on company profitability, job level and years of service. As a family company, we’re committed to providing benefits such as subsidized health care plans, maternity/paternity/adoption leave, flexible work arrangements, vacation purchase options, recreation and fitness centers, childcare, counseling services and more.
Inclusion & Diversity
We’re a global business, with people from every culture, ethnicity, race, religion, gender identity, sexual orientation, age and ability. We recognize the breadth of human experience, and we work to celebrate it. It is our goal to build a diverse, inclusive and supportive work environment where all people can thrive.
We’re committed to ongoing efforts that help us attract, hire, and retain diverse talent who want to build a positive, inclusive environment. Read more about our ongoing initiatives at https://jobs.scjohnson.com/inclusion.
Better Together
At SC Johnson, we strive to create a positive, inclusive and unique workplace. We strongly believe SCJ people are able to achieve their best when they can collaborate and work together in person.
Equal Opportunity Employer
The policy of the Company is to ensure equal opportunity for all qualified applicants and employees without regard to race, color, religion, gender, marital status, sexual orientation, national origin, ancestry, age, gender identity, gender expression, disability, citizenship, pregnancy, veteran status, membership in any active or reserve component of the U.S. or state military forces, genetic history or information or any other category protected by law.
Accommodation Requests
If you are an individual with a disability and you need an accommodation or other assistance during the application process, please call our Human Resources department at 262-260-3343 or email your request to SCJHR@scj.com. All qualified applicants are encouraged to apply. Download the EEO is the Law poster for more information.