Power BI Developer

VSG Business Solutions LLC

Boston (MA)

On-site

USD 120,000 - 170,000

Full time

11 days ago

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

VSG Business Solutions LLC in Boston is seeking a Senior Power BI/Data Engineer to design, develop, and maintain enterprise reporting and ELT pipelines using dbt, Snowflake, Power BI, and Power Automate.

This role partners with stakeholders to transform data into actionable insights, automates reporting workflows, and explores AI-enabled improvements across reporting and analytics in an on-site, four-days-a-week setting. 3–7+ years of BI/analytics experience required.

Qualifications

3–7+ years in BI, reporting, analytics, or application development.
Experience developing Power BI Paginated Reports.
Experience with SQL and data modeling.

Responsibilities

Design, develop, and maintain Power BI Paginated Reports and reports.
Publish, manage, and secure reporting assets in Power BI Service.
Build and automate report delivery and workflows with Power Automate.
Design, build, and maintain ELT pipelines using dbt.
Develop scalable data models, testing, and documentation in Snowflake and related stacks.
Validate data quality and support production reporting environments.

Skills

Power BI Development

SQL Development

Data Analysis

ELT/ETL Understanding

Education

Bachelor's degree in Computer Science, Information Systems, Business Analytics, or related field

Tools

Power BI Report Builder

Power BI Service

Power Automate

dbt

Snowflake

AWS S3

Azure DevOps

Git

Job description

4days onsite a week at Boston, MA

Interview Process

1st Video Interview Technical 30 mins
2nd Final Interview Onsite In Boston

Here is the job description:

Need a data-savvy developer who can perform some ETL work with DBT, mine data in Snowflake, and create pipelines that support reporting requirements. DBT is the relevant cloud-based ETL tool.
The expected workflow is for the developer to locate and understand the required source data, combine or prepare it through a DBT pipeline when necessary, and then build the Power BI report. Be able to do end-to-end report development rather than report construction alone.

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.

Education

Bachelor's degree in Computer Science, Information Systems, Business Analytics, or related field; or equivalent combination of education and experience.

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.

Required Knowledge and Skills