Senior SQL Analyst

Health Business Solutions; United States; Remote; USD 80,000 - 110,000; Full time

Job summary

Health Business Solutions is seeking a data analyst to streamline stakeholder communications, build BI reports, and contribute to the enterprise data warehouse. You will craft SQL queries, develop dashboards in Power BI, and ensure data quality while collaborating with analysts and engineers across healthcare operations.

The role emphasizes data curation, requirements documentation, and QA testing, with a focus on delivering actionable insights and scalable data solutions for internal and

Qualifications

• 5 years proven experience as a Data Analyst, Business Analyst, SQL Developer, or similar role.
• Proficiency in SQL and PowerBI.
• Healthcare revenue cycle or claims experience is strongly preferred.

Responsibilities

• Build and grow understanding of business needs and work with autonomy.
• Develop and implement data marts, enterprise data warehouse, reports, analytics, and other data solutions by writing SQL scripts for ETL, reports, error handling, and QA.
• Complete ad hoc requests and analytics using SQL, Excel, PowerBI, or other sources as appropriate.
• Build reports and dashboards for ongoing use in Power BI; gather requirements, document definitions, write SQL queries and DAX as needed, publish vetted dashboards with value.
• Review client and internal data for accuracy; raise data quality issues and maintain the issue log.
• Document data transformations and cleansing business rules.
• Support onboarding ETL testing and building for new clients or products.
• Assist with changes to internal systems or processes while maintaining data integrity.

Skills

SQL

Data analysis

Communication

Tools

Power BI

Job description

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 using SQL and business intelligence best practices. This includes building reports, ad hoc queries, analytics, contributing to the enterprise data warehouse and data marts, conducting stakeholder interviews, creating business requirements documents, QA testing, and collaborating with other data analysts 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.
• Actively contribute to the development and implementation of data marts, enterprise data warehouse, reports, analytics, and other data solutions by writing SQL scripts for ETL, reports, error handling, and QA.
• 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.
• 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.
• Support new client or new product onboarding ETL testing and building.
• Support internal system or process changing, working with stakeholders to maintain data integrity during change.
• 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.

Health Business Solutions (HBiz) is an Equal Opportunity Employer. We are committed to providing equal employment opportunities to all employees and applicants without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other status protected by applicable federal, state, or local law.

HBiz complies with all applicable employment laws for remote and multi-state hiring and provides reasonable accommodations as required by law.