Database Data Modeler (Some Telework Capability)

Riverside Research is an independent National Security Nonprofit dedicated to research and development in the national interest. With revenues of $125M+, and a staff of more than 630, Riverside Research provides high-end technical services, research and development, and prototype solutions to some of the country’s most challenging technical problems. Riverside Research also supports advanced technical education and collaborates widely with university researchers.

The company was formed from a respected research laboratory at Columbia University and has a current focus on technical areas including Radar systems, Optics and Photonics, Electromagnetics, Plasma physics, Geoint, Masint, Systems Engineering, and Modeling & Simulation.

Riverside Research’s open innovation R&D model encourages both internal and external collaboration to accelerate innovation, advance science, and expand market opportunities. In 2015, Riverside Research expanded its facility in Dayton, OH, adding a 30,000 square-foot Open Innovation Center (OIC). The OIC is a collaborative R&D environment that fosters creativity, synergy, and ultimately delivers innovative solutions to current and anticipated challenges. The OIC sets the standard for collaborative innovation and is dedicated to promoting research across the company. Riverside Research has additional research facilities in Boston, MA; New York, NY; Centreville, VA; and Champaign, IL.

Job Number: 727

*** We are offering a Sign-on bonus if hired ***

Riverside Research is seeking a Data Modeler to support the development of a Defense Intelligence Agency (DIA) transitional modernized database for foundational military intelligence (FMI). The Data Modeler will work as part of an integrated team consisting of ISR mission subject matter experts, database developers, data scientists, and application testers to create and implement a comprehensive, scalable, flexible, and rigorous artificial intelligence/machine learning (AI/ML)-ready analytic data environment. The Data Modeler will be responsible for creating conceptual, logical, and physical data models based upon data requirements captured thru iterative engagements with DIA and other intelligence community (IC) analysts. This position requires occasional travel to gain an understanding of customer challenges and the complex environment in which they operate.

All Riverside Research opportunities require U.S. Citizenship.

This position offers some Telework capability but must be able to go into either Dayton OH or Centreville VA office

Job Responsibilities:

• Works with Mission and MIDB production SMEs to analyze, discover, define and document current MIDB databases’ data structures organized around objects that relate to the infrastructure mission.
• Redesigns the data model using requirements and guidance provided by the Government and migrating the data into the new data models.
• Applies Artificial Intelligence (AI) and Machine Learning (ML models) to identify data values from disparate source systems that are null or incorrect. 
• Understand and translate business needs into data models supporting long-term solutions for relational and object-oriented databases.
• Work with database team to implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimize/update logical and physical data models to support the new requirements.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Create data cataloging capabilities
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments. Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies. Validate business data objects for accuracy and completeness.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Develop data models according to best practices.

Minimum Qualifications:

• TS/SCI Clearance required (ability to obtain CI Poly).
• Bachelors degree.
• 2-5 years of experience in data modeling principles/methods including conceptual, logical & physical Data Models.

Desired Qualifications:

• TS/SCI with CI Poly preferred.
• Prior experience with PostgreSQL
• Knowledge/experience with Data Modeler Tools such as Erwin, ER/Studio, or any native DB modeling tools SQL DB Diagrams, MySQL Workbench, etc.
• Knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio, or others).

Riverside Research strives to be one of America's premier providers of independent, trusted technical and scientific expertise. We continue to add experienced and technically astute staff who are highly motivated to help our DoD and Intelligence Community (IC) customers deliver world class programs. As a not-for-profit, technology-oriented defense company, we believe service to customers and support of our staff is our mission. Our goal is to serve as a destination company by providing an industry-leading, positive, and rewarding employee experience for all who join us. We aspire to be a valued partner to our customers and to earn their trust through our unwavering commitment to achieve timely, innovative, cost-effective and mission-focused solutions.

All positions at Riverside Research are subject to background investigations. Employment is contingent upon successful completion of a background investigation including criminal history and identity check.

Our EEO Policy
Riverside Research is an equal opportunity employer. We recruit, employ, train, compensate and promote without regard to race, religion, sex, color, national origin, age, gender identity, sexual orientation, marital status, disability/veteran, status as a protected veteran, or any other basis protected by applicable federal, state and local law.

If you need assistance at any time in our application or interview process, please contact Human Resources at 937-427-7074 or email HR@RiversideResearch.org. A member of the HR team will be available to assist.

This contractor and subcontractor shall abide by the requirements of 41 CFR 60-741.5(a). This regulation prohibits discrimination against qualified individuals on the basis of disability and requires affirmative action by covered prime contractors and subcontractors to employ and advance in employment qualified individuals with disabilities.

This contractor and subcontractor shall abide by the requirements of 41 CFR 60-300.5(a). This regulation prohibits discrimination against qualified protected veterans and requires affirmative action by covered contractors and subcontractors to employ and advance in employment qualified protected veterans.

For more information on "EEO is the Law," please visit:
http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf

https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/eeopost.pdf