drjobs IT Data Analyst - In Person (Sacramento, CA)

IT Data Analyst - In Person (Sacramento, CA)

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Sacramento, CA - USA

Monthly Salary drjobs

$ 30 - 41

Vacancy

1 Vacancy

Job Description

*$1000 Hiring Bonus*

Stanford Sierra Youth & Families Administrative Office is located in Sacramento County.

This position requires daily in-person attendance in our Sacramento office.

QUALIFICATIONS

Education & Experience

  • Minimum of High School diploma or IT data certification plus three (3) years IT experience required including collecting processing and analyzing data
  • Associates degree in data sciences or related field plus two (2) years IT experience required including collecting processing and analyzing data
  • Bachelors degree in data sciences or related field plus one (1) year IT experience required including collecting processing and analyzing data
  • Demonstrated knowledge and experience of database system design concepts and best practices
  • Demonstrated progressive work experience in data management systems
  • Demonstrated successful project management experience
  • Familiarity or experience with the workings of a nonprofit organization and communications programs preferable
  • Experience and proficiency in data warehouse administration
  • Knowledge and experience with Extract Transform and Load (ETL) Tools
  • Knowledge and experience with Data Visualization software such as Tableau or Power BI
  • Experience and knowledge of setting and administering security within a data warehouse

ESSENTIAL JOB FUNCTIONS

Position Specific

Data Infrastructure Architecture

  • Support the front-end design and future-state data management framework based on the organizations needs.
  • Support the definition of data standards governance principles metadata structure and quality controls.
  • Help translate business and compliance requirements into scalable data architecture specifications.

Data Migration Strategy & Diagramming

  • Create comprehensive data migration diagrams to definewhatdata should be movedhowit will be transferred andwhere it will reside.
  • Aide in data mapping transformation logic retention parameters (e.g. length/age of data) and interface specifications in collaboration with business users and technical teams.
  • Help establish protocols for data movement and lineage across systems.

ETL Engineering (Functional Oversight)

  • Define build and optimize ETL pipelines to extract transform and load large volumes of structured and unstructured data from multiple systems (e.g. EHRs CRMs social care platforms).
  • Manage API-based data exchanges and automated workflows that support interoperability.
  • Collaborate with software vendors and internal teams to ensure secure and compliant data transfer.

Data Modeling & Warehouse Architecture

  • Initiate conceptual and logical data model design under the direction of the Data Infrastructure Architect.
  • Ensure that data structures support organizational analytics reporting and operational use cases.
  • Design construct and oversee data warehouse architecture including multidimensional models and relational databases.
  • Define and enforce standards for query optimization access control and data security.

General

  • Provide ongoing support and training to staff fostering partnership between Information Technology and all other aspects of the organization
  • Serve as lead point of contact for data warehouse/ETL/Data visualization systems and takes charge of all aspects of project management.
  • Takes lead on all augmentation/cleanup of existing data sources and ensures data is fresh current and as enhanced as possible to ensure the most effective use of all the information available.
  • Appropriately manage and prioritize special projects/requests from agency leaders
  • Provides support for other tasks as assigned.

Agency Specific

  • Performs all duties in a manner consistent with the principles and values of agency while adhering to applicable professional codes of ethics the agencys policies and procedures contractor requirements and regulatory requirements.
  • Model and communicate appropriate positive attitudes toward the agencys Mission Vision and Values
  • Work collaboratively with all agency programs and staff to provide support as needed
  • Utilize and maintain calendar with all work-related details in order to manage time effectively and share calendar information with coworkers
  • Participate in on-going training to expand and develop professional skills
  • Perform other duties as necessary for the agency as assigned

    Employment At-Will
    Employment at the Agency is terminable at-will which means that employment may be
    terminated at any time without cause or reason by either the employee or the
    addition the Agency may also demote layoff transfer or reassign employees at any time at its
    sole discretion without cause or reason.

    Check out our Diversity Equity & Inclusion Statement

    Salary Range: $30.00 - $41.35 DOE


    Required Experience:

    IC

    Employment Type

    Full-Time

    Report This Job
    Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.