Business Analytics Supervisor (Data Analyst III)

Job Announcement

Join the Park Authority and our nationally recognized team of professionals! The Fairfax County Park Authority (FCPA) is seeking a Business Analytics Supervisor to be a part of one of the most highly regarded park systems in the country. With more than 25,000 acres of parkland, nine RECenters, eight golf courses, three lakefront parks, and more, FCPA is an exciting organization to be a part of and there are many opportunities for staff to make a difference at every level.

Under the direction of the Business Office Branch Manager, plans and directs significant data projects undertaken by the agency, including development of various agency databases and data models. Provides guidance for development of data-oriented projects and implements approaches to accomplishing data analytics across the agency. Manages a coordinated data management strategy and develops data standards. Conducts regular and ongoing research on data products, systems, and available technology. Designs data schemas and develops complex data models and databases. Manages agency-wide analytics and provides guidance for business applications. Acts as main agency contact on data analytics, business intelligence, and performance measures. Directs the work of staff on analytics, research, data modeling, and performance measures. Use of county or personal vehicle to attend scheduled and last-minute county and agency wide business meetings. 

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 description.) 
 

• Mentors the work of lower-level 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;
• Designs reporting schemas and data models of moderate to advanced scope and complexity Identifies and documents data subject areas, data entities, attributes, relationships, information types, domains, and constraints;
• 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 data-related 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;
• Some knowledge of services-oriented architecture, object-oriented application development, data integration, data exchange protocols, or XML schema design;
• Skill in brainstorming, presenting, sharing, discussing, and defending ideas;
• Skill in problem-solving, 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;
• Skill in applying work and ideas to advance enterprise architecture goals and objectives: Ability to establish and maintain effective business relationships;
• Ability to help stakeholders effectively resolve issues related to cross-agency 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 employees in the use of data access tools.

Employment Standards

MINIMUM QUALIFICATIONS: 
Any combination of education, experience, and training equivalent to the following:
(Click on the aforementioned link to learn how Fairfax County interprets equivalencies for “Any combination, experience, and training equivalent to”)
Graduation from an accredited four-year college or university with a degree in Information Technology, Information Systems, Computer Science, Business Administration, or related field and coursework in analytics, biosystematics, biology, information  architecture, engineering, library science, statistics, sociology, demographics, and/or marketing, Plus five years analysis of data and information experience in an academic, data administration, or business data analytics environment that involves using data modeling, database consolidation, ad hoc query, or business intelligence tools, relational databases, metadata, XML schema design, and/or taxonomy.

PREFERRED QUALIFICATIONS:

• Strong analytical skills with the ability to collect, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Knowledge of statistics and experience analyzing large datasets.
• Experience working with various business intelligence software and reporting tools, including Microsoft Power BI and Tableau.
• Experience creating and developing solutions for GIS systems to include data and applications
• Experience creating data models, knowledge of data transformation and data management – both spatial and non-spatial.
• Experience conducting business and financial analysis and creating performance measures.
• Experience presenting complex information to a variety of audiences.

CERTIFICATES AND LICENSES REQUIRED:
Driver's license (required)

NECESSARY SPECIAL REQUIREMENTS:
The appointee to the position will be required to complete a criminal background check and driving record check to the satisfaction of the employer.

PHYSICAL REQUIREMENTS:
Sedentary with walking and lifting less than 5 pounds. All duties performed with or without reasonable accommodations.

SELECTION PROCEDURE:
Panel interview and may include exercise.

The population of Fairfax County is very diverse where 38.7% of residents speak a language other than English at home (Spanish, Asian/Pacific Islander, Indo-European, and others) and we encourage candidates bilingual in English and a foreign language to apply to this opportunity.

Fairfax County Government prohibits discrimination on the basis of race, color, religion, national origin, sex, pregnancy, childbirth or related medical conditions, age, marital status, disability, sexual orientation, gender identity, genetics, political affiliation, or military status in the recruitment, selection, and hiring of its workforce.
 
Reasonable accommodations are available to persons with disabilities during application and/or interview processes per the Americans with Disabilities Act. Contact 703-324-4900 for assistance. TTY 703-222-7314.DHREmployment@fairfaxcounty.govEEO/AA/TTY.