Intermediate Data Analytics and Integration

3 weeks ago

Pembroke, Canada AIG Full time

Who we are

American International Group, Inc. (AIG) is a leading global insurance organization. AIG member companies provide a wide range of property casualty insurance in approximately 70 countries and jurisdictions. These diverse offerings include products and services that help businesses and individuals protect their assets and manage risks.

Validus Re is among the world’s largest and most successful reinsurers specializing in the assumption and management of volatility risk. Validus Re operates from seven offices internationally and provides a broad suite of reinsurance products and services, backed by highly rated capital and specialized local knowledge, in virtually every corner of the world.

About the role

The Intermediate Data Analytics and Integration Specialist be responsible for developing and supporting solutions within the Validus ecosystem as well as assisting the Business Transformation team within their AGILE project methodology framework. This will include working with senior business and IT stakeholders to ensure the development priorities are correctly aligned and prioritized. Additionally, the role will work with the Application Support and Service desk teams to assist with troubleshooting issues, and general ticket resolution tasks where applicable.

What you need to know:

- The Intermediate Data Analytics and Integration Specialist will be responsible for delivering small to medium sized projects. It is expected that 25% of your time will be allocated towards business analysis and coordinating the efforts of the business and development teams. The remaining 75% will be hands on writing code, troubleshooting issues, system support, executing test cases, etc. This is very much a generalist position where you will need to wear many hats.
- This is a hands-on position requiring strong analyst skills and technical and business expertise.
- Working with IT colleagues to understand and document available data sources and their integrations
- Collaborating with other team members to design solutions and ensure that business requirements are met
- Providing guidance to project teams to improve the quality of the product and processes
- Project management duties will include issue log tracking, schedule monitoring, resource allocation, ability to push back constructively when needed and communicating project status to the project stakeholders.
- Investigate operational requirements, problems, and opportunities, seeking effective business reporting solutions through improvements in automated and non-automated components of new or changed reporting processes
- Obtain formal agreement by stakeholders and recipients to scope and requirements and establish a base-line on which delivery of a solution can commence
- Designing and planning BI Reporting solutions including OLTP and dimensional data modeling, ETL processing and cubes
- Reverse engineering complex SQL code and translating it into an easy to maintain solution
- Building robust, fault tolerant data processes
- Other duties as required

What we’re looking for:

- Bachelor’s degree with 3+ years experience
- Ability to manage small to medium-sized projects and teams
- Power Platform - including work experience with Canvas Power Apps, Power Automate, Custom Connectors, and Dataverse
- SQL Server - including advanced TSQL, SSIS, and performance tuning
- Developing C# REST APIs using Docker and K8S
- PowerBI, SSRS, or Tableau
- Knowledge of ITIL processes, SOX Compliance and SDLC (Waterfall and Agile) methodologies
- Degree in Information Systems, Computer Science, or a related field.
- Strong interpersonal and communications skills
- Ability to clearly explain complex business and technical issues, procedures, and processes in verbal and written format to an audience of managers and directors.
- Strong analytical skills.
- Ability to function independently and produce results that meet standards of quality, timeliness, and acceptability.

Preferred:

- Business knowledge of Accounting, Insurance or Re-insurance
- Experience of working in a multi-country, multi-site environment
- Azure DevOps and Git

QUALIFICATIONS FOR CONTINUED EMPLOYMENT:

- Execution of key duties and responsibilities at a high level
- Adherence to all Human Resource Policies and Practices
- Punctuality and regular attendance

We are an Equal Opportunity Employer

