Senior Power BI & Data Automation Engineer

Plymouth Rock Assurance; Boston (MA); On-site; USD 100,000 - 120,000; Full time

Job summary

Plymouth Rock Assurance, based in Boston, MA, seeks a Senior Power BI/Data Engineer to design, build, and maintain enterprise reporting and analytics using Power BI, Power Automate, and AI-enabled solutions. You will collaborate with data engineers, analysts, and business stakeholders to convert data into actionable insights while advancing automation.

Responsibilities include developing paginated reports, managing the Power BI service, implementing ELT with dbt, Snowflake, and AWS S3 data lake,

Qualifications

• Bachelor's degree or equivalent in a relevant field with 3–7+ years BI/analytics experience.
• Experience with Microsoft Power BI Service and semantic models.
• Experience developing Power Automate workflows and data ETL/ELT processes.
• Proficient SQL writing and data quality validation in enterprise environments.

Responsibilities

• Design, develop, and maintain enterprise Power BI reporting and analytics solutions.
• Build automated workflows using Power Automate integrated with AI features.
• Develop ELT transformations with dbt and manage Snowflake data models.
• Collaborate with stakeholders to translate data into actionable insights.
• Ensure data quality, security, and governance across BI platforms.

Skills

Power BI

SQL development

Data modeling

DAX

Power Query

AI & Generative AI

REST APIs

Data integration

Communication

Analytical thinking

Education

Bachelor's degree in CS/IS/Analytics or related field

Tools

Power BI Report Builder

Power BI Service

Power Automate

Snowflake

DBT

AWS S3/Data Lake

SQL

Job description

Plymouth Rock Assurance, based in Boston, MA, seeks a Senior Power BI/Data Engineer to design, build, and maintain enterprise reporting and analytics using Power BI, Power Automate, and AI-enabled solutions. You will collaborate with data engineers, analysts, and business stakeholders to convert data into actionable insights while advancing automation.

Responsibilities include developing paginated reports, managing the Power BI service, implementing ELT with dbt, Snowflake, and AWS S3 data lake,