Allstate is looking to solve real-world business challenges through data by building scalable data infrastructure and enabling analytics across the enterprise.
Requirements
- Strong SQL skills and familiarity with Python.
- Exposure to cloud platforms and data warehouse technologies.
- Experience with dbt or similar transformation tools.
- Familiarity with CI/CD and Git.
- Understanding of business intelligence tools (Power BI, Tableau).
Responsibilities
- Develop and maintain ETL/ELT pipelines using SQL, Python, and cloud services.
- Support data modeling and warehouse design (e.g., Snowflake, Redshift).
- Collaborate with analytics teams to deliver reliable datasets and dashboards.
- Ensure data quality and documentation across analytics assets.
- Contribute to reusable analytics components and templates.
Other
- Currently pursuing a degree in Computer Science, Data Engineering, Information Systems, or related field.
- Interest in enabling data-driven decision-making.
- Attractive compensation package
- Collaborative team environment
- Potential for full-time employment after graduation
