Data Modeler
ORBIS INC.
Quantico, United States of America
19 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
IntermediateJob location
Quantico, United States of America
Tech stack
Server Applications
Cloud Computing
Configuration Management
Information Systems
Databases
Data Architecture
Data Governance
Data Integrity
Data Security
Data Warehousing
Database Design
Design of User Interfaces
Meta-Data Management
Microsoft SQL Server
Oracle
Pattern Recognition
Power BI
Application Data
SQL Stored Procedures
Data Streaming
Systems Integration
Data Classification
Data Strategy
Information Technology
Data Analytics
Physical Data Models
Microservices
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.
Requirements
- 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.
Benefits & conditions
ORBIS offers an excellent benefits package and a competitive salary in a professional atmosphere.