- Design and implement data modeling solutions using relational, dimensional, and NoSQL databases based on need.
- Work closely with Project Data Architect to design databases or data warehouses using a mixture of conceptual, physical, and logical data models.
- 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.
- Work with subject matter experts across programs, divisions, policy areas, and levels of knowledge.
- 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.
- Perform research with technical staff and data users to determine the ideal interfaces for implementation of future technical systems.
- 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.)
- Conduct hands-on troubleshooting to optimize data system query performance where appropriate.
- 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.
- U.S. Citizenship Required
- 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
-
Data Modeler
3 weeks ago
RIT Solutions, Inc. Sacramento, United StatesWe are seeking a Data Modeler for a 3-year Hybrid assignment. · This position requires that you be able to work on-site in Sacramento, California. · Key Duties/Responsibilities: · • Develops physical data model and/or works with architect to develop physical data model. · • Devel ...
-
Data Modeler
1 week ago
eStaffLLC Sacramento, United StatesDetails: · We are seeking a Data Modeler for a 3 year Hybrid assignment with our Sacramento, California based client. This position requires that you be able to work on-site in Sacramento, California. · Key Duties/Responsibilities: · Performs business and systems analysis and ...
-
Information Technology Specialist Ii
1 week ago
Public Employees Retirement System Sacramento County, CA, United States**Anticipated Interview Dates**:Virtual interviews are anticipated to be held between May 20th and May 31st, 2024. · **Telework Information**:This position is eligible for hybrid work schedule, with up to two days of remote work and three days or more onsite, per week. · Are you ...
-
Junior Specialist
2 weeks ago
University of California, Davis Sacramento, United StatesPOSITION OVERVIEW · **Salary range**: A reasonable estimate for this position is $51,300/yr or $24.57/hr at Step 1 or $54,600/yr or $26.15/hr at Step 2 · APPLICATION WINDOW · *** · **Open date**:May 8, 2024 · **Next review date**: Thursday, May 23, 2024 at 11:59pm (Pacific Time) ...
-
Monitoring and Data Coordinator
4 days ago
International Rescue Committee Sacramento, United StatesThe International Rescue Committee (IRC) responds to the world's worst humanitarian crises, helping to restore health, safety, education, economic wellbeing, and power to people devastated by conflict and disaster. Founded in 1933 at the call of Albert Einstein, the IRC is one of ...
-
Hydrogeologist
1 week ago
Montgomery & Associates Sacramento, United StatesMontgomery & Associates (M&A) is seeking a **full-time** **hydrogeologist **to join our California Team. The position includes mid-level responsibilities and requires the ability to manage and provide technical support to multiple tasks and/or projects simultaneously. The person ...
-
Data Governance Consultant
4 days ago
DiLytics Inc West Sacramento, United StatesDiLytics offers best-in-class team and cutting-edge analytics expertise with industry-leading data analytics tools to help you capture, organize and analyze your enterprise data for accurate, faster and more informed decision making. · DiLytics is looking for **Data Governance Co ...
-
Data Governance Architect
1 week ago
DiLytics Inc West Sacramento, United StatesDiLytics offers best-in-class team and cutting-edge analytics expertise with industry-leading data analytics tools to help you capture, organize and analyze your enterprise data for accurate, faster and more informed decision making. · DiLytics is looking for **Data Governance Ar ...
-
Staff Operations Specialist,
1 week ago
Franchise Tax Board Sacramento County, CA, United StatesUnder the general direction of the Administrator II in the Filing Enforcement Section, the Staff Operations Specialist on the Filing Enforcement (FE) Systems Analysis and Support (SAS) team works to promote filing compliance of taxpayers and the success of the FE program. The FE ...
-
Obiee Environment
6 days ago
Elegant Enterprise Wide Solutions, Inc West Sacramento, United States**Qualifications**1. At least three (3) years of experience in some or all areas of Pension, Health Insurance, Customer Service, or Finance2. At least four (4) years of experience performing tasks pertaining to OracleBusiness Intelligence Enterprise Edition Functional/System Admi ...
-
Data Visualization and Dashboard Developer
6 days ago
Elegant Enterprise Wide Solutions, Inc West Sacramento, United States**Qualifications**1. At least three (3) years of experience in some or all areas of Pension, Health Insurance, Customer Service, or Finance · 2. At least four (4) years of experience performing tasks pertaining to Oracle Business Intelligence Enterprise Edition Functional/System ...
-
Fleet Electrification Project Manager
5 days ago
Frontier Energy Sacramento, United Statesand fuel cell-electric vehicles. Our clients operate medium · - and heavy-duty vehicles and need realistic and thoughtful help to plan for and implement infrastructure, ZEVs, policies, and processes. · This is a hybrid position that can work close to either our Sacramento, CA or ...
-
California Department of Housing and Community Development Sacramento, United States**Job Duties** · Under direction of the Staff Services Manager I, the Associate Governmental Program Analyst (AGPA) will perform varied and complex technical analytical assignments during the development and implementation of enterprise-wide organizational efforts to improve busi ...
-
Report Writer with PowerBI and T-SQL
1 week ago
Prelude Systems, Inc. Sacramento, United StatesMinimum Job-Specific Skills/Qualifications · - Collaborate with cross-functional teams to gather business requirements. · - Develop Power BI solutions that address stakeholders' needs. · - Design and create intuitive dashboards, reports, and visualizations to present complex data ...
-
Scientific Aid
1 week ago
Department of Pesticide Regulation Sacramento County, CA, United StatesAs a member of the Air Program in the Environmental Monitoring Branch, the Scientific Aid perform a variety of duties related to the DPR's environmental projects that primarily involve pesticides in air, but may also include soil, surface water and groundwater. · Under general su ...
-
Manager, Data
1 week ago
Sutter Health Sacramento, United States**Organization**: · SHSO-Sutter Health System Office-Valley · **Position Overview**: · This position is available to work from home and also onsite. · - Extensive knowledge and experience with Epic analytics tools highly desired. · **EDUCATION**: · - Equivalent experience will be ...
-
Student Assistant
6 days ago
University Enterprises, Inc. Sacramento, United StatesThe Governor's Office of Emergency Services (OES) is seeking to hire one student to actively contribute to the creation and enhancement of innovative solutions. Under the guidance of the Enterprise Solutions Services team, this role involves close collaboration with multidiscipli ...
-
Information Technology Specialist Ii
2 weeks ago
Department of Transportation Sacramento County, CA, United StatesThe Department of Transportation (Caltrans) Information Technology (IT) Program - one of the largest IT programs within the State of California - is seeking a motivated and positive Information Technology Specialist II functioning as a Senior Oracle Data Warehouse Specialist with ...
-
Healthcare Coordinator
1 week ago
Pacific Dental Services Sacramento, United States: · Overview: · The primary role of the Healthcare Coordinator (HC) is to partner with supported Dentists to help gain a financial commitment from the patient to start the best course of treatment with urgency. Key responsibilities include understanding and utilizing financial op ...
-
Information Technology Specialist Iii
2 weeks ago
Franchise Tax Board Sacramento County, CA, United StatesUnder the general direction of the Intake and Enterprise Applications Analysis Services Assistant Bureau Director, the IT Specialist III serves as a data specialist with a focus on maintaining the architectural integrity of enterprise data ensuring the stability and availability ...
Data Modeler - Sacramento, United States - Red River
Description
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:
Required Experience and Education:
Basic Qualifications:
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.
_Don't see a job you want to apply for? Click '
Get Started
' below to send us your resume so we can reach out for future openings
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?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").
om/wp-content/uploads/2023/08/CPRA-Notice-to-Employees-