Data Specialist
State Farm - Phoenix, AZ

This job posting is no longer available on State Farm. Find similar jobs: Data Specialist jobs - State Farm jobs

WHAT ARE THE DUTIES AND RESPONSIBILITIES OF THIS POSITION?

Designs, creates, alters and maintains database solutions, across multiple platforms and computing environments, that meet business needs

Performs industry research for data and database technologies and related software, tools, standards and training

Develops, follows, and/or implements data and database administration procedures, strategies, guidelines, standards, tools, support and training

Performs analysis and problem resolution related to data and databases

Works to improve time to market opportunities and provide flexible solutions by embracing the solution provider mindset

Applies innovation, passion, flexibility, adaptability, and initiative in daily activities in order to contribute to a Systems culture that clearly reflects these ideals

Maintains an understanding of how technology can enhance State Farm's business and helps our business partners

WHAT KNOWLEDGE AND SKILLS ARE NEEDED TO BE SUCCESSFUL IN THIS POSITION?

Keeps abreast of data and database administration industry trends/best practices for use in strategic and/or tactical planning

Conducts research, analyzes and synthesizes information; anticipating business needs and its application to Systems processes and potential solutions

Leads and/or contributes to strategic work (highly complex and crosses multiple organizational boundaries) and influences team members and business partners

Functions with the highest level of autonomy; consistently assumes a lead/coordination role in the completion of work responsibilities

Drives/delegates work of other analysts towards the goals of the department (financial responsibility, expense management)

Provides leadership to others within sphere of influence, including business partners and other areas within Systems

Drives, embraces, and enables an environment of change - fostering innovation; championing initiatives, efforts, and ideas for Systems and the Enterprise

Is sought out as a subject matter expert in area of expertise and provides comprehensive database knowledge on various design and access techniques for complex efforts

Applies breadth and depth of knowledge to complete significant troubleshooting on the most technical data issues or business situations that hinder the achievement of service level objectives

Works independently on daily work and demonstrates sound judgment in making decisions with respect to matters of moderate to high complexity and importance

Assists in budgeting and component/project planning, as requested

Participates in and/or leads vendor product reviews, evaluations, demonstrations, proofs of concept and implementations, as required

Applies broad-based knowledge of database indexes, index management, and referential integrity with an in-depth/specialized knowledge of at least one database management system to perform daily tasks

Completes SQL Performance tuning and query optimization to reduce CPU consumption and response time and increase integration/operability of systems

Completes SQL reviews to improve or ensure efficient database access techniques

Diagnoses and troubleshoots database integrity, performance, and data replication issues

Applies broad-based knowledge of data backup, restore, and recovery methods to complete daily assignments

Keeps abreast of business and IT industry trends and best practices while modifying processes to meet changing needs and influences the direction of solutions

May lead some strategic work and/or contributes to strategic work (e.g. cross departmental or enterprise initiatives)

Maintains solid relationships and strategic partnering skills with business partners, team members, and external associates

Mentors other database specialists

Applies depth or breadth of knowledge regarding Systems Department structure and processes to complete assignments

Provides database administration support to business partners

Provides incident resolution

Leads tactical work and contributes to strategic work (e.g. creating something new or modifying something currently in existence to meet business needs)

Assists with developing or modifying database policies, guidelines, standards, procedures, and documentation, as required

ITEMS OF NOTE

ADDITIONAL INFORMATION

Horizontal Data Movement (HDM) is a newly formed area providing execution of complex data movement or data migration to ensure on-time, quality delivery. This includes designing, developing, and implementing the initial population and enabling ongoing synchronization for data movement. Attaining resources that have expertise or a strong aptitude to learn transactional management, will help promote appropriate design and access to improve data quality. This will provide a better customer experience.

Preferred knowledge:
_ DB2 Experience
_ PostgreSQL experience (or multiple other Linux-based RDBMS s)
_ Distributed DBMS Experience (sharing, clustering, load balancing, and replication)
_ Data Access Design
_ Data Access Development
_ Data Validation develop, automate and execution
_ SQL experience
_ Transactional Data Design
_ OO Design
_ Experience with execution/ongoing sync process
_ Experience working with large data sets
_ Performance Tuning experience for High volume applications

Additional Skills that would be beneficial to this position:
_ PostgreSQL master-master replication and conflict resolution
_ NoSQL DBMS experience (Riak, Cassandra, MongoDB, CouchDB)
_ Caching

SFARM

BENEFITS: TOTAL REWARDS

Our Total Rewards benefits package includes:
Competitive starting salary

Annual merit reviews

Annual bonus potential

You may also be eligible to participate in Medical, Dental, Life and Disability Insurance, Vision, 401(k) Plan (Savings & Thrift in Canada), Credit Union, a fully funded retirement pension plan, and more.

To search for more information on careers in the U.S., visit statefarm.com/careers. To search for more information on careers in Canada, visit statefarm.ca/careers.

State Farm Insurance is an equal opportunity employer

State Farm - 20 months ago - save job - block
Recommended Jobs
Data Specialist - Data Design
State Farm - Phoenix, AZ
State Farm - 7 days ago

Data Specialist - Data Design
State Farm Mutual Automobile Insurance Company - Phoenix, AZ
State Farm Mutual Automobile Insurance Company - 6 days ago

Data Specialist
State Farm - Phoenix, AZ
State Farm - 7 days ago
About this company
1,584 reviews
State Farm Mutual Automobile Insurance Company® is the largest auto insurer in the U.S. since 1942. About one of every five cars on the...