Data Modeler

Job Description: 

•   Experience in Data modeling, Data strategy, and Data architecture, developing linkages between systems and troubleshooting data flow processes.
•    Experience in identifying and maintaining structural solutions working with database administrators, system administrators, and developers to provide access to the data.
•    Demonstrate experience with creating/updating both tables and stored procedures using defined Configuration Management (CM) process through the development lifecycle.
•    Experience in using the defined CM process to take ad-hoc queries from a customer through to production.
•    Experience in creating Power BI reports based on data residing in SQL Server and Oracle databases.
•    Troubleshoot application issues from the application data used in the back-end to the final output seen by the user over multiple servers.
•    Experience reviewing and mitigating STIGs on the application servers.
•    Experience designing and creating data models that represent the structure of data within an organization.
•    Translate business rules and requirements into conceptual, logical, and physical data models that serve as blueprints for database design and ensure data consistency and integrity.
•    Collaboration with Data Architects, database administrators, and developers to ensure that the data models align with business needs and technical constraints.
•    Demonstrate a deep understanding of data relationships, normalization, and database design principles.
•    Determine impacts on the performance and scalability of applications.
•    Ability to translate complex data into useful information structures that can be easily understood and leveraged.
•    Design and implement data models to meet the organizational needs.
•    Collaborate with business analysts and stakeholders to gather and analyze requirements.
•    Ensure data integrity, stability, and security across databases.
•    Establish and enforce data modeling standards and best practices.
•    Create and maintain metadata management and data governance.
•    Optimize and tune data models for performance.
•    Support database administrators and engineers in ongoing database tasks.
•    Conduct data model reviews and provide feedback for improvement.
•    Document and communicate data models and their specifications.
•    Use data modeling tools and software for model creation and management.
•    Stay current with industry trends and emerging technologies to keep data models updated.
 

Required Skills and Experiences:

• In-depth experience of designing and implementing information solutions.
  •    Hands-on experience with implementing data and analytics management programs is preferred.
  •    Three (3) to five (5) years' experience as a data analyst is highly desirable.
  •    Effective conceptualization, pattern recognition and teaming skills.
  •    Business acumen, and the ability to communicate to executives, business domain stakeholders and technical staff alike.
  •    Demonstrated influence, communication, presentation and facilitation skills.
  •    Experience with innovation and ideation methods, such as design thinking.
  •    Business domain, data/content and process understanding.
  •    System integration experience, including interface design, and familiarity with web-oriented architecture techniques.
  •    Data modeling and information classification expertise at the enterprise level.
  •    Understanding of common information architecture frameworks and information models.
  •    Knowledge of Department of War (Dow) Enterprise Architecture artifacts a plus.
  •    Understanding of metamodels, taxonomies and ontologies, as well as of the challenges of applying structured techniques (data modeling) to less-structured sources.
  •    Familiarity with data science concepts, as well as Meta Data Management (MDM), business intelligence, and data warehouse design and implementation techniques.
  •    Experience with distributed management and analytics in cloud and hybrid environments.
  •    Also, an understanding of a variety of data access and analytics approaches (for example, microservices and event-based architectures).
  •    Knowledge of problem analysis, structured analysis and design, and programming techniques.
  •    Ability to assess rapidly changing technologies and apply them to business needs.
  •    Strong communication and persuasion skills, including the ability to create marketing and messaging materials that meet stakeholder needs.
  •    Ability to analyze project, program and portfolio needs, as well as determine the resources needed to achieve objectives and overcome cross-functional barriers a plus.
  •    In-depth understanding of solution, business, information and data a