Data Insights Analyst - Power BI Fabric

Merakey
Lafayette Hill, PA, United States
about 2 months ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Compensation
$80,000.0 - $90,000.0
Working hours
Regular working hours
Job source

Tech stack

Data Analysis Databases Data Architecture Data Files Extract Transform Load (ETL) Data Structures Data Warehousing Database Development Microsoft Visual Studio Microsoft SQL Server NoSQL Power BI
+7 more
DataOps SQL Stored Procedures SQL Databases Apache Spark Microsoft Fabric Information Technology Data Analytics

Job description

The Data Insights Analyst plays a critical role within the Data Operations team by transforming raw data into meaningful insights that guide organizational strategy and performance. This hands-on role is responsible for designing robust data structures, mining complex datasets, and supporting analytics initiatives across the organization. The Analyst collaborates closely with both technical and non-technical stakeholders to identify trends, uncover patterns, and deliver insights that strengthen population health, operational effectiveness, and strategic decision-making., * Design and develop scalable, reliable data sets and dashboards to support business intelligence, analytics, and population health initiatives.

  • Partner with stakeholders to understand program and business requirements and translate them into clear technical specifications.
  • Develop and maintain SQL queries, stored procedures, and other database objects to enable efficient reporting and analysis.
  • Consolidate data from internal and external sources to enhance comparative insights and strengthen analytic outputs.
  • Build, refine, and maintain databases used to track and report key performance indicators (KPIs).
  • Ensure the accuracy, consistency, and integrity of data across systems and platforms.
  • Support existing reporting and analytics infrastructure in coordination with DataOps and other IT teams.
  • There may be occasional instances of afterhours/weekend work required for deploying certain production changes or responding to a system outage.

Requirements

This position requires deep technical expertise paired with strong business acumen and the ability to communicate clearly across diverse teams. The Analyst must bring a disciplined approach to data architecture and SQL development, ensuring data accuracy, integrity, and accessibility across platforms., * Bachelor’s degree in Computer Science, Management Information Systems, Information Technology, or Data Science is required. Equivalent experience may be considered for those who can demonstrate proven success as a Business Information Architect, Data Insights Analyst, or in a comparable data-focused role within the healthcare industry.

  • Experience with data modeling, data warehousing, and ETL processes required.

The ideal candidate will possess:

  • Expertise in Power Bi Dashboard/Report Development along with strong proficiency in Microsoft Fabric and enterprise database management systems, including SQL Server.
  • Experience with data modeling, data warehousing, and ETL processes is essential.
  • Strong analytical mindset, excellent problem-solving skills, and high attention to detail.
  • Proficiency with tools such as Visual Studio, MS SQL, NoSQL technologies, and Spark.
  • Knowledge of HIPAA and other regulatory standards strongly preferred
  • Strong communication and interpersonal skills are essential, as the position requires frequent collaboration with both technical and non-technical partners across the organization.

Benefits & conditions

Pulled from the full job description

  • Tuition reimbursement
  • Health insurance
  • Retirement plan
  • Employee discount
  • Vision insurance
  • Dental insurance
  • Employee assistance program, Merakey offers generous benefits that promote well-being, financial security, and work-life balance, including:

. Comprehensive medical, dental, and vision coverage, plus access to healthcare advocacy support.

. Retirement plan - both pre-tax and Roth (after-tax) options available for employee contributions.

. DailyPay - access your pay when you need it!

. On the Goga well-being platform, featuring self-care tools and resources.

. Access Care.com for backup childcare, elder care, and household services.

. Confidential counseling, legal, and financial services through our Employee Assistance Program (EAP).

. Tuition reimbursement and educational partnerships.

. Employee discounts and savings programs on entertainment, travel, and lifestyle.

. Access to Pryor Online Learning for free online personal development classes.

About the company

Merakey is a non-profit provider of developmental, behavioral health, and education services. More than 8,000 employees provide support to nearly 40,000 individuals and families throughout 12 states across the country each year.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

2:00 min

Separating dataset creation from low-level software implementation steps

Jan Zawadzki · World Congress 2022

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · World Congress 2025

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · World Congress 2026 Europe

Videos

See all

Related articles

See all