Associate Manager, Data Engineer

SC 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 IT 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, products owners, business users and data scientist to help build highly complex data pipelines to support analytics, visualization, and new data products.

Essential Duties and 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

• 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

• Define and own automation and monitoring frameworks for data pipeline quality and performance

• Work with data scientist and ML Operations to deploy data science models in production

• Partner with Platform engineers and administrators to ensure data pipelines meet performance and scalability requirements

• Lead discussions and interactions with various business functions to capture analytical requirements, use cases, create prototypes, and iterate on design with a product mindset

• 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 Skills / Experience / Competencies:

• Bachelor's Degree or military experience considered in lieu of education requirement

• 5 years of strong demonstrable experience with data integration tools like Azure Data Factory, Informatica 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 Skills / Experience / Competencies:

• 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 with occasional operational support outside core business hours

• Ability to travel when conditions return to normal ~10%

• Remote work is available once a week for eligible employees

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.

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.