Michigan, Grand Rapids-Muskegon-
Responsible to design and maintain enterprise databases that model data and optimize analytical databases. Document business requirements, utilize modeling tools to build and analyze databases, and develop the database design ensuring effective and optimal database solutions.
Bachelor' s Degree (Required) Computer Science
Information Technology, Business Administration or related field or equivalent combination of education and/or experience.
Three years of Information Technology experience in database modeling/relational database administration.
Experience with and knowledge of data modeling tools, principles and practices and related configuration management concepts.
Responsibilities and Essential Duties
Create and maintain various database versions to model data to optimize database design and share relational data across various applications. Document data model standards and database diagrams. Work with cross-functional departments to coordinate the database changes in a timely and accurate manner.
Utilize modeling tools to build and analyze databases and to develop logical and physical models to include relationships, constraints, attributes, and other modeling information to understand impact for proposed systems, and setup approved systems.
Design data model structures that enhance the application performance through the development of aggregation and summarization structures. Document model structures (i.E., keys, indexes, constraints) and partner with cross-functional IT (i.E., Data Warehouse/Database Administration) for the process of data normalization and physical data base design.
Gather and document business requirements and convert requirements into testable designs; and work with the business and application teams to refine design requirements on assigned projects.
Maintain data reliability and integrity to eliminate data redundancy and to streamline the reporting platform. Maintain current knowledge of organization data uses to recommend improvements and maintain data integrity.
Establish and maintain common data definitions (i.E., naming guidelines, standard abbreviations, naming conventions) for database users to eliminate data redundancy and improve data integrity. Document data definitions and coordinate data models, dictionaries, and other database documentation across multiple applications.
Identify key business components and gather specification requirements to design and maintain relational databases and interface with business processes; develop detailed requirements documents and/or workflow diagrams. Develop logical data models which include the entity-relationship diagram, entity and data item business names and descriptions, and define data item valid values, format/type, text/number length, etc.
Identify, recommend and implement process improvements that enhance department practices and effectiveness.
Provide technical guidance to the applications development team regarding database design to reduce risk of design issues. Interface with appropriate IT sub-departments and/or cross functional business areas to address concerns and resolve issues in a timely manner.
Participate in the development of project scope and milestones to meet assigned project requirements. Partner cross-functionally to meet deadlines and audit databases/reports, and work with management on critical issues.
Maintain current knowledge of industry trends and best Information Technology/Data Administration practices; make recommendations to improve current programs and processes.
May participate in new application evaluation to determine feasibility and potential for sharing existing data.
Knowledge, Skills Abilities
Strong verbal and written communication skills; ability to communicate IT data modeling/administration in a non-technical manner. Must have strong organization, prioritization, analytical and problem-solving skills. Must be detail oriented, have good project/time management and strong data management and documentation skills. Working knowledge of MS Office, MS Project and Visio. Ability to travel up to 10% based upon department and customer needs. Must have thorough knowledge of dimensional databases and experience developing logical and physical data models. Must have technical knowledge of applications systems, programming and analysis, and knowledge of databases and design techniques. Technical knowledge and experience with ERWIN and relevant database platforms (e.G., Oracle, DB2, SQL).