Farmers is looking to solve the problem of acquiring, curating, and publishing data for analytical or operational uses, ensuring a single version of the truth across all data consumers.
Requirements
- Practical knowledge of SQL, Dimensional modeling, Query tuning, ETL orchestration ,PowerBI, Python, preferred.
- Hands-on experience with multiple cloud platforms including AWS, Google, and Azure, preferred.
- Hand on experience with developing on SSIS and SSAS, preferred.
- Intermediate experience in SQL, Spark (Scala or Python), Spark SQ or equivalent.
- Solid experience in dimensional modeling.
- Sound knowledge and experience building data pipelines to transform data as per business logic.
- Sound knowledge and understanding with pipeline orchestration.
Responsibilities
- Consults independently, works iteratively, and is viewed as an expert on data projects of a complex nature.
- Ability to understand design requirement and existing business processes to lead in the design, development, and implementation of data products in partnership with business partners and data scientists.
- Produces complex data building blocks, data models, and data flows working with business partners and data scientists within personal lines and distribution domains to deliver requests such as dimensional data models, standard and ad hoc reporting, data feeds, dashboard reporting, ad hoc analysis, data profiling etc.
- Designs and manages highly complex projects while handling multiple complex cross-functional projects.
- Preps/cleanses data to optimize for downstream reporting using Farmers standards.
- Functions as an expert in serving as a SME for appropriate data sources and for how best to operationalize solutions working closely with business partners and data scientists.
- Acts as a conduit between business and IT teams for all aspects of the work.
Other
- 3-5 years of related experience required.
- High School Diploma or equivalent required.
- Bachelor's degree preferred.
- Strong verbal communication and listening skills, preferred.
- Effectively coaches junior members and delivers constructive feedback, preferred.
- Proven experience interacting with executive and senior leadership stakeholders around the topics of data access, quality, appropriate use, metric definitions and standardization.
