Role PurposeThe Data Warehouse Developer will be responsible for designing, developing, and maintaining robust, scalable data warehouse and reporting solutions. This includes ensuring data quality, building efficient ETL pipelines, converting legacy reports, and delivering actionable insights through advanced data visualisation tools.
Requirements
Total Experience
Relevant Experience
- 5+ years as a Data Warehouse Developer or in a similar role.
- Strong proficiency in SQL and experience with various non/relational databases.
- Extensive experience with ETL/ELT tools and methodologies (e.g., SSIS, DataFactory, Informatica, Talend, etc.).
- Solid understanding of data warehousing concepts, including Kimball and Inmonmethodologies.
- Experience with data modeling (dimensional modeling, snowflake, star schemas).
- Familiarity with cloud data platforms (e.g., Azure Synapse, AWS Redshift, Google BigQuery) is a plus.
- Experience with data visualization tools (e.g., Power BI, Tableau) is beneficial.
Duties and Responsibilities
KEY ACCOUNTABILITIES/KRAs/KPIs
Internal Process
- Develop Power BI solutions, working from high level technical requirements in line with business requirements.
- Quality assurance checks on all new Power BI project functionality and business requirements.
- Produce documentation for written code.
- Configure real-time replication of data from the source system to the Data Warehouse, using tools like Stelo SQDR
- Partake in a roster of Operational Support, troubleshooting errors, and data queries on existing reporting.
- Basic interaction and collaboration with technical stakeholders to identify data sources, find data definitions for master and meta data as well as formulate and implement solutions.
- Promote the use of existing enterprise and divisional data standards to enhance data quality, ensure constant compliance and adherence to data governance principles.
- Promote reusability, maintainability, reliability, and scalability in design and development of data solutions.
- Process live and confidential data according to specified guidelines.
- Convert Legacy Excel reports to Power BI
- Development and design of professional reports and dashboards to support various stakeholders within the company.
- Testing, debugging & reconciliation of data to source data to ensure data integrity.
- Ensure accuracy and integrity of data & its attribution to costs incurred by business.
- Communicate progress, including easily understandable representation of the data.
- Proactive in suggesting opportunities as well as making analytical observations on any aspect that would be beneficial to business.
- Design, develop, and implement robust and scalable data warehouse solutions.
- Develop, maintain, and optimize ETL/ELT processes to ensure efficient data extraction, transformation, and loading.
- Collaborate with stakeholders, including business analysts and data scientists, to
understand data requirements and translate them into technical specifications.
- Ensure data quality, accuracy, and consistency across all data warehouse components.
- Monitor and optimize data warehouse performance, troubleshooting issues as they arise.
- Implement data governance and security best practices.
- Provide technical guidance and mentorship to junior developers.
- Stay updated with industry trends and emerging technologies in data warehousing and analytics.
Client
- Provide authoritative expertise and advice to clients and stakeholders.
- Continuous interaction with clients and internal stakeholders.
- Deliver on service level agreements made with clients and internal and external stakeholders to ensure that client expectations are met.
- Participating and contributing to a culture which builds rewarding relationships, facilitates feedback and provides exceptional client service.
People
- Develop and maintain productive and collaborative working relationships with peers and stakeholders.
- Continuously develop your own expertise in terms of professional, industry and legislative knowledge.
- Contribute to continuous innovation through the development, sharing and implementation of new ideas.
- Take ownership for driving career development.
As an applicant, please verify the legitimacy of this job advert on our company career page.
