Skip to content

Open nowPosted 42 days ago

Senior Power BI Data Engineer

Plymouth Rock Assurance Corporation79 open roles

Where
Boston, MA, USA
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowSenior Power BI Data EngineerPlymouth Rock Assurance Corporation · Boston, MA, USA
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Plymouth Rock Assurance Corporation's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

11.3% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.0%1 day
  2. 4.3%3 days
  3. 11.3%7 days
  4. 17.6%14 days
  5. 34.3%30 days
  6. 43.5%60 days
This job: posted 42 days ago

The posting

Senior Power BI Data Engineer

Job Summary

The Senior Power BI/Data Engineer is responsible for designing, developing, and maintaining enterprise reporting, analytics, workflow automation, and AI-enabled solutions leveraging Microsoft Power BI, Power Automate, Microsoft Copilot technologies, DBT, Snowflake, AWS S3 Stores.

This role serves as a key contributor in the organization's data journey by building scalable reporting solutions, implementing automated business processes, developing ELT transformations, and identifying opportunities to leverage Artificial Intelligence to improve business efficiency and decision-making.

The successful candidate will collaborate with business stakeholders, data engineers, analysts, and technology teams to transform data into actionable insights while driving innovation through automation and AI.

Duties and Responsibilities

Power BI Reporting Development

  • Design, develop, and maintain Power BI Paginated Reports utilizing Power BI Report Builder.
  • Create highly formatted operational, regulatory, financial, and executive reports.
  • Develop parameter-driven reports and interactive reporting solutions.
  • Create reusable report templates and standards.
  • Optimize report performance and query execution.
  • Troubleshoot and resolve reporting issues in production environments.

Power BI Platform

  • Publish, manage, and maintain reporting assets within the Power BI Service.
  • Configure scheduled refreshes, subscriptions, and report distribution.
  • Implement row-level security and governance standards.
  • Support workspace administration and deployment processes.
  • Monitor and optimize Power BI environment performance.

Power Automate Development

  • Implement automated report delivery, approvals, notifications, and workflow solutions.
  • Integrate Power Automate with Microsoft 365, SharePoint, Teams, Outlook, and Power BI.
  • Evaluate and implement AI-powered business solutions utilizing tools like Claude/Copilot.
  • Partner with others to identify opportunities for AI-driven process improvements and operational efficiencies.
  • Develop AI-assisted reporting, documentation generation, summarization, and workflow capabilities.
  • Build automated business processes using Power Automate integrated with AI services.

Data Engineering

  • Design, build, and maintain ELT pipelines using dbt.
  • Develop and support scalable transformation models within Snowflake.
  • Create reusable data models, testing frameworks, and documentation within dbt.
  • Implement data quality controls, reconciliation processes, and automated validations.

Data Analysis and Development

  • Write complex SQL queries, stored procedures, and datasets.
  • Work with Snowflake, SQL Server, DB2, or other enterprise data sources.
  • Validate data quality and reconcile results with source systems.
  • Participate in testing, deployment, and production support activities.
  • Provide production support and issue resolution.

Qualifications and Education:

  • Bachelor's degree in Computer Science, Information Systems, Business Analytics, or related field; or equivalent combination of education and experience.
  • 3-7+ years of experience in business intelligence, reporting, analytics, or application development.
  • Experience developing Power BI Paginated Reports.
  • Experience with Microsoft Power BI Service and semantic models.
  • Experience developing Power Automate workflows.
  • Experience writing advanced SQL queries.
  • Experience supporting enterprise reporting environments.

Preferred Qualifications

  • Insurance industry experience, particularly Property & Casualty Insurance.
  • Experience developing regulatory/financial reports.
  • Experience with SharePoint Online and Microsoft Teams integrations.

Required Knowledge and Skills

  • Power BI Report Builder (Paginated Reports)
  • Power BI Service Administration
  • Power BI Dataset/Semantic Model development
  • Power Automate Cloud Flows
  • SQL development and query optimization
  • Snowflake, SQL Server, DB2, or similar relational databases
  • Data analysis and troubleshooting skills
  • Requirements gathering and documentation
  • SDLC and Agile methodologies
  • Source control systems (Azure DevOps, Git, etc.)
  • Strong verbal and written communication skills
  • Strong analytical and problem-solving abilities
  • Ability to manage multiple priorities and projects simultaneously
  • Ability to work independently and collaboratively

Technical Skills

  • Power BI Report Builder (Paginated Reports)
  • Power BI Service
  • Power Automate
  • SQL Knowledge
  • Snowflake Data Platform
  • DBT
  • Data Modeling
  • DAX
  • Power Query (M)
  • Microsoft Fabric/Azure Data Services
  • Git / Azure DevOps
  • AI & Generative AI Technologies
  • REST APIs and Data Integration
  • Data Lake (AWS-S3)

Salary Range: $100,000-$120,000 per year + bonus. Actual compensation will vary based on multiple factors, including employee knowledge and experience, role scope, business needs, geographical location, and internal equity.

About the Company:

The Plymouth Rock Company and its affiliated group of companies write and manage over $2.2 billion in personal and commercial auto and homeowner’s insurance throughout the Northeast and mid-Atlantic, where we have built an unparalleled reputation for service. We continuously invest in technology, our employees thrive in our empowering environment, and our customers are among the most loyal in the industry. The Plymouth Rock group of companies employs more than 2,000 people and is headquartered in Boston, Massachusetts. Plymouth Rock Assurance Corporation holds an A.M. Best rating of “A-/Excellent”.

#LI-DNI

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Plymouth Rock Assurance Corporation's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on Plymouth Rock Assurance Corporation's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    Plymouth Rock Assurance Corporation's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.