Senior Analytics Engineer

• Ability to apply advanced working knowledge of conceptual and physical BI implementations to demonstrates they are an expert within the area of Analytics and BI
• Adept at interacting directly with external clients in a verbal manner as well as having the interpersonal savvy to pick up on the nuances within the conversation from one client to the next and through those interactions be able to conceptualise what the overall end-to-end database architecture and data model would look like from the source to the destination of the data
• Advanced hands-on experience of working with and querying, structured, semi-structured and unstructured data within data warehouses, data lakehouses and data lakes both on-prem and in cloud (Microsoft SQL Server, Azure, AWS or GCP)
  • at least 8 yrs. of demonstrable advanced experience in SQL Server and cloud-based data stores to implement complex and robust solutions
• Advanced hands-on experience of ETL / ELT methods such as incremental and full load as well as advanced experience of the various tools to implement these methods such as Microsoft Fabric, Azure Synapse, Azure DataBricks, Azure Data Factory, SSIS, Python, dbt, Kafka, airflow to cater for complex data flows (at least 8 yrs. of demonstrable experience)
• Advanced hands-on experience of implementing real-time, near real-time or low latency analytics solutions (at least 8 yrs. of demonstrable experience)
• Advanced hands-on experience of implementing dimensional data models within analytics databases / data warehouses
• Advanced hands-on experience of working with Python / Spark packages for analytical data modelling, data analysis and data flows (panda, NumPy, scikit, etc.) as well as data visualisation (matplotlib, plotly, dash, etc.) to solve complex problems
• Advanced hands-on experience of BI tools – Power BI, Tableau, etc., (at least 7 yrs. of demonstrable experience) showcasing advanced storytelling and deep insights
• Advanced experience of various java libraries for front end development and embedding of visuals (i.e. D3, react, node, etc.)
• Ability to take a broad perspective to identify solutions and work independently with guidance in only the most complex situations
• Ability to guide others in resolving complex issues

Tasks (what does the role do on a day-to-day basis)

• Engaging with external clients, vendors, project reps, internal stakeholders from operations as well as client services teams to understand their analytics and dashboard requirements and interpret them into technical specifications
• Creating and maintaining high-level database and model architecture of the BI solution recommending best practice
• Conducting in-depth exploratory data analysis and define business critical features and critical data elements
• Working with key teams within Group Technology to get appropriate access and infrastructure setup to develop advanced visualisations (BI dashboards)
• Creating and optimize SQL Server stored procedures, views, queries as well as queries from multiple data sources to efficiently and effectively retrieve data from databases, employing the fundamentals of dimensional data modelling
• Designing and creating advanced and robust Data Solutions to develop best practice data warehouse solutions that support business analytics asks
• Creating, maintaining and document the different analytics solution processes created per project worked on
• Resolving IT and Data Issues. When database issues arise or support requests come in through Azure DevOps or the help desk, BI Developers are expected to work to resolve these problems. This requires a good understanding of legacy solutions and issues.
• Ensuring updates to Azure DevOps items, help desk tickets and work in progress are well communicated and escalations regarding the support being provided is kept to a minimum

Key competencies for position and level (see Group Competency model)

• Analytical Reasoning – Ability to identify patterns within a group of facts or rules and use those patterns to determine outcomes about what could / must be true and come to logical conclusions
• Critical Thinking – Ability to conceptualise, analyse, synthesise, evaluate and apply information to reach an answer or conclusion
• Conceptual Thinking and Creative Problem Solving - Original thinker that has the ability to go beyond traditional approaches with the resourcefulness to adapt to new / difficult situations and devise ways to overcome obstacles in a persistent manner that does not give up easily
• Interpersonal Savvy – Rel