Description:
Responsible for acquiring, curating, and publishing data both on prem and in the cloud for analytical or operational uses for basic to moderate 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 with coaching and support. Utilizes skills to translate business analytic requests/requirements into design, development, testing, deployment, and production maintenance tasks. Works with various technologies from big data, relational and non-relational databases, cloud environments, different programming languages and various reporting tools and is familiar with a few but requires training for some.
The person for this role will need to be able to work (or adjust their hours) to Pacific Standard Hours, Monday - Friday.
What You'll Do
- 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.
- Create Dimensional Data Models, STTM’s and other technical documents for offshore developers and oversee technical delivery of projects by conducting code reviews, documentation reviews etc.
- Performs other duties as assigned.
What You'll Bring
- 3-5 years of related experience required.
- Possesses strong technical aptitude, preferred.
- Strong verbal communication and listening skills, preferred.
- Extensive experience interacting with senior leadership stakeholders around the topics of data access, quality, appropriate use, metric definitions and standardization, preferred.
- Effectively coaches junior members and delivers constructive feedback, preferred.
- 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.