About this role
This Data Analyst role is focused on SQL-driven data investigation, discrepancy analysis, and root cause identification. You will validate data outputs against expected logic and business rules rather than building reports or dashboards.
Key Responsibilities
- Write and execute complex SQL queries to extract, analyze, and validate data
- Investigate data discrepancies and identify root causes
- Analyze large datasets to detect patterns, inconsistencies, and anomalies
- Validate data outputs against expected logic and business rules
- Document findings and support process improvements
Technical Overview
You will write and execute complex SQL queries using joins, subqueries, aggregations, and case logic to analyze large datasets. The work includes data validation, anomaly detection, discrepancy investigation, and optionally using Excel, Power BI, and Python/automation for process improvements.
Ideal Candidate
The ideal candidate is a data analyst with 3+ years of hands-on SQL experience focused on investigation rather than dashboards. They can write complex SQL (joins, subqueries, aggregations, case logic), validate data outputs against business rules, identify discrepancies, and communicate root causes with high accuracy.
Must-Have Skills
SQLcomplex SQL queries (joinssubqueriesaggregationscase logic)data validation and analytical problem-solvinginvestigating data discrepancies and identifying root causesanalyzing large datasetsproven ability to analyze data and identify inconsistencies or errorsstrong attention to detailhigh levels of accuracycomfortable working with large datasets
Nice-to-Have Skills
healthcare datafinancial datatransactional datadata validationauditingor quality control processesExceldata visualization tools (Power BI or similar)Pythonautomation tools
Tools & Platforms
SQLExcelPower BIPython
Required Skills
SQLcomplex SQL queriesjoinssubqueriesaggregationscase logicdata validationanalytical problem-solvinginvestigating data discrepanciesroot cause analysisanalyzing large datasetspatternsinconsistenciesanomaliesvalidating outputs against expected logic and business rulesdocumentationprocess improvementsExcelPower BIPythonautomation tools
Hard Skills
SQLcomplex SQL queriesjoinssubqueriesaggregationscase logicdata validationanalytical problem-solvinginvestigating data discrepanciesroot cause analysisanalyzing large datasetsdetecting patternsdetecting inconsistenciesdetecting anomaliesvalidating data outputs against expected logic and business rulesdata auditingquality controlExceldata visualization toolsPower BIPythonautomation toolsdocumentation of findingsdata security and confidentiality standards
Soft Skills
detail-orientedinvestigative mindsetindependent workownership of findingsquestioning data rather than assumingaccountabilityhigh level of accuracycollaboration with internal teams
Keywords for Your Resume
Data AnalystData Analyst (SQL & Data Investigation)SQLcomplex SQL queriesjoinssubqueriesaggregationscase logicdata validationanalytical problem-solvingdata discrepanciesroot causeslarge datasetspatternsinconsistenciesanomaliesexpected logicbusiness rulesinvestigative analysisdocument findingsprocess improvementsExcelPower BIPythonautomation toolsdata security and confidentiality
Deal Breakers
Minimum 3+ years of hands-on SQL experience, Must be able to write complex SQL queries including joins, subqueries, aggregations, and case logic, Must be focused on data validation and analytical problem-solving (not reporting/dashboards)
Get matched to jobs like this
Luna finds roles that fit your skills and career goals — no endless scrolling required.
Create a Free Profile