SENIOR SYSTEMS INTEGRATOR TECHNOLOGY SERVICES (Senior Data Engineer)

Job ID: 55784

Job Category: Information & Technology

Division & Section: Technology Services, Enterprise Services & Operations

Work Location: Metro Hall, 55 John St, Toronto

Job Type & Duration: Permanent, Full-time

Salary: $113,683.00 - $155,216.00

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 of Senior Systems Integrator Technology Services (Senior Data Engineer) should describe your qualifications as they relate to:

1. Post-secondary education in computer science, or the approved equivalent combination of education and/or experience.
2. 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.
3. Considerable experience with AWS Cloud services, including a suite of data platform tooling, AWS Glue, S3, AWS Athena, RDS, Redshift and Network features.
4. Extensive experience with the design, implementation, and optimization of data integration solutions, providing technical expertise and guidance in ETL and data pipeline development.
5. Extensive experience with various on premise and cloud connections for data exchange (e.g. OData services, Salesforce, Google, SQL Databases, etc.).
6. Considerable experience in troubleshooting and resolving issues related to data integration, transformation, ETL performance, and data accuracy.
7. 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.
8. Understanding of data warehousing concepts and familiarity with tools like MS Fabric including Data Factory and PowerBI.
9. Familiar with data and AI strategies, BI best practice and cloud architectures, and services
10. Strong written and oral communication skills, including the ability to present and compose written documents appropriate for clients.
11. Strong customer service orientation along with a demonstrated ability to establish and maintain effective stakeholder relationships.
12. Excellent problem-solving, leadership, facilitation, presentation and interpersonal skills.
13. Ability to work effectively as a team member, collaboratively with others in a multidisciplinary team environment and independently, as required.
14. Advanced time management and estimation capabilities and ability to perform several tasks and projects concurrently.
15. Ability to develop technology standards, techniques and product specifications.
16. Ability to work flexible hours including days, afternoons, nights and weekends, as required.
17. 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.

Accommodation

The City of Toronto is committed to creating an accessible and inclusive organization. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs. Disability-related accommodation during the application process is available upon request. Learn more about the City’s Hiring Policies and Accommodation Process.