Mid-Level DATA ENGINEER: Microsoft Power Platform & AI Copilot Studio (HYBRID)

State Farm

Bloomington, Dunwoody, Richardson, Tempe (IL, GA, TX, AZ)

Hybrid

USD 90,000 - 130,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Annual raise & bonus
Healthcare premium covered
Tuition assistance
Generous time off
Matching gifts
401(k) contributions

Job summary

State Farm is seeking a Data Engineer to join the Power Platform/data engineering team in Bloomington, IL. The role focuses on building scalable data pipelines, enabling AI-powered experiences, and ensuring governance across enterprise data assets.

You will collaborate with Microsoft engineering and product teams, design data products, and contribute to modern cloud data architecture while enjoying a hybrid work setup and competitive compensation.

Qualifications

  • 3+ years of professional data engineering experience.
  • 3+ years of SQL experience for querying, transforming, and modeling data.
  • 2+ years of Python for data engineering and automation.
  • 2+ years with modern cloud data technologies (e.g., Microsoft Fabric, Azure Synapse, Databricks, Snowflake).
  • Experience applying DataOps practices (version control, CI/CD, testing).
  • Experience with structured, semi-structured, and unstructured data.
  • Strong communication and collaboration across technical and business teams.

Responsibilities

  • Design, build, and maintain scalable data pipelines and integrations.
  • Develop reusable data products supporting AI, Power Platform, analytics, and automation.
  • Engineer data solutions for AI and generative AI use cases with trusted enterprise data.
  • Partner with engineers, architects, and business partners to deliver data solutions.
  • Transform, cleanse, profile, and validate diverse data types.
  • Apply DataOps including CI/CD, monitoring, and automated testing.
  • Design data integrations from APIs, databases, SaaS, and enterprise systems.
  • Support secure, governed data solutions aligned with enterprise standards.

Skills

Data engineering
SQL
Python
DataOps
Analytical thinking
Collaboration

Tools

Microsoft Fabric
Azure Data Factory
Azure Synapse
Azure Databricks
Snowflake
Power Platform

Job description

Overview

Being good neighbors – helping people, investing in our communities, and making the world a better place – is who we are at State Farm. It is at the core of how we operate and the reason for our success. We're moving with urgency to become a Next Gen Good Neighbor, with technology that strengthens human connections and enhances the customer experience. As an employee, you'll spend less time navigating systems and more time applying judgment, empathy, and expertise in the moments that matter most.

Hybrid Work Arrangement:

A “Hybrid” position means selected candidates will be assigned to a facility and will spend some time working both in the office and from home. For Enterprise Technology, a hybrid work arrangement will require approximately 40% in‑office time each month, beginning in late 2027. HUB LOCATIONS: Bloomington, IL; Richardson, TX; Tempe, AZ; or Dunwoody, GA

SPONSORSHIP:

Applicants for this position are required to be eligible to lawfully work in the U.S. immediately; employer will not sponsor applicants for U.S. work authorization (e.g. H-1B visa) for this opportunity.

Responsibilities

State Farm is building the next generation of AI-powered business solutions, and data is at the center of that transformation. The Power Platform team is looking for an experienced Data Engineer who is passionate about building modern, scalable data solutions that enable automation, analytics, AI-powered experiences, and intelligent applications across the enterprise.

Our team works closely with Microsoft engineering and product teams to evaluate and enable emerging technologies. In this role, you'll help design and deliver scalable, secure, and governed data solutions that support Microsoft Power Platform, AI, Microsoft Fabric, Dataverse, and other cloud technologies.

This is an opportunity to help shape the data foundation supporting modern application development, automation, analytics, and AI at enterprise scale.

Some Responsibilities May Include:

  • Design, build, and maintain scalable data pipelines, integrations, and data solutions.
  • Develop reusable data products that support AI, Power Platform, analytics, reporting, and enterprise automation.
  • Engineer data solutions that support AI and generative AI use cases, including the preparation, integration, and delivery of trusted enterprise data for intelligent applications.
  • Partner with software engineers, architects, citizen developers, and business partners to design and deliver trusted data solutions.
  • Transform, cleanse, profile, and validate structured, semi-structured, and unstructured data from enterprise and external sources.
  • Apply DataOps practices including source control, automation, monitoring, testing, continuous integration and continuous delivery (CI/CD), and deployment.
  • Design solutions that integrate data from application programming interfaces (APIs), databases, software-as-a-service (SaaS) platforms, and enterprise systems.
  • Support secure, governed, and compliant data solutions aligned with enterprise standards.
  • Contribute to modern cloud data architecture and evaluate emerging technologies that improve engineering productivity and platform capabilities.
  • Help establish reusable patterns and engineering best practices for enterprise data solutions.
Why Join Our Team?
  • Work with Microsoft engineering and product teams as we evaluate and enable emerging technologies.
  • Help shape the future of AI, Power Platform, data, and enterprise automation at State Farm.
  • Build reusable platform capabilities that enable thousands of builders across the organization.
  • Contribute to modern enterprise architecture and engineering practices.
  • Join a collaborative team focused on innovation, enablement, experimentation, and continuous learning.
Qualifications

We Are Seeking Candidates With:

  • 3+ years of professional data engineering experience, including designing and building production data pipelines, integrations, or data solutions.
  • 3+ years of experience with SQL, including querying, data transformation, and data modeling.
  • 2+ years of experience using Python for data engineering, automation, data transformation, or pipeline development.
  • 2+ years of experience with modern cloud data technologies, such as Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, Azure Databricks, Snowflake, or comparable cloud data platforms.
  • Experience applying modern DataOps and software engineering practices, including version control, automated testing, CI/CD, and deployment.
  • Experience working with structured, semi-structured, and unstructured data.
  • Strong analytical and problem-solving skills with the ability to independently investigate and solve technical problems.
  • Strong written and verbal communication skills and the ability to collaborate across technical and business teams.
