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 expertise in data analysis, SQL, and Python for creating and maintaining analytical datasets and reporting solutions. Proficient in data governance, cloud-based data pipelines, and visualization tools to deliver actionable insights and support business objectives.
Highest-signal resume keywords
SQL ProficiencyPython ExperienceAzure Data FactoryData GovernanceP&C Insurance Experience
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data AnalysisData ProfilingETLData ModelingKPI DesignData ValidationQuery OptimizationSemantic ModelingXML/JSON ParsingAutomated Testing
Soft Skills
Analytical SkillsProblem-Solving SkillsCommunication SkillsTime ManagementOrganizational Skills
Tools & Technologies
Power BIAzure SynapseAzure SQLAzure DevOpsInformaticaMicrosoft FabricDelta LakeParquetEvent HubsService Bus
Industry Keywords
Data GovernanceOperational MetricsFinancial MetricsBusiness GlossaryCloud Platforms
Tech Stack
Tools & technologiesAzureCloudETLInformaticaPySparkPythonSOAPSparkSQL
About the role
Key responsibilities & impact- Translate reporting and analytical requirements into analytical datasets, metric definitions, and reporting solutions
- Design and document source-to-target mappings, transformation logic, and data lineage for cross-system integrations
- Conduct deep-dive data analysis to validate logic, resolve discrepancies, and support modernization or migration initiatives
- Respond to ad hoc and urgent requests by delivering accurate, timely information in a fast-paced environment
- Communicate complex data concepts clearly to technical and business audiences
- Collaborate with product owners to define and document KPIs, metric logic, and shared business rules
- Create and maintain curated analytics datasets, including SQL views, tables, and semantic layers, for dashboards and self-service analytics
- Perform data profiling, quality checks, and reconciliation using SQL and Python
- Parse, transform, and validate XML/JSON using Python, XPath, and schema rules
- Maintain source-to-target mappings supporting Azure Data Factory, Synapse, and Informatica workflows
- Improve analytics performance through query optimization, semantic modeling, and scalable dataset design
- Support data governance through documentation, lineage tracking, and data management standards
- Collaborate with Data Engineering to translate requirements into cloud-based data pipelines
- Align datasets with enterprise data models and Azure standards
- Support Azure and Fabric monitoring for pipeline health, data freshness, validation checks, and SLA adherence
- Validate and analyze data stored in ADLS containers
- Perform integrity checks on Delta Lake and Parquet files
- Conduct reconciliation and quality verification across cloud storage zones
- Contribute to tool enhancements, process improvements, and innovation initiatives
Requirements
What you’ll need- Bachelor's degree preferred
- Authorization to work in the United States without current or future sponsorship (U.S. citizen or lawful permanent resident)
- 2+ years of experience in a related field such as data engineering, ETL, data modeling, analysis, validation, reporting, or analytical solution delivery
- Strong proficiency with SQL for data analysis, data profiling and quality with large and complex datasets
- P&C insurance experience is strongly preferred, including understanding of operational and financial metrics
- Strong analytical and problem-solving skills
- Advanced Excel, Power BI and other visualization tools; ability to translate data into meaningful insights
- Excellent written and verbal communication skills
- Strong time management, prioritization, and organizational skills
- Knowledge of technical mapping, including database schema, XML schema, and JSON schema
- Hands-on experience with Azure Data Factory, Synapse (SQL & Spark), ADLS, Azure SQL, and Azure DevOps (CI/CD)
- Python experience for data wrangling, XML/JSON parsing, XPath, automation, and validation
- Experience creating semantic models and analytical datasets for BI platforms
- Understanding of KPI design, data governance, lineage, and business glossary concepts
- Ability to work across legacy (Informatica) and cloud platforms and validate logic during migrations
- Ability to plan for future capability needs and continuous improvements
- Preferred: data quality frameworks and automated testing with SQL/Python
- Preferred: Synapse Spark / PySpark; Delta Lake and notebook development
- Preferred: Microsoft Fabric (datasets, pipelines, governance)
- Preferred: Microsoft Purview or similar metadata/lineage tools
- Preferred: Parquet, partitioning, and performance optimization in lakehouse architectures
- Preferred: Azure DevOps CI/CD (YAML, Git branching)
- Preferred: Event streaming (Event Hubs, Service Bus) and APIs/Web Services (REST/SOAP)
Benefits
Comp & perks- Full-time, exempt position
- Remote work arrangement available
- Opportunity to work with a modern Azure-based data ecosystem
- Opportunity to contribute to tool enhancements, process improvements, and innovation initiatives