Job ID :
9947
Company :
DC Government
Location :
WASHINGTON, DC
Type :
Contract
Duration :
4/02/18 + possible extensions
Salary :
open
Status :
Active
Openings :
1
Posted :
06 Apr 2017
Job Seekers, Please send resumes to resumes@hireitpeople.com
Required Skills - Report Developer, SQL Server, Relational database, ETL, JSP, HTML, dashboard development.  

Job Description:

Client is seeking an experienced report developer to support our front end and SQL reporting activities. They will have primary responsibility for creating front end report applications using Jaspersoft and direct SQL queries reporting on K12 related data.

 

Position Description:  

 

Client is seeking an experienced report developer to support our front end and SQL reporting activities. They will have primary responsibility for creating front end report applications using Jaspersoft and direct SQL queries that report on K12 related data in a business-intelligent manner to internal clients. The report developer will also be reviewing and updating pre-existing report applications and SQL reports and underlying dataset queries while being thoughtful about report design to gather and present data in a business intelligent manner. In addition to designing to fill a particular set of requirements, they will also balance immediate needs with future direction and ensure that work for one project can be leveraged for other purposes as much as possible.  Additional areas of focus include initiatives to increase report automation, making data more easily available to allow for self-service end user data pulls, and the creation of infrastructure to consolidate data transfer between the main Student Information System and other systems of record (service oriented architecture, etc.),  In addition to technical skill they must have a strong sense of curiosity as a critical part of the role will be to help come up with the future long term vision for data systems in DCPS and plan out what should be built to implement that vision. 

 

Specific Duties:

 

1.         Work with Program Teams to develop an understanding of each department's role within the company and to understand their unique reporting requirements to assist in the development of reports.

2.         Responsible to lead projects to develop and deploy new reports and various visual representations including self-service reports using Veera, SSRS, Power BI, Excel, and other BI Tools to meet reporting needs.

3.         Deliver accurate and timely ad-hoc extracts that support different business requirements using complex ETL (Veera, SSIS etc.)

4.         Research, review, and analyze the effectiveness and efficiency of existing reports, and develop strategies for enhancing and improving the performance of these reports

5.         Support the migration of data feed platform from Oracle to MS SQL by contributing in technical specification documentation, ETL development and maintenance.

6.         Write code and procedures aligned with DCPS requirements

7.         Trouble shoots complex code, identify SQL performance bottlenecks and optimize SQL queries

8.         Adhere to coding standards and participate in peer code reviews

9.         Maintains clean and elegant code as well as ensures up to date code repository.

10.       Investigates new technologies and suggests new solutions to business problems

11.       Performs other related duties as assigned.

 

Required Skills and Experience

1.         Required: 8+ years of professional experience

2.         Required: 5+ years of experience as a dedicated Report Developer / Reporting Analyst

3.         Required: 5+ years of hands on experience in SQL Server, Relational Database, Extract Transform and Load (ETL).

4.         Required: 2+ years of experience writing, troubleshooting, and tuning Java Script Pages (JSP), HTML, and XML

5.         Required: 2+  years of experience with dashboard development using tool such as Tableau, Qlick, or preferably Power BI

6.         Required: 2+ years of experience developing from end report using tools such as jaspersoft, crystal reports, or other.

7.         Required: Keen sense of maximizing return on investment, focusing on the 80% solutions rather than a fruitless quest for perfection

8.         Required: Strong attention to detail and the ability to translate high level technical and business initiatives and goals into discrete tasks and specific timelines

9.         Required: Excellent communication skills, especially the ability to actively listen and draw out the true needs rather than the stated wants of any given stakeholder

10.       Required: Superb problem solving skills and troubleshooting abilities

11.       Required: Ability to work independently as well as collaboratively in a multidisciplinary team

12.       Required: Strong focus on teamwork and developing the skills of DCPS colleagues both technical and non-technical

13.       Nice to have: Experience in K12 Data models

14.       Nice to have: knowledge of HIPPA and FERPA

 

---------------------------------------------

CONTRACT JOB DESCRIPTION

 

Responsibilities:

1. Provides all activities related to the administration of computerized databases.

2. Projects long-range requirements for database administration and design in conjunction with other managers in the information systems function.

3. Designs, creates, and maintains databases in a client/server environment.

4. Conducts quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data.

5. Advises users on access to various client/server databases.

6. Designs, implements, and maintains complex databases with respect to Job Control Language (JCL), access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.

7. Applies knowledge and experience with database technologies, development methodologies, and front-end (e.g., Cognos)/back-end programming languages (e.g., Structured Query Language (SQL).  Performs database programming and supports systems design.

8. Includes maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design.

 

Minimum Education/Certification Requirements:

Bachelor’s degree in Information Technology or related field or equivalent experience