ETL / Data Developer

David Aplin Job Details

ETL / Data Developer

Halifax, NS

Permanent

Posted Date: 11/05/2022

Job ID: MH417980511

Information Technology

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. 
 
Responsibilities:
  • 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
Qualifications:
  • 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

  • Max. file size: 128 MB.
  • This field is for validation purposes and should be left unchanged.

Get notified for
similar jobs.

Sign up for Job Alerts