Business Intelligence Engineer

MSIG USA; New Jersey; On-site; USD 65,000 - 80,000; Full time

Job summary

An established industry player is seeking a skilled Analytics Engineer to enhance their data capabilities. In this pivotal role, you will design and maintain robust data pipelines, ensuring the delivery of high-quality data for informed decision-making. Collaborating with data scientists and analysts, you will transform raw data into actionable insights, contributing to innovative data-driven products. This opportunity offers a dynamic environment where your analytical skills will directly impact business outcomes, making it a perfect fit for those passionate about data and collaboration.

Qualifications

• Strong proficiency in SQL and experience with relational databases.
• Experience with ETL/ELT tools and Azure Cloud technologies.
• Strong experience with BI tools like Power BI.

Responsibilities

• Build, maintain, and optimize data pipelines for analytics.
• Create clear and visually appealing dashboards using Power BI.
• Perform exploratory analysis to identify trends and patterns.

Skills

SQL

Data Analysis

ETL/ELT Tools

Power BI

Communication Skills

Team Collaboration

Problem Solving

Education

Bachelor’s or Master’s degree in Computer Science

8+ years of experience in Analytics or BI

Tools

Azure ADF

Azure Fabric

Git

Job description

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.

Requirements:

• 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Insurance

Referrals increase your chances of interviewing at MSIG USA by 2x

Get notified about new Business Intelligence Engineer jobs in New Jersey, United States.

Jersey City, NJ $126,000.00-$163,800.00 1 week ago

Business Intelligence Engineer , Internal Audit - Data Analytics Support

Jersey City, NJ $130,000.00-$140,000.00 1 day ago

Trenton, NJ $144,768.00-$209,109.33 6 months ago

Newark, NJ $144,768.00-$209,109.33 6 months ago

New Jersey, United States $65,000.00-$80,000.00 13 hours ago

New Jersey, United States $65,000.00-$80,000.00 1 month ago

Trenton, NJ $112,597.33-$152,810.66 3 months ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.