Reporting/BI Analyst
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
Responsibilities include but are not limited to the following:
- 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.