Additional Skills That Will Help You Stand Out

Experience with one or more of the following is beneficial:

  • Microsoft Power Platform
  • Databricks
  • Microsoft Dataverse
  • Microsoft Fabric and OneLake
  • Microsoft Graph
  • Microsoft Foundry or Azure OpenAI
  • Data engineering supporting AI or generative AI applications
  • Lakehouse architecture
  • Power BI semantic models and enterprise analytics
  • REST APIs and event-driven architectures
  • Microsoft Azure certifications
Our Benefits

Because work-life balance is a priority at State Farm, compensation is based on our standard 38:45-hour work week!

  • Potential starting salary range: $90,000 - $130,000
    • Starting salary will be based on skills, background, and experience. *High end of the range limited to applicants with significant relevant experience*
  • Potential yearly incentive pay up to 14% of base salary

At State Farm, we offer more than just a paycheck. Check out our suite of benefits designed to give you the flexibility you need to take care of you and your family!

  • Get Paid! On top of our competitive pay, you are eligible for an annual raise and bonus.
  • Stay Well! Focus on you and your family’s health with our robust health and wellbeing programs. State Farm pays most of your healthcare premium, and we offer multiple healthcare plan options, including a high deductible plan. All medical plans provide 100% coverage for in-network preventative care, AND you and your family have access to vision, dental, telemedicine, 24/7 mental health professionals, and much more!
  • Develop and Grow! Take advantage of educational benefits like industry leading training programs, top-notch tuition assistance programs, employee resource groups, and mentoring.
  • Plan Ahead! Plan for those big moments in life with benefits like fertility/IVF/adoption assistance, college coaching, national discount programs, interactive monthly financial workshops, free financial coaching, and more. You can also start a savings account or consider financing through our State Farm Federal Credit Union!
  • Take a Little “You” Time! You will have access to our generous time off policies designed so you can plan around holidays, family events, volunteering, or just to take a relaxing day off. With the opportunity to initially earn up to 20 days annually plus parental leave, paid holidays, celebration day, life leave (40 hours/year), bereavement leave, and community service/education support days, there will be plenty of time for you!
  • Give Back! We offer several ways to give back through our Matching Gift Program, Good Neighbor Grant Program, and the Employee Assistance Fund.
  • Finish Strong! Plan for retirement using free financial advisors and a 401(k) plan with company contributions of up to 7% of your salary.

Visit our State Farm Careers page for more information on our benefits, locations, and the hiring process of joining the State Farm team!

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Staff ML Engineer
Staff ML Engineer

State Farm • Atlanta (GA)

Hybrid
USD 160,000 - 220,000
Health benefits
Hybrid work
401(k) plan
+2
Lead Fullstack Engineer (AWS)
Lead Fullstack Engineer (AWS)

State Farm • Richardson (TX)

Hybrid
USD 81,000 - 142,000
Potential starting salary range: $81,0
Potential yearly incentive pay up to
Staff ML Engineer
Staff ML Engineer

State Farm • Bloomington (IL)

Hybrid
USD 160,000 - 220,000
Annual bonus
Comprehensive health plan
Retirement benefits
+2
Lead Software Engineer (Python)
Lead Software Engineer (Python)

State Farm • Richardson (TX)

Hybrid
USD 107,000 - 135,000
Salary range $107,000-$135,000
Annual bonus up to 10%
Health & wellbeing programs
+4
REMOTE - Lead MLOps Engineer (Databricks)
REMOTE - Lead MLOps Engineer (Databricks)

State Farm • Bloomington (IL), Dunwoody (GA), Richardson (TX), Tempe (AZ)

Hybrid
USD 100,000 - 200,000
Annual raise & bonus
Health & wellbeing programs
Tuition assistance
REMOTE - Lead MLOps Engineer (Databricks)
REMOTE - Lead MLOps Engineer (Databricks)

State Farm • Atlanta (GA)

Hybrid
USD 100,000 - 200,000
Annual raise
Health benefits
401(k) plan
+2
Lead MLOps Engineer — Databricks, MLflow & Agentic AI
Lead MLOps Engineer — Databricks, MLflow & Agentic AI

State Farm • Bloomington (IL), Dunwoody (GA), Richardson (TX), Tempe (AZ)

Hybrid
USD 100,000 - 200,000
Annual raise & bonus
Health & wellbeing programs
Tuition assistance
Lead Java Developer (Cloud)
Lead Java Developer (Cloud)

State Farm • Atlanta (GA)

Hybrid
USD 81,000 - 142,000
Healthcare premium covered
Educational benefits and tuition
401(k) with company contributions
+4
Staff Data Scientist - Databricks
Staff Data Scientist - Databricks

State Farm • Atlanta (GA)

Hybrid
USD 160,000 - 220,000
Annual raise & bonus
Health insurance
Tuition assistance
+2
Lead Software Engineer: ServiceNow & GenAI–Now Assist (HYBRID)
Lead Software Engineer: ServiceNow & GenAI–Now Assist (HYBRID)

State Farm • Bloomington (IL), Dunwoody (GA), Richardson (TX), Tempe (AZ)

Hybrid
USD 107,000 - 160,000
Annual raise and bonus
Health and wellbeing programs
Tuition assistance
+3