Job Description

Job Overview:

In this Data Architect role, you will focus on designing and governing data architecture to facilitate data-driven decision making. Your responsibilities will include crafting and overseeing the implementation of efficient data ingestion strategies, ensuring robust ETL processes, and maintaining data quality and accessibility. You will leverage your expertise in Snowflake data warehousing, SQL optimization, and data integration technologies to drive the data strategy forward, with a primary emphasis on design and governance rather than hands-on implementation.

You will also have the chance to deliver data-driven organizational transformation, utilizing on-premises and cloud data and applying the best practices and methods in this field.

Your responsibility will be:

• Take the initiative and ownership of work streams and clients
• Design and architect to appropriately safeguard data security, data integrity, and data privacy at the conceptual and logical level.
• Own the definition and implementation of the Data Architecture Roadmap to support the client's strategic and operational roadmap.
• Design and implement data integration solutions to consolidate data from various sources into clients' analytical platforms and develop and manage data ingestion pipelines using modern technologies for timely and accurate data availability.
• Lead the development of efficient, scalable, and maintainable ETL processes and frameworks to extract, transform, and load data into the data artefacts.
• Collaborate with business analysts and stakeholders to create and maintain source-to-target mappings, documenting data lineage and transformation logic to ensure accurate data requirements.
• Implement best practices for data modeling, security, and performance optimization in Data Warehouse systems (Cloud and On-Premises) to design and manage data warehousing solutions.
• Collaborate with data engineers, data scientists, and business stakeholders to provide comprehensive data solutions while offering technical leadership and mentorship to junior team members.
• Provide technical expertise during client meetings, helping to address questions and concerns related to data architecture and management.

Key skillset required:

• Excellent problem-solving, attention to detail, and communication skills (written and spoken)
• Proven technical expertise in Data Architecture, Data Management, or in a similar role.
• Experience in system-level architecture and conducting dimensional modeling.
• Extensive experience in designing performant data warehouse schemas, e.g., star and snowflake schemas, with a deep understanding of the tradeoffs related to normalization/denormalization.
• Extensive experience working with Cloud or On-premises data warehousing systems like Snowflake, Synapse, Big Query, Redshift, Teradata, DB2, Oracle, etc.
• Experience in the management of structured, semi-structured, and unstructured data like tabular, parquet, Avro, JSON, XML, audio, video, etc.
• Experience with any major public cloud, preferably AWS, Azure, and their data services.
• Knowledge of big data technologies such as Hadoop, Spark, Flink, Kafka, Databricks, Synapse, etc.
• Proficient in SQL and experienced in query planning and optimization.
• Strong background in data integration, ETL development, and data ingestion technologies like DBT, SQL Mesh, Spark, Python, Matallion, etc.
• Experience with data profiling, source target mappings, and data quality management with tools like Open Metadata, Datahub, Great Expectations, Atlan, Alation, etc.
• Familiarity with testing methodologies and implementation processes.
• Familiarity with data governance and compliance standards like GDPR, HIPAA, etc.
• Experience with at least one major data visualization/BI platform such as Tableau, Power BI, Qlik, Cognos, etc. is a plus.

Job Tags

Similar Jobs