Business Intelligence Developer III

Availity is a Healthcare IT company headquartered in Jacksonville, FL with an office in Bangalore, IN and a significant remote workforce as well. Availity is the nation's largest health information network, connecting 2 million providers nationwide and processing more than 12 billion transactions a year, and growing! We work collaboratively with health plans and providers to disrupt an antiquated healthcare system by solving core issues in the way stakeholders communicate. Fixing the broken provider data management process and creating real time communication of risk and quality information are just two of the ways Availity is streamlining this process. Availity also offers providers, hospitals, and health systems revenue cycle and patient financial management solutions. We help prepare our providers for the rise in consumerism and value-based care, so that they can get paid accurately, and timely, for their services.

Job Summary:

The BI Developer III is responsible for leading and developing complex data model designs for business intelligence tools and creating compelling and intuitive data visualizations. This individual will translate business requirements into technical requirements, conduct hands-on analysis, and ensure deliverable commitments are met. You will partner with product and technical teams throughout the product development lifecycle to create solutions that utilize and translate data and analytics into visual storytelling. You will actively participate in discovery, solutioning, and development by deeply understanding the product vision and proactively making recommendations that bring our vision to life. This role also serves as a mentor to colleagues by sharing knowledge and skillsets that are pertinent to a successful analytics team.

This position be part of our Payment Accuracy team and will help define and build our suite of data and analytics products that support the team's vision and mission. You will help create and build data sets that measure efficiency, enable workflow optimization, track new product adoption, and support research and development. This role works directly with the product owner, product analyst, data architect, and development manager to research and identify business requirements with sufficient detail and clarity to allow the development of the data or reporting solution needed.

***Sponsorship for this role of any kind will not be accepted***

To be qualified for this position, you:

• Bachelor's degree (preferably Information Systems, Computer Science, Statistics, Business Management, or equivalent Certifications)

• 4-6 years of experience with AWS QuickSight (or other BI tools such as Tableau, Power BI, Domo).

• 4-6 years of experience and strong proficiency in SQL and Python with experience in writing, debugging, and optimizing complex queries.

• 4-6 years of data modeling within a business intelligence tool

• Proficiency in relational databases; design, structure, data associations, and query language.

• Experience in conducting root cause analysis and recommend corrections to data issues reported by customers or exceptions reports.

• Experience in cross-examination of multiple data sources to provide actionable insights and feedback.

• Ability to develop strong relationships with management and team to enhance knowledge and lead project work with minimal direction. Maintains composure and professionalism in a fast-speed environment.

• Able to plan work, set clear direction, and coordinate own tasks in a fast-paced multi-disciplinary environment. Proficient at triaging issues, identifying data abnormalities, and debugging software

• Experience with product discovery/R&D and comfortable collaborating with product teams to help define business and technical requirements

• Capable of clearly presenting findings in oral, written, and graphical forms

• Flexible and able to embrace change

To differentiate yourself, you:

• Experienced in manipulating and analyzing large-scale health administrative claims (Commercial, Medicare), billing, operational, customer service and click-stream data, knowledge of different dataset's limitations and strengths

• Experience in healthcare industry data such as X12, CPT/HCPCS, ICD-10

• AWS experience including but not limited to Redshift, S3, Airflow, Quicksight

• Ability to work collaboratively in a team and proactively suggest solutions to business problems.

• You are passionate about telling compelling stories using data

• Comfortable with ambiguity

• Ability to nimbly pivot and respond to change when needed

What you will be doing:

• Collaborate closely with business stakeholders, including product management, business development, customer service, and clients, to define project scope, requirements, and timeline

• Analyze healthcare data, including healthcare transactions, medical procedures, health conditions, and provider practices

• Apply statistical, predictive modeling, and/or data mining techniques to develop analytical solutions

• Creating complex but easy to use data models for end-users to create data analytics products such as dashboards and reports

• Work with engineering teams to enhance data model, improve ETL methodologies, and optimize cloud computing performance

• Apply business acumen to enhance data cleaning and curation methodologies to ensure accurate and reliable inputs to analysis and predictive modeling

• Identify data abnormalities and their root causes, suggest possible steps for mitigation, and liaise with data steward to develop long-term solutions

• Assess and explain the impact of data and methodology changes on analysis results to technical and non-technical audience

• Identify opportunities for process improvement. Design and implement the new workflow

• Coach, mentor, and knowledge share for growth of the team and quality improvement. Work with junior data analysts in technical aspects including but not limited to applying industry standards and query optimization recommendations.

Why you want to work on this team:

• The Payment Accuracy team is focused on delivering solutions that optimize healthcare experiences for payers, providers, and members.

• We are a fast-paced, innovation-minded team that has the opportunity to make significant impact within the enterprise and the healthcare industry.

• Your voice will have a direct impact on what we build and will ensure we create innovative data and analytics solutions that wow our stakeholders and clients

• This is a great opportunity for someone who has advanced data analytic experience and knowledge and wants to share the knowledge with others

• This role works primarily with internal stakeholders and provides great exposure to different teams within the organization daily

Why work at Availity:

• Availity is a certified "Great Place to Work", a "Best Workplaces for Technology Companies", a "Best Workplaces for Women" and a "Best Workplaces for Millennials"!

• Culture is important to us and there are many ways for you to make your mark here!

• We have several Diversity & Inclusion teams and various ways to engage with fellow Availity associates. "AvaiLadies", "Beyond Black", "HOLA", "Availity Pride", "VetAvaility" a Young Professionals Group and "She Can Code IT" a group for women in tech are some of the groups you can get involved in.

• Availity is a culture of continuous learning. We have many resources and experts in our tech stack and in our industry that can help get you there too!

• We offer a competitive salary, bonus structure, generous HSA company contribution, healthcare, vision, dental benefits and a 401k match program that you can take advantage of on day one!

• We offer unlimited PTO for salaried associates + 9 paid holidays. Hourly associates start at 19 days of PTO and go up from there with all the same holiday benefits.

• Interested in wellness? We allow our associates to reimburse up to $250/year for gym memberships, participation in racing events, weight management programs, etc.

• Interested in furthering your education? We offer education reimbursement!

• Availity offers Paid Parental Leave for both moms and dads, both birth parents and adoptive parents.

• Want to work for an organization that gives back to the community? You're at the right place! Availity partners with various organizations, both locally and nationally, to raise awareness, funds and morale as our staff members volunteer their time and funds to engage the organizations campaign.

Next steps in process:

After you apply, you will receive text/email messages thanking you for applying and then you will continue to receive more text/email messages alerting you as to where you are in the recruitment process.

Interview process:

• Recruiter Interview

• Manager Interview

• Technical Assessment

• Panel interview