Data Architect II Remote

Roles and Responsibilities

Typical activities that would be expected are:

• Responsible for building data lake, data foundation and analytical solution with standard design and modern cloud/hybrid architecture pattern
• Work with cross functional teams to make the data usable for functional users and applications to enable delivery of business values to customers
• Provide architectural leadership and vision for Next Gen Data Platform and Data Lakehouse
• Develop and maintain architectural roadmap for data products and data services plus ensuring alignment with the business and enterprise architecture strategies and standards
• Drive design and architecture for Data Transformation & aggregations, design and development of a roadmap, and implementation based upon current vs. future state in a cohesive architecture viewpoint
• Review and understand business requirements and technical designs for physical data design, data pipelines (ETL) and other technical integrations
• Build data pipelines for multiple storage solutions, including distributed platforms such as Databricks, Trino, Hadoop and MPP databases and cloud Data warehouse
• Design and implement low latency analytical platform services leveraging open source and cloud technology
• Design and implement data governance and MDM tools
• Designing and building data capabilities to support cloud data strategy, including fully automated data Pipelines, data curation and consumption

Preferred Candidate

• Decent SQL knowledge
• Able to suggest modelling approaches & Solutioning for a given problem.
• Significant experience in one or more RDBMS (Oracle, DB2, and SQL Server)
• Real-time experience working in OLAP & OLTP database models (Dimensional models).
• Comprehensive understanding of Star schema, Snowflake schema, and Data Vault Modelling. Also, on any ETL tool, Data Governance, and Data quality.
• Eye to analyse data & comfortable with following agile methodology.
• Adept understanding of any of the cloud services is preferred (Azure, AWS & GCP)
• Enthuse to coach team members & collaborate with various stakeholders across the organization and take complete ownership of deliverables.
• Experience in contributing to proposals and RFPs
• Good experience in stakeholder management
• Decent communication and experience in leading the team.