• Skip to primary navigation
  • Skip to main content
  • Skip to footer

1.844.822.0541

info@nexusgroup.ca

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • English
    • Français
  • Consultant Login
  • Find Your Opportunity
Nexus Systems Group

Nexus Systems Group

  • Home
  • What We Do
    • Staffing Solutions Made Easy
    • Contingent Workforce Management and Payroll Solutions
    • Technology Consulting and Delivery
  • Who We Serve
  • Who We Are
    • Our Team
    • News and Awards
    • Associations and Community
  • Contact Us
  • News

ETL Developer – SSIS/SSRS

January 19, 2022 by

ETL Developer – SSIS/SSRS
Location Address: Toronto Once Covid Restrictions Lifted (Will return in hybrid model)
Contract Duration: 12-18 months – currently til end of fiscal year because of funding (Possibility for extension or conversion)
Number of Positions: 1
Schedule Hours: 9am – 5pm

Story Behind the Need
Business group: Solution Architecture & Engineering – team works most closely with Global Human Resources team – part of GHRIT
Project: Solution Architecture & Engineering is seeking a ETL Developer to work on business as usual doing general ongoing support for the applications to cover for the individual on mat leave
Reason for request: Mat Leave

Candidate Value Proposition
The successful candidate will not only have the opportunity to gain valuable experience working with some of the most advanced technologies in the financial industry.

Typical Day in Role
– Primarily building ETL’s and supporting interfaces between the bank and multiple vendors
– Design and develop solutions to resolve complex, multi-faceted problems to meet the business needs of HR related systems. Ability to wear multiple hats at a time to run with multiple ongoing projects.
– Provide 3rd level application support in a timely fashion at times when required across multiple business units globally. Provide assistance to other team members during UAT testing and production rollout.
– Keep current on rapidly changing technological trends and maintain an understanding of the Division’s business and technology strategies.
– Maintain technical design documentation as required and contribute to ongoing definition of standards and Software Development Lifecycle processes.
– Not only work in a highly collaborative environment, but also come up with the ideas to further promote collaboration and efficiencies within the organization.
– Conducts routine and non-routine services and activities with minimal supervision
– Responded to queries of limited complexity, often of a sensitive and confidential nature.
– Provides functional guidance to junior team members.
– Identifies need for policy and procedural modification.
– Identifies and independently resolves routine issues as well as non-routine issues of limited complexity.
– Proposes solutions to moderately complex issues.
– Analyses data and prepares reports to be used in key decision making.
– Exercises some judgment and moderately complex decisions falling within standard policies.
– Elevates matters that fall beyond existing practice standards and procedures.
– Maintains working relationships with customer clients, suppliers, contractors and team members.
– Works closely with customers, Business Analysts, and team members to understand business requirements that drive the analysis and design of quality technical solutions.
– Involved in the full systems life cycle and is responsible for designing, coding, testing, implementing and supporting applications software that is delivered on time and within budget.
– Makes recommendations towards the development of new code or reuse of existing code.
– Responsibilities may also include participation in component and data architecture design; performance monitoring, product evaluation and buy vs. build recommendations.
– Provides guidance and training to less experienced analysts and programmers.

Candidate Requirements/Must Have Skills:
1) 5 – 7 years of experience with ETL Development
2) 5-7 years experience with Microsoft SSIS/SSRS (2014+) technologies / data management development
3) 3-5 years of experience with Windows/Linux environment and proficient in shell scripting, as well as standard encryption tools such as PGP
4) 3-7 years of experience with major transport protocols: FTP, SFTP and other SSH connectivity tools.
5) Must have excellent T-SQL development skills for Microsoft SQL 2008+

Nice-To-Have Skills:
1) Experience with Java development would be an asset
2) Experience with Microsoft Team Foundation Server (2018) would be an asset

Soft Skills:

Degrees or certifications:
Computer Bachelor’s degree (equivalent or higher) in Computer Science, Software Engineering or equivalent

Candidate Review & Selection
1 Interview with HM and Sr Manager
– Mixed technical / cultural only about 45
 

  • Apply Now
  • See All Jobs

Footer

ABOUT NEXUS SYSTEMS GROUP

Nexus is one of North America’s leaders in the provision of technology staff augmentation and strategic resource consulting. With a team of talented professionals using best of breed methodologies, Nexus consistently over delivers with quick, quality and trusted results to its clients and consultants.

LATEST OPPORTUNITIES

  • Senior Change Manager May 20, 2022
  • Java Developer x 3 May 20, 2022
  • Application Software Engineer- Expert May 20, 2022
  • Change Manager May 20, 2022

SOCIAL

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
Report on Business Canada's Top Growing Companies - Nexus Group
Nexus Group Growth 500 2019
Nexus Systems Group Growth 500 2018
NEXUS GROUP SYSTEMS GROUP INC. NEXUSGROUP.CA
  • Contact Us
  • Terms & Conditions
  • Privacy Policy