Logo of Huzzle

Associate Data Analyst

image

Chubb

Yesterday

  • Job
    Full-time
    Junior Level
  • Data
    IT & Cybersecurity

AI generated summary

  • You need 2+ years in data analysis, strong SQL skills, understanding of DBMS, data warehousing tools, a relevant degree, and experience with Azure Synapse or Informatica is a plus.
  • You will support data analysis and testing, reconcile discrepancies, monitor data systems, document requirements, generate reports, and ensure data integrity through quality assurance practices.

Requirements

  • 2+ years of experience in a Data Analysis, Business Analysis, Data Quality Assurance (or similar) role as part of a data warehouse team and supporting data-driven projects
  • Experience working with DBMS platforms, including a demonstrated understanding of table structures, hierarchies, joins, etc.
  • Advanced knowledge of SQL, with the ability to write and troubleshoot medium to advanced SQL queries
  • Knowledge of data warehousing methodologies and tools including their connection to systems both up and down stream
  • Bachelor’s degree in Mathematics, Engineering, Computer Science, or a related discipline preferred
  • Prior experience within the insurance industry is a plus
  • Prior experience with Azure Synapse and/or Informatica Intelligent Cloud Services (IICS) is a plus

Responsibilities

  • Support assigned work efforts through all phases of the development, testing, and implementation life cycle, reviewing all requirements, creating test scenarios, developing test plans, analyzing results and testing/validating data
  • Reconcile multiple data sources and identify the root cause of discrepancies in expected output; distinguish between multiple root causes and/or multiple trends in a given data set and articulate results to various stakeholders, management, and technical resources
  • Analyze and test relational databases and investigate any data load failures or data retrieval issues
  • Monitor data warehousing systems based on assigned tasks to ensure reliability and accuracy of information loaded into the databases
  • Aid in defining and documenting requirements, communicating changes in scope or requires, to all stakeholders; initiate change management processes as required
  • Generate reports, dashboards, and ad hoc extracts for business and/or leadership
  • Ensure data integrity by implementing quality assurance practices, gathering, and entering missing data, and resolving any anomalies

FAQs

What are the main responsibilities of the Associate Data Analyst role?

The main responsibilities include analyzing and certifying data, troubleshooting data issues, promoting data quality, supporting the development and implementation life cycle, reconciling data sources, generating reports, and ensuring data integrity.

What qualifications are required for this position?

Candidates should have 2+ years of experience in a data analysis or similar role, experience with DBMS platforms, advanced knowledge of SQL, and preferably a Bachelor’s degree in Mathematics, Engineering, Computer Science, or a related discipline.

Is prior experience in the insurance industry necessary?

While prior experience in the insurance industry is a plus, it is not a strict requirement for the position.

What technical skills are emphasized for this role?

Advanced knowledge of SQL, experience with relational databases, familiarity with data warehousing methodologies, and some experience with Azure Synapse and/or Informatica Intelligent Cloud Services (IICS) are emphasized.

Will there be opportunities for skill development in this position?

Yes, the role provides opportunities to build upon technical skills and expand insurance knowledge as the data warehouse and related infrastructure evolve.

How will my performance be evaluated in this role?

Performance will be evaluated based on the ability to analyze data, troubleshoot issues, manage data-related projects, and ensure the reliability and accuracy of the information presented to stakeholders.

What types of reports will I be responsible for generating?

You will generate reports, dashboards, and ad hoc extracts for business and leadership to support business decisions.

What kind of team will I be working with?

You will work closely with applications teams, IT teams across the business, stakeholders, and the Data Architect.

Are there opportunities for advancement within Chubb?

Yes, Chubb is committed to employee development and offers opportunities for advancement and career growth within the organization.

What is the company's stance on diversity and inclusion?

Chubb is committed to equal employment opportunity and prohibits unlawful discrimination, ensuring a diverse and inclusive workplace.

The world's largest publicly traded property and casualty insurance company

Finance
Industry
10,001+
Employees
1882
Founded Year

Mission & Purpose

Chubb is the world’s largest publicly traded property and casualty insurance company. With operations in 54 countries and territories, Chubb provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance and life insurance to a diverse group of clients. As an underwriting company, we assess, assume and manage risk with insight and discipline. We service and pay our claims fairly and promptly. The company is also defined by its extensive product and service offerings, broad distribution capabilities, exceptional financial strength and local operations globally. Parent company Chubb Limited is listed on the New York Stock Exchange (NYSE: CB) and is a component of the S&P 500 index. Chubb maintains executive offices in Zurich, New York, London, Paris and other locations, and employs 31,000 people worldwide.