17 sql analytics jobs at 6 companies in Washington, IL

1d
Save
Mark Applied
Hide
Analyst - Agency/Marketing Analytics
Bloomington or Richardson or Tempe or Dunwoody
$96k-$148k/yr HybridFull Time
State Farm
State Farm: Provider of auto, home, life, and health insurance.
5+ YOE5+ years analytics experience required, marketing agency experience preferred. Must analyze paid media channels, develop measurement and test plans, and present data-driven recommendations.
Athena, Redshift, Sagemaker, Python, SAS, SQL, Google Marketing Platform, Microsoft Power BI, Datorama, Adobe
1w
Save
Mark Applied
Hide
Lead Azure FinOps Analyst
Bloomington or Dunwoody or Richardson or Tempe
$107k-$142k/yr HybridFull Time
State Farm
State Farm: Provider of auto, home, life, and health insurance.
Deep Azure experience, FinOps and cost-optimization knowledge, advanced SQL, Power BI and automation (Python/SQL) skills, strong analytic and communication abilities for executive reporting.
Microsoft Azure, Power BI, Python, SQL
3d
Save
Mark Applied
Hide
Lead Business Intelligence Analyst
Chicago or Peoria or Irving
$128k-$193k/yr HybridFull Time
Caterpillar
CaterpillarNYSE: CAT: Manufactures construction equipment, mining machinery, and industrial engines.
Lead BI initiatives, design scalable analytics and datasets, advanced SQL and Snowflake expertise, BI governance, stakeholder communication, and program management skills.
SQL, Snowflake, Tableau, Power BI
1w
Save
Mark Applied
Hide
Lead AWS FinOps Analyst
Bloomington or Dunwoody or Richardson or Tempe
$107k-$142k/yr HybridFull Time
State Farm
State Farm: Provider of auto, home, life, and health insurance.
Expertise with AWS cost tooling, FinOps principles, advanced SQL, Python, API integration, QuickSight analytics, and experience translating cloud consumption into financial recommendations.
Amazon Web Services (AWS), AWS Cost Explorer, AWS Cost and Usage Reports (CUR), AWS Cost Optimization Hub, AWS Trusted Advisor, Amazon QuickSight, Amazon Bedrock, Bedrock APIs, OpenAI, Claude, Cloudability, Python, SQL, CI/CD
1mo
Save
Mark Applied
Hide
Lead Data Scientist
Morton or Chicago or Manchester or Prescott or Stuart or Malden or Plainville or Newburyport or Whitesboro or Thomasville or Cleveland or United States
$144k-$198k/yr RemoteFull Time
Pursuit Aerospace
Pursuit Aerospace: Manufactures complex engine components for the global aerospace industry.
2+ YOEBachelor's degree, 2+ years data science experience, 2+ years with SQL, Python, ML modeling and time-series analytics, eligible to work in US without sponsorship, able to comply with ITAR/EAR regs.
SQL, Python, Snowflake, Claude, GitHub, Microsoft Azure
1mo
Save
Mark Applied
Hide
Data Scientist
Bloomington or Richardson or Dunwoody or Tempe or Atlanta or Dallas or Phoenix
$102k-$163k/yr HybridFull Time
State Farm
State Farm: Provider of auto, home, life, and health insurance.
Master's or advanced degree in an analytical field required; experience building GLM and at least one of time series, clustering, tree-based algorithms, or neural networks; experience with SAS, R, or Python; cloud/AWS, Linux, and SQL preferred; strong communication skills.
SAS, R, Python, AWS, Linux, SQL
4w
Save
Mark Applied
Hide
Aftermarket Insights Sales Data Scientist
Peoria, Illinois, United States
$89k-$134k/yr OnsiteFull Time
Caterpillar
CaterpillarNYSE: CAT: Manufactures construction equipment, mining machinery, and industrial engines.
2+ YOEMaster's in engineering or related field plus 2 years experience in aftermarket product support in data analytics/engineering. Experience with Python, SQL, Microsoft Power BI, MWAA, EC2, Snowpark, stored procedures, GitHub, Microsoft Azure DevOps, Microsoft Visual Studio, and Alteryx.
Python, Structured Query Language (SQL), Microsoft Power BI, Managed Warehouse for Apache Airflow (MWAA), EC2, Snowpark, Stored Procedures, GitHub, Microsoft Azure DevOps, Microsoft Visual Studio, Alteryx
3w
Save
Mark Applied
Hide
Senior Data Systems Analyst
Downers Grove or San Antonio or Boston or Omaha or Hartford or Bloomington
$89k-$148k/yr HybridFull Time
Kemper
KemperNYSE: KMPR: Provides specialized auto, life, and health insurance services.
6+ YOEBachelor's degree (or equivalent) and 6+ years in data quality, warehousing, systems analysis or QA; insurance and enterprise data warehouse experience; advanced SQL; Snowflake/Oracle/SQL Server; Informatica/IICS; Power BI; Python; cloud experience.
SQL, Snowflake, Oracle, SQL Server, Informatica, IICS, Microsoft Power BI, XML, JSON, API, Python, Microsoft Azure, AWS, ETL/ELT, CI/CD, DataOps, DevOps, Agile
2w
Save
Mark Applied
Hide
Sr. Business Intelligence Analyst, Cat Digital
Peoria or Chicago
$113k-$169k/yr OnsiteFull Time
Caterpillar
CaterpillarNYSE: CAT: Manufactures construction equipment, mining machinery, and industrial engines.
5+ YOE5+ years Power BI experience, strong SQL and data‑analysis skills, ability to tell a story with data, programming knowledge, excellent communication and attention to detail.
Power BI, SQL, R, DevOps, Excel, Alteryx, Snowflake, Microsoft Management studio
5d
Save
Mark Applied
Hide
Principal Data Engineer
Peoria, Illinois, United States
$128k-$209k/yr OnsiteFull Time
Caterpillar
CaterpillarNYSE: CAT: Manufactures construction equipment, mining machinery, and industrial engines.
5+ YOE5+ years development experience building scalable Snowflake-based data platforms, ETL/ELT pipelines, and AI/ML solutions; proficiency with Python and SQL; data governance and cloud platform experience.
Snowflake, Snowpipe, Snowpark, Snowsight, Python, SQL, EMR, Glue, Snap Logic, GitHub, Cortex, Bedrock, Agent core, Dataiku, AWS Lambda, Power BI, Power Apps, Streamlit
5d
Save
Mark Applied
Hide
Data Science Manager
Alpharetta or Bloomington or Boston or Chicago or Columbus or Hartford or Omaha
$116k-$193k/yr HybridFull Time
Kemper
KemperNYSE: KMPR: Provides specialized auto, life, and health insurance services.
6+ YOEGraduate STEM degree with 6+ years (PhD with 4+ preferred), 6+ years ML/statistical modeling, Python and SQL proficiency, experience deploying models to production, prior mentoring/management, strong communication.
Python, SQL, Git
2mo
Save
Mark Applied
Hide
MID-LEVEL DATA ENGINEER-Python, AWS, Spark (Hybrid)
Bloomington or Richardson or Tempe or Dunwoody
HybridFull Time
State Farm
State Farm: Provider of auto, home, life, and health insurance.
2+ YOE2-4 years as a Data Engineer; proficiency in Python, Spark SQL/PySpark, R, Java, Bash; hands-on AWS (ETL tools, Lambda, Step Functions, S3, DynamoDB, Kinesis, Redshift, SageMaker); Spark/Databricks; IaC (OpenTofu); CI/CD with Airflow.
Python, Apache Spark, PySpark, R, Java, Bash, AWS, Glue, EMR Serverless, Lambda, Step Functions, EventBridge, S3, DynamoDB, Kinesis Firehose, Redshift, Iceberg, SageMaker, Databricks, OpenTofu, Terraform, Airflow, SQL, Athena
1w
Save
Mark Applied
Hide
Sr. Contact Channel Performance Analyst (Hybrid)
Bloomington, Illinois, United States
$90k-$110k/yr HybridFull Time
Afni
Afni: Global provider of contact center and customer engagement services.
3+ YOEBachelor's (or equivalent) and 3+ years in contact strategy/campaign management; strong analytical skills, A/B testing experience, multi-channel campaign expertise, stakeholder leadership, and compliance orientation.
Microsoft Excel, SQL
6d
Save
Mark Applied
Hide
Data Scientist
Morton, Illinois, United States
$89k-$145k/yr OnsiteFull Time
Caterpillar
CaterpillarNYSE: CAT: Manufactures construction equipment, mining machinery, and industrial engines.
Experience modernizing legacy simulation software, programming in modern languages, statistical modeling, machine learning, and stakeholder communication.
FORTRAN, C++, Python, R, SAS, SQL, Dataiku, Power BI, LangChain, LangGraph, Power Automate, Excel VBA, Tableau
2w
Save
Mark Applied
Hide
Senior P&C Actuarial Analyst – Sharing Economy
Bloomington or Dunwoody or Tempe or Richardson
$105k-$149k/yr HybridFull Time
State Farm
State Farm: Provider of auto, home, life, and health insurance.
2+ YOEBachelor's in an analytical field, 2+ years working with gig/sharing economy, 3+ SOA/CAS exams passed (ACAS preferred), experience with Microsoft Excel, SQL, R and/or Python, strong communication and analytical skills.
Microsoft Excel, SQL, R, Python
1w
Save
Mark Applied
Hide
Transportation Specialist
Morton, Illinois, United States
$113k-$169k/yr OnsiteFull Time
Caterpillar
CaterpillarNYSE: CAT: Manufactures construction equipment, mining machinery, and industrial engines.
Subject matter expert in international transportation systems; experience with TMS, e2open GLO, Parts Viz, Snowflake, SQL, EDI/API, Power BI; logistics/process improvement and analytical skills; project experience preferred.
Blue Yonder TMS, e2open GLO, Parts Viz, Snowflake, SQL, EDI/API, Power BI
1mo
Save
Mark Applied
Hide
Assistant MIS Manager (Peoria, IL)
Peoria, Illinois, United States
OnsiteFull Time
MH Equipment
MH Equipment: Authorized dealership for Hyster and Yale material handling equipment.
2+ YOEAccounting degree (associates) with 2+ years' experience, Power BI and Microsoft program proficiency, experience with Crystal, SQL, Microsoft Access, Unix, strong analytical and communication skills, ability to coordinate inventory and run month-end close.
Crystal, SQL, Microsoft Access, Microsoft Excel, Power BI, Unix, NDS