in NORTH AMERICA-USA-CALIFORNIA-HAYWARD, USA-California-Hayward
DuPont Pioneer, a leader in plant biotechnology delivering advanced plant genetics to farmers, is seeking a Data Analyst to help develop a Next Generation Data warehouse for scientific data. We are developing concepts to integrate and present data to support the characterization and development of commercial traits for various crops in all Pioneer markets. We are looking for creative individuals with critical thinking skills to develop robust and innovative solutions to complex problems in an evolving research environment.
• Translates Business Rules and Requirements into analytical models
• Analyze, document and communicate source system data structures as well as explicit and implicit dependencies within and between data sources
• Works with Requirements Analyst, Data Architect, Data Modeler and the ETL Team to translate Business Rules into Technical Requirements for ETL processes
• Ability to drive the Source to Target Mapping Specifications process
• Drive the understanding/validation of data
• Discover/Mitigate/Validate problematic data and communicate with Source Teams and Data Warehouse Team
• Develop Data Migration solutions for disparate data sources
• Define and communicate cleaning and filtering requirements on data sources
• Identify integration points of new data sources with existing data and define integration mappings
Bachelor's degree and 4 years of experience developing data warehouse solutions required; or equivalent levels of relevant education and experience.
Competencies & Experience:
• Strong analytical and problem solving skills with ability to clearly articulate solution alternatives
• Solid knowledge of data warehouse concepts
• Highly proficient in SQL/PL SQL, BI Tools and other Database Tools
• Strong knowledge of Dimensional Modelling and familiar with complex, large-scale relational databases.
• Ability to collaborate effectively and work closely within a coordinated team environment
• Excellent verbal and written communication skills and ability to communicate well, solve problems
DuPont Pioneer (www.pioneer.com/careers) headquartered in Des Moines, Iowa, is the world’s leading developer and supplier of advanced plant genetics, providing high-quality seeds to farmers in more than 90 countries. DuPont Pioneer provides agronomic support and services to help increase farmer productivity and profitability and strives to develop sustainable agricultural systems for people everywhere. Science with Service Delivering Success™.