Complete Description:
Gather and understand business rules and functional and technical requirements, analyze data, develop and deploy complex scheduled and ad hoc reports delivering business intelligence, and create project documentation for District agency related projects.
MAJOR DUTIES
Interfaces independently with high level stakeholders via meetings, emails, and phone calls to manage data projects, gather and document requirements; and to gather sample data throughout all phases of the project to ensure data quality.
- Works with District agency resources to analyze, compile, verify, and query data across multiple operating systems
- Creates metadata, network diagrams and data dictionaries as required.
- Evaluates program-specific data sets to identify duplicative data elements and to design a normalized data structure for a unified system for DDOE programs.
- Designs and implements reports using SQL as well as a variety of reporting and business intelligence tools.
- Coordinates all activities with the project manager throughout the full software development life cycle (SDLC), to include design, development, and testing.
- Works with minimal oversight as a technical lead on data-driven reporting and applications development projects.
- Performs other related duties as assigned.
KNOWLEDGE REQUIRED FOR THE POSITION
The selected candidate will have a minimum of five years of professional IT experience working as a senior-level data analyst.
The selected candidate will have strong requirements analysis, and data analysis skills. Extensive experience working with relational database technologies is also required.
Perform complex data analyses including experience validating data and identifying and correcting data inconsistencies and errors.
The selected candidate will have senior-level experience working through the full software development life cycle (SDLC), as well as, managing small IT projects with minimal oversight.
The selected candidate will have extensive experience creating metadata/data dictionaries, and designing and implementing reports, and creating database views used for the purposes of establishing live data feeds as well as the development of data-driven dashboard applications.
The selected candidate will have knowledge of data warehousing concepts and extensive experience working with data architects in the design of database schemas.
Must have experience interacting with high level stakeholders.
The selected candidate will have excellent verbal and written communication skills with the ability to create presentations and technical documentation geared toward the perspective audience.
Experience in the field of environmental affairs is a plus.
Behavior Characteristics:
Strong written and verbal communication. Ability to tailor communication to the appropriate audience, adapt through a complex and changing environment and work in groups and independently. Attention to detail and effective time management.
Skills:
Skill
Required / Desired
Amount
of Experience
Expertise Rating
Strong requirements analysis and data analysis skills
Required
5
Years
3 - Expert
Extensive experience working with relational database technologies
Required
5
Years
3 - Expert
Perform complex data analyses including experience validating data
Required
5
Years
3 - Expert
Experience identifying and correcting data inconsistencies and errors
Required
5
Years
3 - Expert
Have senior-level experience working through the full software development life cycle (SDLC)
Required
5
Years
3 - Expert
Experience managing small IT projects with minimal oversight
Required
5
Years
3 - Expert
Extensive experience creating metadata/data dictionaries
Required
5
Years
3 - Expert
Experience designing and implementing reports
Required
5
Years
3 - Expert
Experience creating database views used for the purposes of establishing live data feeds
Required
5
Years
3 - Expert
Experience developing of data-driven dashboard applications
Required
5
Years
3 - Expert
Knowledge of data warehousing concepts
Required
5
Years
3 - Expert
Extensive experience working with data architects in the design of database schemas
Required
5
Years
3 - Expert
Experience interacting with high level stakeholders
Required
5
Years
3 - Expert
Have excellent verbal and written communication skills
Required
5
Years
3 - Expert
The ability to create presentations and technical documentation geared toward the perspective audience
Required
5
Years
3 - Expert
Experience in the field of environmental affairs
Nice to have
5
Years
1 - Basic
Analyze, compile, verify, and query data across multiple data sources and applications
Required
5
Years
3 - Expert
Creates metadata, network diagrams and data dictionaries
Required
5
Years
3 - Expert
Evaluate program-specific data sets to identify duplicative data elements and to design a normalized data structure for a unified system
Required
5
Years
3 - Expert
Analyze existing reports and queries, designs and implements reports using SQL as well as a variety of reporting and business intelligence tools
Required
5
Years
3 - Expert
Works with minimal oversight as a technical lead on data-driven reporting and applications development projects
Required
5
Years
3 - Expert
Candidate must provide examples of original network diagrams, technical and project documents as part of the interview.
--