David Aplin Group, one of Canada's Best Managed Companies, has partnered with our client in the monitoring and data analytics industry to find a talented ETL / Data Developer to join their team in Nova Scotia.
Reporting directly to the Network Operations Manager, this individual will be responsible for data mapping, design, development, unit test, and deployment of automated and manual ETL processes. In this role, the ETL / Data Developer will interface with internal business teams, customers, and partners to ensure effective data integrations and migrations. Our client provides a competitive compensation program, comprehensive health benefits, a matching RRSP program, and a remote working environment.
Utilize SSIS and other tools to develop, test, deploy, and maintain complex ETL processes and SQL code that include process logging, data validation, and integrity checks
Analyze business requirements for data requests to map and design ETL processes
Configure, monitor, and maintain SSIS packages and other automated ETL processes to ensure maximum performance, availability, and security
Optimize ETL extract/load performance and minimize concurrent OLTP impacts
Refine and automate complex manual processes using SSIS or other tools
Assist software developers with complex query tuning and participate in SQL code reviews
Work with database administrators, network administrators, system analysts, and software developers to resolve problems with ETL processes and data integrations
Effectively document and communicate database changes, issues, and risks to the appropriate stakeholders
Bachelor’s degree or relevant experience in a related field
Advanced level MS SQL (T-SQL) development and query performance tuning skills, as well as an understanding of database and data structures
Experience designing, developing, and implementing complex ETL automated and manual processes utilizing SSIS
Experience utilizing XML and JSON
Ability to perform complex data analysis and troubleshooting
Experience with Microsoft Reporting Services (SSRS)
Familiarity with Red-Gate tools will be a benefit in this position
Job ID: MH417980511
If you are interested in this position and meet the qualifications, apply today! We thank all applicants; however, only those who are authorized to work in Canada or are selected for an interview will be contacted.
David Aplin Group, one of Canada’s Best Managed Companies, is an employment agency specializing in finding top talent for exceptional organizations across North America. There are no fees to apply to our jobs or engage with our recruiters to find a new career. Companies hire us to help them grow their teams. Visit our website to learn more: www.aplin.com
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.