Senior Power BI Data Engineer

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

Benefits offered by this job

Bonus

Job summary

Plymouth Rock Assurance Corporation is seeking a Senior Power BI/Data Engineer to design, develop, and maintain enterprise reporting and AI-enabled solutions across Snowflake, dbt, and AWS S3. You will collaborate with stakeholders to transform data into actionable insights and drive automation and efficiency.

The role emphasizes building scalable reporting, ELT transformations, and AI-enabled processes, with a focus on Power BI, Power Automate, and Copilot technologies to enhance business

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Business Analytics, or related field; or equivalent.
• 3-7+ years in BI, reporting, analytics, or app development.
• Experience with Power BI Service and semantic models.
• Experience developing Power Automate workflows.
• Experience writing advanced SQL queries.
• Experience supporting enterprise reporting environments.

Responsibilities

• Design, develop, and maintain Power BI reports and dashboards.
• Manage Power BI assets, security, and governance.
• Develop automated workflows using Power Automate and integrate with Microsoft 365 ecosystem.
• Implement AI-powered solutions and integrate with Copilot/AI services.
• Build ELT pipelines using dbt and support Snowflake transforms.
• Write complex SQL, validate data quality, and support production environments.

Skills

Power BI

Power Automate

SQL

Snowflake

dbt

Data Modeling

DAX

Power Query (M)

AI & Generative AI

REST APIs

AWS S3

Education

Bachelor’s degree in CS/IS/Analytics or related

Tools

Power BI Report Builder (Paginated Reports)

Power BI Service

Power Automate

Snowflake

DBT

Data Modeling

DAX

Power Query (M)

REST APIs

AWS-S3

Job description

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.
• 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 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 with SharePoint Online and Microsoft Teams integrations.

Required Knowledge and Skills

• Power BI Report Builder (Paginated Reports)
• Power BI Service Administration
• 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
• 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)
• 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

Location(s)

695 Atlantic Avenue, Boston , Massachusetts 02111 , United States

undefined

Employer Privacy Policy

Plymouth Rock is committed to a policy ofnon-discrimination and equal opportunity for all qualified applicants andemployees without regard to race, color, religion, gender, sexual orientation,age, national origin, ancestry or disability.

EEO is the Law

ADP Privacy Statement Artificial Intelligence Google Privacy Policy Google Terms of Service