Advanced Data Engineer TA Apps

PowerToFly; Charlottetown; Hybrid; CAD 70,000 - 74,000; Full time

Job summary

A leading global investment firm in Charlottetown seeks a Database Developer to enhance their North American Transfer Agency services. The ideal candidate will possess 3-5 years' experience, particularly in SQL Server and Power BI. Responsibilities include supporting development processes and collaborating on quality assurance testing. This role offers an annual salary between $70,000 - $74,000, comprehensive benefits, and a hybrid work environment tailored for professional development and flexibility.

Benefits

Hybrid working environment

RRSP Contributions

Health & Wellness Benefits

Work flexibility Programs

Parental Leave Benefits

Study Support

Qualifications

• Minimum 3-5 years’ experience in database development.
• Experience with SQL Server stored procedures and transformations.
• Solid experience in Agile software development.

Responsibilities

• Complete tasks in software development life cycle.
• Build and test system components.
• Prepare documentation for system support.

Skills

Database development

SQL Server

Python

Agile methodologies

Problem analysis

Communication skills

Tools

Power BI

Stonebranch UAC

Business Objects

Embarcadero Studio

Job description

As one of the world’s leading independent global investment firms, Invesco is dedicated to rethinking possibilities for our clients. By delivering the combined power of our distinctive investment management capabilities, we provide a wide range of investment strategies and vehicles to our clients around the world. If you're looking for challenging work, intelligent colleagues, and exposure across a global footprint, come explore your potential at Invesco.

Job Description

The North American Transfer Agency (NATA) and Leveraged Solutions team sits within the realm of Distribution Engineering (D2E2). Their vision is to deliver compelling and competitive technology solutions that excite our clients, energize our employees, and protect the firm's business and client assets.

Key Responsibilities / Duties:

• Complete all tasks related to building and unit testing, quality assurance, system test and implementation in accordance with the Technology development life cycle
• Build and test system components or amendments
• Always conform to documentation, coding and quality standards as defined
• Review, discuss and work within agreed timescales and feedback to project managers any variances arising as tasks are performed
• Prepare for and support user acceptance testing
• Perform quality assurance tests on the work of other developers
• Prepare all necessary documentation and processes to enable ongoing support of the systems
• Communicate with internal and external customers, supervisors and management using clear, user-friendly terminology (emails, phone, meetings)
• Assist project and line managers in producing estimates for the development phase of projects and enhancements
• Third tier support escalation as required
• Participation in business recovery exercise as required

Work Experience / Knowledge:

• Minimum 3-5 years’ experience in a broad range of database development facets including some or most of the following:
• Development of stored procedures, packages and transformations on SQL Server and PowerBi
• Stonebranch UAC enterprise scheduler experience are a plus
• Development of data transformations and validations for database import/export activities (SQL Server Information Services, Python)
• Additional experience with Sterling Connect Direct, Business Objects, Embarcadero Studio platform knowledge are a plus
• Experience with full participation in software development methodology: Scope, Requirements, Design, Development, Testing, Deployment
• Solid experience of working in project teams and with third party vendors
• Experience with Agile software development

Skills / Other Personal Attributes Required:

• Enjoy challenging and thought-provoking work and have a strong desire to learn and progress (motivated enough to self learn)
• Ability to pick up new technology independently
• Must have good organization and planning skills – capable of managing own workload
• Be able to work under pressure and multi-task while remaining professional and courteous
• Ability to analyze requirements / problems and to propose innovative but workable solutions
• Team player
• Open minded, flexible, and willing to listen for other people’s opinions
• Interpersonal skills necessary to effectively communicate over the phone, Skype and via email with a variety of individuals at all technical levels are required
• Excellent verbal and written skills
• Financial Services domain experience a plus

The salary range for this position in Charlottetown is $70,000 - $74,000/year. The total compensation offered for this position includes salary and incentive pay and will vary based on skills, experience and location

Full Time / Part TimeFull timeWorker TypeEmployeeJob Exempt (Yes / No)NoWorkplace Model

Pursuant to Invesco’s Workplace Policy, employees are expected to comply with the firm’s most current workplace model, which as of October 1, 2025, includes spending at least four full days each week working in an Invesco office. This reflects our belief that spending time together in the office helps us build stronger relationships, collaborate more easily, and support each other’s growth and development.

What’s in it for you?

Our people are at the very core of our success and we strive to provide employees with a competitive total rewards package which includes:

• Hybrid working environment

• RRSP Contributions

• Health & Wellness Benefits

• Work flexibility Programs

• Parental Leave Benefits

• Study Support

The above information on this description has been designed to indicate the general nature and level of work performed by employees within this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job. The job holder may be required to perform other duties as deemed appropriate by their manager from time to time.

Invesco is committed to fair and accessible employment practices. If selected for an interview, we will work with you to ensure that your interview is accessible and accommodation is provided. Please contact us at [e-mail] or 1.800.874.6275 to let us know if you require accommodation for an interview due to a disability.