-
Plant Engineer
1 day ago
OSCO Construction Group Saint John, NB, CanadaAbout Strescon LimitedEstablished in 1963, Strescon Limited has grown to become the largest precast, pre-stressed concrete manufacturer in Eastern Canada. Its primary market covers the Atlantic Provinces and the New England region of the United States. Strescon manufactures a wid ...
-
Project Engineering
1 week ago
Irving Oil Ltd. Saint John, NB, CanadaWe are seeking a Senior Project Engineer to join our Engineering Services team at our Home Office in Saint John, NB. In this position, you will work collaboratively to lead multi-disciplinary engineering teams on projects and/or programs using your engineering management, stakeho ...
-
Junior Technical Sales Associate
1 day ago
OSCO Construction Group Saint John, NB, CanadaAbout UsEstablished in 1963, Strescon Limited has grown to become the largest precast, pre-stressed concrete manufacturer in Eastern Canada. Its primary market covers the Atlantic Provinces, the New England region of the United States, and Bermuda. Strescon manufactures a wide ra ...
-
Senior Business Analyst
6 days ago
Airswift Saint John, NB, CanadaFunction IT & Telecoms · Job Type Contract · Date Added April 24, 2024 · Airswift is currently looking for aSenior Business Analyst, for one of our major clients in the EPC industry – inSaint John, NB. This position has a5/40 schedule andis on-site for a1-year contract. (Only ...
-
Senior Project Engineer
3 days ago
Irving Oil Ltd. Saint John, NB, CanadaWe are seeking a Senior Project Engineer to join our Engineering Services team at our Home Office in Saint John, NB. In this position, you will work collaboratively to lead multi-disciplinary engineering teams on projects and/or programs using your engineering management, stakeho ...
-
Estimator - Manufacturing
3 weeks ago
Borcherdt Concrete Products Limited Saint John, NB, CanadaBachelor's Degree · Full time · Petro Service Limited is an industry leading solutions provider to the fueling landscape with operations throughout Canada.Established in 1985, Petroservice evolved from rebuilding gas pumps to being one of the fastest growing Petroleum Service p ...
-
Area Office Manager
2 weeks ago
Personnel Search Ltd. Saint John, NB, CanadaReporting to the Director, of Operations, the Branch Manager will be responsible for the achieving key performance measures and providing safety leadership. · Responsible for the safety, leadership, and management of the day-to-day activities for the Saint John Branch · Adhere ...
-
Project Cost Estimator
2 weeks ago
OSCO Construction Group Saint John, NB, CanadaIn business since 1960, FCC Construction is an open shop, multi-trade, specialty contractor serving Atlantic Canada. Construction Management, Electrical Contracting, and Communication Cabling. · The Estimator will be responsible for the completion of Tenders, Bid Requests, Reque ...
-
Construction Project Manager
4 days ago
OSCO Construction Group Saint John, NB, CanadaAbout UsIn business since 1960, FCC Construction is an open shop, multi-trade, specialty contractor serving Atlantic Canada. FCC's three main operating divisions include: Construction Management, Electrical Contracting and Communication Cabling. Job SummaryThis position is within ...
-
Market (Sales) Associate
1 day ago
OSCO Construction Group Saint John, NB, Canada FreelanceAbout Us Established in 1963, Strescon Limited has grown to become the largest precast, pre-stressed concrete manufacturer in Eastern Canada. Its primary market covers the Atlantic Provinces, the New England region of the United States, and Bermuda. Strescon manufactures a wide r ...
-
Chemical Process Engineer
1 day ago
J.D. Irving, Limited Saint John, NB, CanadaChemical Engineering Student - Pulp & Paper Division - Fall 2024 CHEMICAL ENGINEERING STUDENT – FALL 2024 · We currently have exciting opportunities within our Pulp & Paper Division operations for Chemical En gineering Students to join our teams in Saint John and Utopia, New Bru ...
-
Transportation Engineer in Training
6 days ago
CBCL Limited Saint John, NB, CanadaCBCL is currently looking to add an entry-level Transportation Engineer-in-Training to our team of talented employees in our Saint John, NB office. · The successful candidate will be a motivated self-starter and will join our established transportation team of professionals to a ...
-
Intermediate Construction Manager
1 day ago
OSCO Construction Group Saint John, NB, CanadaAbout UsIn business since 1960, FCC Construction is an open shop, multi-trade, specialty contractor serving Atlantic Canada. FCC's three main operating divisions include: Construction Management, Electrical Contracting and Communication Cabling. Job SummaryThis position is within ...
-
Project Engineer-in-Training
3 weeks ago
City of Saint John Saint John, NB, CanadaFacebook · Twitter · Under the general supervision of the HAF Project Manager, you will be part of a high-caliber cross functional team leading two key initiatives under the City of Saint John Housing Accelerator Fund (HAF) Project while also providing support for the other ini ...
-
Senior Technical Inspector
6 days ago
Englobe Saint John, NB, CanadaYour Employer · Dare to join Englobe · At nearly 3,000 people, Englobe is one of Canada's premier firms specializing in professional engineering services, environmental sciences, and soil and biomass treatment. · With offices located across Canada, the United Kingdom and Franc ...
-
Junior Technical Sales Associate
2 days ago
EightSix Network Inc Saint John, NB, CanadaEstablished in 1963, Strescon Limited has grown to become the largest precast, pre-stressed concrete manufacturer in Eastern Canada. Its primary market covers the Atlantic Provinces, the New England region of the United States, and Bermuda. Strescon manufactures a wide range of b ...
-
Website Administrator
2 weeks ago
Acadia Broadcasting Limited Saint John, NB, CanadaAcadia Broadcasting is a growing media company with radio stations in Atlantic Canada and Northwestern Ontario. In each of our markets, our company focuses on being the community's local voice for entertainment, news, and events. Acadia recently launched a new digital marketing d ...
-
Website Administrator
6 days ago
Evanov Radio Group Saint John, NB, CanadaAcadia Broadcasting is a growing media company with radio stations in Atlantic Canada and Northwestern Ontario. In each of our markets, our company focuses on being the community's local voice for entertainment, news, and events. Acadia recently launched a new digital marketing d ...
-
Junior Technical Sales Associate
6 days ago
EightSix Network Inc Saint John, NB, CanadaEstablished in 1963, Strescon Limited has grown to become the largest precast, pre-stressed concrete manufacturer in Eastern Canada. Its primary market covers the Atlantic Provinces, the New England region of the United States, and Bermuda. Strescon manufactures a wide range of b ...
-
Project Engineer/Engineer
6 days ago
09 Irving Oil Limited Saint John, NB, CanadaSenior Project Engineer · As a Senior Project Engineer you will work collaboratively to lead multi-disciplinary engineering teams on projects and/or programs using your engineering management, stakeholder and client relationship management skills. Your goal will be to help refin ...
senior data engineer microsoft bi - Saint John, NB, Canada - Investment Management Corporation of Ontario
Description
Senior Data Engineer, Core Investment Data page is loaded Senior Data Engineer, Core Investment DataApply locations Toronto - 16 York St time type Full time posted on Posted 5 Days Ago job requisition id R24-82 At IMCO, our talent is among the best IMCO offers a uniquely stimulating and rewarding environment where you can help build and drive organizational transformation, all while seeking to challenge yourself, learn, and grow your career.
Our vision is to be the partner of choice for Ontario's public sector funds and build a high-performing, value-based Asset Management firm in the heart of downtown Toronto.
As a key member of the Core Investment Data team, the Senior Data Engineer will work closely with the Lead Data Engineer, internal data teams, and key application support teams to design, build, and support the cloud-based infrastructure for the data pipeline, including maintenance, improvement, cleansing, and manipulation of data and analytics across IMCO's data platforms.
The Senior Data Engineer will be a collaborative technical SME that can drive solutions while working closely with Data Leads, Data Architects, business systems analysts, and business stakeholders to analyze, design, and implement data-driven solutions for IMCO.
Contribute to designing and implementation of data architecture and technology infrastructure for new data and analytics platform with Azure data stackDesign and build scalable ETL workflows for all data ingestion into the data platform
convert to ingestible formats, call external web services, and third-party APIs.
Create database objects with a strong understanding of data modeling.
Write complex SQL for ETL and data extractions with high-performance and easy-to-manage code.
Develop and maintain automated build and deployment processes for all solutions using cloud tools and CI/CD practices.
Develop functional specifications and systems configuration documentation to support solution rollout.
Design and develop reports and analytical dashboards in Power BI
Work closely with business systems analysts SMEs on projects and operations to deliver effective support, investigate root causes, recommend changes, and maintain accurate documentation.
Reverse-engineer, investigate, and document data flow for operational procedures and support.Evaluate existing data flow and operations, develop processes for effective maintenance, monitoring, and performance tuning, and recommend improvements for operational efficiency.
Enhance environment stability by working with others to set up and maintain production configurations. Continuously improving service levels with all business and technical stakeholdersAutomate manual processes, optimize data delivery, and redesign infrastructure for greater efficiency and scalability.
Provide health status of operations within the platform with specific database and ETL processes support.
Initiate knowledge dissemination of design, coding, and analysis techniques in a collaborative manner
Facilitate testing of solutions and production implementation planning while performing as a trusted liaison between IT, Investment business stakeholders, and external solution providers
Explore innovative solutions to leverage Microsoft Azure data & analytics services to solve complex technical and business problems with a forward-thinking approach
Incorporate operational risk and systems performance management in all initiatives
Support BI solutions with SQL Server and SSIS.
Minimum 7 years of experience in data warehousing, designing complex SQL queries, tables, views, and procedures, including performance tuning and query optimization.
Undergraduate degree in Computer Science or Engineering or other related discipline with experience building and maintaining IT data operations in asset management or investment.
Expert experience in ETL processing using tools Azure Data Factory and AirflowIntermediate to senior-level experience in operationalizing data platforms with Azure data solutions such as Azure Databricks, Azure Analysis Service, Azure Synapse, and Snowflake
Solid experience in building and maintaining dimensional data models.
Hands-on experience with source control management systems and continuous integration/deployment
Net C#.
Experience with SSIS and SQL Server.
Experience with Azure Devops
Proficient in Python development
Track record to work in an exploratory capacity to innovate, benchmark, and make recommendations to improve the efficiency and effectiveness of design and data operations.
Superior tactical, analytical, evaluative, and problem-solving abilities to translate business requirements into technical specifications.Strong working knowledge of trading lifecycle and investment workflow with experience in investment data flows, operational processing requirements, and management of data assets
Strong domain knowledge in IT service management, including incident management, change management, configuration management, and operations management.
Good understanding of agile practices, with demonstrated experience in operating in Kanban or Scrum for delivery.
Practical experience in building data warehouses and report building in Power BI is an asset.
Exposure to data science, machine learning, and LLM is an asset.
IMCO is committed to providing accommodation for people with disabilities in its recruitment process.
The Investment Management Corporation of Ontario (IMCO) is Ontario's professional asset manager, investing on behalf of our public sector clients so they can care for beneficiaries and secure retirement futures.
With approximately $77 billion in assets under management, we are one of the largest institutional investment managers in Canada and around the globe.
Our mandate is to provide broader public sector clients with exceptional investment management services, including best-in-class advice around portfolio construction, efficient access to a diverse range of asset classes and superior reporting on risks and returns.
Our vision is to rank among the world's leading public-sector asset managers.