Mid-Level/Lead DATA ENGINEER-Python, AWS, Spark (Hybrid-TX & IL)
State Farm2 months ago
Bloomington, IL, USA or Richardson, TX, USAMid Level / Staff+
Base Salary
$86k - $135k/yr
Responsibilities
- Build and maintain reusable, scalable, compliant data solutions and automated data pipelines across multiple platforms.
- Identify, acquire, cleanse, profile, transform, and load data for analytical discovery and production deployments.
- Design, deploy, support, monitor, and secure data-related technology assets in accordance with regulations and best practices.
- Investigate data sources and emerging technologies, establish business-domain knowledge, and recommend data engineering solutions.
- Analyze technical needs and develop solution proposals, implementation plans, and integration plans with partner teams.
- Apply automation and DataOps practices to deliver reliable, high-quality data solutions.
Requirements
- Professional experience as a Data Engineer.
- Proficiency in programming languages such as Python, Scala, Java, or Bash.
- Hands-on experience with AWS services including Glue, EMR Serverless, Lambda, Step Functions, EventBridge, S3, Kinesis Firehose, Redshift, and Iceberg.
- Experience with Apache Spark, Databricks, or Spring Batch for distributed data processing.
- Experience with OpenTofu or Terraform for infrastructure as code and cloud resource deployments.
- Familiarity with CI/CD pipelines, automated testing, and security scans.
- Knowledge of Dynatrace, AWS QuickSight, and CloudWatch for auditing and monitoring.
- Experience or ability to rapidly gain Property & Casualty data-domain knowledge, including rating, underwriting, or claims.
- Experience with relational databases, version control systems such as GitHub or GitLab, SQL, and Athena.
- Experience designing, building, and maintaining automated data-processing pipelines.
- Knowledge of data modeling techniques including star and snowflake schemas and data architecture.
Benefits
- Potential base salary of $85,500 to $135,000 annually, with potential yearly incentive pay up to 15% of base salary.
- Hybrid work arrangement in Richardson, Texas, or Bloomington, Illinois, requiring approximately 40% in-office time each month beginning in late 2027.
- Health, dental, vision, telemedicine, preventive-care, and mental-health benefits, with State Farm paying most of the healthcare premium.
- Annual raises, bonuses, training programs, tuition assistance, employee resource groups, and mentoring.
- Fertility, IVF, adoption, college coaching, financial workshops, financial coaching, and credit union programs.
- Paid time off, up to 20 days initially, parental leave, paid holidays, celebration day, life leave, bereavement leave, and community service or education support days.
- Matching gifts, community grants, and an employee assistance fund.
- 401(k) plan with company contributions of up to 7% of salary and access to financial advisors.
Tech Stack
Categories
Data Engineering
About State Farm
State Farm is a U.S. mutual insurance group that sells auto, home, renters, life, health, and small-business coverage, plus select financial services. It markets policies primarily through a large network of local agents and earns revenue from premiums and investing customer reserves. Founded in 1922 and headquartered in Bloomington, Illinois, it is among the largest personal lines insurers in the United States.