Data Analyst - Reporting

Remote - Open, MI

At HBS the data analytics team strives to be transformative leaders that support our internal and external stakeholders in maximizing their potential and carrying value forward into the healthcare system and people’s everyday lives. This means understanding and valuing the impact of our work, upholding a commitment to excellence of ourselves and team, striving together, and bringing and finding joy in our work.

A successful candidate in this role will efficiently facilitate the flow of information to stakeholders and contribute to data curation and maintenance. This includes building ongoing reports and dashboards, ad hoc requests, analytics, conducting stakeholder interviews, creating and reviewing technical specifications, maintaining report and data definitions, and collaborating with other data analysis and engineers.

Responsibilities:

  • Build and grow a deep understanding of the business needs, processes, and functions to effectively contribute to stakeholder conversations and work with a certain degree of autonomy.
  • Complete ad hoc requests and analytics in a timely manner and accurately; correctly qualify requests through questioning and identify a reference point and/or test cases to validate. May be done using SQL, Excel, PowerBI, or other sources as appropriate.
  • Build reports and dashboards for ongoing use in Power BI. Gather user requirements and business case, create documentation and definitions, write SQL queries and DAX statements if needed, adhere to design standards, and publish well thought out and vetted dashboards that have good adoption and business value.
  • Train users on Power BI including navigating the interface, library or reports and definitions, and some self-serve features for power users.
  • Review client and internal data for accuracy and completeness, raise data quality issues to the team, help manage, communicate, and resolve the issue log.
  • Clearly document data transformations and cleansing business rules for data engineering team.
  • Support new client or new product onboarding with data file mapping and testing.
  • Support internal system or process changing, working with stakeholders to maintain data integrity during change.
  • Collaborate with business stakeholders (internal and external), and data engineers and to facilitate the development and implementation of data marts, enterprise data warehouse, reports, and other data solutions.
  • Comply with all security and privacy requirements.
  • Continuously research and stay current on data trends, technologies, and best practices, identifying opportunities for improvement.

Qualifications:

  • 5 years proven experience as a Data Analyst, Business Analyst, SQL Developer, or similar role.
  • Strong knowledge of business intelligence practices such as business requirements documentation, ETL, data normalization, star schema, and quality assurance.
  • Proficiency in SQL and PowerBI.
  • Healthcare revenue cycle or claims experience is strongly preferred.
  • Excellent analytical and problem-solving skills, and attention to detail.
  • Strong communication skills, both written and verbal.