Data Engineering Applications Associate We are committed to investing in our employees and helping you continue your career at ScotiaTech. - Champion a customer-focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge. - Design and implement end-to-end ETL solutions from data analysis to deployment. Key Responsibilities: - Analyze complex business rules and logic, translating them into technical implementations. - Merge disjointed data sources, perform data transformation, and load data into SQL Server or Azure SQL DB. - Develop ETL processes using MS SQL Server BI stack, SQL Server Integration Services, and Azure Data Factory. - Conduct source data analysis and profiling, completing source to target mapping. - Model data infrastructure for fast querying of large volumes of data. Requirements: - Bachelor's degree in computer science, computer engineering, or related field required. - 3 years of experience in designing, developing, and deploying large-scale data warehouse projects. - Expert knowledge in SQL Scripting, SSIS, and Azure Suite. - Working knowledge of dimensional data modeling methodology. Working Conditions: Work in a standard office-based environment with non-standard hours.