Summary:
This Data Analytics Developer position is responsible for developing, maintaining, and supporting the business analytics solutions for the company. The position requires expertise in relational and multidimensional database schemas. Primary responsibilities include designing and building OLAP (online analytical processing) cubes, applying data mining algorithms, writing queries, and designing reports. This includes the aggregation of data from multiple sources in an efficient data warehouse to support the company’s business intelligence needs.
Essential Functions:
- Primarily serving as a liaison with the Finance department, including involvement with new projects as well as ongoing support to facilitate data related needs for revenue cycle and credentialing.
- Overseeing the development and operations of an enterprise data warehouse, combining data from disparate data sources, systems, and vendors.
- Managing inbound and outbound data feeds, including billing files to our 3rd party billing company.
- Coordinating with company’s management and project team members to identify key performance indicators and to design and implement reporting solutions to provide real-time access to these measures.
- Improving and streamlining processes regarding data flow and data quality to improve data accuracy, visibility, and value.
- Overseeing the ongoing development and operations of a business intelligence architecture that enables fact-based decision making and ad hoc analysis.
- Documenting business requirements and technical designs.
- Developing test scripts and documented use cases. Coordinating with users to test, validate, troubleshoot, and enhance analytics applications and reports.
- Managing database, application, and report change requests within ITIL best practices for change management.
- Managing projects and tasks using Lean and Agile development principles.
- Other duties as assigned.
- Regular and timely attendance required.
Qualifications:
Education:
- Bachelor’s degree in Computer Science or related field, or any equivalent combination of education and experience which provides the required knowledge, skills, and abilities to perform the essential functions of the position.
Experience:
- 3+ years of relevant work experience in the development of data warehouse and analytics solutions.
- Healthcare industry related experience preferred.
Skills/Knowledge:
- Proven experience with Microsoft SQL Server development and administration, with extensive experience in complex database and query design.
- Working knowledge and experience in OLTP relational data, dimensional data modeling techniques, and OLAP cubes, metadata, and reports.
- Extensive experience in ETL (Extract, Transform, Load) using Microsoft Integration Services / SSIS.
- Tableau and/or equivalent reporting software experience required.
- PowerShell and/or Command Line experience preferred.
- Dashboard/UX (User Experience) design.
- Experience with healthcare billing and revenue cycle data preferred.
- Project Management experience preferred.
- Natural Language Processing (NLP) experience preferred.
- C# experience a plus.
- Ability to work within a team-based environment.
- Experience with developing analytics solutions using non-relational data preferred.
- Exceptional interpersonal, verbal, and written communication skills.