Data Architect

JOB RESPONSIBILITIES:

• Develop an understanding of the organization's key data assets and work with data governance team to document key data sets in our enterprise data catalog
• Work with business stakeholders to build a conceptual business model by understanding the business end to end process, challenges, and future business plans.
• Collaborate with application architects to bring in the analytics point of view when designing end-user applications.
• Develop Logical data model based on business model and align with business teams
• Work with technical teams to build physical data model and data lineage and keep all relevant documentations
• Develop a process to manage to all models and appropriate controls
• With a use-case-driven approach, enhance and expand enterprise data model based on legacy on-premises analytics products and new cloud data products, including advanced analytics models
• Design key enterprise-conforming dimensions and ensure understanding across data engineering teams (including third parties); keep data catalog and wiki tools current
• Primary point of contact for new Digital and IT programs to ensure alignment to enterprise data model
• Be a clear player in shaping Organizations cloud migration strategy, enabling advanced analytics and world-leading Business Intelligence analytics
• Work in close collaboration with data engineers, ensuring data modeling best practices are followed

Measures of success:

• Demonstrated history of driving change in a large, global organization
• A true passion for well-structured and well-governed data; you know and can explain to others the real business risk of too many mappings tables
• You live for a well-designed and well-structured conformed dimension table
• Focus on use-case-driven prioritization; you are comfortable pushing business teams for requirements that connect to business value and also able to challenge requirements that will not achieve the business goals
• Developing data models that are not just elegant but truly optimized for analytics, both advanced analytics use cases and dashboarding / BI tools
• A coaching mindset wherever you go, including with the business, data engineers and other architects
• A infectious enthusiasm for learning: about our business, deepening your technical knowledge and meeting our teams
• Have a get things done attitude. Roll up the sleeves when necessary; work with and through others as needed

Key Qualifiactions & Experiences:

• Data Design and Governance
• At least 5 years of experience with data modeling to support business process
• Ability to design complex data models to connect and internal and external data
• Nice to have: ability to profile the data for data quality requirements
• At least 8 years of experience with requirement analysis; experience working with business stakeholders on data design
• Experience working with real-time data.
• Nice to have: experience with Data Catalog tools
• Ability to draft accurate documentation that supports the project management effort and coding
• Technical skills
• At least 5 years of experience designing and working in data warehouse solutions building data models; preference for having S4 Hana knowledge.
• At least 2 years of experience in visualization tools, preferably Power BI or similar tools. e
• At least 2 years designing and working in Cloud Data Warehouse solutions; preference for Azure Databricks, Azure Synapse or earlier Microsoft solutions
• Experience Visio, Power Designer, or similar data modeling tools
• Nice to have: Experience in data profiling tools (Informatica, Collibra or similar data quality tools).
• Nice to have: Working experience on MDx
• Experience in working in Azure cloud environment or similar cloud environment
• Must have : Ability to develop queries in SQL for assessing , manipulating, and accessing data stored in relational databases; hands-on experience in PySpark and Python
• Nice to have: Ability to understand and work with unstructured data
• Nice to have at least 1 successful enterprise-wide cloud migration being the data architect or data modeler. - mainly focused on building data models.
• Nice to have: experience working with manufacturing/digital manufacturing.
• Nice to have: experience designing enterprise data models for analytics, specifically in a PowerBI environment
• Nice to have: experience with machine learning model design (Python preferred)
• Behaviors and Attitudes
• Comfortable working with ambiguity and defining a way forward.
• Experience challenging current ways of working
• A documented history of successfully driving projects to completion
• Excellent interpersonal skills
• Attention to the details.
• Good interpersonal and communication skills
• Comfortable leading others through change