Overview
On Site
$60 - $70
Full Time
50% Travel
Skills
Data Modeling
Erwin Data Modeler
NoSQL
AWS
Job Details
Overview:
Responsible for designing and implementing data architecture in alignment with the agency/organization's business practice. This role involves designing robust and scalable data models and collaborating across teams to implement data solutions that meet business requirements in both operational and analytical contexts.
Responsible for designing and implementing data architecture in alignment with the agency/organization's business practice. This role involves designing robust and scalable data models and collaborating across teams to implement data solutions that meet business requirements in both operational and analytical contexts.
The individual is responsible for the following tasks:
- Design, develop, and maintain end-to-end data architecture to support application development, data warehouse, data marts, analytics, and business intelligence initiatives.
- Define and enforce data architecture standards, principles, and best practices, including documentation such as data dictionaries, entity-relationship diagrams, and data flow diagrams.
- Collaborate with multiple teams including data engineers, UI/API developers, business analysts, and stakeholders to understand data usage requirements and objectives and to support data-driven decision-making.
- Identify and evaluate data management solutions and technologies, including relational (RDBMS) and NoSQL databases, in support of performance, scalability, and business alignment.
- Implement data governance policies and procedures to promote data quality, integrity, security, and compliance, including AWS-based implementations and data masking.
- Evaluate, improve, and optimize current systems, including ensuring performance efficiency for data loads and queries, and alignment with ETL frameworks and pipelines.
- Create and update documentation for conceptual, logical, and physical data models, and track modeling changes using tools such as Erwin, Jira, and Bitbucket in an Agile framework. Additional Integrated Responsibilities:
- Design and validate scalable data models and database structures that align with business rules and requirements.
- Ensure that data models are consistent, accurate, reliable, and in sync with ETL development processes.
- Analyze data from formats including JSON and Parquet and support transformation logic based on business rules.
- Monitor and tune database performance and optimize AWS storage and compute resources.
- Ensure that all data practices comply with regulatory requirements and department policies. Manage tasks in Jira and participate in Agile sprint planning to track resource work progress and deliverables.
Education:
This position requires a bachelor's or master's degree from an accredited college or university with a major in computer science, statistics, mathematics, economics, or a related field. Three (3) years of equivalent experience in a related field may be substituted for the Bachelor's degree.
This position requires a bachelor's or master's degree from an accredited college or university with a major in computer science, statistics, mathematics, economics, or a related field. Three (3) years of equivalent experience in a related field may be substituted for the Bachelor's degree.
General Experience:
The proposed candidate must have a minimum of three (3) years of experience as a data architect. This includes direct experience designing and implementing data models and supporting the change management and performance monitoring of enterprise data environments.
The proposed candidate must have a minimum of three (3) years of experience as a data architect. This includes direct experience designing and implementing data models and supporting the change management and performance monitoring of enterprise data environments.
Specialized Experience:
The candidate should have experience as a data architect or in a similar role, with a strong understanding of data architecture principles and practices. The candidate must:
- Be proficient in data modeling tools (e.g., Erwin) and source control tools (e.g., Bitbucket). Have hands-on experience with relational, non-relational (NoSQL), and graph databases.
- Understand ETL frameworks and work closely with development teams to align data models with business logic.
- Be familiar with Agile methodologies, including creating and managing tasks in Jira and participating in sprints.
- Possess experience in AWS environments, including cost optimization, security practices, and masking tools.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.