Data Modeler Security Clearance

Position: Data Modeler with Security Clearance
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 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…