15 49.0138 8.38624 1 1 4000 1 https://freedmanhealthcare.com 300 true

Careers

Careers

Business Analyst/Programmer

Freedman HealthCare (FHC) specializes in health care performance measurement and improvement, health information technology, and strengthening linkages between public health and health care reform. Through our national work with state health organizations and policy makers, FHC is committed to creating a more efficient health care system.  FHC is seeking an experienced Business Analyst/Programmer to join our team at Freedman HealthCare.

Analytical skills

  • Help clients define critical business reporting strategies by reviewing, analyzing and documenting business processes and user needs
  • Develop, test, implement, and maintain reports in various formats (flat, drillable, graphic, charts, dashboards, KPIs) drawn from inter and intra application data stores and made available through various methods
  • Understand customer requirements and business objectives
  • Transform ad hoc and manual processes into sustainable, repeatable, scalable, and automated solutions
  • Proven ability to analyze an organization’s current technologies and needs to make recommendations and provide guidance
  • Exceptional critical thinking and problem-solving skills
  • Provide strategic advice on using technology to achieve goals
  • Advise clients on data management and data governance best practices, including data mapping and migration, conceptual and physical data models, quality assurance, and integrity
  • Develop data visualizations and dashboards in Tableau, PowerBI, BusinessObjects, or other comparable tools
  • Understand specific focus on health care claims and eligibility data

Technical capabilities

  • Familiar with databases, data architecture and data modeling concepts and methodologies (e.g. Kimball vs. Inman; relational vs. dimensional models)
  • Understand concepts of master data management
  • Experience with extract, transform, load (ETL)
  • Proficient with business intelligence/data visualization tools, such as Tableau, Cognos, Power BI, etc.
  • Develop complex/multi-data source queries
  • Develop complex SQL queries and reports
  • Strong Microsoft Excel skills, including pivot tables, ODBC or other direct connections to data warehouses (macros, conditional formatting, complex formulas)
  • Translate high-level design into specific implementation steps

3-5 years’ experience, preferably with health care claims datain a complex analytic and reporting environment..

Experience with SQL is required. In addition, R, Python and Visual Basic knowledge is a plus

Bachelors degree in a related field required.

Location: Newton, MA (work must be performed on site; no remote possible)

To apply for this position, please contact Joanne Halpern at hr@freedmanhealthcare.com. ​Interested candidates should reply with BOTH a thoughtful cover letter with salary requirements and a resume.

Data Architect | Rhode Island Data Ecosystem and All Payer Claims Database

Position Description
Freedman HealthCare is seeking an experienced Data Architect for the State of Rhode Island to join their growing cross-agency business intelligence team that integrates data from across the state to help better steward state resources and serve Medicaid beneficiaries, however they interact with the state. This person will serve as a Senior contractor for the work, overseeing highly complex data integration and modeling to support data product opportunities, such as such as interactive reports and dashboards and curated data sets modeled for specific project purposes.

About the Client:

The state of Rhode Island, led by the Executive office of Health and Human Services (EOHHS), has developed an integrated data environment – the Data Ecosystem – that provides operational analytic solutions to internal clients (other state agencies), self-service analytics for staff across the state, and increasingly, analytic product solutions to external partners, including higher education, researchers and evaluators. They have integrated, at the person level, over 15 data sources across EOHHS and a few other agencies, developed a robust person matching process, and delivered several major and dozens of smaller data-driven projects that have, in some cases, directly led to state policy changes.

The Ecosystem also houses the All Payer Claims Database (APCD), a powerful tool that collects, organizes, and visualizes medical claims data from most public and private payers in the State. Its depth and breadth of data allow policy makers, legislators, and state program managers to make data-driven policy decisions, understand the full picture of health care spending and utilization in Rhode Island for Medicaid and comparative populations, and recognize trends in disease burden early and accurately. The Ecosystem and the APCD together form the integrated data warehouse component of the Medicaid IT Enterprise.

 

About Freedman HealthCare:
Freedman HealthCare (FHC) specializes in health care performance measurement and improvement, health information technology, and strengthening linkages between public health and health care reform. Through our national work with state health organizations and policy makers, FHC is committed to creating a more efficient health care system.

Job Requirements of the Data Architect

  • Support the Deputy Director of Data and Analytics of EOHHS oversee the end-to-end technical structure of the Data Ecosystem, the integrated data environment which provide self-service and centralized analytics and houses the All Payer Claims Database (APCD).
  • Support data intake, modeling, and solution deployment.
  • Support the continuous improvement of the person mastering process.
  • Ensure high availability of the databases using database management tools such as database mirroring, database clustering and hardware tools.
  • Perform database administration: database recoverability, integrity, security, availability, performance, patching, scheduled updates and development/testing support.
  • Document and maintain database data dictionaries, database storage definitions, security policies and other documentation required for database integrity, as needed.
  • Work with security, operational and administrative staff in day to day operations and to develop formal procedures to manage the databases.
  • Create testing, development and training database instances or copies.
  • Execute secure operations of the staging, development and production data environments of the EOHHS Data Ecosystem and APCD.
  • Provide recommendations for entity relationships, database and table design, and database normalization.
  • Creation of SQL statements, database triggers and stored procedures.

 

