Analytics Engineer

MSIG USA continues to grow! 

Company Overview:

MSIG USA is the US-based subsidiary of MS&AD Insurance Group Holdings, Inc., one of the world’s top P&C carriers and a global Class 15 insurer, with A+ ratings and a reach that spans 40+ countries and regions. Leveraging our 350-year heritage, MSIG USA brings the financial strength, expertise, and global footprint to offer commercial insurance solutions that address your business’s unique risks.

Summary:

Analytics Engineers will be responsible for building, maintaining and optimizing the data pipelines and infrastructure that power our Analytical capabilities. They will collaborate closely with data scientists, data analysts, and data engineers to ensure the reliable delivery of high-quality data to enable data driven business decisions for our company. They will be a key player in transforming raw data into actionable insights, contributing to the development of data-driven products and services.

Essential Functions:

• Data Pipeline Development and Maintenance

  • Design, build, and maintain robust and scalable data pipelines for ingesting, transforming, and storing data from various sources (e.g., policy administration systems, claims systems, third-party data providers)

  • Implement and optimize ETL/ELT processes using modern data engineering tools and technologies (e.g., Azure ADF, cloud-based data warehouses like Azure Fabric).

  • Ensure data quality, consistency, and reliability through data validation and monitoring.

  • Design, develop, and maintain data infrastructure that power business intelligence tools and enable data-driven decision making

  • Test data to ensure it is of high quality, in all stages of the analytics pipeline, from data ingestion to delivery

  • Ensure data models are running reliably in a production environment

  • Provide relevant documentation on modeled data and metrics including data definitions, data lineage, business logic, sample queries to enable self-serve, analytics

• Data Reporting and Visualization

  • Create clear, concise and visually appealing dashboards and reports using Power BI

  • Translate data insights into clear and compelling visualizations for stakeholders

  • Maintain and Optimize Power BI reports, dashboards, and other data presentation products that align to the enterprise architecture

• Data Analysis

  • Perform exploratory analysis, identify trends and patterns and draw conclusions from data sets

  • Extract complex data from multiple sources into usable and meaningful reports and analyses

Supervisory Responsibilities:

No supervisory responsibilities

Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Technical Skills:

  • Strong proficiency in SQL and experience with relational databases and data warehousing concepts

  • Experience with ETL/ELT tools (Azure ADF) and other Azure Cloud technologies (Data Fabric)

  • Strong experience with BI tools like Power BI for data visualization and dashboard creation

  • Familiar with software engineering practices such as version control with Git, Testing, and CI/CD

  • Familiarity with Property & Casualty (P&C) insurance data model is a major plus

  • Experience with data governance and security best practices is a plus

• Data Analysis Skills: Strong analytical thinking and problem-solving abilities to identify trends and patterns in data

• Communication Skills: Excellent written and verbal communications skills to translate complex data insights into clear, concise, and actionable information for both technical and non-technical audiences.

• Business Acumen: Understanding of core business concepts and the ability to connect data analysis to real-works business problems and opportunities

• Team Skills:

  • Strong team collaboration skills

  • Curious, empathetic, attention to detail, and relentless follow through

Education Required: 

• Bachelor’s or Master’s degree in Computer Science, Data Science, Engineering or a related field preferred

• 8+ years of experience as a Analytics or BI Engineer, Data Analyst, BI Analyst or equivalent work experience

It's an exciting time for our company and a great opportunity to join a financially sound and growing global insurance group!  

It is the policy of MSIG USA to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, MSIG USA will provide reasonable accommodations for qualified individuals with disabilities.