Senior Data Engineer
Farmers Insurance
full-time
Posted on:
Location Type: Hybrid
Location: California, Colorado, District of Columbia, Hawaii, Illinois, Maryland, Massachusetts, Minnesota, New Jersey, New York, Ohio, Vermont, Washington • 🇺🇸 United States
Visit company websiteSalary
💰 $112,720 - $200,625 per year
Job Level
Senior
Tech Stack
AWSCloudETLPythonScalaSparkSQLTableau
About the role
- Responsible for acquiring, curating, and publishing data both on prem and in the cloud for analytical or operational uses for moderate and complex scenarios.
- Ensures the data is in a ready-to-use form that creates a single version of the truth across all data consumers, including business/technology users, reporting and visualization specialists, and data scientists.
- Utilizes skills to translate business analytic requests/requirements into design, development, testing, deployment, and production maintenance tasks.
- Works independently with various technologies from big data, relational and non-relational databases, cloud environments, different programming languages, and various reporting tools.
- This role sits at the intersection of business, data, and technology, and is ideal for someone who thrives on building data-driven solutions and collaborating cross-functionally.
- This role is pivotal in designing, building, and maintaining scalable data products and analytics solutions that empower Advanced Analytics, Business Intelligence, and Data Science initiatives.
- You will play a critical role in building a semantic data layer, defining and implementing cutting-edge data products, and delivering innovative AI-driven solutions that fuel business growth and enhance customer experience.
Requirements
- 5-7 years of related experience required.
- Advanced experience in SQL, Snowflake, DBT, AWS, Spark (Scala or Python), Spark SQL or equivalent.
- Advanced experience in dimensional modeling.
- Advanced Experience building data pipelines, ETL to transform data as per 1 of 2 business logic.
- Advanced knowledge and understanding with pipeline orchestration.
- Advanced understanding of cloud computing environments.
- Advanced experience with BI visualizations such as Power BI, Tableau etc.
- Strong verbal communication and listening skills.
- Demonstrated experience interacting with executive and senior leadership stakeholders around the topics of data access, quality, appropriate use, metric definitions and standardization.
Benefits
- 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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLSnowflakeDBTAWSSparkScalaPythonSpark SQLdimensional modelingETL
Soft skills
verbal communicationlistening skillscollaborationinterpersonal skillsstakeholder interaction