SC Johnson - Racine, WI

posted 4 months ago

Full-time - Manager
Racine, WI
Chemical Manufacturing

About the position

SC Johnson is seeking a Manager, Senior Data Architect to join its Global Data and Analytics team. This role is pivotal in meeting the increasing demand for data and analytics services and products. As a Senior Data Architect, you will be responsible for transforming business data into intuitive, reliable, and user-friendly formats. You will work closely with business and technology partners to strategize and develop prioritized roadmaps for a variety of analytic products, all driven by a strong data mindset that encompasses data architecture, data models, and data flows. In this position, you will translate business requirements and user needs into comprehensive architecture blueprints that deliver cost-effective, high-performing, and high-quality analytics solutions. You will lead discussions with various business functions to capture data and analytical requirements, ultimately building a robust data roadmap. Your expertise will guide the definition and maintenance of best practice guidelines for data warehouse and data lake modeling methodologies, ensuring the design and development of scalable and efficient reporting and analytics solutions. You will also provide assessments of architecture and devise strategies for technologies such as Azure Synapse, Fabric, ADF, and Power BI. Facilitating cross-functional workshops will be a key part of your role, as you establish processes for data ingestion, validation, mining, engineering, modeling, visualization, artificial intelligence, and analytics. Collaboration with master data and data governance teams will be essential to define best practices for master data and metadata management, as well as to develop a master data model and implement data quality rules. Your leadership will extend to the development of normalized and star schema data models, data dictionaries, ETL mapping, and data virtualization. You will actively engage in design sessions, demonstrations, prototyping, testing, and training workshops in collaboration with business users and IT associates, translating data strategies into actionable data integration frameworks and reporting solutions that enable business analytics. Additionally, you will lead design and data model reviews with delivery teams, ensuring alignment with business objectives and technical standards.

Responsibilities

  • Translate business requirements and end user's needs into architecture blueprints that deliver cost effective & high performing, high quality analytics solutions.
  • 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.
  • 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.
  • Work with master data and data governance teams to define best practices for master data and meta data management.
  • 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, 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.
  • Translate data strategies into data integration frameworks and reporting to enable 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 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.

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), 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.
  • 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.

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
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service