Data Warehouse Developer

Job Description

We are seeking a highly skilled Data Warehouse Developer to join our dynamic team. The ideal candidate will have extensive experience in designing, developing, and maintaining data warehouse solutions and data governance processes for data integrity. Key Responsibilities: Data Warehouse Development: Design, develop, and maintain data warehouse structures, data integration, and data cleansing. Use ETL tools to automate the data extraction from various sources and ensure data quality during the transformation process. Implement and manage data pipelines to ensure timely and accurate data availability. Optimize database performance and ensure data quality and consistency across the data warehouse. Data Quality Assurance Establish and maintain data quality standards and policies. Monitor and validate data quality and integrity through regular audits and validations Troubleshoot and resolve data-related issues to ensure accurate reporting Documentation and Best Practices: Document data warehouse structures, ETL processes, and Power BI reports to ensure transparency and knowledge sharing. Stay updated on industry best practices and emerging technologies related to data warehousing and business intelligence. Collaboration and Support: Work closely with key stakeholders and IT departments to integrate and support data solutions. Provide ongoing support and maintenance for existing reports and dashboards. Troubleshoot and resolve issues related to data accuracy, report performance, and user access. Qualifications: Education: Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field. Masters degree or relevant certifications are a plus. Experience: Proven experience as a Data Warehouse Developer or BI Developer. Hands-on experience with data modelling, ETL processes, and data warehousing concepts. Experience establishing data quality standards and documenting procedures. Experience with SQL Server, Azure Data Services, or similar technologies is preferred. Experience modelling data from ERP systems such as Microsoft Dynamics Nav or Business Central is highly advantageous. Additional experience with extending the data warehouse to PowerBi is advantageous. Skills: English speaking Strong analytical and problem-solving skills with attention to detail. Excellent communication skills, with the ability to translate technical concepts for non-technical stakeholders. Ability to work independently and collaboratively in a fast-paced environment. Familiarity with version control systems and agile development practices is advantageous.