Manager, Sr Data Architect

SC Johnson - Racine, WI

Full-time - Manager

Racine, WI

Chemical Manufacturing

About the position

The Manager, Senior Data Architect at SC Johnson will play a crucial role in the Global Data and Analytics team, focusing on creating intuitive, reliable, and user-friendly data solutions. This position involves collaborating with business and technology partners to develop strategic roadmaps for analytics products, ensuring compliance with company standards and long-term technical strategies. The role requires translating business needs into architectural blueprints and leading discussions to capture data requirements, ultimately delivering high-quality analytics solutions.

Responsibilities

• Translate business requirements and end user's needs into architecture blueprints for analytics solutions.
• Lead discussions with various business functions to capture data and analytical requirements and build a data roadmap.
• Define and maintain best practice guidelines for data warehouse/data lake modeling methodologies.
• Provide assessments of architecture and create roadmaps for technologies such as Azure Synapse, Fabric, ADF, and Power BI.
• Facilitate cross-functional workshops for data ingestion, validation, mining, engineering, modeling, visualization, and analytics.
• Work with master data and data governance teams to define best practices for master data and metadata management.
• Lead the development of normalized and star schema data models, data dictionary, ETL mapping, and data virtualization.
• Engage in design sessions, demonstrations, prototyping, testing, and training workshops with business users and IT associates.
• Translate data strategies into data integration frameworks and reporting for business analytics.
• Lead design and data model reviews with delivery teams.

Requirements

• 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 a Data Architect.
• 5+ years of experience with data modeling skills, including strong foundation in data warehousing concepts.

Nice-to-haves

• 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) and data warehouse integration.
• Strong understanding of data quality management principles and practices.
• Knowledge of data governance key functional areas like MDM, data catalog, and data quality.
• Experience with different SAP platforms like SAP ECC, SAP PLM, S/4HANA.

Benefits

• 401(k) matching contributions
• Profit sharing based on company profitability
• Subsidized health care plans
• Maternity/paternity/adoption leave
• Flexible work arrangements
• Vacation purchase options
• Access to recreation and fitness centers
• Childcare support
• Counseling services