Data Analyst Iii - Fairfax, United States - Fairfax County Government

Mark Lane

Posted by:

Mark Lane

beBee recruiter


Description

Salary
- $83, $139,409.71 Annually
Location

  • FAIRFAX (EJ26), VA
    Job Type
  • FT Salary W BN
    Job Number

Department

  • Park Authority
    Opening Date
  • 05/23/2024
    Closing Date
  • 5/28/2024 11:59 PM Eastern
    Pay Grade
  • S29
    Posting Type
  • Transfer
    Job Announcement:

Illustrative Duties:

(The illustrative duties listed in this specification are representative of the class but are not an all-inclusive list. A complete list of position duties and unique physical requirements can be found in the position job description.)

  • Mentors the work of lowerlevel data analysis, providing work counseling, guidance, and training as needed;
  • Develops data standards, analytic schemas, and complex data models to ensure complete, correct, accessible and shareable data for information technology development projects;
  • Gathers and documents business data, information, physical, and analytics requirements;
  • Develops logical business models;
  • Prepares physical database design and consolidation, standardization, cleansing, migration, or upload of data;
  • Assists with planning and facilitating user requirement sessions for data analysis, data standardization, and data ownership;
  • Analyzes business forms, reports, processes, practices, and procedures;
  • Develops structured diagrams, including data flow, entity life cycle, hierarchy,
- entity/relationships, conceptual schemas, and association matrix diagrams;

  • Assesses disparate databases for streamlining, standardization, and consolidation opportunities, designing appropriate schemas to enable modernization or optimization;
  • Assists with identifying physical implementation requirements such as denormalization, data types, defaults, keys, transformations, referential integrity, and screen/script mapping;
  • Assists with coordinating the development of shared information assets including logical data standards, definition standards, domain, and type standards, and with the resolution of related conflicts;
  • Provides key input to the development of the corporate information architecture,
- policies, and methodologies;

  • Maintains metadata, schemas, data repositories, and data dictionaries;
  • Assists with the selection, implementation, guidance and training of data administration practices, data access and CASE tools;
  • Designs and runs database queries to assess or validate data;
  • Performs data cleansing and transformations to assess data quality;
  • Supports data testing and analysis for initiatives of high complexity;
  • Attends training workshops, product demonstrations, conferences, technical briefings, and conventions;
  • Serves on committees and task forces;
  • Undertakes special projects;
  • Stays abreast of technology changes;
  • Provides assistance to other staff, as needed.

Required Knowledge Skills and Abilities:

- (The knowledge, skills and abilities listed in this specification are representative of the class but are not an all-inclusive list.)_

  • Considerable knowledge of information systems and the components that process data; Considerable knowledge of the principles, practices, and methods related to information architecture;
  • Considerable knowledge of data administration areas such as policies and standards, data definition, modeling and logical design, database design, and quality control; Considerable knowledge of data concepts such as syntax, taxonomy, and hierarchy; Considerable knowledge of relational databases (such as Oracle or DB2) Knowledge of business intelligence solutions or datarelated CASE and modeling tools;
  • Knowledge of data modeling mapping, cleansing, extraction, exchange, manipulation, and load principles;
  • Extensive knowledge of business process analysis and redesign;
  • Some knowledge of business intelligence and information system design principles;
  • Skill in brainstorming, presenting, sharing, discussing, and defending ideas;
  • Skill in problemsolving, with appreciation and respect for diversity of differing professional views;
  • Skill in leading meeting participants toward consensus;
  • Skill in designing and presenting conforming, efficient, and unambiguous models and diagrams of complex reporting and information systems;
  • Ability to help stakeholders effectively resolve issues related to crossagency data sharing, usage conflicts, and data inconsistencies;
  • Ability to follow special formatting requirements and conventions in work products;
  • Ability to establish and maintain appropriate version control over work products; Ability to communicate effectively, both orally and in writing;
  • Ability to make use of provided resources and seek guidance as needed;
  • Ability to analyze and evaluate administrative processes and procedures for data analysis purposes;
  • Ability to conduct research into new information technology;
  • Ability to prepare essential task deliverable and documentation;
  • Ability to translate technical terminology into simple language and concepts;
  • Ability to train empl

More jobs from Fairfax County Government