Business Intelligence Engineer (Partial Remote)

Analytic Search; Pennsylvania; Remote; USD 80,000 - 110,000; Full time

Job summary

A global property and casualty provider is seeking a Business Intelligence Engineer to build and optimize data pipelines and infrastructure. This role involves collaboration with data scientists and analysts to transform raw data into actionable insights, enabling data-driven business decisions. The ideal candidate will have strong SQL skills, experience with Azure ADF, and proficiency in Power BI for data visualization.

Qualifications

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

Responsibilities

• Design, build, and maintain data pipelines for various sources.
• Create dashboards and reports using Power BI.
• Ensure data quality and reliability through validation.

Skills

SQL

Data Visualization

Data Governance

Software Engineering Practices

Education

Bachelor’s or Master’s degree in Computer Science

Tools

Azure ADF

Power BI

Data Fabric

Git

Job description

Global Property & Casualty Provider seeks a Business Intelligence Engineer to be responsible for building, maintaining and optimizing the data pipelines and infrastructure that power our Analytical capabilities. In this role you 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. You will be a key player in transforming raw data into actionable insights, contributing to the development of data-driven products and services.

Responsibilities:

• 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
  

• 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 resentation products that align to the enterprise architecture
  

Qualifications:

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

• 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
  

* U.S. Citizen or Green Card Required *