Job Seekers, Please send resumes to resumes@hireitpeople.com

Short Description:

DCPS is seeking an experienced (3 to 7 years)database developer  write and maintaining ETL scripts as well as writing complex queries for reporting using Perl, Ruby etc.

Complete Description:

CPS is seeking an experienced database developer to support our Student Information System and reporting in general.  They will have primary responsibility for developing and maintaining ETL scripts as well as writing complex queries for reporting using raw SQL queries and scripting languages such as Perl, Ruby, etc.   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. 

Position Responsibilities:

•                Works with other programs and offices within DCPS to understand overall DCPS needs so as to implement strategic rather than tactical solutions

•                Write SQL code to implement complex queries for reporting

•                Create scripts and queries to enable data integration between various student data systems

•                Design ETL approach to pull data from systems of record into reporting systems

•                Creates user-friendly report formats and on-demand report interfaces for use by non-technical users

•                Investigates new technologies and suggests new solutions to business problems

•                Evaluate software to determine the level that it meets the needs of the business today and in the future (design, extendibility, flexibility, integration, utilizes generic business objects/components etc.).

•                Supports and carries out the Chancellor’s mission to transform DC Public Schools and close the achievement gap

•                Performs other related duties as assigned.

Professional/Educational Qualifications

•                Bachelor’s degree required

•                5 to 9 years experience in database development or database administration

•                Strong Experience with Oracle and/or MS SQL Server

•                Strong Experience with ETL approaches, concepts, and tools

•                Strong Experience with standard scripting languages (Shell, Perl, Ruby, etc)

Strong Candidate will have

•                Advanced degree is a plus.

•                Experience with data warehousing a plus

•                Exceptional facility with tuning SQL queries to optimize performance relative to application needs

•                Exceptional knowledge of standard database concepts (query optimization, database tuning, data modeling, etc)

•                Experience with application development languages and tools a plus (Java, node.js, etc)

•                Good experience with supporting tools and technologies including basic operating system tools (mainly Linux) and configuration options.

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

•                Strong self-starter and ability to work independently

•                Strong attention to detail and the ability to translate high level technical and business initiatives and goals into discrete tasks and specific timelines

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

•                Superb problem solving skills and troubleshooting abilities

•                Ability to work independently as well as collaboratively in a multidisciplinary team

•                Strong focus on teamwork and developing the skills of DCPS colleagues both technical and non-technical

Skills: