Senior Data Engineer

Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.

We are looking for a collaborative and resourceful Senior Data Engineer. You are dedicated, naturally inquisitive and are comfortable in a fast-paced environment.

This role will be part of and a member of our Data Delivery Group, you will be responsible for analysis, design and implementation in high-performing, experienced team. You'll be required to apply your depth of knowledge and expertise to all many areas including requirements, infrastructure, and solutioning. Aviva has embarked on an exciting journey to modernize, craft and build a next generation of data platform to support the growing data needs for data engineering, analytics and Data Science.

We embrace a culture challenging the status quo and constantly look to efficiently simplify processes, technology, and workflow.

This position reports to the AVP – Data Delivery.

What you’ll do

Design, build and operationalize large scale enterprise data solutions and using AWS data and analytics services.

Demonstrates outstanding understanding of AWS cloud services especially in the data engineering and analytics space.

Analyze, re-architect and re-platform on premise big data platforms to AWS.

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.

Design and Develop ETL Pipeline to ingest data into Hadoop from different data sources (Files, Mainframe, Relational Sources, NoSQL Etc.) using Informatica BDM

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.

What you’ll bring

University degree in Computer Engineering or Computer Science.

5+ years of experience crafting solutions for data lakes, data integrations, data warehouses/marts.

Solid grasp/experience with data technologies & tools (Hadoop, PostgreSQL, Informatica, etc.,)

Outstanding knowledge and experience in ETL with Informatica product suite.

Knowledge/experience in Cloud Data Lake Design – preferred AWS technologies like S3, EMR, Redshift, Snowflake, could data catalog etc.,

Experience implementing Data Governance principles and efficiencies.

Understanding of reporting/analytics tools (QlikSense, SAP Business Objects, SAS, DataIku, etc.,).

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.

What you’ll get

Competitive rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.

Exceptional Career Development opportunities.

We’ll support your professional development education.

Additional Information: Aviva Canada has an accommodation process in place to provide accommodations for employees with disabilities. If upon commencement of employment you require a specific accommodation because of a disability, please contact your Talent Acquisition Partner so that an appropriate accommodation can be arranged. This process applies throughout your career with Aviva Canada.