FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates advanced SQL/T-SQL development skills, with a strong understanding of reporting and analytics lifecycles, data quality assurance, and effective stakeholder communication. Proficient in automating reporting processes and managing multiple reporting initiatives while ensuring data accuracy and compliance with HIPAA regulations.
Highest-signal resume keywords
Advanced SQL/T-SQL DevelopmentReporting Documentation and GovernanceData Quality AssuranceRoot Cause AnalysisPower Automate Automation
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQL/T-SQLQuery OptimizationData ValidationData ModelingETL ConceptsReporting WorkflowsMicrosoft ExcelBusiness AnalysisReporting StandardsData Structures
Soft Skills
Strong Communication SkillsCritical ThinkingOrganizational SkillsProject ManagementAttention to Detail
Tools & Technologies
SQL ServerSnowflakePower AutomateAzure DevOpsTableau
Industry Keywords
HIPAA ComplianceHealthcare AnalyticsBusiness IntelligenceData AnalyticsSpecialty Pharmacy
Tech Stack
Tools & technologiesAzureETLSQLTableau
About the role
Key responsibilities & impact- Develop, maintain, and optimize reporting solutions using SQL/T-SQL within SQL Server and Snowflake environments
- Build new reports and enhance existing reporting assets by translating business requirements into efficient and accurate query logic
- Gather and validate reporting requirements, including business definitions, granularity, assumptions, and edge cases
- Perform validation and reconciliation before releasing reporting deliverables to ensure data accuracy and integrity
- Review and reverse-engineer inherited SQL code, reporting logic, and existing reporting structures
- Conduct root cause analysis of reporting discrepancies, data quality concerns, and operational reporting issues
- Identify, document, and communicate findings and recommendations from data investigations
- Scope, draft, and submit reporting and stored procedure requests to Information Technology teams and manage requests through implementation
- Automate recurring reports, workflows, and business processes using Power Automate or other approved tools
- Maintain reporting documentation, business logic documentation, report inventories, process documentation, and data dictionaries
- Collaborate with subject matter experts to validate business logic and ensure reporting aligns with stakeholder intent
- Present data trends, findings, and recommendations to technical and non-technical audiences
- Support operational, client, and leadership reporting needs through recurring and ad hoc reporting requests
- Prioritize and manage multiple concurrent reporting initiatives while meeting established deadlines
- Own reporting requests from intake through delivery, managing stakeholder communication, timelines, and issue resolution
- Drive continuous improvement initiatives that enhance reporting quality, automation, efficiency, and scalability
- Comply with HIPAA obligations related to Protected Health Information and report violations
- Attend and complete required HIPAA training
- No supervisory responsibilities
- No travel expected
Requirements
What you’ll need- Advanced SQL/T-SQL development skills with the ability to write complex, efficient queries from scratch
- 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
- Strong 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 data modeling fundamentals, including keys, relationships, data grain, and reporting layers
- Ability to evaluate reporting outputs critically and identify inconsistencies or anomalies
- Strong requirements gathering and business analysis skills
- 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 evaluating data and reporting results
- Self-motivated and capable of working independently with limited 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 skills
- Ability to work effectively in a rapidly evolving environment where processes and infrastructure continue to mature
- Excellent 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 reporting, analytics, business intelligence, or related experience
- Demonstrated experience writing advanced SQL/T-SQL queries in a business or operational environment
- Experience delivering recurring and ad hoc reporting solutions for business stakeholders
- Experience validating and reconciling reporting outputs to ensure data accuracy
- Experience working with sensitive and confidential healthcare-related information
- Experience managing multiple priorities and stakeholder requests simultaneously
- Strong understanding of reporting documentation and governance practices
- Preferred: PBM, healthcare, specialty pharmacy, or health plan experience
- Preferred: Experience with Snowflake data environments
- Preferred: Experience with Azure DevOps, source repositories, or change management processes
- Preferred: Experience utilizing ticketing systems for work intake and project tracking
- Preferred: Tableau experience, including report development, maintenance, or support
- Preferred: Experience supporting operational, client-facing, or healthcare analytics functions
Benefits
Comp & perks- 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