The Data Modeler works with the project team to define risks and tradeoffs related to different design choices and to help the organization make informed decisions about implementation options for new or rebuilt systems. The Data Modeler must be comfortable modeling data for relational, dimensional, and NoSQL databases; however, they may be focused on modeling in one more than the others depending on the project context. They should be proficient in data modeling and query analysis tools (e.g., Power Designer, DAX Studio, ERWin, ER/Studio, etc.) and SQL. Minimum of three (3) years of relevant experience in data modeling, and Bachelor’s degree.

Responsibilities:

1. Design and implement data modeling solutions using relational, dimensional, and NoSQL databases based on need.

2. Work closely with Project Data Architect to design databases or data warehouses using a mixture of conceptual, physical, and logical data models.

3. Prepare models that can improve the interoperability of data among the project related systems and improve the performance of underlying data queries and data movement that feed applications.

4. Work with subject matter experts across programs, divisions, policy areas, and levels of knowledge.

5. Lead working groups and stakeholder meetings for data specifications and know the appropriate level of specificity to model at different stages of a project from conceptual to logical to physical.

6. Perform research with technical staff and data users to determine the ideal interfaces for implementation of future technical systems.

7. Conduct the evaluation of existing project data systems, including constructing as-is data models (where they are not already documented) and identifying foundational data model issues that could affect the efficient and effective use of data (e.g., slow queries, poorly validated data, unnecessary duplication of data, etc.)

8. Conduct hands-on troubleshooting to optimize data system query performance where appropriate.

Required Experience and Education:

• Minimum of three (3) years of relevant experience in data modeling.

• Bachelor’s or advanced degree (master's or PhD) in computer science, engineering, math or related field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.

Basic Qualifications:

• U.S. Citizenship Required

Red River offers a competitive salary, excellent benefits and an exceptional work environment. You can review our benefit offerings here (https://redriver.com/wp-content/uploads/2022/01/Benefits-At-A-Glance-2022.pdf) . If you are ready to join a growing company, please submit your resume and cover letter (optional).

EOE M/F/DISABLED/Vet

Red River is an equal opportunity employer and makes employment decisions based on business needs, job requirements and individual qualifications, without regard to race, color, religion, national origin, sex (including pregnancy), sexual orientation, gender identity or expression, marital status, age, family medical history or genetic information, disability, past or present military service, or any other characteristics protected under the laws applicable in the locations where Red River operates. Red River will not tolerate discrimination or harassment based on any of these characteristics.

Red River does not accept unsolicited resumes from individual recruiters or third party recruiting agencies in response to job postings or otherwise. Placement fees will not be paid to any recruiter unless Red River has an active agreement in place with the recruiter and such a request has been made by the Red River Talent Acquisition team and such candidate was submitted to the Red River Talent Acquisition Team via our Applicant Tracking System. Any unsolicited resumes or other data submitted to Red River in violation of this policy may be used by Red River without obligation to pay any fees of any kind to the recruiter.

Red River brings together the ideal combination of talent, partners and products to disrupt the status quo in technology and drive success for business and government. Red River serves organizations well beyond traditional technology integration, with more than 20 years experience in security, networking, analytics, collaboration, mobility and cloud solutions. Our operations, support, sales and technical teams all work together to create a positive impact on citizens, soldiers, consumers and employees. That’s what it means to Rock the Red. Are you ready?

• We work with purpose, looking to disrupt the status quo in meaningful ways.

• We act with integrity, showing respect for all and demonstrating our commitment to ethics

• We value collaboration and work as a team to accomplish goals

• We elevate creativity, and support curiosity to re-imagine the use of technology

• We have a strong work ethic, and seek continuous improvement in all we do

• We embrace philanthropy, working together to drive positive change and lasting impact within communities around us

Please see the linked document below for our consumer privacy notice. The notice provides you with information about what Red River Technology LLC and its affiliates (collectively referred to as “Company”, “we”, “our” or “us”) may collect about you, how this information may be used by Company, your privacy rights and the Company’s obligations in accordance with California Consumer Privacy Act of 2018 ("CCPA") and the California Privacy Rights Act of 2020 ("CPRA").

https://redriver.com/wp-content/uploads/2023/08/CPRA-Notice-to-Employees-updated30.pdf

https://www.dol.gov/agencies/ofccp/posters