Position: Sr Data Engineer
Location: Markham,ON
Position: Full time/Subcon
Mode: Hybrid (Mandatorily need to visit office 3 days a week)
Job Description:
We are looking for a collaborative and resourceful Data Engineer (Sr) for our IT Data Platform Engineering Delivery team. You are dedicated, naturally inquisitive and are comfortable in a fast-paced environment.
This role will be part of and a member of our Information Technology Enterprise Data Services Group. You will be responsible for leading the architecture, design, analysis, and implementation in a successful, and experienced team. You'll be required to apply your depth of knowledge and expertise with both modern and legacy data platforms to develop data ecosystems that will meet business requirements and align enterprise architecture goals and standards. Exciting journey to modernize, craft, and build a next generation data platform to support the growing data needs of the business and to enable the capabilities of AI to drive business value.
We embrace a culture challenging the status quo and constantly look to efficiently simplify processes, technology, and workflow.
What you'll do
Design, build and operationalize large scale enterprise data solutions in Hadoop, Postgres, Oracle, and Snowflake.
Design and Develop ETL Pipeline to ingest data into Oracle/Hadoop/Postgres from different data sources (Files, Mainframe, Relational Sources, NoSQL, Hadoop Etc.) using Informatica Power center and BDM
Work will also encompass crafting & developing solution designs for data acquisition/ingestion of multifaceted data sets (internal/external), data integrations & data warehouse/marts.
You are collaborative with business partners, product owners, partners, functional specialists, business analysts, IT architecture, and developers to develop solution designs adhering to architecture standards.
Responsible for supervising and ensuring that solutions adhere to enterprise data governance & design standards.
Act as a point of contact to resolve architectural, technical and solution related challenges from delivery teams for best efficiency.
Advocate importance of data catalogs, data governance and data quality practices.
Outstanding problem-solving skills.
Work in an Agile delivery framework to evolve data models and solution designs to deliver value incrementally.
You are a self-starter with experience working in a fast-paced agile development environment.
Strong mentoring and coaching skills and ability to lead by example for junior team members.
Outcome focused with strong decision making and critical thinking skills to challenge the status quo which impacts delivery pace and performance and striving for efficiencies.
Minimum 3 days a week in the office
What you'll bring
University degree in Computer Engineering or Computer Science.
8+ years of experience crafting solutions for data lakes, data integrations, data warehouses/marts.
Solid grasp/experience with data technologies & tools (Snowflake, Hadoop, Oracle, PostgreSQL, Informatica BDM & Power center, etc.,)
Excellent coding skills in SQL Scripts, and Java.
Knowledge or experience in GW CC (Guidewire claim center) will be an additional nice to have.
Outstanding knowledge and experience in ETL with Informatica product suite.
Experience implementing Data Governance principles and efficiencies.
Familiar with the Agile software development.
Excellent verbal and written communication skills.
Insurance knowledge an asset-Ability to foundationally understand complex business process driving technical systems.
