Job Title : Data Integration Specialist
Status : Regular Full Time
Working Conditions : Hybrid Working Environment - 3 days in the office
Education Level : University degree in Engineering, Science or Business
Location(s) : Courtice, ON
Deadline to Apply : October, 11th, 2023
Electrify your career and help build a brighter tomorrow.
Every generation has a challenge that defines them. At OPG, we are calling on all innovators, disruptors, thought leaders and change-makers.
Join us to electrify life in one generation and build a sustainable future powered by our electricity, our ideas, and our people.
Join OPG and make history.
Whether you work in the skilled trades or are a business professional, a career at OPG is an opportunity to electrify your life on and off the job.
ACCOMMODATIONS
OPG is committed to fostering an inclusive, equitable, and accessible environment where all employees feel valued, respected, and supported.
If you require accommodation during the application or interview process, please advise us as soon as possible so appropriate arrangements can be made.
If you require information in a format that is accessible to you, please contact [email protected]
JOB OVERVIEW
Ontario Power Generation (OPG) is looking for dynamic, strategic and results-driven professional to join our Enterprise Project Office team in the role of a Data Integration Specialist located in Courtice, Ontario .
The Data Integration Specialist is responsible for providing support to the Section Manager through deploying code changes to the TIBCO EBX Platform, handling SQL ETL and TSQL scripting tasks, and facilitating direct communication with stakeholders.
Your expertise in data integration, SQL scripting, and stakeholder management will contribute to the successful execution of our projects.
This position is within OPG's Enterprise Project Organization and is an incredible opportunity to gain exposure to projects across different lines of business including Renewable Generation, Nuclear Refurbishment, IT Projects, New Nuclear and more!
This is an exciting opportunity to work in an environment where you will contribute to Ontario Power Generation's continued growth and success in being Ontario's low cost electricity generator of choice.
KEY ACCOUNTABILITIES
- Deploy code changes to the TIBCO EBX Platform, ensuring smooth and efficient implementation.
- Collaborate with development teams to understand code changes and their impact on the TIBCO EBX Platform.
- Perform SQL ETL tasks, including data extraction, transformation, and loading, to support data integration processes.
- Develop and maintain TSQL scripts for data manipulation, data validation, and data cleansing.
- Work closely with stakeholders to gather requirements, provide technical guidance, and address any concerns or issues.
- Conduct data analysis to identify data quality issues, data inconsistencies, and opportunities for data optimization.
- Collaborate with cross-functional teams, including developers, database administrators, and business analysts, to ensure seamless data integration.
- Monitor and troubleshoot data integration processes, identifying and resolving any performance or operational issues.
- Maintain documentation for data integration processes, code changes, and troubleshooting procedures.
- Stay updated with industry trends and advancements in data integration, SQL scripting, and relevant technologies.
EDUCATION
4-year university degree, Computer Science, Engineering, or a related field
QUALIFICATIONS
- 6+ years of proven experience as a DevOps Engineer with expertise in CI / CD methodologies.
- Strong proficiency in CI / CD tools such as Jenkins, GitLab CI / CD, or CircleCI.
- Solid understanding of version control systems like Git and SVN.
- Proficient in scripting languages (e.g., Shell, Python, or PowerShell) for automation tasks.
- Familiarity with IBM WebSphere Application Server and its deployment processes is a definite asset.
- Experience with SQL, ETL, and database administration, including performance tuning and optimization.
- Knowledge of containerization technologies (e.g., Docker, Kubernetes) and orchestration tools.
- Strong problem-solving skills with the ability to analyze and debug complex issues.
- Excellent communication and collaboration skills to work effectively within cross-functional teams.
- Ability to collaborate and communicate well, both verbally and written, is essential.
- Ability to present information clearly and effectively.
- Comfortable working with / learning the application of various computer systems and software.
- Ability to work effectively and efficiently in a flexible hybrid office environment.
The successful candidate will exhibit uncompromising integrity and commitment to upholding corporate values, and the OPG Code of Business Conduct.
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 Integration Specialist
Conduct data analysis to identify data quality issues, data inconsistencies, and opportunities for data optimization. Job Title: Data Integration Specialist. Perform SQL ETL tasks, including data extraction, transformation, and loading, to support data integration processes. Develop and maintain TSQ...
API Integration Specialist
Outlier helps the world’s most innovative companies improve their AI models by providing human feedback.Are you an experienced software engineer who would like to lend your coding expertise to train AI models?.We partner with organizations to train AI large language models, helping cutting-edge gene...
Data Entry Clerk Work From Home - Part Time Focus Group Panelists
Data Entry Clerk Work From Home - Part Time Remote Focus Group Panelists. Data entry clerk experience is not necessary. If you are a data entry clerk or someone just looking for a flexible part time remote work from home job, this is a great way to supplement your income. No Data Entry experience ne...
Data Architect/Principal Data Engineer
Experience developing standards for database design and implementation of various strategic data architecture initiatives around data quality, data management policies/standards, data governance, privacy and metadata management• Working experience integrating with BI frameworks like Qlik, ThoughtSpo...
Senior Business Analyst - Finance
Business Analysts will partner with business functions to understand strategic direction and will not only support but will also drive, and architect system and process solutions that enable those strategic goals. As a Senior Business Analyst you will decompose business requirements into system capa...
Academic Administrative Assistant
ADMINISTRATIVE ASSISTANTThe Administrative Assistant provides support for the Academic Administration Team, including the Heads of our Junior, Middle and Senior Schools, the Director of Student Life and the Vice Principal. POSITION RESPONSIBILITIES Support logistical arrangements and provide adminis...
Data Entry Clerk Work From Home - Part-Time Survey Participants
Position: Data Entry Clerk Work From Home - Part-Time Focus Group Participants (Side Gig)We are seeking individuals to participate in National & Local Paid Focus Groups, Clinical Trials, Phone Interviews or Paid Surveys. Data entry clerk experience is not necessaryJob Benefits:Flexibility to take pa...
Administrative Assistant
Rehabilitation, Secretary, Equity, Administrative Assistant, Healthcare, Administrative, Research, Finance. As Administrative Assistant, you will act as a trusted liaison between the Office of Inclusion & Diversity (OID), the Office of Indigenous Health (OIH) and the Office of Access and Outreach (O...
Data Engineer - Synthetic Data Team
As a Data Engineer on the Synthetic Data Team at Ipsos, you will play a pivotal role in building and maintaining the infrastructure necessary to support our synthetic data initiatives. You have a solid foundation in data engineering, with experience in building and maintaining scalable data pipeline...
Data Scientist
The Risk Operations Data Science team is looking for a Data Scientist to develop advanced machine learning models, guide measurement, strategy, and data-driven decision making to support various risk and operational areas at the client. The Data Scientist will work closely with Credit, Risk, Product...