Credera

Senior Engineer, Data

14 March 2024
Apply Now
Deadline date:
£45000 - £84000

Job Description

 

Description

We’re looking for someone with hands-on, business-oriented strategic and technical consulting to our clients for cloud infrastructure, automation solutions, and solution architecture.

In this role, you will:

  • Evaluate business needs, and objectives and build algorithms and prototypes.
  • Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports and reporting environments.
  • Conduct complex data analysis and report on results, analyze and organize raw data.
  • Identify opportunities for data acquisition by developing analytical tools and programs.
  • Collaborate with data scientists and architects on several projects.
  • Consolidate and optimize available data warehouse infrastructure.
  • Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports and reporting environments.
  • Assembles performance statistics, analyzes them, and makes recommendations for improvements.
  • Establishes system documentation and ensures it is continually sustained.
  • Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients.
  • Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
  • Carry out monitoring, tuning, and database performance analysis.
  • Design, automate, build, and launch scalable, efficient and reliable data pipelines into production.
  • Perform root cause analysis and resolve production and data issues.

Requirements

Technical Skills you bring in:

  • Experience and expertise with data models, data mining, and segmentation techniques
  • Experience with SQL database design
  • Experience with programming languages (e.g. Python)
  • Experience in combining raw data from different sources and conducting complex data analysis
  • Experience in building algorithms and prototypes and perform complex data analysis
  • Experience in design and implement ETL procedures for intake of data from both internal and external sources, as well as ensure data is verified and quality is checked
  • Experience in design and implement ETL processes and data architecture to ensure proper functioning of analytics, as well as client’s or third-party’s reporting environments and dashboard
  • Carry out monitoring, tuning, and database performance analysis
  • Minimum 1+ years of experience performing data warehouse architecture development and management
  • Minimum 4 years experience with technologies such as SQL Server, SQL and stored procedures
  • Minimum 1+ years experience developing code, testing for quality assurance, administering RDBMS, and monitoring databases
  • High proficiency in dimensional modeling techniques and their applications
  • Minimum 1 + years experience in custom ETL design, implementation and maintenance (ADF/Databricks/Synapse)
  • Advanced SQL skills is a must

Requirements / Qualifications:

  • Desirable: Bachelor or master’s degree in Computer Science or related technical field
  • Data engineering certification (preferable)
  • Ideally Intermediate English Proficiency (B2 reading, writing, and conversation).