KEY SKILLS REQUIRED
The Senior Analytics Engineer manages data flow in the data lakehouse, ensuring well-structured, high-quality data for analysis and strategic decision-making. Key responsibilities include designing scalable data architectures in conjunction with Domain and Product Data Architects, overseeing data pipeline development, and maintaining data integrity. This role involves collaboration with Domain and Business Data Stewards to align data solutions with organizational objectives. Below are the key technical skills needed by an Senior Analytics Engineer:
· Advanced SQL expertise is essential for querying, transforming, and managing data within databases to support business insights. Proven experience in developing and optimising ETL/ELT pipelines, particularly with tools like DBT, ensures efficient data transformation and modelling.
· A strong understanding of data modelling techniques, including star and snowflake schemas, is critical for structuring data for analysis. Proficiency in cloud platforms, such as AWS and GCP, with hands-on experience in services like Databricks, Redshift, BigQuery, and Snowflake, is highly valued.
· Advanced Python skills for data manipulation, automation, and scripting, using libraries like Pandas and NumPy, are necessary for effective data engineering. Expertise in managing and optimising data architectures within data warehouse and lakehouse environments is a core requirement.
· Proficiency in version control tools like Git ensures effective collaboration and management of code and data models. Experience with workflow automation tools, such as Apache Airflow, is crucial for streamlining and orchestrating complex data processes.
· Skilled at integrating data from diverse sources, including APIs, databases, and third-party systems, ensuring seamless connectivity. A strong commitment to data quality assurance is demonstrated through rigorous validation and monitoring processes throughout the data pipeline.
· Strong problem-solving abilities are essential for diagnosing and resolving pipeline issues while optimising performance for scalability. Knowledge of analytics platforms, such as Tableau and ThoughtSpot, ensures compatibility with data visualisation and reporting requirements.
What you’ll get in return
· Competitive base salary
· Up to 20% bonus
· 25 days holiday
· BAYE, SAYE & Performance share schemes
· 7% pension
· Life Insurance
· Work Away Scheme
· Flexible benefits package
· Excellent staff travel benefits
Apply
Complete your application on our careers site.
We encourage individuality, empower our people to seize the initiative, and never stop learning. We see people first and foremost for their performance and potential and we are committed to building a diverse and inclusive organisation that supports the needs of all. As such we will make reasonable adjustments at interview through to employment for our candidates.
#MP2 #LI-HYBRID