Senior Business Intelligence Developer
Apply NowCompany: OpTech
Location: Troy, MI 48085
Description:
Why work at OpTech? OpTech is a woman-owned company that values your ideas, encourages your growth, and always has your back. When you work at OpTech, not only do you get health and dental benefits on the first day of employment, but you also have training opportunities, flexible/remote work options, growth opportunities, 401K and competitive pay. Apply today! OpTech is an EOE, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. https://www.optechus.com/eeo_self_identification/
Duties:
Under the direction of a Manager, Director or Lead/Experienced developer, implements a comprehensive program to extract data using a computer programming language or collect data, then analyze it and effectively report information from this data to a variety of customers in a user-friendly and actionable way. This position generates reports, develops tools and provides consultative support as needed. Our customers include physicians, physician groups, physician leaders, hospital leaders, the Board of Trustees, system leadership, transformation consulting, clinical/non-clinical services, Markets, Community, Service Lines, Revenue Cycle, Finance, external oversight/regulatory bodies, or any other user needing information.
The Senior Business Intelligence Developer should be able to enhance the data driven culture within our client, must be able to work in cross-collaboration to gather data,
generate reports, develop automated tools, and provides actionable interpretation of information to all the customers. The candidate must be able to present information to customers at all levels, including but not limited to executives, physicians, clinical staff, peers, and external oversight/regulatory bodies. Independently develop comprehensive data assets, ad-hoc reports and implement new or improved reporting processes to support strategic goals, clinical efforts, and any business initiative. Must be able to work with least amount of direction, manage deadlines, maintain timeliness, delivery, and high quality of the products. Anticipate and quickly adapt to evolving needs of the customer. Consistently demonstrate excellent analytical and problem-solving skills while maintaining keen attention to detail. Candidate must be able to handle complex and ambiguous requests, maintain timeliness of delivery, data quality and manage changing
deadlines.
Skills:
29206
Duties:
Under the direction of a Manager, Director or Lead/Experienced developer, implements a comprehensive program to extract data using a computer programming language or collect data, then analyze it and effectively report information from this data to a variety of customers in a user-friendly and actionable way. This position generates reports, develops tools and provides consultative support as needed. Our customers include physicians, physician groups, physician leaders, hospital leaders, the Board of Trustees, system leadership, transformation consulting, clinical/non-clinical services, Markets, Community, Service Lines, Revenue Cycle, Finance, external oversight/regulatory bodies, or any other user needing information.
The Senior Business Intelligence Developer should be able to enhance the data driven culture within our client, must be able to work in cross-collaboration to gather data,
generate reports, develop automated tools, and provides actionable interpretation of information to all the customers. The candidate must be able to present information to customers at all levels, including but not limited to executives, physicians, clinical staff, peers, and external oversight/regulatory bodies. Independently develop comprehensive data assets, ad-hoc reports and implement new or improved reporting processes to support strategic goals, clinical efforts, and any business initiative. Must be able to work with least amount of direction, manage deadlines, maintain timeliness, delivery, and high quality of the products. Anticipate and quickly adapt to evolving needs of the customer. Consistently demonstrate excellent analytical and problem-solving skills while maintaining keen attention to detail. Candidate must be able to handle complex and ambiguous requests, maintain timeliness of delivery, data quality and manage changing
deadlines.
Skills:
- Create reports, metrics, tools, data models, data-marts, cubes, dashboards, document process flows, fulfil data needs for the Service Lines on priority basis and work on one-time requests from other areas of the system.
- Value Based Care IT & Analytics
- Gather detailed requirements, document them in our central intake process then identify existing solutions in the Analytics space OR if a new solution is needed then create a detailed product delivery plan, navigate tools, pull preliminary data from internal systems plus external systems such as MiHIN, Payor Interfaces, Azara and any others as required.
- Per-Member-Per-Month, Case Management, Ambulatory and Utilization Management
related work as directed by the leadership. - Revenue Cycle Analytics
- Working with charge, payments, adjustments, billing and claims data.
- Create reports aligned with the yearly Playbook initiatives.
- Develop customer requested automated tools, reports, dashboards, data models, data-marts, data analyses for Coding, Billing, Bad Debt, Payments, Revenue,
- Customer Service data and others as needed.
- Bachelor's Degree with a Healthcare, Computer Science, Engineering,
Mathematics/Statistics, Business, OR an Applied Science major. - Three to four (3-4) years of experience in a Healthcare OR Business setting.
- Expert in the use of advance Excel, SQL, report building, tool development,
requirements gathering and technical documentation. - Experience in the use and design of Relational Databases, Data Models, Data
Visualizations, curated datasets, data cubes OR experience in Electronic Medical
Record (EMR) report development, functionality of any EMR (Epic, Cerner, McKesson
or other widely used EMRs). - Maintain code repositories on SCM system, familiar with merging, pushing, pulling,
branching, staging and code commenting OR MS TFS. - Good understanding of fundamental Computer Programming concepts OR Electronic
Medical Record systems. - Basic understanding of Statistical and Machine Learning concepts.
- Basic understanding of dimensional models and Data Warehouse OR Electronic
Medical Record system. - Experience in any Business Intelligence tools such as Tableau, Cognos, Looker,
Toad, Minitab, Power BI, Qlik, SSRS OR any other. - Develop multidimensional semantic layer and analytics query objects for end-users.
- Proven customer service experience with strong active listening skills.
- Able to present complex information to diverse audiences.
- Excellent written and verbal communication skills.
- Make decisions with Diversity, Equity, Inclusion and Justice in mind.
29206