Associate Analytics Engineer Hartford, CT (Hybrid) at Farmers

We are Farmers!We are more than just your favorite commercials. At Farmers we strive to deliver peace of mind to our customers by providing protection and comprehensive advice and delivering in the moments of truth. That means having people who can help us meet changing customer and business needs. Farmers high-performance culture is focused on results and the people who achieve them. We hold ourselves and others accountable for sustainably growing the business and each other. We seek solutions own our actions and grow through discomfort. We see setbacks as opportunities while continuously asking ourselves how we impact our customers.Farmers is an award winning equal opportunity employer committed to the strength of an inclusive 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 isnt just our business its our culture! To learn more about our high-performance culture and open opportunities check out be sure to follow us on Instagram LinkedIn and TikTok.Workplace: Hybrid ( #LI-Hybrid ) Remote ( #LI-Remote )Farmers believes in a culture of collaboration creativity and innovation which thrives when we have the ability to work flexibly in a virtual setting as well as the opportunity to be together in person. Our hybrid work environment combines the best of both worlds with at least three (3) days in office and up to two (2) days virtual for employees who live within fifty (50) miles of a Farmers corporate office. Applicants beyond fifty (50) miles may still be considered.Job Summary This position plays a role in the data ecosystem by assisting in transforming raw data into structured high-quality datasets that are ready for analysis. The role primarily focuses on low to moderately complex business problems while receiving coaching and guidance from data leadership. The role combines the technical skills of a data engineer the analytical mindset of a data analyst and working business acumen to ensure data is not only collected and stored efficiently but also accessible and insightful for end users. With some coaching and guidance from more experienced engineers the position is responsible for end-to-end data workflow including data ingestion transformation modeling and validation to enable data-driven decision-making across the organization. The position requires understanding of data engineering business processes and analytics principles as well as a proactive approach to solving complex data challenges.What Youll Do Emerging data infrastructure development with coaching and guidance: Pipeline Design and Development - Architects and builds scalable data pipelines using modern ETL (Extract Load Transform) tools and frameworks such as dbt (Data Build Tool) Apache Airflow or similar. Automates data ingestion processes from various sources including databases APIs and third party services. Data Storage and Management - Designs and implements data warehousing solutions using platforms like Snowflake Redshift or BigQuery. Optimizes storage solutions for performance cost efficiency and scalability.Emerging data modeling and transformation with coaching and guidance: Data Modeling - Develops and maintains logical and physical data models to support business analytics. Creates and manages dimensional models star/snowflake schemas and other data structures. Data Transformation - Transforms raw data into clean organized and analytics-ready datasets using SQL Python or other relevant langua ges. Implements data transformation workflows to handle data cleansing normalization and enrichment. Data Quality Assurance - Conducts data validation and consistency checks to ensure the accuracy and reliability of data. Implements data quality monitoring and alerting mechanisms.Emerging collaboration and stakeholder management with coaching and guidance: Cross-Functional Collaboration - Works closely with data analysts data scientists and business stakeholders to gather requirements and understand their data needs. Acts as a liaison between technical teams and business units to translate business requirements into technical specifications. Technical Communication - Clearly communicates complex technical concepts and data insights to non-technical stakeholders. Provides training and support to team members on data tools best practices and methodologies.Emerging data governance and security knowledge with coaching and guidance: Governance Policies - Implements and enforces data governance policies to ensure data privacy security and compliance with relevant regulations. Defines and manages data access controls permissions and audit trails. Security Measures - Monitors and enforces data security measures to protect sensitive information from unauthorized access and breaches. Ensures compliance with industry standards and regulations such as GDPR CCPA or HIPAA and others as applicable.Emerging tool and technology utilization with coaching and guidance: Technology Stack - Utilizes modern data tools and technologies such as SQL Python dbt Airflow and cloud platforms like AWS Azure or GCP. Evaluates and integrates new tools and technologies to improve data infrastructure and processes. Continuous Learning - Stays updated with the latest trends best practices and advancements in data engineering and analytics. Participates in professional development opportunities to enhance technical and analytical skills. Provides code as requirements for hardening and operationalization by technology with significant coaching guidance and feedback. Performs other duties as assigned.Additional Qualifications Strong verbal communication and listening skills.Demonstrated written communication skills.Demonstrated analytical skills.Demonstrated problem solving skills.Effective interpersonal skills.Ability to influence internal and/or external constituents.Seeks to acquire knowledge in area of specialty.Possesses strong technical aptitude. Basic experience with SQL or similar dimensional modeling pipeline orchestration building data pipelines to transform data and BI visualizations. Acts as translation layer for and conduit to technology for all aspects of the workWhat Youll Bring 1-2 years of related work experience required.1-2 years of experience with Python SQL1-2 years of experience with Data EngineeringGood to have experience with AWS DBT or PySparkEducation Requirements High School Diploma or equivalent required.Bachelors degree preferred in computer science data science engineering or a related field.Physical Actions Job is performed in-person at a Farmers office or virtually at an approved alternative work location. The physical work environment is indoors and climate-controlled with adequate lighting and ventilation. Normal and customary distractions include background noise produced by office equipment and chatter among people as well as interruptions. Frequently sits for prolonged periods of time up to a full shift. Occasionally moves about the workplace including navigating stairs ramps and level or uneven surfaces. Occasionally moves pushes pulls lifts carries and/or places objects or materials weighing up to 25 pounds without assistance. Frequently uses shoulders arms hands and fingers to manipulate equipment tools and objects necessary to perform job duties. Frequently performs fine motor tasks such as typing mousing or writing up to a full shift. Rarely performs movements such as bending stooping crouching kneeling twisting and reaching overhead or below the knees. Possesses clear vision with or without correction to visually read and verify information. Relies on depth perception and peripheral vision to navigate the work environment visually by identifying barriers changes in terrain and locating objects. Possesses adequate hearing with or without correction to communicate with co-workers respond promptly to auditory signals or alarms and discern sounds essential for maintaining safety and productivity in the workplace. Jobs in this category require rare if any travel.BenefitsFarmers offers a competitive salary commensurate with experience qualifications and location.o CA Only: $84640 - $134530o CO Only: $79360 - $116380o HI/IL/MN/VT Only:$79360 - $124300o MA Only:$79360 - $124300o MD Only: $79360 - $124300o DC/NJ/NY/OH Only: $79360 - $134530 o Albany County NY/Cleveland OH: $84640 - $116380o WA Only: $79360 - $141250Bonus Opportunity (based on Company and Individual Performance)401(k)MedicalDentalVisionHealth Savings and Flexible Spending AccountsLife InsurancePaid Time OffPaid Parental LeaveTuition AssistanceFor more information review What we offer on Location(s): US - CT - Hartford US - CT - West HartfordAnticipated application deadline: At Farmers the recruitment process is designed to ensure that we find the best talent to join our team. As part of this process we typically close open positions within 8 to 21 days after posting. If you are interested in any of our open positions we encourage you to submit your application promptly.Farmers will consider for employment all qualified applicants including those with criminal histories in accordance with the Los Angeles Fair Chance Initiative for Hiring Ordinance or other applicable law. Pursuant to 18 U.S.C. Section 1033 Farmers is prohibited from employing any individual who has been convicted of any criminal felony involving dishonesty or a breach of trust without prior written consent from the state Department of Insurance.It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.Farmers is an Equal Opportunity Employer and does not discriminate in any employer/employee relations based on race color religion gender sexual orientation gender expression genetic information national origin age disability marital status military and veterans status or any other basis protected by applicable discrimination laws.Want to learn more about our culture & opportunitiesCheck out be sure to follow us onInstagramLinkedIn andTikTok.Spokane WA only: Residents who prefer not to provide their address click here to submit your resume via email:Required Experience:IC Key Skills Adobe Analytics,Data Analytics,SQL,Attribution Modeling,Power BI,R,Regression Analysis,Data Visualization,Tableau,Data Mining,SAS,Analytics Employment Type : Full Time Experience: years Vacancy: 1 Monthly Salary Salary: 79360 - 141250