Data Warehouse Developer

What You'll Do
As a Data Warehouse Developer, you will be responsible for designing, developing, and maintaining data warehousing solutions on the Azure stack. You will implement the architectural strategies developed by the Enterprise Architect by building efficient data pipelines and ETL processes using tools like Azure Data Factory and Logic Apps. You will ensure data quality, security, and performance within the Azure environment while working closely with business users, analysts, and other stakeholders.

• Design and Develop Data Warehouses: Architect, create, and implement scalable, high-performing data warehouse solutions using Azure services. This includes working with the Enterprise Architect to translate high-level strategies into practical, functional solutions
• Build & Maintain ETL Processes: Develop and maintain robust ETL pipelines using tools like Azure Data Factory, Azure Functions, and Logic Apps to integrate data from diverse internal and external sources into the data warehouse
• Data Modeling and Schema Design: Design logical and physical data models, as well as schemas, that align with business requirements and optimize for efficient data storage, retrieval, and analysis
• Ensure Data Quality and Security: Implement comprehensive security measures to protect sensitive information and enforce data governance policies. You will be responsible for ensuring data accuracy, completeness, and consistency through validation and monitoring
• Performance Optimization: Continuously monitor and optimize database performance, query execution, and data loading processes within the Azure environment to ensure reliability and scalability
• Troubleshoot and Maintain: Proactively identify and resolve performance bottlenecks, data discrepancies, and other issues to ensure the overall health and stability of the data warehouse system
• Collaborate and Document: Work closely with business users, data analysts, and other stakeholders to translate data needs into technical specifications. You will also maintain comprehensive documentation of the data warehouse architecture, ETL processes, and data models to ensure clarity and supportability
• Implement Architectural Strategies: Act as the hands-on developer, coder, and implementer of architectural strategies developed by the Enterprise Architect, turning vision into reality through code and configuration

About You
You are an experienced and driven professional with a strong track record of designing and developing data warehousing solutions. You have a natural curiosity for technology and a passion for contributing to a more sustainable future. In addition, we believe that an individual with the following experience will have the best opportunity for success in this role:
Professional Experience & Skills:

• Proven experience in designing, developing, and maintaining data warehousing solutions on the Azure stack
• Demonstrated ability to build and optimize efficient ETL/ELT pipelines using tools like Azure Data Factory
• Experience with data modeling and schema design to optimize data storage and retrieval for reporting and analytics
• Familiarity with ensuring data quality, implementing data governance policies, and establishing security measures
• A solid understanding of performance optimization within the Azure environment, including Azure Synapse Analytics and SQL Data Warehouse
• Proven ability to collaborate with business users, analysts, and other stakeholders to understand data needs and translate them into technical specifications

Education:

• A degree in a relevant field such as Computer Science, Data Science, or a related technical discipline is preferred
• Equivalent professional experience in data warehousing will also be considered