Senior Data & BI Architect: Pipelines, Power BI, SQL

(PACS) Providence Administrative Consulting Services, Inc.; United States; On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Health coverage

PTO and vacation

401(k) with company contributions

HSA/FSA

Employee Assistance Plan (EAP)

Job summary

PACS is seeking a Data / Business Intelligence Analyst to join our team. You will design, build, and maintain scalable data pipelines, models, and dashboards using Power BI and SQL, turning complex data into reliable insights for decision makers.

The role requires Python expertise, strong SQL, and hands-on experience with Microsoft Fabric or Delta Lake. You will collaborate with stakeholders, own data infrastructure, enforce governance, and produce repeatable analyses that guide strategy

Qualifications

• Bachelor’s degree in a quantitative or technical field preferred.
• 3-5 years of experience in a data analytics, data engineering, or BI analyst role.
• Proven ability to build and manage data pipelines independently, from ingestion to reporting.
• Proficiency in Python, including scripting, notebooks, and data manipulation libraries.

Responsibilities

• Design, build, and maintain scalable data pipelines using Microsoft Fabric/Delta Lake medallion architecture.
• Develop and optimize SQL queries for data retrieval, transformation, and analysis.
• Create and maintain data models that support accurate, consistent reporting across the business.
• Build and maintain reports and dashboards in Power BI or comparable BI tools.
• Write DAX measures and calculations to support complex business metrics.
• Collaborate with stakeholders to understand data needs and translate them into technical solutions.
• Ensure accuracy, reliability, and governance of data across all pipelines and reports.
• Troubleshoot data and issues and proactively identify opportunities for improvement.
• Document data models, pipeline logic, and reporting standards.
• Stay current with best practices in data engineering, analytics, and the Microsoft Fabric ecosystem.
• Write Python scripts and Jupyter notebooks for data extraction, transformation, and automation.

Skills

Python

SQL

Data pipelines

Data analysis

Microsoft Fabric

Delta Lake

Education

Bachelor's degree in a quantitative or technical field

Tools

Microsoft Fabric

Delta Lake

Job description

PACS is seeking a Data / Business Intelligence Analyst to join our team. You will design, build, and maintain scalable data pipelines, models, and dashboards using Power BI and SQL, turning complex data into reliable insights for decision makers.

The role requires Python expertise, strong SQL, and hands-on experience with Microsoft Fabric or Delta Lake. You will collaborate with stakeholders, own data infrastructure, enforce governance, and produce repeatable analyses that guide strategy