Senior Data Engineer

Senior Data Engineer/SQL/ETL/DWH/Data Analysis/PostgreSQL/AWS

    We are looking for individuals with the following skills and knowledge:

  • Interpret and analyze data from various source systems to support data integration and data reporting needs
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Work with team leads to prioritize business and information needs
  • Prepare high-level ETL mapping specifications.
  • Develop complex code data scripts (Primarily SQL) for ETL
  • Data Quality Control, Metrics
  • Troubleshoot & determine best resolution for data issues and anomalies
  • Manage exploratory data analysis to support database and dashboard development, as well as advanced analytics efforts
  • May assist in development of software technical documentation
  • Designs, specifies, implements, and maintains systems using Agile scrum methodology.
  • Advanced SQL skills - Adept at queries, report writing and presenting findings
  • Experience with different databases, including PostgreSQL
  • Expertise in Data Analysis, Data Profiling, and SQL Tuning
  • Expertise in translating business requirements to project design, development, and execution
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Ability to clearly communicate capabilities, opportunities, and recommendations to both technical and nontechnical audiences
  • Experience working in Data warehouse ETL & BI platforms and have a good understanding of related development activities and challenges
  • Strong knowledge of and experience with reporting, databases (SQL etc), programming (ETL frameworks, Cloud Integration, AWS and others)
  • Experience in understanding the source data from various platforms and mapping them into Entity relationship model(ER) for data integration and reporting.
  • Has deep understanding of data architecture & Datamodelling best practices and guidelines for different data and analytic platforms

For more information please contact joao@mccabebarton.com - 020 7796 3218