American International Group, Inc., its subsidiaries and affiliates are committed to be an Equal Opportunity Employer and its policies and procedures reflect this commitment. We provide equal opportunity to all qualified individuals regardless of race, color, religion, age, gender, gender expression, national origin, veteran status, disability or any other legally protected categories such as sexual orientation. At AIG, we believe that diversity and inclusion are critical to our future and our mission - creating a foundation for a creative workplace that leads to innovation, growth, and profitability. Th

  • Coordinator I, Epidemiology and Health Analytics

    1 week ago

    Pembroke, Canada Renfrew County and District Health Unit Full time

    The Renfrew County and District Health Unit has an opening for one (1) Temporary Coordinator I, Epidemiology and Health Analytics. **General Duties**: As a member of the management team, the Coordinator, Epidemiology and Health Analytics provides leadership in population health assessment and surveillance in accordance with the Ontario Public Health...

  • Data Clerk

    1 week ago

    Pembroke, Canada Ottawa River Power Corporation Full time

    **Data Clerk - Collections** **(Pembroke Operations Centre)** Nestled along the scenic Ottawa River, Pembroke stands as a vibrant hub in the Ottawa Valley, offering affordable living, healthcare access, and a dynamic lifestyle. Ottawa River Power Corporation (ORPC) is currently seeking a motivated Data Clerk to strengthen our Front Office team, focusing on...

  • 23-p01- Intermediate Environmental Technician

    2 days ago

    Pembroke, Canada Jp2g Consultants Inc. Full time

    _**Jp2g Consultants Inc. **_is an employee owned, multi-disciplinary consulting firm providing a comprehensive range of environmental, engineering, planning, and project management services to the public and private sectors, from offices in Arnprior, Ottawa and Pembroke. Jp2g is committed to maintaining client satisfaction, encouraging employee growth, and...

  • Wildlife Technician

    1 week ago

    Pembroke, Canada Ministry of Natural Resources and Forestry Full time

    The Ontario Public Service (OPS) is committed to being an employer of first choice, creating a positive and inclusive work environment. We offer: - A defined benefit pension plan - Comprehensive Health Plan - Life and Disability insurance - Collegial and professional work culture - Career growth and development opportunities across multiple business...

  • Child & Youth Mental Health Collaboration Lead

    1 week ago

    Pembroke, Canada Corporation of the County of Renfrew Full time

    The OVOHT is one of 57 Ontario Health Teams across the province built with the goal of delivering more connected and integrated care for patients, families, and caregivers. Under OHTs, hospitals, physicians, homecare, community health, and social service providers work as one coordinated and integrated team - no matter where they provide care. The Phoenix...

  • Resources Clerk

    2 weeks ago

    Pembroke, Canada Ministry of Natural Resources and Forestry Full time

    Are you an efficient office administration professional with excellent organizational skills? If so, consider these positions with the Ministry of Natural Resources and Forestry, Regional Operations Division. **OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism**: We are committed to build a workforce that reflects the communities we...

  • Gis Technician

    2 months ago

    Pembroke, Canada The Corporation of the County of Renfrew Full time

    **Responsibilities**: - Performs the responsibilities of the position within the legislative and regulatory standards set out in the applicable Provincial and Municipal Acts. Performs the responsibilities of the position consistent with the Operational policies of the County of Renfrew. - Receive and process requests for GIS information, analysis and...

  • Duty Counsel

    1 month ago

    Pembroke, Canada Legal Aid Ontario Full time

    Company Bio Legal Aid Ontario employees are committed to making a difference in the lives of our clients. As an integral partner in the Justice system, working at Legal Aid Ontario is more than just a job. It's an opportunity to help people who need it the most; to ensure each client receives the access to justice afforded to them under the law. If you are...

  • Duty Counsel

    3 weeks ago

    Pembroke, Canada Legal Aid Ontario Full time

    Company Bio Legal Aid Ontario employees are committed to making a difference in the lives of our clients. As an integral partner in the Justice system, working at Legal Aid Ontario is more than just a job. It's an opportunity to help people who need it the most; to ensure each client receives the access to justice afforded to them under the law. If you are...

  • Duty Counsel

    1 week ago

    Pembroke, Canada Legal Aid Ontario Full time

    Union: The Society - Job Number: J0223-0385 - Job Title: Duty Counsel - Criminal and Family (French Bilingual) - Job Type: Permanent Full Time - City, Province, Country: Pembroke, Ontario, Canada - Job Location: Pembroke - Job Category: Legal - Role Designation: - LAO Workplace Based - Role is physically based in an in-person LAO workplace.- Open Positions:...

  • Bilingual Legal Aid Worker

    3 days ago

    Pembroke, Canada Legal Aid Ontario Full time

    Company Bio Legal Aid Ontario employees are committed to making a difference in the lives of our clients. As an integral partner in the Justice system, working at Legal Aid Ontario is more than just a job. It's an opportunity to help people who need it the most; to ensure each client receives the access to justice afforded to them under the law. If you are...

  • Duty Counsel

    3 weeks ago

    Pembroke, Canada Legal Aid Ontario Full time

    Union: The Society - Job Number: J0523-1162 - Job Title: Duty Counsel - Criminal AND/OR Family - Job Type: Permanent Full Time - City, Province, Country: Pembroke, Ontario, Canada - Job Location: Pembroke - Job Category: Legal - Role Designation: - LAO Workplace Based - Role is physically based in an in-person LAO workplace.- Open Positions: 1 - Posting...

  • IT Network Administrator

    2 months ago

    Pembroke, Canada 401 Auto Full time

    At the 401 Group of Companies, we want to focus on not who you are, but who you CAN be! We strive to hire exceptional employees who see themselves as _trailblazers, trendsetters, creators, do-ers, catalysts, go-getters, and influential leade_rs in all aspects of who they aspire to be daily. **Location: Pembroke, ON** **Role and Responsibilities**: -...

  • IT Network Administrator

    2 days ago

    Pembroke, Canada 401 Auto Full time

    At the 401 Group of Companies, we want to focus on not who you are, but who you CAN be! We strive to hire exceptional employees who see themselves as _trailblazers, trendsetters, creators, do-ers, catalysts, go-getters, and influential leade_rs in all aspects of who they aspire to be daily. **Location: Pembroke, ON** **Role and Responsibilities**: -...

  • Articling Student

    2 months ago

    Pembroke, Canada Legal Aid Ontario Full time

    Union: The Society - Job Number: J0523-0093 - Job Title: Articling Student - Criminal & Family (10 months) - Job Type: Articling Student - Contract Duration: 10 months - City, Province, Country: Pembroke and area, Ontario, Canada - Job Location: Pembroke and area - Job Category: Legal - Job Classification: AS - Role Designation: - LAO Workplace Based - Role...

  • 2025/26 Articling Student

    2 weeks ago

    Pembroke, Canada Legal Aid Ontario Full time

    Union: The Society - Job Number: J0524-0224 - Job Title: 2025/26 Articling Student - Criminal & Family - Job Type: Articling Student - Contract Duration: 10 months - City, Province, Country: Pembroke, Ontario, Canada - Job Location: Pembroke - Job Category: Legal - Job Classification: AS - Role Designation: - LAO Workplace Based - Role is physically based in...

  • Resource Management Technician

    2 weeks ago

    Pembroke, Canada Ministry of Natural Resources and Forestry Full time

    Do you have a passion to create awareness and promote resource management protection? If so, consider this challenging opportunity to join our team. The Ontario Public Service (OPS) is committed to being an employer of first choice, creating a positive and inclusive work environment. We offer: - a defined benefit pension plan - maternity and parental...

  • Laser Technician

    1 week ago

    Pembroke, Canada Integrated Health Centre Full time

    Integrated Heath Centre, a comprehensive alternative health facility providing Applied Kinesiology - which is an approach to chiropractic that looks at the whole body; Chemical, Emotional and Physical. Offering a variety of services to support the chiropractors - we have Bioflex lasers, orthotics, nutritional supplements, health footwear and a 24-hour...

  • Part-time Institutional Research Analyst

    4 days ago

    Pembroke, Canada Algonquin College Full time

    Department: Community and Student Affairs (Jamie Bramburger) Position Type: Part-Time Support Salary Range: $22.28-$25.78-Hourly Scheduled Weekly Hours: 24 Anticipated Start Date: March 18, 2024 Length of Contract: n/a Posting Information Posting Closing Date: February 29, 2024 Please note: jobs are posted until 11:59 pm on the job closing...

  • Night Auditor

    3 weeks ago

    Pembroke, Canada Comfort Inn Pembroke Full time

    **THE OPPORTUNITY**: NIGHT AUDITOR REPORTS TO GENERAL MANAGER **THE COMPANY**: Passion Drives Performance. InnVest succeeds because our people love what we do. Our entire team shares a deep-rooted passion for the world of hospitality & travel that extends far beyond the walls of our offices and hotels. Our company culture is built on collaboration. A...