Senior Data Warehouse Developer

Role Purpose

We are seeking an experienced and highly skilled Senior Data Warehouse Developer to join a dynamic and data-driven environment. This role is critical in the design, development, and maintenance of enterprise-level data warehouse solutions, ensuring high standards of data integrity, performance, scalability, and accessibility.

The successful candidate will be responsible for gathering, analysing, and interpreting data from multiple sources and transforming it into clear, accurate, and actionable insights. A key requirement of the role is the ability to present complex data in an easily understandable format for both technical and non-technical stakeholders.

Key Responsibilities and Outputs

Internal Processes

• Develop Power BI solutions based on high-level technical specifications aligned with business requirements.
• Perform quality assurance checks on all new Power BI functionality and reporting outputs.
• Produce and maintain comprehensive technical documentation for developed solutions and code.
• Configure and manage real-time data replication from source systems into the data warehouse using replication tools (e.g., Stelo SQDR or similar).
• Participate in operational support rotations, including troubleshooting reporting errors and responding to data queries.
• Collaborate with technical stakeholders to identify data sources, define master and metadata, and implement effective data solutions.
• Promote and enforce enterprise data standards to enhance data quality and ensure compliance with data governance principles.
• Design solutions that prioritise reusability, maintainability, reliability, and scalability.
• Process live and confidential data in line with defined security and compliance guidelines.
• Convert legacy Excel-based reports into Power BI dashboards.
• Design and develop professional dashboards and reports to support a wide range of stakeholders.
• Perform testing, debugging, and reconciliation of data to source systems to ensure accuracy and integrity.
• Ensure correct attribution of data to business costs and financial reporting requirements.
• Communicate progress and insights clearly using effective visual and narrative data representations.
• Proactively identify opportunities for improvement and provide analytical insights that support business decision-making.
• Design, develop, and implement robust and scalable data warehouse architectures.
• Develop, maintain, and optimise ETL/ELT processes for efficient data movement and transformation.
• Work closely with business analysts, data scientists, and other stakeholders to translate business requirements into technical solutions.
• Monitor and optimise data warehouse performance and resolve issues as they arise.
• Implement data governance, security, and best-practice controls.
• Provide technical guidance and mentorship to junior team members.
• Stay current with emerging trends, tools, and technologies in data warehousing and analytics.

Client and Stakeholder Engagement

• Provide authoritative technical expertise and advice to internal and external stakeholders.
• Maintain ongoing interaction with stakeholders to ensure alignment and understanding of data solutions.
• Deliver against agreed service level expectations.
• Contribute to a service-driven culture focused on collaboration, feedback, and high-quality stakeholder engagement.

People and Professional Development

• Build and maintain productive, collaborative working relationships.
• Continuously enhance professional, industry, and legislative knowledge.
• Contribute to innovation through the sharing and implementation of new ideas.
• Take ownership of personal career development and skills growth.

Behavioural Competencies

• Examining Information
• Generating Ideas
• Interpreting Data
• Articulating Information
• Producing Quality Output
• Providing Insights
• Team Collaboration

Skills Required

• Strong verbal and written communication skills
• Interpersonal and stakeholder engagement skills
• Analytical and problem-solving abilities
• Report writing
• Attention to detail
• Time management
• Critical thinking

Knowledge Requirements

• Business acumen
• Database and data warehouse development
• Software Development Lifecycle (SDLC)
• Intermediate SQL
• Intermediate Excel
• Intermediate data visualisation and analysis
• Data extraction and reconciliation techniques
• Intermediate Power BI
• Entry-level experience with data replication tools (e.g., Stelo SQDR, Qlik Replicate)
• SQL Server 2022
• SSIS
• T-SQL data warehouse development

Experience and Qualifications

• Minimum of 5 years’ experience as a Data Warehouse Developer or in a similar role
• Relevant 3-year degree in Mathematics, Economics, Computer Science, Information Management, Statistics, or related field
• Introductory Cloud Certification (advantageous)
• Strong SQL proficiency with experience in relational and non-relational databases
• Extensive experience with ETL/ELT tools and methodologies (e.g., SSIS, Data Factory, Informatica, Talend)
• Solid understanding of data warehousing methodologies (Kimball, Inmon)
• Experience in dimensional modelling (star and snowflake schemas)
• Exposure to cloud data platforms (e.g., Azure Synapse, AWS Redshift, Google BigQuery) advantageous
• Experience with data visualisation tools such as Power BI or Tableau
• Ability to work independently and collaboratively within a team environment

Advantageous Experience

• Exposure to big data technologies (e.g., Spark, Hadoop)
• Scripting experience (e.g., Python, PowerShell)
• Version control systems (e.g., Git)
• Experience across ETL and visualisation platforms