Job Details

ID #16317504
State California
City Sacramentoremoteworkifnotlocal
Job type Permanent
Salary USD $54178.00 - $54178.00 per annum 54178.00 - 54178.00 per annum
Source Experis
Showed 2021-07-04
Date 2021-07-04
Deadline 2021-09-02
Category Et cetera
Create resume

Data Analyst

California, Sacramentoremoteworkifnotlocal, 95811 Sacramentoremoteworkifnotlocal USA

Vacancy expired!

The Data Analyst will prepare, structure, and build complex databases, data collection systems, and data analytics. The analyst will also filter and clean data by reviewing data element dictionaries and apply industry best practices and domain expertise on big data sets. 1) Develop specifications, design, and implementation of database queries, scripts, views, tables, and structures; provide database monitoring, performance tuning, troubleshooting, query development, replications, data mining, and data warehousing. 2. Support and participate in determining data elements and structures that need to be accessed and extracted, moved and loaded, validated and cleaned, and standardized and transformed; use data integration tools to support all these processes, and make it possible to execute the rules created in the design phase of data warehousing. 3. Analyze, modify, enhance, test, and debug existing database structures, systems, and programs to meet user needs and/or system design changes; analyze problems and make modifications to systems and individual programs; preserve the performance and integrity of data. 4. Oversee and participate in the design, implementation, configuration, upgrading, testing, troubleshooting, tuning, and maintenance of the data and systems architecture for the data warehouse and system integration tools, including the development of: (a) logical and physical data models, (b) ETL scripts, (c) metadata definitions and models, queries, and reports, and (d) operations activities. 5. Promote teamwork by sharing knowledge, providing cross-training for other employees, cooperating with others, participating in meetings and work groups, and supporting the goals and objectives of the organization. 6. Develop, maintain, and enforce database procedures, standards, and security practices to safeguard information against accidental or unauthorized damage, modification, or disclosure of data. 7. Define database items, structures, and relationships, including redundancy; develop, maintain, and provide specific documentation including data standards, policies, procedures, designs, and definitions for the data dictionary (metadata). 8. Disaggregate test data using quantitative methods, including statistical analysis and interpretation. 9. Maintain a database to ensure that data can be retrieved and appropriately used in the future through documentation and archiving. 10. Administer the collection of data, compile and verify data for the production of regular and/or special statistical reports from various sources. 11. Prepare reports and makes presentations as needed to various audiences. Knowledge, Skills, Abilities, and Qualifications 1. Ability to appropriately select and use data analysis tools and techniques. 2. Ability to interpret performance data delivered in raw, converted, and chart form. 3. Ability to convert performance data into useable information for various audiences. 4. Ability to work with changing priorities, regulations, and deadlines; to manage multiple tasks while meeting critical deadlines; and to handle confidential matters. 5. Exceptional organizational skills and ability to multi-task. 6. Flexibility and ability to adapt to changing landscape and duties. 7. Experience writing grant proposals and reports. 8. A commitment to improving public education. Education and Experience Requirements 1. Any combination equivalent to: Bachelor's degree in information systems, computer science, or a related field, and three years of experience as a data analyst. 2. Experience with Microsoft SQL Server and database performance tuning and capacity planning.

Vacancy expired!

Subscribe Report job