SENIOR SYSTEMS INTEGRATOR TECHNOLOGY SERVICES (Senior Data Engineer)

City of Toronto; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a Senior Systems Integrator in Technology Services. This role involves overseeing data integration solutions, managing workflows across hybrid environments, and ensuring adherence to security practices. You will lead projects, manage budgets, and collaborate with stakeholders to implement effective technical solutions. Ideal candidates will possess extensive experience with AWS Cloud services and SAP data integration methodologies. Join a forward-thinking organization dedicated to equity, diversity, and inclusion, where your contributions will significantly impact the community.

Qualifications

• Experience with SAP data platform integration methodologies.
• Strong knowledge of AWS Cloud services and data platform tooling.

Responsibilities

• Implement policies and procedures for program specific requirements.
• Supervise and train staff to ensure high standards of work quality.

Skills

SAP data platform integration

AWS Cloud services

Data integration solutions

ETL and data pipeline development

Data warehousing concepts

Troubleshooting data integration issues

Data security practices

Communication skills

Education

Post-secondary education in computer science

Tools

AWS Glue

AWS S3

AWS Athena

AWS RDS

AWS Redshift

MS Fabric

PowerBI

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert: Create Alert

Job ID: 55784

Job Category: Information & Technology

Division & Section: Technology Services, Enterprise Services & Operations

Job Type & Duration: Permanent, Full-time

Shift Information: Monday to Friday, 35 hours per week

Affiliation: Non-Union

Number of Positions Open: 1

Posting Period: 07-May-2025 to 21-May-2025

Major Responsibilities:

• Implements detailed plans and recommends policies/procedures regarding program specific requirements.
• Supervises, motivates and trains assigned staff, ensuring effective teamwork, high standards of work quality and organizational performance, continuous learning and encourages innovation in others.
• Supervises the day to day operation of all assigned staff including the scheduling, assigning and reviewing of work. Authorizes and co-ordinates vacation and overtime requests. Monitors and evaluates staff performance, approves salary increments, hears grievances and recommends disciplinary action when necessary.
• Provides input into and administers assigned budget, ensuring that expenditures are controlled and maintained within approved budget limitations.
• Leads, facilitates and contributes to the design, creation, development and sustainment of corporate standards for the division, including formalized project management and methodology, data warehousing architecture, data modeling, metadata, change management, and application development and migration.
• Responsible to senior management within the division, business and technical stakeholders for all aspects of assigned projects, including the project charter, project plan and schedule, progress, budget, risk management, issue management, change management, resource management, quality review/best practices.
• Provides project budget and financial management such as sole source requests; contract negotiations; leasing agreements; business cases; feasibility and cost/benefit analysis.
• Prepares and/or supervises the preparation of various formal contractual documents such as Request For Information/Proposal/Quotation (RFI/P/Q), Statement Of Work (SOW), Memorandum Of Understanding (MOU) and Service Level Agreements (SLA).
• Provides leadership in the evaluation, selection and recommendation of technical solutions and professional services; manages vendors and contractors in the overall solution delivery process.
• Identifies and develops divisional/cross-divisional initiatives to produce synergies and economies of scale.
• Negotiates with senior management, clients and various stakeholders often with competing and conflicting goals, objectives and priorities.
• Provides assessments and recommendations of new technology trends on the effective use, acquisition and integration of technology by the City.
• Identifies and analyzes current business processes and practices in the context of evolving information architecture and performance measures; prepares feasibility study and recommends overall technical solutions for business initiatives and leverage existing enterprise infrastructure investments.
• Recommends and implements security, privacy and quality assurance requirements consistent with both the Municipal Freedom of Information Privacy and Protection Act (MFIPPA), and corporate and legislated standards regarding the storage, processing and retention of confidential data.
• Recommends, establishes, and sustains various project management structures that span one or more levels of government such as the Provincial Offence Act and Social Housing downloading initiatives.
• Assesses and recommends scalable multi-jurisdictional business and technical solutions that meet client and business requirements in the context of corporate standards, policies and procedures for information technologies and architectures. This includes determining requirements, conducting research and evaluations and obtaining all approvals and signoffs.
• Informs and educates senior managers, business users and technology peers on technology trends, and the effective use of business and technology solutions and information management.

Key Qualifications:

Your application for the role ofSenior Systems Integrator Technology Services (Senior Data Engineer)should describe your qualifications as they relate to:

• Post-secondary education in computer science, or the approved equivalent combination of education and/or experience.
• Considerable experience with SAP data platform integration methodologies, including SAP Datasphere integration with public cloud technologies, and the ability to design and implement workflows across hybrid environments.
• Considerable experience with AWS Cloud services, including a suite of data platform tooling, AWS Glue, S3, AWS Athena, RDS, Redshift and Network features.
• Extensive experience with the design, implementation, and optimization of data integration solutions, providing technical expertise and guidance in ETL and data pipeline development.
• Extensive experience with various on premise and cloud connections for data exchange (e.g. OData services, Salesforce, Google, SQL Databases, etc.).
• Considerable experience in troubleshooting and resolving issues related to data integration, transformation, ETL performance, and data accuracy.
• Demonstrated knowledge implementing secure data practices, including both in transit and at rest by implementing robust data storage and access controls, encryption, and masking techniques.
• Understanding of data warehousing concepts and familiarity with tools like MS Fabric including Data Factory and PowerBI.
• Familiar with data and AI strategies, BI best practice and cloud architectures, and services
• Strong written and oral communication skills, including the ability to present and compose written documents appropriate for clients.
• Strong customer service orientation along with a demonstrated ability to establish and maintain effective stakeholder relationships.
• Excellent problem-solving, leadership, facilitation, presentation and interpersonal skills.
• Ability to work effectively as a team member, collaboratively with others in a multidisciplinary team environment and independently, as required.
• Advanced time management and estimation capabilities and ability to perform several tasks and projects concurrently.
• Ability to develop technology standards, techniques and product specifications.
• Ability to work flexible hours including days, afternoons, nights and weekends, as required.
• Ability to be on call for support of production systems, as required.

Equity, Diversity and Inclusion

The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity .