CDC Data Architect

Design and Development: Build, enhance, and lead the company's logical, conceptual, and physical data models, demonstrating Snowflake's advanced capabilities.

Data Integration: Lead all aspects of the development of comprehensive data integration processes using ETL for various data types, including structured, semi-structured, and unstructured data, ensuring seamless integration with Snowflake.

Performance Tuning: Implement and fine-tune Snowflake features such as resource monitors, RBAC controls, scalable virtual warehouses, SQL performance tuning, zero copy clone, and time travel to optimize performance.

Data Security: Ensure robust data security and handle access controls effectively within the Snowflake environment.

Cloud Integration: Deploy cloud-based enterprise data warehouse solutions, Leverage AWS services such as S3, Glue, Athena, CloudWatch, and EMR to enhance data storage, processing, and analytics capabilities and integrate seamlessly with platforms like AWS and applying Snowflake's cloud-native architecture.

Data Governance: Uphold consistent data governance, testing, and continuous delivery practices, ensuring data integrity and compliance within Snowflake.

AI Integration: Incorporate AI and machine learning models into the data architecture, demonstrating Snowflake's capabilities to handle large-scale data processing and real-time analytics.

Snowpark/Python Development: Use Python/Snowpark for developing data pipelines, ETL processes, and automation scripts, ensuring efficient data handling and processing within the Snowflake environment

Teamwork: Serve as a data domain expert, working closely with various teams to ensure standard methodologies in data management are followed, and facilitate the integration of AI insights into business processes !

Candidate Profile / Key skills

Experience: At least 8 years in Data Engineering or Data Management Solutions, with a proven track record of improving data pipeline processes and leading initiatives.

Snowflake Expertise: A minimum of 5 years of meaningful experience with Snowflake.

Client Leadership: Skilled in leading data-centric client engagements.

Technical Proficiency: Demonstrable skills in sophisticated SQL, Unix Shell/Python scripting, performance tuning, and database optimization.

Cloud Technologies: Expertise in AWS services, including S3, EC2, Lambda, and Redshift.

Data Handling & Migration: Proficient in managing semi-structured data (JSON, XML) and using Snowflake's VARIANT attribute. Experience in migrating data from on-premises databases to Snowflake.

Automation: Skilled in crafting and developing automated data pipelines using Snowpipe and other relavant tools !

Database Experience: Hands-on experience with databases and data warehousing solutions such as Oracle, Microsoft SQL Server, AWS Redshift, or Snowflake.

Cloud Experience: Experience with AWS or Azure is a plus.

SQL Analysis: Strong SQL analysis skills and familiarity with tools like JIRA, Asana, or other relevant defect tracking tools. Experience in implementing data quality frameworks is an added advantage.

Programming Skills: Proficiency in Python, PySpark, or Snowpark is helpful. Additional expertise in Cortex or AI capabilities is a big plus.

LSEG is a leading global financial markets infrastructure and data provider. Our purpose is driving financial stability, empowering economies and enabling customers to create sustainable growth.

Our purpose is the foundation on which our culture is built. Our values of Integrity, Partnership, Excellence and Change underpin our purpose and set the standard for everything we do, every day. They go to the heart of who we are and guide our decision making and everyday actions.

Working with us means that you will be part of a dynamic organisation of 25,000 people across 65 countries. However, we will value your individuality and enable you to bring your true self to work so you can help enrich our diverse workforce. You will be part of a collaborative and creative culture where we encourage new ideas and are committed to sustainability across our global business. You will experience the critical role we have in helping to re-engineer the financial ecosystem to support and drive sustainable economic growth. Together, we are aiming to achieve this growth by accelerating the just transition to net zero, enabling growth of the green economy and creating inclusive economic opportunity.

LSEG offers a range of tailored benefits and support, including healthcare, retirement planning, paid volunteering days and wellbeing initiatives.

We are proud to be an equal opportunities employer. This means that we do not discriminate on the basis of anyone’s race, religion, colour, national origin, gender, sexual orientation, gender identity, gender expression, age, marital status, veteran status, pregnancy or disability, or any other basis protected under applicable law. Conforming with applicable law, we can reasonably accommodate applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs.

Please take a moment to read this privacy notice carefully, as it describes what personal information London Stock Exchange Group (LSEG) (we) may hold about you, what it’s used for, and how it’s obtained, your rights and how to contact us as a data subject.

If you are submitting as a Recruitment Agency Partner, it is essential and your responsibility to ensure that candidates applying to LSEG are aware of this privacy notice.