Power BI Developer

VSG Business Solutions•Boston, MA

2d•Hybrid

About The Position

We are seeking a data-savvy developer to perform ETL work with DBT, mine data in Snowflake, and create pipelines that support reporting requirements. The role involves end-to-end report development, from understanding source data and preparing it through a DBT pipeline to building Power BI reports. The Senior Power BI/Data Engineer will be responsible for designing, developing, and maintaining enterprise reporting, analytics, workflow automation, and AI-enabled solutions using Microsoft Power BI, Power Automate, Microsoft Copilot, dbt, Snowflake, and AWS S3 Stores. This role is crucial in building scalable reporting solutions, implementing automated business processes, developing ELT transformations, and exploring AI opportunities to enhance business efficiency and decision-making. The successful candidate will collaborate with stakeholders, data engineers, analysts, and technology teams to transform data into actionable insights and drive innovation through automation and AI.

Requirements

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.
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
Power BI Report Builder (Paginated Reports)
Power BI Service
Power Automate
SQL
Snowflake Data Platform
DBT
Data Modeling
Power Query (M)
Microsoft Fabric/Azure Data Services
Git / Azure DevOps
AI & Generative AI Technologies
REST APIs and Data Integration
Data Lake (AWS-S3)

Nice To Haves

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

Responsibilities

Design, develop, and maintain Power BI Paginated Reports using 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.
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.
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 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.
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.