Data Modeler

International Executive Service Corps; Virginia (MN); On-site; USD 80,000 - 120,000; Full time

Job summary

International Executive Service Corps in Virginia is seeking an experienced data analyst with strong expertise in data modeling and architecture. The ideal candidate will possess in-depth knowledge of data management and analytics, having at least ten years of IT experience, including five years in information system design.

This role requires working alongside Data Architects and stakeholders, ensuring data integrity and implementing best practices. A Bachelor's degree in computer science or a related field is essential. TS/SCI clearance eligibility is required.

Qualifications

• In-depth experience of designing and implementing information solutions.
• Three to five years' experience as a data analyst is highly desirable.
• Experience with innovation and ideation methods.

Responsibilities

• Design and implement data models to meet organizational needs.
• Collaborate with business analysts and stakeholders to gather requirements.
• Ensure data integrity, stability, and security across databases.

Skills

Data modeling

Data strategy

Data architecture

Power BI

SQL Server

Oracle

Communication skills

Business acumen

Education

Bachelor's degree in computer science or related field

10+ years of experience in IT

Tools

Data modeling tools

Cloud managed services

Job description

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.

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.