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 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.

• 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 meta models, 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…