Job Seekers, Please send resumes to resumes@hireitpeople.com
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.
