» More in this section

Senior ETL Developer

Posting Number: 6789
Company Description: Nova Scotia Power Inc.
Department Description: Corp. Information Technology
Number of Open Positions: 1
Location: CA - Halifax, Nova Scotia


Job Title:  Senior ETL Developer
Reference #:  6789
Type of Employment: Regular, Full time
Location: Halifax, NS


Nova Scotia Power’s greatest source of energy is our people. In a culture focused on safety and our customers, we’re committed to providing exceptional electricity service to Nova Scotians and rewarding careers for our employees. We’re hiring solution-minded people excited to help us grow into the future. Therefore we are currently looking to fill the position of Senior ETL Developer (Extract, Transition, and Load).

As a member of NSP’s Business Intelligence and Analytics (BIA) team, the Snr ETL Developer is responsible, working under the technical guidance of the Data Architect, for the design, development and testing of workflows, business rules, scripts and custom coding for data movement into target analytic data structures both in batch and in real time, as dictated by requirements. The individual in this position has a high degree of competency in ETL development and has significant, recent hands-on experience with both Microsoft SSIS and Oracle’s Fusion Middleware tool suite. 

The ETL developer has a sound understanding of ETL standards and best practices and ensures the quality and efficiency of the ETL processes through same.  In addition to ETL development, the individual in this position has a solid knowledge of and experience with real time data movement using EAI and/or service bus tools, data profiling, data quality assessment and data analysis techniques.


The ETL Developer will:

  • In adherence with standards provided by the Data Architect, create detailed ETL/data movement design specifications.
  • Have primary responsibility for the development and testing of ETL workflows, business rules, custom code and scripts to cleanse, transform and integrate data from a variety of sources (structured, semi-structured, etc.) into analytic data structures
  • Create detailed designs, develop and test real time or near-real time processes to meet requirements where low-latency data is required using tools such as Oracle Fusion Middleware or other tools such as Kafka.
  • Work with and assist data analysts in profiling and assessing the quality of data, both in source systems and in analytic data structures.
  • Play the secondary role of data warehouse administrator supporting in-production applications.
  • Be responsible for performing code reviews & testing results for work done by consultants & junior team members.
  • Provide coaching and mentoring to BIA team members about ETL skills and competencies to more junior ETL developer resources.

Skills, Capabilities and Experience:

  • Minimum requirement is a post-secondary degree in computer science, information systems or data/ information management or a suitable combination of formal education and experience.
  • Minimum 3-5 years of recent experience with ETL/data integration in a business intelligence system context and must include recent hands-on experience with Microsoft SSIS and Oracle Data Integrator.
  • Experience working with dimensional data models and other analytic data structures.
  • Deep knowledge of and experience with SQL Programming, both procedural and non-procedural, on the Oracle database platform. 
  • Thorough knowledge of and experience with an application programming language such as Java or Python a plus.
  • Ability to work effectively in a complex environment characterized by multiple, competing/shifting priorities.
  • Ability to communicate effectively both verbally and in written form (i.e., through technical documentation).
  • Effective knowledge of BI-specific delivery methodologies & familiarity with agile development methods and techniques

The successful candidate must be willing to complete a Criminal Background Check.

At Nova Scotia Power our employees are our greatest strength.  Our Leadership Competencies set standards that advance our business strategy, deliver results for customers, and provide career development for employees. As the ideal candidate, you speak up on health, safety and environment issues and demonstrate a belief that all injuries are preventable.  You support flexibility in the workplace and embrace change.  You build strong collaborative relationships with a commitment to a respectful, inclusive and productive work environment.   You demonstrate integrity and a commitment to operational excellence for our customers.   You proactively ask questions and seek information to understand and make informed decisions.

Reports To:  Director, Business Intelligence and Analytics

Salary: Commensurable with qualifications and experience.

To apply please click on the 'Apply' button at the end of the online posting and complete all required fields. Application deadline is 27th January 2020. Late applications may not receive consideration


Recruitment & Promotion Policy:  When filling vacant positions, we are determined to hire the best candidates available.  We're committed to providing employees with a fair and equal opportunity to compete for jobs.  Hiring and promotion of employees is based on skills, capabilities, knowledge and demonstrated abilities.

We value diversity in the workplace and strongly encourage applications from all qualified candidates including African Nova Scotians and other members of the visible minority community, Aboriginal peoples, persons with disabilities, and women in non-traditional roles.  Applicants from these designated groups wishing to self-identify may do so through a series of questions in the on-line application process.

Normally, unless otherwise requested in advance, the supervisors of internal candidates selected for an interview will be contacted in order to facilitate scheduling of the interviews.  The supervisor will maintain the confidentiality of the employee's application.



Complete for Returning Applicants (You have applied for a job with Emera, Nova Scotia Power, Emera Energy, Emera Utility Services or Emera Newfoundland, you are a returning applicant.)


Previous Applicants:

If you do not remember your password click here.

Complete for First Time Applicants (You have never applied for a job with Emera, Nova Scotia Power, Emera Energy, Emera Utility Services, Emera Newfoundland.)

Back to Search Results

New Search

Powered By Taleo