Create Alert
Apply now »

Senior ETL Developer

Category:  Digital & IT
Location: 

Mississauga, Ontario, CA

   

PURPOSE OF THE JOB

                                                                                                             

The primary purpose of the Senior Extract Transform Load (ETL) Developer is to help develop and deploy data warehouse BI solutions, data analytics and data integrations that support business processes and reporting needs of the organization and provide operational support on existing and new solutions.

 

 

KEY AREAS OF RESPONSIBILITY

 

  • Adapt the existing data warehouse and ETL processes to accommodate new business requirements that mainly include analytic requirements
  • Comply with the master data when building solutions
  • Ensure timely availability of data to the business stakeholders through timely execution of operational data loads
  • Design, enhance, and maintain SSIS packages to load data in a variety of formats and from a variety of source systems using built-in and third-party SSIS components
  • Be a key contributor to the modernization of our data structure – knowledge of Informatica MDM and MuleSoft valued
  • Develop SSIS packages in a multi-server environment using SSIS SQL configurations to share configured parameter values between packages
  • Leverage the full functionality of SSIS expression, script tasks, loop controls, etc.
  • Leverage the full functionality of T-SQL features as it applies to tables, views, stored procedures, user-defined functions, cursors, dynamic SQL, and partitioned tables
  • Develop, enhance, and maintain a variety of SSAS cubes that make use of partitions, perspectives, user hierarchies, many-many relationships, parent-child relationships, custom MDX calculations, DSV calculations, relative-time based calculations, etc.
  • Investigate assigned incidents and provide resolution
  • Administration:
    • As required, create new SQL Agent jobs, schedules, notifications, and configurations that execute SSIS packages
    • Use SQL Profiler and any other tools required to investigate, identify, and resolve issues in ETL, T-SQL, reporting, and legacy SQL applications
  • Maintain a documented history of changes to data systems
  • Complies with NN Quality Business Processes and Policies as outlined in ISOtrain by completing the required training and filing the corresponding Read and Understood Form in ISOtrain or the Training archive in order to ensure up to date information
  • Complies with IT internal processes as outlined on internal procedures and as instructed by other IT employees to ensure proper operation and control of IT system landscape
  • Continues own professional development by completing an annual development plan and executing against the plan to keep current with changing technology and to build competencies
  • Project Management exposure with an ability to understand project charters, Gantt charts and project budgets.

 

 

KEY COMPLIANCE

 

  • Complies with NN Quality Business Processes and Policies as outlined in ISOtrain by completing the required training and filing the corresponding Read and Understood Form in ISOtrain or the Training archive to ensure up to date information
  • Complies with IT internal processes as outlined on internal procedures and as instructed by other IT employees to ensure proper operation and control of IT system landscape
  • Complies with International and North American Standards in terms of tools, data best practices and architecture patterns to ensure economies of scale with broader Novo Nordisk technology ecosystem

 

 

EDUCATION (MINIMUM REQUIREMENTS)

 

  • University degree in the field of Computer Science, Engineering, or Management Information Systems
  • Project Delivery Certificates / Education considered nice to have (Agile Preferred).

 

 

EXPERIENCE (MINIMUM REQUIREMENTS)

 

  • Proven experience in overseeing the direction, development, and implementation of application software solutions in a corporate environment
  • 7+ years direct experience in all aspects of managing a Data Warehouse and reporting platforms in an enterprise environment. Including deep understanding of Data Quality, stewardship and general data management and reporting
  • Experience developing and executing practical implementation strategies
  • Experience in collaborating across multiple stakeholders in designing application solution strategies and roadmaps for future system capabilities and business needs
  • Proven experience in developing and delivering training to end users
  • Working knowledge of Customer Relationship Management Systems
  • Working knowledge of network and PC operating systems (Windows / iOS)

 

 

WORKING CONDITIONS:

 

  • Works in an open-office environment with exposure to multiple stakeholders regularly
  • Some lifting of computer equipment may be required
  • Occasional overtime may be required
  • Occasional out of town travel

 

APPLICATION DEADLINE: December 11, 2023.

 

 

We commit to an inclusive recruitment process and equality of opportunity for all our job applicants. 

 

At Novo Nordisk we recognize that it is no longer good enough to aspire to be the best company in the world. We need to aspire to be the best company for the world and we know that this is only possible with talented employees with diverse perspectives, backgrounds and cultures. We are therefore committed to creating an inclusive culture that celebrates the diversity of our employees, the patients we serve and communities we operate in. Together, we’re life changing.

 
Apply now »