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.
Senior Business and Data Analyst
Abacus Insights. Write and execute SQL daily to profile source data, test assumptions, quantify data quality, and prototype logic .
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in SQL for data profiling, analysis, and quality assessment within the US healthcare domain. Capable of translating complex business requirements into actionable data solutions while effectively communicating with both technical and non-technical stakeholders.
Highest-signal resume keywords
SQL ProficiencyHealthcare Data AnalysisRoot-Cause AnalysisBusiness Requirements ElicitationClient-Facing Communication
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQLData ProfilingData Quality AssessmentRoot-Cause AnalysisMetrics DefinitionData VisualizationTest Condition DocumentationTransformation LogicAggregationsWindow Functions
Soft Skills
Analytical RigorClient CommunicationAdaptabilityMentoring
Tools & Technologies
DatabricksSnowflake
Industry Keywords
US HealthcareHealth PlanMembership/EnrollmentProviderClaimsAuthorizationsData EcosystemBusiness MetricsKPIUAT
Tech Stack
Tools & technologiesSnowflakeSQL
About the role
Key responsibilities & impact- Write and execute SQL daily to profile source data, test assumptions, quantify data quality, and prototype logic
- Analyze source data for field population, distributions, key integrity, duplicates, outliers, and gaps
- Reconcile and validate outputs against source systems and client benchmarks, investigate variances to root cause, and document findings
- Define and document business metrics and KPIs, including numerator, denominator, inclusion/exclusion logic, time basis, and grain
- Perform exploratory and root-cause analysis and provide quantified recommendations
- Produce data profiling reports, analysis readouts, and visualizations
- Lead discovery and requirements-gathering sessions for use cases
- Translate use cases into clear, testable requirements and maintain traceability from business need through testing
- Document source-to-target mappings, transformation logic, business rules, test conditions, and expected results
- Recommend dataset grain and structure and assess downstream impacts
- Identify dependencies and cross-workstream impacts; escalate them to the Business Solution Manager
- Recognize and shape reusable patterns across clients, states, and use cases
- Present analysis results, data quality findings, and recommendations to client stakeholders
- Represent client intent through delivery and serve as day-to-day point of contact for assigned use cases
- Translate between business and technical audiences
- Connect clients and internal delivery teams on assigned workstreams
- Serve as the business and data analysis SME for Solution Architects, Product, QA, Account Management, and Program Management
- Support QA and UAT with validation queries, expected results, variance analysis, and defect triage
- Maintain awareness of wider engagement impacts and flag ripple effects
Requirements
What you’ll need- Bachelor's degree, or equivalent relevant experience
- 5+ years working in the US healthcare domain and with healthcare data
- Direct experience working with or for a US health plan (Medicare, Medicaid, or Commercial), whether in-house or through healthcare consulting
- Working command of core payer concepts such as membership/enrollment, provider, claims, and authorizations
- Strong, hands-on SQL, including joins across large multi-table datasets, window functions, CTEs, aggregations, and date/span logic
- Demonstrated analytical rigor, including data profiling, data quality assessment, root-cause analysis, and communicating quantified findings
- Experience defining metrics, mentoring junior analysts, and eliciting and authoring business requirements in complex, data-driven environments
- Confident client-facing communication with technical and non-technical audiences
- Ability to operate with ambiguity and re-prioritize while managing multiple use cases
- Experience designing for reuse and scale across states, clients, or use cases and tracing impacts across a data ecosystem
- Exposure to Databricks or Snowflake is desirable
- Must be eligible to work in the United States
Benefits
Comp & perks- Unlimited paid time off – recharge when you need it
- Work from anywhere – flexibility to fit your life
- Comprehensive health coverage – multiple plan options to choose from
- Equity for every employee – share in our success
- Growth-focused environment – your development matters here
- Home office setup allowance – one-time support to get you started
- Monthly cell phone allowance – stay connected with ease
- Eligibility for performance bonuses
- Equity grants