Summary:
The Data Modeler/Data Architect will provide Technical Leadership and assist with the design and implementation of Relational Database Management Systems (RDBMS) and NoSQL systems, including but not limited to Oracle, Postgres, MongoDB, Snowflake and Dynamo DB for large complex applications. 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, and other business interests.
Essential Job Duties and Responsibilities:
- Develop and maintain conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
- Oversee and govern data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
- Analyze and translate business needs into long-term solution data models.
- Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics).
- Evaluate existing data systems.
- Collaborate with business, application/solution, and development team to create conceptual data models and data flows.
- Develop best practices for data coding to ensure consistency within the system.
- Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
- Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
- Hands-on modeling, design, configuration and installation across environment, performance tuning.
- Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
- Comply with all company policies and procedures.
- Maintain regular and punctual attendance.
Other Job Duties and Responsibilities:
Performs other related duties as assigned.
Supervisory Responsibilities:
This position is an individual contributor with no direct reports but may provide guidance, leadership, or training to others.
Qualifications:
To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
- Strong experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required.
- Strong experience in development of stored procedures, packages, triggers, SQL queries, reports, and scripts.
- Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.
- Experience in communication, and presentation.
Education and/or Experience:
- Bachelor’s or master’s degree in computer/data science technical or related experience.
- 8+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
