Data Modeler

Job Title: Data Modeler

Location: Omaha, Nebraska, United States (On-site)

Duration: 6+ Months

JOB OBJECTIVE:

As a Data warehouse/Data Modeler, you will be responsible for designing and developing Relational and Dimensional data models that align with our organization's data strategy and business requirements. Your expertise in data modeling and understanding of data structures will play a critical role in shaping our data infrastructure and supporting effective data management practices. This position will be a hands-on data modeling role. You will create and maintain data models through effective data management practices. You will work closely with analysts to correctly translate requirements into the development team's technical design. In this role, you will assist application and data engineers at all levels with interpreting requirements, creating detailed designs, conducting Data Model and SQL reviews, and participating in all phases of the agile development cycle.

ESSENTIAL JOB DUTIES AND RESPONSIBILITIES:

"Success will be measured by the individual's ability to deliver and help others deliver well-architected data models at a steady pace of innovation. Co-design data models with DevOps and data warehouse product teams for OLTP, OLAP, and AI. Design, develop, test and publish logical/physical data models for Azure Cloud.

• Determine the impact of the Enterprise Data Model (EDM) and refine the EDM as needed as new applications or products are added.
• Research data sources for new business data and better sources of data feeds
• Participate in business requirement definition and review business requests for data and usage.
• Participate in application design reviews to ensure data model adherence and data standards.
• Ensure alignment with Data Governance practices.
• Work closely with the Architect(s) to ensure the EDM is integrated with development efforts.
• Ensure all data has a complete and accurate definition
• Establish and monitor data quality initiatives. "

Builds and Maintains Logical and Physical Data Model

• Develop, enhance, and maintain data warehouse and data mart logical & physical data models.
• Design conceptual and logical data models and data flows, ensuring data security and compliance with Financial and Banking industry regulations
• Work closely with the Data Base Architect (DBA) team to implement the physical data model.
• Analyze content and quality of data model(s) and databases. "

Participates in Agile Ceremonies/on Agile Team

• Participates by leading, listening, asking questions, and collaborating with the Agile team in Agile Ceremonies and discussions. Makes suggestions and presents ideas for team and process improvements. "

Communication

• Leads and facilitates collaboration among the team.
• Lead and facilitate data model review sessions
• Regularly collaborates with stakeholders to solve data-related business issues by gaining an understanding of business's requirements, providing technical knowledge and recommendations on how data products and processes could benefit their teams, and communicating project expectations and status updates.
• Work with Developers, Managers, and others to determine new data sources, technologies, and other ways the Data Warehouse can better serve customers' needs. "

ADDITIONAL DUTIES:

Coaching and Mentoring

• Regularly assists and guides junior data modelers or architects on day-to-day tasks. "

Best Practices

• Understands best practices and how to leverage/implement them. Identifies areas for implementing and improving best practices within products or processes. Guides and instructs others on the use of best practices. Aids in the proposal, planning, and creation of methods and procedures to enable best practices for secure coding and handling of data.
• Uses technologies essential to development activities, including source control software, development environments, deployment software, and integration applications. Supports and follows best practices for continuous integration and continuous delivery."

Security

• Assists with identifying and managing security risks within software products and data processes. May collaborate with Information Security team to identify, understand, and help resolve security risks within new and existing applications.
• Clearly communicates risks to technology team members and suggests appropriate course(s) of action to mitigate risks.
• Assists others in work aimed at mitigating risks and vulnerabilities within software applications.
• Ensure the data model is designed and implemented with the appropriate data security and privacy controls."

Documentation

• Creates and delivers documentation whenever necessary. Creates and maintains clear and accurate written documentation and procedures.
• Create mapping documents to document business logic rules to transform data before loading it into the target data warehouse.
• Guides and instructs team members and others on documentation needs, creation, maintenance, etc.