Reporting/BI Analyst:
OrthoFi is looking for an experienced Reporting Analyst with a passion for creating insights by developing analytics, dashboards and reports. We are expanding our Data & Analytics team in 2018. You will have the opportunity to not only create impactful analyses for our clients and internal stakeholders, but also participate in the development of our next-generation data & analytics platform from the ground up. This is a unique opportunity to get in on the ground floor of a new platform build.
As a Reporting Analyst, you will interact daily with OrthoFi’s Data & Analytics team members, internal stakeholders and occasionally with clients to define and develop solutions to provide insights. You will collaborate with other team members to help build a data-driven culture of insight and well-informed decisions.
Responsibilities:
Collaborate with business stakeholders to understand operational reporting needs including the identification of business problems, service levels and KPIs
Participate in voice of customer meetings with clients to understand and identify analytics that will help grow their businesses
Design and develop analytics, interactive visualizations, dashboards and reports that create business insights and clearly communicate data and trends
Develop complex SQL queries to obtain data from our source systems
Perform data validation and quality assurance of dashboards, reports and metrics
Participate in the development of our next-generation Data & Analytics platform by designing schemas, developing ETL/ELT processes and calculating metrics and KPIs
Desired Skills and Experience:
Tableau experience developing dashboards and reports with complex metric calculations and cohesive drill-down and filtering capability
Experience developing advanced SQL queries with complex joins, subqueries and calculations
Demonstrate a solid understanding of the business in which you are working
Strong business-facing skills to gather and synthesize requirements, recommend solutions and build relationships with our stakeholders
Experience performing data validation and quality assurance of dashboards, reports and metrics
Ability to communicate complex technical and data concepts to less technical audiences
Experience with source control platforms
Agile / Scrum experience
Data warehousing experience a plus
ETL experience a plus
Python experience a plus
Healthcare and/or Insurance Service experience a plus
Perks:
Nurturing and supportive culture
Unlimited PTO
On-site gym
Company breakfast once a month
Monthly team building activities
Company and team outings
Peer-to-peer recognition program
Casual dress atmosphere
About OrthoFi:
OrthoFi is a Denver-based startup that is revolutionizing the orthodontic industry with software solutions that give doctors the capability to start more patients and to offload time consuming front-office processes. Our solution puts patients in control of their payment plans and makes costly treatments affordable to almost everyone. Founded by a combination of medical professionals, industry leaders, and technical experts, OrthoFi is revenue positive and looking to grow in 2018 and beyond. OrthoFi was recently named one of Denver’s fastest growing companies by the Denver Business Journal and ranked in Built in Colorado’s list of 2016 Top 100 Digital Companies in Colorado.
In the OrthoFi community, members are valued for who they are, supported no matter where they are, and motivated to excel personally and professionally. People who join our community are self-starters and love a challenge! We’re looking for passion-driven, dynamic individuals that are excited about a fast-paced and fun environment. Our team enjoys the opportunity to impact people’s lives and help to create more smiles every day.
If you are truly excited about growing with an amazing company, send your resume to [email protected] and describe why you feel you would be a good fit at OrthoFi.
***Even if you don’t tick every box on the description above, we encourage you to apply. We’re growing a lot in 2018 and might have a great role for you.