Skills & Experience

  • Excellent written and oral communication – cover letter explaining your interest in the role and how your experience fits is required.
  • Demonstrated deep commitment to customer needs.  In this role, your clients are often your colleagues.
  • Fluency in SQL; Experience with SQL Server, PowerBI, or similar BI tools preferred.
  • Successful experience building and maintaining a structured analytic environment with responsibility for optimizing performance and usability.
  • Experience with assessing data quality, identifying data and reporting errors, implementing strategies to assure data integrity.
  • Thorough knowledge of software application requirements to effectively interface with the database.
  • Ability to maintain and enforce database standards, policies and procedures across the enterprise and organizations.
  • Ability solve computer operational and software problems; and related capacities and abilities.
  • Successful experience building and maintaining a structured analytic environment with responsibility for optimizing performance and usability.
  • Experience with assessing data quality, identifying data and reporting errors, implementing strategies to assure data integrity.
  • Careful and demonstrated attention to detail.

This is a full-time contractual position located in Cranston, RI

Senior BI Analyst | Rhode Island Data Ecosystem and All Payer Claims Database

Position Description
Freedman HealthCare is seeking an experienced analyst for the State of Rhode Island to join their client’s growing cross-agency business intelligence team that integrates data from across the state to help better steward state resources and serve Medicaid beneficiaries, however they interact with the state. This person will serve as lead analyst supporting BI for Medicaid programs and demonstrations, including the development of highly complex data products, interactive reports and dashboards and curated data sets modeled for specific project purposes. If you join this team, some of your projects might look to answer the following:

  • What is the statistically significant cross-agency and whole-family characteristics of high Medicaid utilizers, for distinct types of utilizers? What notable non-medical experiences can help us better address the needs of these individuals and their family support networks?
  • When a family or individual exhausts unemployment insurance benefits, what are some of the common next experiences within Medicaid? How do reduced cash support correlate with medical experiences and enrollment in other safety et benefits?
  • Which census blocks are associated with multi-system high utilizers? Where are our true hot spots and how many different statistically significant types of high-utilizers exist who we can meaningfully support through program changes?

About the Client:

The state of Rhode Island, led by the Executive office of Health and Human Services (EOHHS), has developed an integrated data environment – the Data Ecosystem – that provides operational analytic solutions to internal clients (other state agencies), self-service analytics for staff across the state, and increasingly, analytic product solutions to external partners, including higher education, researchers and evaluators. They have integrated, at the person level, over 15 data sources across EOHHS and a few other agencies, developed a robust person matching process, and delivered several major and dozens of smaller data-driven projects that have, in some cases, directly led to state policy changes.

The Ecosystem also houses the All Payer Claims Database (APCD), a powerful tool that collects, organizes, and visualizes medical claims data from most public and private payers in the State. Its depth and breadth of data allow policy makers, legislators, and state program managers to make data-driven policy decisions, understand the full picture of health care spending and utilization in Rhode Island for Medicaid and comparative populations, and recognize trends in disease burden early and accurately. The Ecosystem and the APCD together form the integrated data warehouse component of the Medicaid IT Enterprise.

About Freedman HealthCare:
Freedman HealthCare (FHC) specializes in health care performance measurement and improvement, health information technology, and strengthening linkages between public health and health care reform. Through our national work with state health organizations and policy makers, FHC is committed to creating a more efficient health care system.

Job Requirements:

  • Oversees and develop data products supporting evaluations of Medicaid programs and demonstrations.
  • Understand and develop customer requirements and business objectives; translates high-level design into specific implementation steps.
  • Transforms ad hoc and manual processes into sustainable, repeatable, scalable, and automated solutions.
  • Leverage Agile- and/or Scrum-based solutions.
  • Develop complex SQL queries and reports.
  • Develop complex/multi-data source queries.
  • Trains, guides and mentors Jr. analytic contractors.
  • Supports data quality efforts.

Skills & Experience

  • Excellent written and oral communication – cover letter explaining your interest in the role and how your experience fits is required.
  • Demonstrated deep commitment to customer needs.  In this role, your clients are often your colleagues – fellow state government employees – and increasingly research partners outside the state.
  • Experience in SQL. Experience with SQL Server, PowerBI, or similar BI tools preferred.
  • Experience with assessing data quality, identifying data and reporting errors, implementing strategies to assure data integrity.
  • Exceptional critical thinking and problem-solving skills.
  • Careful and demonstrated attention to detail.
  • Experience working with heath and/or human service data.

This is a full-time position located in Cranston, RI