SQL Data Warehouse Developer

Responsibilities

They will be responsible for ensuring our data is in sync between systems, up to date, performance of databases, overall data management and analysis of data
Research, analyze, support, and implement database solutions and changes for the data warehouse
Gather business requirements and functional specifications
Transform complex customer business requirements into effective, efficient, and maintainable solutions
Modify data warehouse processes and objects as necessary to include best practice standards
Design, implement and maintain ETL processes from multiple data sources
Monitor production jobs and resolve any issues
Implement processes and systems to monitor data quality, ensuring data is always accurate and available for key stakeholders
Write and code logical and physical database descriptions and specify identifiers of database creating a data dictionary
Develop, implement and optimize Stored Procedures
Analyze existing SQL queries for performance improvement