Associate Manager, Data EngineerRacine, Wisconsin Job ID 23027 Apply
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
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.
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.
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.