Farmers Insurance Group | Data Engineer (Application SME I) | Remote | United States | BigDataKB.com | 20 Oct 2022

Job Location: Remote

We are Farmers!

We areโ€ฆ more than just your favorite commercials. We are a passionate, award winning, equal opportunity employer, committed to the strength of a diverse workforce. We are dedicated to supporting the well-being of our people through our extensive suite of benefits, as well as the well-being of the communities we serve through employee volunteer programs and nonprofit partnerships. Helping others in their time of need isnโ€™t just our business โ€“ itโ€™s our culture! We are Farmers!

Do you thrive in a high-volume, fast-paced environment? Do you enjoy the challenge of a position where no two days are alike? We are looking for positive, high-energy professionals who are not just looking for a job, but a meaningful career!


Job Summary

Use MS SQL SSIS to build ETL process to create new business functionalities as well to solve business problems: Respond to new requests for reports/data understanding business objectives and processes; review and refine technical requirements/User Stories; and communicate estimated hours and timeline to complete; Extract data directly from relational databases (e.g. DB2, SQL Server), data warehouses, or other data stores using SQL; Ability to create manual as well as automated data exports/reports; and Support application unit testing for enhancements or system upgrades; identify and communicate data quality issues or data differences. Work productively on assigned tasks; Collaborate effectively with other team members; Demonstrate accountability to management and business for hours spent on assigned tasks; and diligently strive to deliver value.

Essential Job Functions

Work within structure of SAFe Agile team on the successful delivery of Business Intelligence projects, enhancements, and defects. Independently lead and deliver new projects and enhancements. Collaborate with Agile team members to understand functional and technical requirements. Prepare estimates based on high-level requirements and assumptions. Translate functional requirements into technical specifications for ETL development; develop source-to-target mappings and actively manage Development, Unit Testing and Implementation efforts. Troubleshoot production defects, perform root cause analysis and provide guidance to team on the fixes.


Education Requirements

  • High school diploma or equivalent required.
  • Bachelorโ€™s degree preferred, in Information Systems or related field.

Experience Requirements

  • Experience in developing ETL and reporting applications using Microsoft SQL Server (strongly preferred), or Informatica or similar ETL technologies.
  • Experience in a BI/Data Warehouse environment with involvement in design, development, implementation, troubleshooting and support of ETL process on MS SQL Server or DB2 or similar DB platform.
  • Experience with Python and unstructured data manipulation is a plus.
  • Experience with cloud technologies such as AWS Glue, Azure Data Factory, Snowflake is a plus.
  • Experience working in an Agile Environment is a plus.
  • Good knowledge of business intelligence best practices, processes, and methodologies.
  • Good programming experience in writing Stored Procedures, Queries, Views, User Defined Functions, and Common Table Expressions using SQL or T-SQL.
  • Highly committed, motivated, enthusiastic and a natural team player.
  • Good interpersonal and communication skills (both verbal and written) and ability to interact with and effectively address concerns.
  • Good prioritization, time management, analytical, and organization skills.
  • Experienced in facilitating in-person and remote meetings with business & IT.
  • Experienced in effective management of multiple competing and frequently changing assignments and priorities.

Benefits

  • Farmers offers a competitive salary commensurate with experience, qualifications and location
  • Colorado Only: The pay range for this job being performed in Colorado would be 73,600 – 98,100
  • Bonus Opportunity (based on Company and Individual Performance)
  • 401(k)
  • Medical
  • Dental
  • Vision
  • Health Savings and Flexible Spending Accounts
  • Life Insurance
  • Paid Time Off
  • Paid Parental Leave
  • Tuition Assistance

Job Location(s): R_US – RW – Remote Work




Apply Here

Submit CV To All Data Science Job Consultants Across United States For Free

๐Ÿ” Explore All Related ITSM Jobs Below! ๐Ÿš€ โœ… Select your preferred “Job Category” in the Job Category Filter ๐ŸŽฏ ๐Ÿ”Ž Hit “Search” to find matching jobs ๐Ÿ”ฅ โž• Click the “+” icon that appears just before the company name to see the Job Detail & Apply Link ๐Ÿ“๐Ÿ’ผ

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *