Data Architect
LA International
Redhill, United Kingdom
9 days ago
Role details
Contract type
Contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
EnglishJob location
Remote
Redhill, United Kingdom
Tech stack
Query Performance
Azure
Cloud Computing
Computer Programming
Databases
Continuous Integration
Data Architecture
Data Governance
Data Integrity
ETL
Python
Meta-Data Management
Microsoft SQL Server
Azure
SQL Stored Procedures
PL-SQL
SQL Databases
Azure
Snowflake
Ab Initio
PySpark
Star Schema
Data Management
Physical Data Models
Azure
Databricks
Job description
- Define and implement scalable data architecture leveraging Azure Data Factory (ADF), Azure Synapse Analytics, and Snowflake.
- Design logical and physical data models to support business requirements and analytics needs.
- Develop and maintain data pipelines using ADF for ingestion, transformation, and loading from diverse sources.
- Optimize ETL processes for performance and cost efficiency.
- Lead migration projects from Ab-Initio to modern cloud platforms (Azure + Snowflake).
- Ensure data integrity, quality, and compliance during migration.
- Write and tune SQL queries, stored procedures, and implement best practices for query performance.
- Work closely with business stakeholders, data engineers, and analysts to deliver solutions.
- Implement data governance, security, and lineage practices using Azure tools.
- Explore and integrate emerging technologies like Azure Databricks, Python, and orchestration frameworks for advanced analytics.
- Able to take key decisions with respect to technology landscape in data technologies weighing risk versus reward
Requirements
- Cloud & Data Platforms: Azure Data Factory, Azure Synapse, Azure Data Lake, Snowflake.
- Database & Querying: SQL Server, PL/SQL, T-SQL.
- ETL Tools: Ab-Initio (migration experience), Informatica (optional).
- Programming: Python, PySpark (preferred).
- Other: CI/CD with Azure DevOps, Data Modeling (Star/Snowflake schema), Metadata management.
- String analytical, Problem-solving and communication skills.
Desirable skills/knowledge/experience:
- Microsoft Certified: Azure Data Engineer Associate (DP-203).
- Experience in BFSI domain or large-scale enterprise data platforms.
About the company
LA International is a HMG approved ICT Recruitment and Project Solutions Consultancy, operating globally from the largest single site in the UK as an IT Consultancy or as an Employment Business & Agency depending upon the precise nature of the work, for security cleared jobs or non-clearance vacancies, LA International welcome applications from all sections of the community and from people with diverse experience and backgrounds.
Award Winning LA International, winner of the Recruiter Awards for Excellence, Best IT Recruitment Company, Best Public Sector Recruitment Company and overall Gold Award winner, has now secured the most prestigious business award that any business can receive, The Queens Award for Enterprise: International Trade, for the second consecutive period.