Architect - Enterprise Data Operations

Responsibilities

• Complete conceptual, logical and physical data models for any supported platform, including SQL Data Warehouse, EMR, Spark, DataBricks, Snowflake, Azure Synapse or other Cloud data warehousing technologies.
• Governs data design / modeling – documentation of metadata (business definitions of entities and attributes) and constructions database objects, for baseline and investment funded projects, as assigned.
• Provides and / or supports data analysis, requirements gathering, solution development, and design reviews for enhancements to, or new, applications / reporting.
• Supports assigned project contractors (both on- & off-shore), orienting new contractors to standards, best practices, and tools.
• Contributes to project cost estimates, working with senior members of team to evaluate the size and complexity of the changes or new development.
• Ensure physical and logical data models are designed with an extensible philosophy to support future, unknown use cases with minimal rework.
• Develop a deep understanding of the business domain and enterprise technology inventory to craft a solution roadmap that achieves business objectives, maximizes reuse.
• Partner with IT, data engineering and other teams to ensure the enterprise data model incorporates key dimensions needed for the proper management : business and financial policies, security, local-market regulatory rules, consumer privacy by design principles (PII management) and all linked across fundamental identity foundations.
• Drive collaborative reviews of design, code, data, security features implementation performed by data engineers to drive data product development.
• Assist with data planning, sourcing, collection, profiling, and transformation.
• Create Source To Target Mappings for ETL and BI developers.
• Show expertise for data at all levels : low-latency, relational, and unstructured data stores; analytical and data lakes; data str / cleansing.
• Partner with the Data Governance team to standardize their classification of unstructured data into standard structures for data discovery and action by business customers and stakeholders.
• Support data lineage and mapping of source system data to canonical data stores for research, analysis and productization.

Qualifications

Skills Required

snowflake , Data Warehousing, Data Operations, Data Analytics, Azure Databricks, Azure Machine Learning