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 architectures.
  • Ability to learn and absorb new concepts quickly (in business and in systems), apply new knowledge as appropriate, and mentor others.
  • Experience with a variety of data model tools.
  • Experience of Cloud managed service offering will be preferred.
  • Prior experience with Department of War (DoW) or Department of Navy (DON) a plus.
  • Specific Federal Law enforcement (LE) information domain knowledge or previous experience working in LE organizations a plus.
  • This position requires the person(s) to be eligible and adjudicated to TS/SCI clearance level at contract start.
  

Degree Requirements:

• Bachelor's degree in computer science, information systems or a related study (Or equivalent project-related experience). A minimum of ten (10) years of experience in IT, with at least five (5) years in information system design.