Business Intelligence Developer

About the job
This is a hybrid role in our office in Denver, Colorado with the flexibility to work from home. We will also consider remote candidates.
Roles based outside of our Denver office can sit in any of the followin g 36 states AL, AZ, AR, CA, CO, FL, GA, IL, IN, IA, KS, KY, LA, MA, MD, MI, MN, MO, MS, NE, NC, NJ, NV, NM, NY, OH, OK, PA, SC, TN, TX, UT, VA, WA, WV, and WI.
The Opportunity
The Business Intelligence Developer plays a key role in helping our revenue cycle management operations teams review and evaluate performance within our Eligibility and Claims Management spaces. Through data analysis, they will be responsible for deriving insights and making recommendations for process/policy improvements, training, product enhancements, automation, etc. Through these initiatives, the Business Intelligence Developer will help drive continuous improvement and create world-class customer experiences.
What You Will Do:

• Collect, organize, analyze data from various sources including databases, data warehouses, Tableau, Google Sheets
• Analyze data and convert it to actionable insights through creation and implementation of innovative, flexible and informative reports to drive growth, margin improvement, and strategic business management.
• Identify productivity, quality, or strategic opportunities by aggregating and analyzing data sets for patterns, relationships, trends and important findings or business outcomes. Communicate findings to key staff and leadership by means of informative, actionable reports. These reports will support key decisions and strategic processes.
• Executes data quality and validation processes. Advises management on the consistency, reliability and validity of data.
• Evaluate accuracy of insurance estimates and identify opportunities for increase accuracy and automation
• Evaluate effectiveness of insurance claims processes and identify opportunities to streamline / automate
• Participate in operation cross-functional meetings and advise on product / process improvement priorities
• Support real time requests as needed to help review and respond to customer requests
• Create ad-hoc reports to assist with root cause analysis

What You Will Bring:

• 5+ Years of experience with business intelligence & analytics in an operations environment
• Bachelor's degree in Computer Science, Business Analytics, Data Analytics, Operations Research or similar area preferred.
• 2+ years work experience with relational databases, writing efficient queries, and pulling large data sets from data warehouses/marts.
• 2+ years work experience with Tableau or other tools developing and publishing reports and visualizations.
• Demonstrated experience in the areas of statistical analysis, data trending, data forecasting, development of business intelligence reporting.
• Strong written and verbal communication skills.
• Strong working knowledge of the insurance industry and advanced data mining tools preferred;
• Understand the business functions and needs for information. Understand the impact of results on all affected stakeholders. Independent learner who can acquire the necessary business knowledge to complete the work.
• Excellent analytical and problem-identification/solving skills. Ability to take initiative, embrace challenges and develop creative solutions. Ability to troubleshoot and solve issues with reports and questions related to reporting.
• Strong sense of priorities and objectives; ability to anticipate needs, recommend options, and implement. Ability to juggle multiple assignments, manage time efficiently, and with a minimum of supervision.
• Ability to communicate complex results to less quantitatively sophisticated users
• Intellectually curious, analytically rigorous, hard-working and a good business intuition are must-haves!
• Knowledge or experience with scripting languages such as python or node.js is a plus

What's in it for you:

• Full medical, dental, and vision benefits with 100% employer paid options and buy up plans
• Unlimited PTO
• Employer HSA contribution
• 9 Company Paid holidays
• 401(k) match, 2% after 90 days of employment
• Supportive culture with one-of-a-kind growth opportunities
• Option to work from home or in the office
• Paid Parental Leave
• Company and team outings
• Peer-to-peer recognition program
• Company sponsored premium subscription to the Calm app
• Vendor discounts

Compensation: $100,000 - $125,000
**Please note that the above compensation information is a good faith estimate for Colorado-based hires only and is provided pursuant to the Colorado Equal Pay for Equal Work Act and Equal Pay Transparency Rules.**
Work Authorization: You must be authorized to work for any employer in the US.
About OrthoFi
OrthoFi is an experienced, tech-enabled solution that helps Orthodontists start more patients and give them more time to provide great quality care. With the acquisition of OrthoBanc in 2020, OrthoFi is now the US orthodontic industry leader in practice financial management, working with over 2,000 practices in the US. Collectively with OrthoBanc, OrthoFi has helped over 3.2 million patients access quality, affordable Orthodontic care. Our combination of the latest Patient Acquisition software and Revenue Cycle Management solutions helps practices grow by over 13% year-over-year and manages patient and insurance billing and collections with collection results that exceed industry standards. We have about 400 employees, with offices in Denver CO and Chattanooga TN.
Our purpose is to radically improve the way patients access and pay for quality elective care. Diversity, equity, and inclusion (DEI) ensures we can fulfill our purpose by creating a better, more equitable and inclusive workplace for our community members and healthcare experience for all.
By focusing on DEI, we are working towards our mission of connecting more patients with quality orthodontic and dental care and helping make treatment accessible to over 1 million patients a year by 2025 . Equity is core to our mission to serve patients, and DEI is embedded in our core values, especially "seek diversity," and "do what's right.""
OrthoFi is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status.
Show more Show less
Top skills for this role
Build these skills listed on the job description or by the job poster.
Python (Programming Language)
Tableau
SQL
Data Analysis
Data Analytics
Data Structures
Data Mining
Business Intelligence (BI)
Data Marts
Data Warehousing
Employer-provided
Pay range in Denver, CO
Exact compensation may vary based on skills, experience and location
Base pay range
$100,000.00/yr - $125,000.00/yr
Featured benefits
Employer-provided
Medical insurance, dental insurance, vision insurance, 401(k), paid maternity leave, and paid paternity leave