Data Analyst - Power BI - 160319

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

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k)

PTO & holidays

Job summary

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 is fully remote with occasional travel for team building on client site.

You will partner with product, clinical, operational, and analytics stakeholders to transform data into actionable insights that drive product performance, operational efficiency, and business outcomes.

Qualifications

• Bachelor’s degree in CS, Math, Statistics, or related field.
• 3+ years of professional data analysis experience.
• Strong data modeling and analysis skills with Databricks, Python/Pandas, and SQL.

Responsibilities

• Define and document KPI metrics for digital products.
• Develop and maintain Power BI dashboards.
• Prepare and model data from data warehouse.
• Respond to ad-hoc reporting requests.
• Communicate findings to cross-functional teams.
• Collaborate with data scientists to operationalize data workflows.
• Support data-driven product and operational decisions.
• Ensure compliance with policies and quality standards.

Skills

Data modeling

SQL

Python / Pandas

Power BI

Excel

Communication

Education

Bachelor’s degree in CS/Math/Stats

Tools

Databricks

GitHub

Azure DevOps

SQL Server

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.

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