US: (877) 240-0467
CA: (888) 624-0014
UK: (020) 7411 9166

Open Positions

Business Intelligence Analyst 

 

POSITION TITLE:

Business Intelligence Analyst 

LOCATION:

Schaumburg, IL or Cambridge, ON 

REPORTS TO:

Vice President, Customer Service 

COMPANY PROFILE

CellTrak is a team of energetic, highly-skilled healthcare and technology experts who help people receive outstanding care in their home and community by solving the problem of how to best manage the delivery of care and the people who deliver it. 

Since 2006, CellTrak has delivered a complete, integrated software-as-a-service solution that facilitates care delivery and real-time field force management - it is to a home care agency as an ERP system is to a manufacturing company. The solution streamlines and automates an agency's core business process, replacing old technology and paper-based process with real-time information for day-to-day care and business management and for optimization. It includes apps for all types of caregivers that run on the leading mobile devices, portals that enable care coordinators, operations personnel, and extended care team to efficiently coordinate and optimize care delivery by a distributed workforce, interfaces to more than 25 leading Electronic Health Records (EHRs), and services to support adoption, management, and optimization.

Today, CellTrak is rapidly growing, venture-backed company. It is a respected brand and the leader in its category, with over 200 customers who operate 4,000 locations in the home health care, home hospice, personal care, and community care markets in the US, Canada, and the UK. CellTrak's customers include leading independent agencies with as many as 20,000 caregivers and major health systems. Combined, they use the software to deliver 1 million in-home visits per week; in 2018, an estimated 500,000 people will receive care enabled by CellTrak. 

THE ROLE DEFINED

The Business Intelligence Analyst is responsible for working with the company's systems, staff and customers to prepare analyses which will inform decision making. Specific responsibilities include: 

  • Extract data from the CellTrak product, Salesforce, Intaact and other company systems
  • Cleanse data to make sure that the data is accurate and reliable
  • Develop reports and dashboards that are easily by management, colleagues and customers
  • Support Industry Advisors with analytics to be used for case studies and white paper
  • Support CSMs, Account Managers and others by providing consumable business intelligence to allow them to better serve their customers
  • Analyze and Research the data in order to provide actionable intelligence to the product team , customer support team and others within the organization
  • Conduct Cohort Analysis of the CellTrak Customer Base
  • Conduct market reseach on the homecare and hospice industry
  • Complete additional responsibilities as assigned

DESIRED EXPERIENCE AND SKILLS

  • 3-5 years' experience in an analytic role
  • Bachelor’s Degree in mathematics, data science, IS preferred
  • Expert-level SQL skills, with the ability to create and optimize queries
  • Familiarity with Big Data technologies such as Hadoop
  • Proficiency in MS Excel, including creation of macros
  • Proficiency in other products within the MS Office suite
  • Experience with Business Intelligence applications such as Tableau, PowerBI or others.
  • Able to understand a relational data model and aggregate data from multiple tables for presentation
  • Able to develop requirements for tools needed and changes to the database to facilitate analytics 
  • Able to manage multiple projects and prioritize appropriately
  • Experience with healthcare data is a plus

BEHAVIORAL COMPETENCIES

  • Analytical
  • Highly organized
  • Clear and concise communication
  • Process-oriented
  • Deadline-driven
  • Push themselves to continually grow and learn
  • Accountable
  • Collaboration

 To be considered for openings, please send or email your resume and cover letter to:

Human Resources
CellTrak Technologies, Inc.
1051 Perimeter Drive, Suite 1000
Schaumburg, IL 60173
careers@celltrak.com

Please indicate your areas of interest as well as preference of office locations.

CellTrak is an equal opportunity employer.