Job Description

Are you looking for an opportunity to advance your career while working with an extraordinary team? At Merakey, we put heart and soul into everything we do. We are seeking a full-time Data Insights Analyst to join our Data Insights team.

Salary Range - $80,000-90,000

This is remote position available to candidates in PA, NJ, or DE

Occasional travel to headquarters in Lafayette Hill, PA required.

Position Details:

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.

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.

Key Responsibilities

• 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.

Benefits

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.

Learn more about our full benefits package - https://www.merakey.org/careers/benefits

About Merakey

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.

Click here to watch a video about Merakey.

Merakey strictly follows a zero-tolerance policy for abuse.

Merakey is proud to be an Equal Opportunity Employer! We deeply value diversity and do not discriminate on the basis of race, religion, color, national origin, ethnic background, sex, gender, gender identity, sexual orientation, age, marital status, veteran status, genetic information, or disability status. Moreover, we are committed to creating teams that reflect the diversity of the communities we serve and encourage applicants from underrepresented backgrounds to apply. Merakey welcomes all Veterans to apply!

Qualifications

• Bachelor’s degree in Computer Science, Management Information Systems, Information Technology, or Data Scienc e 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.