Design and implement effective and scalable database solutions and models to store and retrieve organization data.
Create and maintain conceptual and physical data models that accurately represent the organization's data.
Implement data warehouse architecture standards, processes, and methodologies to ensure the integrity and accuracy of data.
Collaborate with stakeholders and cross-functional teams to gather requirements and design data models that meet the needs of the business.
Ensure data quality and integrity within the data warehouse and data marts.
Responsible for the architecture, modelling, design, development, testing, implementation, and maintenance of the ETL, procedures and structures which populate and grow our databases, data marts and tables.
Provide direction to fellow ETL developers on solution design and implementation. Ensuring standards are being followed.
Monitor system performance by performing regular tests, troubleshooting, and integrating new features.
Guide and coach staff members on standards, guidelines, best practices, and adherence to set standards.
Job Qualifications:
In-depth understanding of multi-dimensional and canonical design.
5+ years of data modelling experience utilizing the Power Designer tool.
7+ years of experience in architecting and building medium to large scale enterprise data warehouses and data marts.
Strong experience with Microsoft SQL Server, Azure Data Warehouse, and Snowflake.
Proven experience implementing data warehouse architecture standards, processes, and methodologies.
Able to hit the ground running with a can-do attitude.
Good written and verbal communication skills.
Bachelor’s degree in computer science, Computer Engineering or relevant field.