Data Engineer
Posted 1 week ago by Axiom Software Solutions Ltd
Negotiable
Undetermined
Hybrid
London, UK
Summary: The Data Engineer position is a long-term B2B contract based in London, UK, requiring a hybrid working arrangement with three days on-site each week. The role demands expertise in data analysis, SQL programming, and experience with various Azure services. Candidates should possess strong analytical skills and the ability to engage with stakeholders effectively. The position emphasizes integrity, self-motivation, and a focus on delivering results.
Key Responsibilities:
- Perform data analysis and exploration using T-SQL.
- Develop strong SQL programming skills, including stored procedures and functions.
- Utilize SQL Server and SSIS extensively.
- Apply data warehouse modelling methodologies such as Kimball and Data Vault 2.0.
- Work with Azure services including Data Factory, Databricks, and Synapse Analytics.
- Build and maintain robust ETL processes.
- Manage Analysis Services databases and cubes.
- Use source control and ADO effectively.
- Understand and implement deployment pipelines.
- Communicate effectively with stakeholders at all levels.
- Demonstrate strong organizational and problem-solving skills.
- Maintain a delivery focus and manage multiple priorities under pressure.
Key Skills:
- Expertise in Databricks, Data Factory, and Data Warehouse.
- Strong SQL programming and T-SQL skills.
- Extensive experience with SQL Server and SSIS.
- Knowledge of data warehouse modelling methodologies.
- Experience with Azure services.
- Ability to build and maintain ETL processes.
- Strong analytical and problem-solving skills.
- Excellent communication and interpersonal skills.
- Self-motivated with strong organizational skills.
- Ability to work under pressure and manage multiple tasks.
Salary (Rate): £300/Day
City: London
Country: UK
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Position: Data Engineer
Location: London, UK (Hybrid 3 days onsite a week)
Duration: Long Term B2B Contract
Job Description:
Must have: Databricks, Data Factory, Data Warehouse
Core skills and knowledge:
Excellent data analysis and exploration using T-SQL
Strong SQL programming (stored procedures, functions)
Extensive experience with SQL Server and SSIS
Knowledge and experience of data warehouse modelling methodologies (Kimball, dimensional modelling, Data Vault 2.0)
Experience in Azure - one or more of the following: Data Factory, Databricks, Synapse Analytics, ADLS Gen2
Experience in building robust and performant ETL processes
Build and maintain Analysis Services databases and cubes (both multidimensional and tabular)
Experience in using source control & ADO
Understanding and experience of deployment pipelines
Excellent analytical and problem-solving skills, with the ability to think critically and strategically.
Strong communication and interpersonal skills, with the ability to engage and influence stakeholders at all levels.
To always act with integrity and embrace the philosophy of treating our customers fairly
Analytical, ability to arrive at solutions that fit current/future business processes
Effective writing and verbal communication
Organisational skills: Ability to effectively manage and co-ordinate themselves.
Ownership and self-motivation
Delivery focus
Assertive, resilient and persistent
Team oriented
Deal well with pressure and highly effective at multi-tasking and juggling priorities