Roundstone
Business Intelligence (BI) Analyst Healthcare Data
Roundstone, Rocky River, Ohio, United States, 44116
Overview
Base pay range: $80,000.00/yr - $90,000.00/yr. We are looking for a technically skilled and business-minded BI Analyst to join our growing team. You will work closely with stakeholders to transform raw healthcare data (claims, eligibility) into clear, actionable insights. This role requires strong data analysis, SQL, Power BI, and data engineering skills to support strategic decision-making across the organization. Responsibilities
Data Collection & Preparation: Gather, clean, and integrate healthcare data from internal and external sources. Ensure data accuracy, integrity, and accessibility across systems. Analysis & Insights: Use advanced SQL for data querying, optimization, and root cause analysis. Analyze trends and identify business opportunities through data. Visualization & Reporting: Develop and maintain Power BI dashboards and reports. Implement Row-Level Security (RLS) and reusable datasets for consistent reporting. Support enterprise-wide Power BI deployment with a focus on performance, governance, and scalability. Stakeholder Collaboration: Work with business leaders to gather requirements and align insights with goals. Present complex findings in an understandable, actionable format. Data Engineering & Automation: Use Python to parse JSON, XML, and flat files and automate ingestion pipelines. Monitor and troubleshoot SFTP file transfers. Maintain knowledge of database structures and schemas. Governance & QA: Conduct QA to validate data accuracy and integrity. Manage version control using Git. Ensure data security and HIPAA compliance. Skills & Qualifications
Bachelors degree in Data Science, Computer Science, Statistics, or related field. 5+ years in BI, data analysis, or analytics roles (healthcare experience preferred). Expertise in Power BI (DAX, data modeling, automated dashboards). Strong SQL skills for data transformation and ETL processes. Experience with Python scripting and file format parsing (JSON, XML, CSV). Familiarity with SFTP and Git/version control. Ability to explain complex data to non-technical audiences. Understanding of healthcare claims and eligibility data is a plus. Benefits
Medical, dental and vision benefits Annual bonus Dependent care 100% match up to max allowable Parental leave PTO beginning on Day 1 Tuition reimbursement Healthy work/life balance Hybrid office schedule 401(k) plan with company match Employee Assistance Program On-site gym with personal trainer access Life insurance and short term disability insurance About Roundstone
Headquartered in Rocky River, Ohio, Roundstone is recognized as a Northeast Ohio Top Workplace. We foster a supportive, values-driven culture where employees feel engaged, valued, and celebrated. We have been named an Inc. 5000 award recipient for eight consecutive years, reflecting our growth and success. #J-18808-Ljbffr
Base pay range: $80,000.00/yr - $90,000.00/yr. We are looking for a technically skilled and business-minded BI Analyst to join our growing team. You will work closely with stakeholders to transform raw healthcare data (claims, eligibility) into clear, actionable insights. This role requires strong data analysis, SQL, Power BI, and data engineering skills to support strategic decision-making across the organization. Responsibilities
Data Collection & Preparation: Gather, clean, and integrate healthcare data from internal and external sources. Ensure data accuracy, integrity, and accessibility across systems. Analysis & Insights: Use advanced SQL for data querying, optimization, and root cause analysis. Analyze trends and identify business opportunities through data. Visualization & Reporting: Develop and maintain Power BI dashboards and reports. Implement Row-Level Security (RLS) and reusable datasets for consistent reporting. Support enterprise-wide Power BI deployment with a focus on performance, governance, and scalability. Stakeholder Collaboration: Work with business leaders to gather requirements and align insights with goals. Present complex findings in an understandable, actionable format. Data Engineering & Automation: Use Python to parse JSON, XML, and flat files and automate ingestion pipelines. Monitor and troubleshoot SFTP file transfers. Maintain knowledge of database structures and schemas. Governance & QA: Conduct QA to validate data accuracy and integrity. Manage version control using Git. Ensure data security and HIPAA compliance. Skills & Qualifications
Bachelors degree in Data Science, Computer Science, Statistics, or related field. 5+ years in BI, data analysis, or analytics roles (healthcare experience preferred). Expertise in Power BI (DAX, data modeling, automated dashboards). Strong SQL skills for data transformation and ETL processes. Experience with Python scripting and file format parsing (JSON, XML, CSV). Familiarity with SFTP and Git/version control. Ability to explain complex data to non-technical audiences. Understanding of healthcare claims and eligibility data is a plus. Benefits
Medical, dental and vision benefits Annual bonus Dependent care 100% match up to max allowable Parental leave PTO beginning on Day 1 Tuition reimbursement Healthy work/life balance Hybrid office schedule 401(k) plan with company match Employee Assistance Program On-site gym with personal trainer access Life insurance and short term disability insurance About Roundstone
Headquartered in Rocky River, Ohio, Roundstone is recognized as a Northeast Ohio Top Workplace. We foster a supportive, values-driven culture where employees feel engaged, valued, and celebrated. We have been named an Inc. 5000 award recipient for eight consecutive years, reflecting our growth and success. #J-18808-Ljbffr