25 Jobs Found
Database analyst Full-time Job
IT & Telecoms MarkhamJob Details
Overview
Languages
English
Education
- College/CEGEP
Experience
3 years to less than 5 years
On site
Work must be completed at the physical location. There is no option to work remotely.
Responsibilities
Tasks
- Develop and maintain computer databases
- Enact measures to make sure unauthorized users cannot access the data
- Test data models and database management systems
- Design and develop database
- Operate database management systems to analyze data
- Develop and implement data administration policy, standards and models
- Research and document data requirements, data collection and administration policy, and data access rules
- Develop policies and procedures for network access and usage and for the backup and recovery of data
- Write scripts related to stored procedures and triggers
- Analyze data and prepare reports
Additional information
Personal suitability
- Efficient interpersonal skills
- Initiative
- Judgement
- Organized
- Team player
- Accountability
How to apply
By email
Database analyst
Visual Mood Ltd.
Markham - 33.82kmIT & Telecoms Full-time
42.75 - 46.75
Learn More
Senior Programmer Analyst with PHP, Python and SQL Full-time Job
IT & Telecoms Scarborough VillageJob Details
Contributes to the overall success of the Back Office Applications/CCA (Caribbean and central America) Technology, International Banking in Canada (Supporting CCA region) ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives. Ensures all activities conducted are in compliance with governing regulations, internal policies and procedures.
Accountabilities
- Champions a client centric culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
- Creating design procedures, write codes, perform testing, debug, trouble shoot technical issues and maintain source code of computer programs to support daily operations of back-office applications.
- Assist in creating technical documentation, objectives, and deliverables required to support technical troubleshooting and incident management.
- Assist with technical analysis based on business requirements, create test cases, and perform testing to support delivery of technical solutions.
- Understands how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
- Actively pursues effective and efficient operations of their respective areas in accordance with Scotiabank’s Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.
- Champions a high-performance environment and contributes to an inclusive work environment.
Dynamics specific to the role
- Countries / regions/business units supported/ Back Office Applications (Canada & CCA region)
- Financial dimensions (e.g., capital budget, annual project cost, operating budget, etc.)
- Regulatory bodies and special requirements/ Comply with Scotiabank’s IT Risk standards.
The incumbent is responsible for the supporting the following:
- Work with business partners to define their needs
- Good to have: Perform and develop data ingestion and extract request from EDL/Data Lake/Data Stage platform or other data source based on user request.
- Interpret data, analyze results using statistical techniques and provide ongoing support.
- Responsible for the solutioning & development of data related initiatives.
- Identify, analyze and interpret trends or patterns in complex data sets
- Filter and “clean” data
- Assist junior staffs to fulfil their assignment.
- May be required to provide off hour support for the ETL data related tasks.
- Good knowledge of Incident, Change management process and Service Requests, etc.
Education and experience:
Must have
- Extensive hands-on experience in PHP, Python, SQL, .Net, IIS, Java, HTML, Power BI, MS Office and MS Access etc.
- Hands on experience with Application support that requires knowledge and experience with bitbucket, JIRA and confluence (Agile methodologies)
- Experience of working in technology projects / supporting systems like ETL process (SSIS),
- Hands on Technology projects / supporting systems like ETL process (SSIS)
- Experience with SQL/NOSQL, scripting, automation, computing in the cloud, and application monitoring technologies.
- Working knowledge of at least one or more programming languages (JavaScript, Java, .NET, Python, Perl, Python, PHP, Bash, XML, HTML, C/C++/C#, RegEx, etc.)
- Bachelor’s degree in computer science or mathematics or Statistics.
- Adept at queries, report writing and presenting findings
Asset to have
- Proven working experience as a data analyst or related education.
- Technical expertise regarding data models, data mining, segmentation techniques, and Machine learning. Willing to learn or a fast learner
- Working knowledge of and experience with reporting packages (tableau, Power BI or Cognos)
- Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel).
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
- Experience with the usage of GitHub (or Git version control systems).
- Experience working in an agile development environment (Confluence, Jira, CiAD pipeline, Scrum/Kanban).
- Experience working with Sterling File Gateway is an asset.
What's in it for you?
- Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
- Accessibility and Workplace Accommodations - We value the unique skills and experiences everyone brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove, and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
- Remote-friendly work environment will provide you with the flexibility to perform at your best.
- Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
- Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
- Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!
#Li-Hybrid
#PHP
#Python
#SQL
Location(s): Canada : Ontario : Scarborough
Senior Programmer Analyst with PHP, Python and SQL
Scotiabank
Scarborough Village - 34.61kmIT & Telecoms Full-time
Learn More
Data Center Technician- Electrician Full-time Job
IT & Telecoms MarkhamJob Details
As a CBRE Data Center Technician, you will perform preventative maintenance and corrective repairs within a Data Center operation.
This job is part of the Critical and Technical Services job function. They are responsible for technical maintenance services in critical client environments.
What You’ll Do:- Assist with daily site inspections of all Mechanical & Engineering systems and technical equipment, including servicing and maintenance.
- Ensure the site's environmental conditions provide a safe work environment.
- React to Building Management System alarms, and complete emergency repairs as needed.
- Work with third-party vendors, ensuring compliance with company-developed processes, procedures, and all applicable laws and regulations.
- Alert management if subcontractor performance doesn’t meet all requirements per the Master Service Agreement.
- Complete planned preventative maintenance (PM) and reactive maintenance on all equipment.
- Check BMS for running and alarm conditions and respond to HVAC-related client problems.
- Building walkthroughs, taking meter readings from UPS, PDU’s and utilities.
- Provide fixes to facility and plant faults and defects.
- Complete assigned work according to established processes and procedures. Follow all safety processes and requirements and ensure all regulatory requirements and quality standards are met. Conduct routine quality checks for comprehensive maintenance records.
- Complete all required training to ensure successful completion of all job-related responsibilities.
- Use existing procedures to solve straightforward problems while having a limited opportunity to exercise discretion.
- Impact through clearly defined duties, methods, and tasks are described in detail.
- Deliver own output by following defined procedures and processes under close supervision and guidance.
- Training in a Technical discipline having served an apprenticeship or equivalent with 1-2 years of job-related experience. In lieu of a diploma, a combination of experience and education will be considered. Ability to work shifts that may include weekends and holidays
- Must be able to Meet the physical requirements of this role.
- To effectively present information to an internal department, client, management and/or colleagues.
- Ability to follow basic work routines and standards in the application of work.
- Communication skills to exchange straightforward information.
- Working knowledge of Microsoft Office products. Examples include Word, Excel, Outlook, etc.
- Strong organizational skills with an inquisitive mindset.
- Basic math skills. Ability to calculate simple figures such as percentages, discounts, and markups.
Data Center Technician- Electrician
CBRE
Markham - 33.82kmIT & Telecoms Full-time
Learn More
Data Engineer - AI & Machine Learning Full-time Job
IT & Telecoms MarkhamJob Details
We are seeking a skilled and experienced Data Engineer to join our dynamic and growing applied data analytics team. As a Data Engineer at BGIS, you will help us build our Analytics and AI Innovation Hub in Toronto. You will play an impactful and critical role in integrating and transforming our unmatched internal datasets with external data to drive insights, inform strategic decisions, and optimize our operations.
Responsibilities:
- Utilize your educational background in a quantitative field, such as computer science, mathematics, or engineering, to design, build, and maintain data pipelines and ETL processes.
- Leverage over five years of experience in data engineering, preferably with teams focused on machine learning, artificial intelligence, or data science.
- Design, build, and maintain robust data pipelines and ETL processes, ensuring data accuracy and accessibility for analysis and modeling.
- Develop and manage APIs for efficient data consumption, facilitating seamless integration and utilization of data across various platforms.
- Apply your passion for problem-solving to address complex data-related challenges, automate and optimize scalable data workflows.
- Maintain a strong understanding of data warehousing, cloud technologies, and big data solutions, constantly updating and improving our data infrastructure and knowledgebase.
- Communicate effectively across technical and business domains, collaborating with cross-functional teams to ensure the seamless integration of AI and data solutions.
- Participate in the development and deployment of AI and machine learning models, working closely with data scientists and analysts.
- Collaborate closely with data scientists and analysts, providing them with clean, structured analytical datasets necessary for advanced statistical modeling and machine learning.
- Demonstrate an aptitude for continuous learning, staying current with emerging technologies and best practices in data engineering, AI and analytics.
Qualifications:
- Bachelor's degree or higher in a quantitative field (Computer Science, Math, Engineering, etc.).
- Over five years of hands-on experience in data engineering, with some emphasis and familiarity with data preparation for AI and ML projects.
- A natural curiosity and enthusiasm for tackling challenging problems.
- Proficiency in data manipulation via SQL preferably using Snowflake
- Proficiency in data pipeline development, data modeling, data warehousing, and ETL processes.
- Familiarity with data visualization tools and techniques [Power BI, Tableau, Python libraries)
- Experience with data engineering technologies and data movement and transformation (e.g. Fivetran, DBT, Informatica, Dataiku, etc.)
- Excellent communication skills, with the ability to collaborate effectively with both technical and non-technical stakeholders.
- Proven track record of supporting delivery of actionable insights and solutions from complex data and analytic projects.
Why BGIS?
- Join a dynamic team at the forefront of data-driven decision-making in the commercial real estate industry, and at the creation of the BGIS Analytics and AI Innovation Hub.
- Collaborate with experts in the field and leverage cutting-edge technology.
- Competitive compensation package and opportunities for career growth.
- A supportive and inclusive work environment that values diversity and innovation.
Data Engineer - AI & Machine Learning
BGIS
Markham - 33.82kmIT & Telecoms Full-time
Learn More
Solutions Delivery Specialist Full-time Job
IT & Telecoms MarkhamJob Details
The Solutions Delivery Specialist is accountable for the technical direction and delivery within one of our strategic product areas. The span of accountability includes overseeing the evaluation, definition, development, modification, implementation, integration and alignment of related systems, processes and tools. Management (indirect) of delivery personnel and/or external vendors may be required from time to time. Managing operational issue resolution (as point-of-escalation with clients) will be required. This role is project & solution-delivery focused with internal client management duties. The particular product area opening we are actively recruiting for at this time is our Remote Command Center line of business.
KEY DUTIES & RESPONSIBILITIES
Technical Lead
- Determines and directs the delivery of appropriate technical solutions that align with business and Information Technology objectives, requirements, and standards.
- Directs a cross functional team engaged in the delivery of technology solutions (including internal and external personnel/ technologies and industry leading solutions).
- Implements Smart Building designs, including connection designs, IT/OT network architecture, system reliability, and leads technical discussions between BGIS InfoSec and project representatives.
- Integrates BAS networking and architecture with third-party systems via network connections and integration.
Strategic Planning
- Accountable for providing direction to the strategic plan of information management systems as it relates to Project Delivery in the commercial / construction space. Oversee the evaluation, definition, development, modification, implementation, integration and alignment (consistency) of related systems, processes and tools.
- Resource planning, project planning, business case development, staff management, systems development lifecycle oversight.
Compliance
- Represents his/her client interests at IT Governance.
- Develops, implements, audits and monitors compliance to standards (audit, client, industry, internal). Implements related best practices.
Relationship Management
- Collaborates with relevant concerned parties to understand business objectives and requirements.
- Directs client interaction at a senior level, representing RCC regarding Smart Building discussions, including connection designs, IT/OT network architecture, system reliability, and be the liaison between BGIS InfoSec and project representatives.
Other
- Other duties as assigned.
KNOWLEDGE & SKILLS
- University degree or college diploma in Computer Science, Engineering management, or related field with demonstrated knowledge that is usually acquired with 5 to 10 years of experience.
- Strong business knowledge.
- Strong understanding of technology elements and how they come together to deliver value within the organization.
- Strong knowledge of application development methodologies and integration techniques.
- Knowledge and experience with BAS networking.
- Excellent written and oral communication skills, including the tact and diplomacy required to interact with senior clients.
- Ability to interface at all levels within the organization from front line to executive.
- Project management and planning skills.
- Demonstrated success in delivering projects to multiple concerned parties – on time – on budget.
- Ability to influence, motivate, and inspire others.
Licenses and/or Professional Accreditation
- None required, but experience with construction / commercial project management and a PMP designation would be an advantage.
Solutions Delivery Specialist
BGIS
Markham - 33.82kmIT & Telecoms Full-time
Learn More
Data Center Technician Full-time Job
IT & Telecoms MarkhamJob Details
Data Center Technician
CBRE
Markham - 33.82kmIT & Telecoms Full-time
Learn More
Data Center Technician Full-time Job
IT & Telecoms MarkhamJob Details
Data Center Technician
CBRE
Markham - 33.82kmIT & Telecoms Full-time
Learn More
IT Project Coordinator (12-Month Contract) Full-time Job
IT & Telecoms MarkhamJob Details
The IT Project Coordinator collaborates with Solutions Consultants, Project & IT Managers, business leads, external clients and subject matter experts to drive the coordination of project activities across multiple programs. The IT Project Coordinator will be responsible for assisting the project team to develop and execute project plans for IT systems and services and to ensure that they are deployed into production environments in an efficient and effective manner. They will need to be well-organized and be able to work in collaboration with other IT teams in supporting managed services and larger projects.
KEY DUTIES & RESPONSIBILITIES
- Supports project leaders (Manager, Technical Product Management, Solutions Consultants, business leads with monitoring and coordination of scope, schedule, and overall project initiatives.
- Assists in developing project artifacts including the project charter, requirements, work breakdown structure, budgets, resource allocation, sprint logs, user stories, schedule, risk logs, action items, lessons learned, etc.
- Assists project teams with planning, coordination, and reporting.
- Assists with visualization and documentation of project scope and deliverables.
- Supports and facilitates project meetings, preparing agendas, presentations, and meeting minutes.
- Maintains communications with all team members.
- Coordinates projects in both agile and waterfall methodology.
- Assists in validating budget forecasts and provides on-going reconciliation of resources and other related project expenditures against set budgets.
- Effectively escalates early warning signs and deviations from the plan.
- Maintains project documentation repositories.
- Documents control; ensures projects adhere to frameworks and all documentation is maintained appropriately for each project.
- Tracking status of deliverables to ensure project deadlines are met.
- Attends and participates in stakeholder meetings.
- Develops project strategies to ensure alignment of team members, priorities based on vision to execute on time, within scope and on budget.
- Scheduling, organizing meetings and team member activities to contribute to project success.
- Provides regular status updates to team members and project leaders.
- Other duties as assigned
KNOWLEDGE & SKILLS REQUIRED
- A university degree/college diploma in project management, management information systems (MIS), or relevant work experience
- Minimum 2 to 3 years project management experience in I.T.
- Demonstrated knowledge and familiarity with project management frameworks, including cost, schedule, risk, issue and status tracking and monitoring
- Demonstrated ability to learn and work with new technologies and applications
- Experience supporting and coordinating a variety of small and large projects
- Experience with business process documentation techniques and tools
- Experience supporting and facilitating a variety of engagement sessions and meetings with technical and professional staff, vendors, and senior stakeholders
- Experience with Microsoft Office and MS Project
- Good written and verbal communication skills
- Good problem-solving and critical-thinking skills
- An ability to interpret flowcharts, schedules and step-by-step action plans
- Solid organizational skills, including multitasking and time-management
- Strong client-facing and teamwork skills
- Familiarity with quality assurance and quality control
Licenses and/or Professional Accreditation
- PMP certification is considered an asset
IT Project Coordinator (12-Month Contract)
BGIS
Markham - 33.82kmIT & Telecoms Full-time
Learn More
Software Developer Full-time Job
IT & Telecoms MarkhamJob Details
As a software developer you will play a vital role in a wide range of activities including new feature development, problem troubleshooting, and customer support in our Digit Labor software suites, development/maintenance/support of our software components and development environment, enhancing automations on our quality assurance and development infrastructure. You’ll be part of a team working on leading edge technology solving some of the world’s most complex problems and supporting the entire Digital Labor organization. Collaboration is at the heart of what we do, and you’ll be working closely with fellow developers, designers, and product managers to ensure our software aligns seamlessly with user expectations.
GSW24
Required Technical and Professional Expertise
- Software Development Expertise:
- Cloud Technology Proficiency:
- Database Technology:
Sound knowledge of databases, handling APIs, network requests, and general data manipulation.
- Artificial Intelligence and Machine Learning:
Familiarity with artificial intelligence and machine learning.
- Self-Starter Mindset:
A self-starter with a proactive mindset, able to initiate and drive projects independently.
- Excellent Problem-Solving Skills:
Demonstrated excellence in problem-solving, with the ability to tackle complex issues and find effective solutions.
- Collaborative Team Player:
Ability to work seamlessly as part of a team, contributing to collective goals and fostering a collaborative work environment.
Preferred Technical and Professional Expertise
- Experience working with Cloud ecosystems.
- Familiarity with Machine Learning and AI.
- Building and maintaining CI/CD workflows.
Software Developer
IBM Canada Limited
Markham - 33.82kmIT & Telecoms Full-time
Learn More
IT Project Coordinator (12-Month Contract) Contract Job
IT & Telecoms MarkhamJob Details
The IT Project Coordinator collaborates with Solutions Consultants, Project & IT Managers, business leads, external clients and subject matter experts to drive the coordination of project activities across multiple programs. The IT Project Coordinator will be responsible for assisting the project team to develop and execute project plans for IT systems and services and to ensure that they are deployed into production environments in an efficient and effective manner. They will need to be well-organized and be able to work in collaboration with other IT teams in supporting managed services and larger projects.
KEY DUTIES & RESPONSIBILITIES
- Supports project leaders (Manager, Technical Product Management, Solutions Consultants, business leads with monitoring and coordination of scope, schedule, and overall project initiatives.
- Assists in developing project artifacts including the project charter, requirements, work breakdown structure, budgets, resource allocation, sprint logs, user stories, schedule, risk logs, action items, lessons learned, etc.
- Assists project teams with planning, coordination, and reporting.
- Assists with visualization and documentation of project scope and deliverables.
- Supports and facilitates project meetings, preparing agendas, presentations, and meeting minutes.
- Maintains communications with all team members.
- Coordinates projects in both agile and waterfall methodology.
- Assists in validating budget forecasts and provides on-going reconciliation of resources and other related project expenditures against set budgets.
- Effectively escalates early warning signs and deviations from the plan.
- Maintains project documentation repositories.
- Documents control; ensures projects adhere to frameworks and all documentation is maintained appropriately for each project.
- Tracking status of deliverables to ensure project deadlines are met.
- Attends and participates in stakeholder meetings.
- Develops project strategies to ensure alignment of team members, priorities based on vision to execute on time, within scope and on budget.
- Scheduling, organizing meetings and team member activities to contribute to project success.
- Provides regular status updates to team members and project leaders.
- Other duties as assigned
KNOWLEDGE & SKILLS REQUIRED
- A university degree/college diploma in project management, management information systems (MIS), or relevant work experience
- Minimum 2 to 3 years project management experience in I.T.
- Demonstrated knowledge and familiarity with project management frameworks, including cost, schedule, risk, issue and status tracking and monitoring
- Demonstrated ability to learn and work with new technologies and applications
- Experience supporting and coordinating a variety of small and large projects
- Experience with business process documentation techniques and tools
- Experience supporting and facilitating a variety of engagement sessions and meetings with technical and professional staff, vendors, and senior stakeholders
- Experience with Microsoft Office and MS Project
- Good written and verbal communication skills
- Good problem-solving and critical-thinking skills
- An ability to interpret flowcharts, schedules and step-by-step action plans
- Solid organizational skills, including multitasking and time-management
- Strong client-facing and teamwork skills
- Familiarity with quality assurance and quality control
Licenses and/or Professional Accreditation
- PMP certification is considered an asset
Please note, this position requires a Reliability Security Clearance.
IT Project Coordinator (12-Month Contract)
BGIS
Markham - 33.82kmIT & Telecoms Contract
Learn More
Senior Full Stack Developer Full-time Job
IT & Telecoms Bedford Park-NortownJob Details
What is the opportunity?
Are you looking to make an impact across many teams? Excited at the thought of transforming the flows that help these teams deliver their products to production? If so, you’ve come to the right place.
We are looking for a Developer obsessed with efficiency and automation to be part of an autonomous team to deliver services for application teams across Capital Markets. An open minded individual who is not afraid to fail fast and pivot when needed. An individual who seeks out gaps and challenges to drive efficiency not only for other application teams but also for their own team. Knowledge sharing is key in this respect. As a Developer, you will participate in transforming DevOps for Capital Markets.
What will you do?
-
Skilled and knowledgeable engineer who will work to transform our technology
-
Build the state of the art, highly scalable data platform as a lead and/or contributor across the team
-
Develop as a contributor to the Standard Technical Services Portfolio
-
Build digital assets to serve our internal and external clients as necessary
What do you need to succeed?
Must-have
-
An engineer mindset, SDLC experience with production class delivery, strong analytical mindset, communication skills, and sense of ownership / drive
-
5+ years of development experience in one of the following languages: Python, RUST, GO, Elixir, Erlang
-
Experience with application and system design patterns
-
Experience with Docker or Kubernetes
-
Experience with Agile methodologies, ie SCRUM
Nice to Have Technology experience
-
Experience using DevOps CICD tools such as GitHub, Jenkins, UrbanCodeDeploy
-
Experience with a public cloud technology, ie AWS, Azure, GCP
-
Experience building or supporting distributed applications
Nice to Have Business experience
-
FinTech
-
DeFi
-
Crypto & Blockchain
-
AI/ML
-
Experience working with Agile/Scrum development methodology
What’s in it for you?
We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.
-
Positive work culture emphasizing diversity and inclusion, volunteerism and community involvement
-
A comprehensive Total Rewards Program including great benefits, annual incentive program and recognition
-
Leaders who support your development
-
A dynamic, collaborative, and high-performing team
-
Opportunities to do challenging work and grow your career
-
Work-life integration
649618712
649581846
#LI-Hybrid
#LI-POST
#TechPJ
Job Skills
Application Development, Application Integrations, Application Maintenance, Applications Architecture, Detail-Oriented, Enterprise Application Delivery, Group Problem Solving, Programming Languages, Software Development Life Cycle (SDLC), System Applications
Additional Job Details
Address:
90 WESTERN PKY:BEDFORD
City:
BEDFORD
Country:
Canada
Work hours/week:
37.5
Employment Type:
Full time
Platform:
CAPITAL MARKETS
Job Type:
Regular
Pay Type:
Salaried
Application Deadline:
2024-10-04
Senior Full Stack Developer
Royal Bank Of Canada
Bedford Park-Nortown - 49.49kmIT & Telecoms Full-time
Learn More
Data Engineer Full-time Job
IT & Telecoms OshawaJob Details
Status: Full Time, Permanent
Education Level: 4-year University education in computer science, computer/software engineering or other relevant programs within data engineering, data analysis, artificial intelligence, or machine learning.
Location(s): Pickering, ON
Travel: 10%
Deadline to Apply: September 18, 2024.
Salary Range: $1,651.02 - $2,832.86 Per Week
Ontario Power Generation (OPG) is looking for dynamic, strategic, and results-drivenprofessional to join our team in the role of a Data Developer.
Reporting to the Senior Manager, IT Programs, the Data Developer is primary responsible for building and supporting the data driven applications which enable innovative, customer centric digital experiences. You will be working as part of a cross-discipline agile team who help each other solve problems across all business areas. You will build reliable, supportable & performant data lake & data warehouse products to meet the organization’s need for data to drive reporting analytics, applications, and innovation. You will employ best practice in development, security and accessibility to achieve the highest quality of service for our customers.
KEY ACCOUNTABILITIES
- Build and productionize modular and scalable data ELT/ETL pipelines and data infrastructure leveraging the wide range of data sources across the organization
- Implement curated common data models that offer an integrated, business-centric single source of truth for business intelligence, reporting, and downstream system use, in collaboration with Data Architect
- Work closely with infrastructure and cyber teams to ensure data is secure in transit and at rest
- Clean, prepare and optimize datasets for performance, ensuring lineage and quality controls are applied throughout the data integration cycle
- Support Business Intelligence Analysts in modelling data for visualization and reporting, using dimensional data modeling and aggregation optimization methods
- Troubleshoot issues related to ingestion, data transformation and pipeline performance, data accuracy and integrity
- Collaborate with business analysts, data scientists, data engineers, data analysts, solution architects and data modelers to develop data pipelines to feed our data marketplace
- Assist in identifying, designing, and implementing internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
- Work with tools in the Microsoft Stack; Azure Data Factory, Azure Data Lake, Azure SQL Databases, Azure Data Warehouse, Azure Synapse Analytics Services, Azure Databricks, Microsoft Purview, and Power BI
- Work within the agile SCRUM work management framework in delivery of products and services, including contributing to feature & user story backlog item development, and utilizing related Kanban/SCRUM toolsets
- Assist in building data catalog and maintenance of relevant metadata for datasets published for enterprise use
- Develop optimized, performant data pipelines and models at scale using technologies such as Python, Spark and SQL, consuming data sources in XML, CSV, JSON, REST APIs, or other formats
- Document as-built pipelines and data products within the product description, and utilize source control to ensure a maintainable code-base
- Implement orchestration of data pipeline execution to ensure data products meet customer latency expectations, dependencies are managed, and datasets are as up-to-date as possible, with minimal disruption to end-customer use
- Create tooling to help with day to day tasks, and reduce toil via automation wherever possible
- Work with Continuous Integration/Continuous Delivery and DevOps pipelines to automate infrastructure, code delivery and product enhancement isolation and proper release management and versioning
- Monitor the ongoing operation of in-production solutions, assist in troubleshooting issues, and provide Tier 2 support for datasets produced by the team, on an as-required basis
- Implement and manage appropriate access to data products via role-based access control
- Write and perform automated unit and regression testing for data product builds, assist with user acceptance testing and system integration testing as required, and assist in design of relevant test cases
- Participate in peer code review sessions, and approve non-production pull requests
- Other Duties as Required
EDUCATION
- 4-year University education in computer science, computer/software engineering or other relevant programs within data engineering, data analysis, artifical intelligence, or machine learning
QUALIFICATIONS
- Minimum 6 years experience with Data Engineering
- Experience as a Data Engineer building data pipelines.
- Fluent in creating data processing frameworks using Python, PySpark, SparkSQL and SQL
- Experience with Azure Data Factory, ADLS, Synapse Analytics and Databricks
- Experience building data pipelines for Data Lakehouses and Data Warehouses
- Good understanding of data structures and data processing frameworks
- Knowledge of data governance and data quality principles
- Effective communication skills to translate technical details to non-technical stakeholders
What Makes a Career at OPG Different?
As Ontario’s largest clean energy generator, we’re building, expanding, and innovating the equipment and technology that keeps Ontario powered with clean, reliable energy.
At OPG, our values are our strengths. They are fundamental truths about our organization that don’t change:
Safety – it’s our business
Integrity – always lead with integrity
Excellence – never satisfied with good enough
Inclusion – working together for powerful outcomes
Innovation - creativity accelerates possibility.
Here's why OPG might just be the ideal workplace for you:
- Exceptional range of opportunities province-wide
- Long-term career growth and development opportunities
- Electricity is vital to the province and OPG’s clean electricity is helping decarbonize other sectors.
Our promise to you:
- We care about the safety and the well-being of our employees. It is our utmost priority.
- A supportive work environment where you can be your best every day.
- Opportunities to stretch and develop.
- Offer different ways for you to give back to communities where we operate.
- Partner with Indigenous communities and support local businesses.
- We support employment equity, diversity and inclusion.
Are you ready to start a career that has the power to electrify life on and off the job? Apply now.
Data Engineer
Ontario Power Generation
OshawaIT & Telecoms Full-time
Learn More