Data Analyst - Power BI

Piper Companies; Columbia (MD); On-site; USD 105,000 - 115,000; Full time

Benefits offered by this job

Comprehensive benefits package

401(k)

PTO and holidays

Job summary

A leading technology firm is looking for a Data Analyst to work fully remote within a mission-driven Digital Transformation team. The candidate will play a vital role in transforming data into actionable insights that enhance operational efficiency and product performance. In this role, you will partner with cross-functional teams to develop KPIs, support data modeling efforts, and contribute to analytical reporting. The position requires strong skills in SQL, Python, and Power BI, along with a Bachelor's degree in a related field.

Qualifications

• 3+ years of professional experience in data analysis or a related field.
• Strong analytical skills to translate complex data into actionable insights.
• Proficient in data visualization and reporting.

Responsibilities

• Identify and document key performance metrics for digital products.
• Clean, model, and prepare data using SQL and Python.
• Develop and optimize Power BI dashboards.
• Communicate findings to cross-functional teams.
• Support product teams with data-driven recommendations.

Skills

Data modeling and analysis

Power BI

Python

SQL

Excel

Education

Bachelor’s degree in Computer Science, Mathematics, Statistics, or a related field

Tools

Databricks

Microsoft SQL Server

GitHub

Azure DevOps

Job description

Piper Companies is seeking a Data Analyst to join a mission‑driven Digital Transformation team focused on reshaping how patients and providers interact through innovative digital solutions. This role plays a key part in enabling data‑driven decision making by transforming complex data into actionable insights that drive operational efficiency, product performance, and meaningful business outcomes. This position is fully remote, with occasional travel for team‑building on client site.

Overview

In this role, you will partner with product, clinical, operational, and analytics stakeholders to understand business objectives, prepare and model data, and deliver reporting that clearly communicates progress toward key product goals. You will support the development of KPIs, build Power BI dashboards, and provide analytical insights that guide product and operational decisions. You will work under the supervision of the Sr. Director of Data & Analytics and collaborate closely with cross‑functional teams across the organization.

Key Responsibilities

• Identify, define, and document key performance metrics for digital products, ensuring consistent and repeatable KPI definitions.
• Clean, model, and prepare data from the enterprise data warehouse and other primary sources using SQL, Python/Pandas, and Databricks.
• Develop, maintain, and optimize Power BI dashboards and visualizations that clearly communicate product performance to stakeholders.
• Respond to ad‑hoc reporting requests by gathering and analyzing data to answer business and operational questions.
• Communicate analytical findings through clear written summaries, presentations, and discussions with product, clinical, and operational teams.
• Collaborate with data scientists and analytics staff to operationalize data workflows and support modeling efforts.
• Partner with product teams to understand business needs, identify opportunities for improvement, and provide data‑driven recommendations.
• Participate in departmental meetings, cross‑functional committees, and quality/service improvement initiatives.
• Adhere to departmental policies, procedures, quality standards, and regulatory requirements.
• Perform additional duties as assigned.

Qualifications

Education & Training

• Bachelor’s degree in Computer Science, Mathematics, Statistics, or a related field.

Experience

• 3+ years of professional experience in data analysis or a related field.

Knowledge, Skills & Abilities

• Strong data modeling and analysis skills, including experience with Databricks, Python/Pandas, and SQL.
• Proficiency working with large relational databases (Microsoft SQL Server preferred).
• Experience with version control tools such as GitHub or Azure DevOps.
• Advanced Power BI skills, including building dashboards, visuals, and DAX measures.
• Strong Excel proficiency.
• Excellent written and verbal communication skills, with the ability to translate complex data into clear insights for diverse audiences.

Compensation & Benefits

• Salary: $105,000 – $115,000 annually.
• Work Environment: Fully remote with occasional travel for team‑building.
• Comprehensive benefits package including Medical, Dental, Vision, 401(k), PTO, holidays, and sick leave as required by law.

Keywords:

data analyst, digital transformation, data modeling, databricks, delta lake, python, pandas, sql, microsoft sql server, relational databases, data cleaning, data preparation, data pipelines, kpis, product analytics, product metrics, performance metrics, power bi, dax, dashboards, data visualization, business intelligence, bi reporting, excel, version control, github, azure devops, enterprise data warehouse, edw, data wrangling, data storytelling, stakeholder communication, cross‑functional collaboration, ad‑hoc reporting, analytics insights, operational analytics, product analytics, healthcare analytics, digital product performance, metric definitions, data workflows, data scientists, analytics engineering, data-driven decision making, remote role, healthcare technology, clinical operations, operational efficiency, business outcomes, python scripting, spark, big data, data modeling best practices, data governance, data quality, data validation, kpi development, metric tracking, business alignment, actionable insights, product teams, product performance reporting, data visualization best practices, remote work, occasional travel, piper companies