ADM Data Modeler- Erlanger, KY in Erlanger, Kentucky
Data Modeler- Erlanger, KY
We exist…To unlock the power of nature to enrich the quality of life!
ADM is seeking a Data Modeler who can partner with Solution Leads and Global Process Owners to understand comprehensive business processes, strategy, standards and source systems in order to develop their data and analytical solutions. Communicate Data and Analytics (DnA) capabilities with DNA Leadership, Portfolio Office and Transformation Office to ensure requests are collected and treated in accordance with the IT operating model, demand management processes and delivered in alignment to DNA’s data and application strategies.
This is an exempt level position.
The data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.
A successful candidate will be responsible for the development of logical and physical data models across all enterprise data platforms. He/She will lead all aspects of and govern the expansion of existing data architecture and the optimization of data query performance via standard methodologies. He/She should demonstrate success in an Agile environment and will be required to work both independently and within a team.
Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL)
Work with solution teams and Data Architects to implement data strategies, build data flows, and develop logical/physical data models
Work with Data Architects to define and govern data modeling and design standards, tools, previous findings, and related development for enterprise data models.
Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.
Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
Build, maintain, optimize and update logical and physical data models along with corresponding metadata to support new and existing projects.
Develop standard methodologies for standard naming conventions and coding practices to maintain consistency of data models.
Recommend opportunities for reuse of data models in new environments.
Perform reverse engineering of physical data models from databases and SQL scripts.
Evaluate data models and physical databases for variances and discrepancies.
Validate business data objects for accuracy and completeness.
Analyze data-related system integration challenges and propose appropriate solutions.
Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.
Evaluate modifications to existing data model and new application design and recommend efficiency gains or corrections when required
Job Description (Continued):
Bachelor degree in computer/data science technical or related experience.
5+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
Experience with data warehouse, Data Lake and enterprise big data platforms in multi-data-center contexts required.
Experience with metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.
Experience in team management, communication, and presentation.
Understanding of agile delivery methodology and experience working in scrum environment
Ability to understand and translate business needs into data vault and dimensional data models supporting long-term solutions.
Work with the Application Development team to implement appropriate data strategies.
This position offers a complete benefit package, including 401K/ESOP, pension, health, life, vision, and dental insurance. ADM requires the successful completion of a pre-employment drug screen and a background check.
KY - Kentucky
ADM is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability and veterans status.