What are the responsibilities and job description for the Data Modeler with Security Clearance position at ORBIS Inc?
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. - Must be a U.S. citizen. 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.