DATA MODELER
Archer Daniels Midland - Erlanger, KY
Apply NowJob Description
Data Modeler Company Introduction 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 captured and treated in accordance with the IT operating model, demand management processes and delivered in alignment to DNA's data and application strategies Job Description 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. The successful candidate will: Be responsible for the development of logical and physical data models across all enterprise data platforms. Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. Demonstrated success in an Agile environment. The candidate must be able to work independently and collaboratively. Responsibilities 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, best practices, 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. Skills 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. Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required. Preferred experience working with services in Azure (Azure Data Factory, Azure Data Lake Storage & Synapse). Experience working on Azure Databricks is a plus. Experience in team management, communication, and presentation. Understand agile delivery methodology and experience working in scrum environment. Understand and translate business needs into data vault and dimensional data models supporting long-term solutions. Work with the Application Development team to implement data strategies, create logical and physical data models using best practices to ensure high data quality and reduced redundancy. Optimize and update logical and physical data models to support new and existing projects. Maintain logical and physical data models along with corresponding metadata. Develop best practices for standard naming conventions and coding practices to ensure 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. Develop data models according to company standards. Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces. Review modifications to existing data models to improve efficiency and performance. Examine new application design and recommend corrections if required.
Created: 2024-09-07