Friday , February 23 2024

State Farm Employment – Data Design Administrator

Website State Farm

Job Description:

State Farm is looking for an experienced Data Analyst who will be responsible for supporting the cloud data warehouse technologies in support of a data marketplace. This individual will be primarily focused on designing and building the data solution.

Job Responsibilities:

As a Data Admin and Designer, you will be responsible for both DBA and Design/Modeling tasks. DBA tasks will be associated with the build out, backup/recovery, Data movement & ETL using AWS technologies Aurora and Redshift. Our new team member will also be responsible for modeling data being migrated from the FDW (Federated Data Warehouse) to create the domains of data on AWS. These domains of data will be consumed for reporting, visualization, and modeling by analytic data consumers.

Job Requirements:

  • Data solution design
  • Requirements gathering and customer collaboration
  • Data modeling
  • Aptitude to learn and/or practical experience working with Amazon Web Services (AWS) – Redshift & Aurora
  • Excellent time management and organizational skills
  • Experience working in insurance or financial sector, a plus
  • Software development experience a plus
  • ETL skills to transform flattened data into a consumable format
  • Experience with developing in Python
  • Experience writing SQL queries

Job Details:

Company: State Farm

Vacancy Type:  Full Time

Job Location: Dunwoody, GA, US

Application Deadline: N/A

Apply Here