Manager, Sr Data Architect

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.

Summary:

The Global Data and Analytics team at SC Johnson is looking to add a Manager, Senior Data Architect to its team to meet the growing need for data and analytics services and products. In this role, you will make business data intuitive, reliable, and easy to use as part of a team of experts whose mission is to collect, connect, collaborate, and deliver data and insights for our business customers. You will collaborate with business and technology partners to strategize, crystalize, and build prioritized roadmaps for diverse, ambiguous, and evolving analytic products, driven by a data mindset — data architecture, data models, and data flows.

This is an onsite role in Racine, WI.

Essential Duties and Responsibilities:

• Translate business requirements and end user’s needs into architecture blueprints that deliver cost effective & high performing, high quality analytics solutions in compliance with S C Johnson’s standards, policies, and long-term technical strategies.

• Lead discussions and interactions with various business functions to capture data and analytical requirements and build a data roadmap.

• Define and maintain best practice guidelines for applying data warehouse/data lake modeling methodologies to design and develop appropriate data staging, integration and reporting structures that would provide for scalable and efficient reporting and analytics solutions.

• Provide assessments of architecture, devise strategies, and create roadmaps for technologies such as Azure Synapse, Fabric, ADF and Power BI.

• Facilitate cross-functional workshops to establish processes for data ingestion, validation, mining, engineering, modeling, visualization, artificial intelligence, and analytics.

• Works with master data and data governance teams to define best practices for master data and meta data management

• Work with data governance team to define taxonomy, master data domains, identify critical data elements, develop master data model, build data catalog and implement data quality rules.

• Lead the development of normalized and star schema data models (Conceptual, Logical and Physical), data dictionary, ETL mapping and data virtualization.

• Lead and actively engage in design sessions, demonstrations, prototyping, testing, and training workshops in collaboration with business users and IT associates.

• Translates data strategies into data integration frameworks and reporting to enable business analytics.

• Lead design and data model reviews with delivery teams.

Required Experience You’ll Bring:  

• Bachelor’s degree in computer science, Information Management, or related field.    

• 8+ years of experience in data/database design and development, including data warehouses, data lakes and master data management systems.

• 3+ years of experience working with Azure data platform capabilities including ADLS, Synapse, ADF and Power BI.

• 5+ years of experience as Data Architect

• 5+ years of experience with data modeling skills including strong foundation in data warehousing concepts, data normalization, dimensional data modeling, OLAP or data vault.

Preferred Experience and Skills

• Experience with modern cloud data platforms like Microsoft Azure Data factory/ Azure Synapse, Azure Databricks or Google Big Query.

• Working knowledge of master data management systems (MDM), experience in data warehouse and MDM integration.

• Strong understanding of data quality management principles and practices.

• Sound knowledge of data governance key functional areas like MDM, data catalog and data quality

• Experience working with different SAP platforms like SAP ECC, SAP PLM, S/4HANA etc.

• 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

•  Regular shift

• This position is 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.

#LI-MHI

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 [email protected]. All qualified applicants are encouraged to apply. Download the EEO is the Law poster for more information.