Data Modeler (Mid-level)

REI Systems’ mission is to deliver innovative technology solutions for Federal Clients. The foundation of our success is an unwavering determination to surpass our client’s expectations. We offer this same commitment to our employees by providing professional development, projects that are impactful and meaningful, and the flexibility to spend time with family and friends. We believe our employees are at their best when they are fulfilled in both their professional careers and their lives outside of work. Learn more at REIsystems.com.

Employees voted REI Systems a Washington Post Top Workplace in 2015, 2016, 2018, 2020, 2021 and 2022!

Have you ever wondered how the food you eat is deemed to be safe, or how pharmaceutical companies are inspected to ensure the drugs they produce meet FDA regulations? If so, we have a very large new program with the Food and Drug Administration (FDA) and would love to have you join us! If you are solution oriented and thrive in a fast paced, agile environment then come work for a company that was named a Washington Post Best Place to Work for 5 out of the last 6 years.

Responsibilities

REI Systems is seeking a talented data modeler to assist with analyzing, designing, and implementing information solutions. As a data modeler, you will be working closely with subject matter experts, business analysts, UX/UI designers, and DBAs, as well as data, business, and solution architects to capture business requirements in logical data models, to transform these models into physical data models, and to generate database scripts. To ensure success as a data modeler, you should have an in-depth knowledge of relational data modeling tools and methods, including 3NF, experience with forward and reverse engineering, and excellent verbal communication and writing skills, and very familiar with BPMN. You should be able to examine a business process and detail a logical data model diagram with the appropriate entities, attributes, and relationships. You should also be able to write rich, informative, grammatically correct definitions for all entities, tables, attributes, and columns. You work to reduce data redundancy, enhance data integrity, streamline data movements, and improve overall enterprise information management.

Analyze and translate business requirements into conceptual and fully detailed logical data models.

Create logical data models based on existing applications and databases.

Review the existing data models and update as needed.

Implement and Maintain data dictionary, data model across multiple interdependent systems.

Contribute to ongoing updates to data modeling standards and guidelines.

Work with business architects, data architect, data stewards to capture business requirements in a Logical Data Model.

Contribute to assessing the appropriate data platform(s) for solutioning efforts.

Evaluate implemented application databases for variances from standards.

Evaluate physical data models to ensure they align to the corresponding logical data models.

Works closely with other architects, DBAs, development teams, security, and operations staff, etc.

Works on either database or application-level development during the lean hours when not performing data modeling.

Works in an agile development environment to deliver models quickly not to impede development and reincorporate changes to model and help developers carry the changes to their program units in the build and release environment.

Qualifications

5+ years of experience with data modeling with Oracle database

Expert in data modeling experience (Conceptual, Logical, Physical/ERD) using proven techniques and modern tools (e.g., erwin Data Modeler and erwin Model Mart).

Excellent analytical and creative problem-solving skills.

Excellent verbal communication and writing skills.

5+ years of experience writing Queries, acquiring data from primary and secondary data sources, and maintaining databases.

5+ years of database development and troubleshooting skills and ability to work closely across multiple teams and vendors to ensure successful releases and enterprise scale data migration.

5+ years of experience designing, developing, and managing enterprise-level databases using Oracle.

Experience implementing large-scale solutions that empower business data and enterprise data integration using Oracle.

Education: Bachelor's degree in information systems, computer science, or other related field.

Clearance: FDA Public Trust clearance must be obtainable

Location: Hybrid - locals to DMV area highly preferred.

EEO Statement: REI Systems is an Equal Opportunity Employer (Minority/Female/Disability/Vet)

Covid Policy Disclosure: Should the essential functions of this position require that the employee performing this role work on-site at REI’s Sterling location the following requirements will apply: the individual holding this position must be fully vaccinated, as defined in CDC guidance, as a condition of continued employment. REI will consider requests to be excused from this policy whenever necessary to comply with legal requirements and will consider any requests for reasonable accommodations due to a disability, religion, or other exemptions on an individual basis in accordance with applicable legal requirements. Employees and applicants requesting accommodations should request the accommodation in writing and should explain in detail the reasons why they are seeking an accommodation. REI will request additional information or documentation it deems necessary to inform its decision on an employee’s or applicant’s accommodation request.

REI Systems is an Equal Opportunity Employer

#LI-HYBRID

#LI-TK1

Full-Time