Vacancy expired!
OverviewWe are not just offering a job but a meaningful career! Come join our passionate team!As a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inclusion to ensure a workforce that is engaged, builds on the strengths and talents of all associates, and creates a Good Neighbor culture.We offer competitive benefits and pay with the potential for an annual financial award based on both individual and enterprise performance. Our employees have an opportunity to participate in volunteer events within the community and engage in a learning culture. We offer programs to assist with tuition reimbursement, professional designations, employee development, wellness initiatives, and more!Visit our Careers page for more information on our benefits, locations and the process of joining the State Farm team! Check out our Enterprise Technology departmentResponsibilitiesAre you looking for an opportunity to join a team that's forging the way in innovation by adopting Cloud technologies for analytics? If so, the Marketplace team may be what you're looking for. Our team is building out the next generation data warehouse in the cloud called 'Marketplace'. The focus is on migrating analytic data and consumers to AWS. Data consumers include Data Scientists, Power Users and BI Reporting to name a few. The future state will also include integration with other marketplaces, as well as other data sources. Data Analysts are responsible for requirements gathering, solution design, data design, data modeling, data integration, and ETL activities associated with Marketplace. Data analysts work with their developer peers to model the flattened source data and 'rehydrate' it into a hierarchical structure for ease of consumption by several consumers. The Marketplace being created will also integrate with other products such as Feature Store, Data Virtualization products and Model development.Qualifications- Advanced SQL development skills
- ETL and data movement skills
- Solution development and deployment on AWS
- AWS technologies (ex: Redshift, Lambda)
Additional skills and experience: - AWS QuickSight
- Dashboard development experience
- DBA experience on a DBMS (i.e. DB2)
- Insurance or financial industry data knowledge
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. #LI-BS1SFARM#LI-Hybrid
- ID: #44640097
-
State: Illinois
Bloomington
61701
Bloomington
USA
- City: Bloomington
- Salary:
USD
TBD
TBD
- Job type: Permanent
- Showed: 2022-08-06
- Deadline: 2022-10-04
- Category: Et cetera