What you’ll do
In a few words…
The name says it all. You’re the master of reports and analysis. No one can make a better chart than you and interpreting data is your drug. There’s no such thing as too much data. More, more! Seriously, maybe you should go get checked. But maybe not, could you might just be the Reporting Analyst for Abarca. If it’s you, then you will play a key role across the full lifecycle of analytics projects, from analyzing business requirements to developing, testing, deploying, training, and supporting users on analytics solutions that meet those requirements. Other duties will include the performance of data validation to ensure accuracy and appropriateness of the information provided. This role will be an integral component of the organization's Analytics department delivering valuable Information through intelligence and informatics, providing direct support to diverse internal departments.
The fundamentals for the job…
- Translate requirements into reporting deliverables; (HINT: Google translate will not help with this.)
- Examine and evaluate the purpose and content of business reports to develop new, or improve existing formats;
- Report/query testing and development;
- Create and analyze reports, create custom reporting software, and share findings with end users (We don’t call you reporter because it would be confusing, but you get the idea.)
- Analyze healthcare claims data to assess trend performance, as well as investigate potential operational and clinical opportunities;
- Recommend the establishment of new or modified reporting methods and procedures that improve report content and completeness of information (Your eternal quest for a better report is often achieved, yet never fully satisfied.)
- Collaborate closely with all facets of the project’s stakeholders (business analysts, business subject matter experts, and all levels of clients) in the development of key Decision Support initiatives;
- Develop proper processes for data collection, data mining, data standardization, and analytics; initiate data management and identify proper use of analytics tools; (Nothing you wouldn’t do in your free time.)
- Ability to work in a collaborative environment with a wide variety of developers and analysts;
- Combine business knowledge and technical expertise to assist customers in evaluating or addressing business issues through use of data;
- Partner with BI team to define and support functional and/or architectural requirements of information delivery; participate in the planning, design, and creation of both standard and ad-hoc reports, dashboards, and scorecards;
- Assure the integrity of project data, including data extraction, storage, manipulation, processing, and analysis;
- Verify the completeness, timeliness, and accuracy of data warehouse information;
- Work with business owners and technical resources to identify and address data quality issues when they arise;
- Provide production support to the end users in a timely fashion;
- Work closely with the BI team to determine appropriate data warehouse architecture and data modeling designs in order to maximize benefits.
What you’re made of
The bold requirements…
- Bachelor’s degree in Computer Science, Business, Statistical Analysis, Healthcare Management or a closely related field. Master’s degree preferred. (In lieu of a degree, equivalent relevant experience may be considered.)
- Working knowledge of healthcare utilization reporting, claims, membership, provider data, and standard healthcare metrics;
- Computer proficiency and knowledge of business intelligence tools (i.e. Microsoft BI, Tableau, Qlikview); designing, reporting, and delivering analytical solutions; (Your geek levels are OP.)
- Plus points and stickers for experience with the development of KPI’s, dashboards, and departmental scorecards;
- More stickers for proficiency with at least one tool of the Microsoft Business Intelligence stack: relational SQL engine, Integration Services, Analysis Services, Reporting Services, and MS Excel PowerPivot;
- 1+ years of experience in a role requiring information analysis & various forms of report deliverables;
- Bonus plus points for working knowledge of Data Warehouse methodologies including relational and dimensional modeling, SQL querying, data profiling, and ETL design and development;
- Strong organizational and analytical skills are required;
- Ability to work both independently and participate as a member of a cross-functional team;
- Willingness to learn new technology;
- Must be able to communicate effectively (read, speak, and write novels, poetry, and hip-hop songs, among other things) in English and Spanish
That something extra we´d love to see…
- Analytical: Obviously because this is an “analyst” position, but even if you weren’t applying, you’d still be trying to analyze why we write these the way we do and how they could be better.
- Influencer: No, you don’t need thousands of followers on Instagram, but your persuasive skills are so sharp people wonder if you’ve hypnotized them. Managing prospects is second nature to you and you know how and when to push others.
- Communicator: You find it easy to put thoughts into words both written and spoken. Your superpower is simplification. You can simplify things so 3-year-olds can understand them. No wonder you ghostwrite “for dummies” books!
- Organized: You crave organization like it was sugar and you can’t help yourself trying to organize other people’s desks. You’ve color-coded your closet. Admit it!
- Driven: Your juggling skills are OP and you never miss a deadline. You go for the win at everything. Your legs could be dead halfway through a marathon and you would still finish the race because not getting there is simply NOT an option.
The above description is not intended to limit the scope of the job or to exclude other duties not mentioned. It is absolutely not a final set of specifications for the position. It’s simply meant to give readers an idea of what the role entails.
Abarca Health LLC is an equal employment opportunity employer and participates in E-Verify. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of gender, race/ethnicity, gender identity, sexual orientation, protected veteran status, disability, or other protected group status.