Data Reporting Analyst

This is a fully remote position, open to applicants in Texas.

📋 Description

• Design, maintain, and enhance reporting solutions utilizing SQL/T-SQL within SQL Server and Snowflake environments.

• Create new reports and improve existing reporting assets by converting business requirements into effective and precise query logic.

• Collect and verify reporting requirements, including business definitions, granularity, assumptions, and edge cases.

• Execute validation and reconciliation before delivering reporting outputs to ensure data accuracy and integrity.

• Analyze and reverse-engineer inherited SQL code, reporting logic, and current reporting structures.

• Perform root cause analysis of reporting inconsistencies, data quality issues, and operational reporting challenges.

• Identify, document, and communicate insights and recommendations derived from data investigations.

• Scope, draft, and submit requests for reporting and stored procedures to Information Technology teams, managing requests through implementation.

• Automate recurring reports, workflows, and business processes using Power Automate or other approved tools.

• Maintain documentation related to reporting, business logic, report inventories, process documentation, and data dictionaries.

• Collaborate with subject matter experts to confirm business logic and ensure reporting aligns with stakeholder expectations.

• Present data trends, insights, and recommendations to both technical and non-technical audiences.

• Support operational, client, and leadership reporting needs through regular and ad hoc reporting requests.

• Prioritize and manage multiple simultaneous reporting initiatives while adhering to established deadlines.

• Oversee reporting requests from inception to delivery, ensuring effective stakeholder communication, timeline management, and issue resolution.

• Champion continuous improvement initiatives aimed at enhancing reporting quality, automation, efficiency, and scalability.

• Adhere to HIPAA obligations regarding Protected Health Information and report any violations.

• Participate in and complete required HIPAA training.

• No supervisory responsibilities.

• No travel expected.

⛳️ Requirements

• Advanced SQL/T-SQL development skills with the capability to write complex, efficient queries from the ground up.

• Experience working within relational database environments, preferably SQL Server (SSMS) and Snowflake.

• Strong understanding of query optimization and performance tuning techniques.

• Ability to work effectively within established data environments using existing tables, views, and reporting objects.

• Ability to independently interpret schemas, understand data structures, and map table relationships.

• Experience reading, troubleshooting, and reverse-engineering existing SQL code and reporting logic.

• Strong proficiency in Microsoft Excel and other Microsoft Office applications.

• Comprehensive understanding of the end-to-end reporting and analytics lifecycle.

• Familiarity with ETL concepts, reporting workflows, and data movement processes.

• Experience conducting root cause analysis and resolving data quality issues.

• Understanding of data modeling fundamentals, including keys, relationships, data grain, and reporting layers.

• Ability to critically evaluate reporting outputs and identify inconsistencies or anomalies.

• Strong requirements gathering and business analysis capabilities.

• Demonstrated commitment to data accuracy, validation, and quality assurance.

• Ability to verify business logic and ensure alignment between stakeholder expectations and reporting outputs.

• Experience maintaining detailed documentation, reporting standards, and data definitions.

• Strong critical-thinking skills and intellectual curiosity when analyzing data and reporting results.

• Self-motivated and able to work independently with minimal direction while maintaining accountability.

• Strong verbal and written communication skills.

• Ability to communicate effectively with technical teams, operational partners, and leadership.

• Consistent and proactive stakeholder communication throughout the lifecycle of a reporting request.

• Strong organizational and project management abilities.

• Capability to work effectively in a rapidly changing environment where processes and infrastructure are continually evolving.

• Exceptional attention to detail and digital organization.

• Experience automating recurring reports and workflows using Power Automate or similar automation platforms.

• Ability to define requirements and coordinate development efforts with centralized IT teams.

• Bachelor's degree in information systems, Data Analytics, Computer Science, Business Analytics, Statistics, or a related field; or equivalent combination of education and practical experience.

• 3 to 5+ years of hands-on experience in reporting, analytics, business intelligence, or a related field.

• Proven experience writing advanced SQL/T-SQL queries in a business or operational context.

• Experience delivering both recurring and ad hoc reporting solutions for business stakeholders.

• Experience validating and reconciling reporting outputs to guarantee data accuracy.

• Experience working with sensitive and confidential healthcare-related information.

• Experience managing multiple priorities and stakeholder requests concurrently.

• Strong understanding of reporting documentation and governance practices.

• Preferred: Experience in PBM, healthcare, specialty pharmacy, or health plan sectors.

• Preferred: Experience with Snowflake data environments.

• Preferred: Knowledge of Azure DevOps, source repositories, or change management processes.

• Preferred: Familiarity with ticketing systems for work intake and project tracking.

• Preferred: Experience with Tableau, including report development, maintenance, or support.

• Preferred: Experience in supporting operational, client-facing, or healthcare analytics functions.

🏝️ Benefits

• Medical, Dental and Vision insurance.

• Disability and Life insurance.

• Employee Assistance Program.

• Remote work options.

• Generous Paid-Time Off.

• Annual Reviews and Development Plans.

• Retirement Plan with company match, immediately 100% vested.