What are the responsibilities and job description for the Senior Programmer Analyst position at City of New York?
Company Description
Job Description
The NYC Department of Sanitation (DSNY) is the world's largest sanitation department, collecting residential and institutional garbage and recyclables daily and clearing litter, snow, and ice from miles of streets.
OMD - Business Intelligence and Analytics is the primary Business Intelligence and Analytics unit for the Department of Sanitation (DSNY). We are a small, independent team tasked with delivering timely analyses of critical operations and with developing software that increases the long-term analytical capabilities of the Department. Our current projects include :
- Developing agency wide data warehouse and very complex data integration solutions
- Applications to support the real-time tracking of DSNY snow operations
- Application development for internal stake holders
- Produce and Deliver agency wide operational reports to internal and external stakeholders
We do as much as we can with open-source, in-house development in Python, Pentaho Kettle, JavaScript, but we also use off-the-shelf Informatica software for ETL development. Our Database and Technology stack is diverse with wide use of Sql Server, Oracle, MongoDb , MySql and PostGres databases
OMD Analytics is seeking an experienced software engineer, who is :
The successful candidate would spend their time in developing and supporting complex integration solutions using ETL tools, writing complex SQL code and stored procedures, python code or optimizing if possible.
The candidate would have significant latitude to propose and work on any project that would better support or allow new insight into DSNY operations. These could include :
Our team has a history of creating innovative solutions tailored to the specific needs of our Department. We are looking for someone who shares our interest in using software to facilitate responsive and effective government.
The successful candidate would have the ability to make an immediate impact, working directly with New York's Strongest to improve systems that directly impact New York City citizens every day. They would also have the opportunity to think strategically about our spatial data infrastructure. Are we collecting the right data? Are we storing it in a way that makes the jobs of our data scientists easy? Are we coordinating effectively with other parts of the agency, and with other agencies?
The ideal candidate would also be willing to work overtime during major snow events or other emergency response events.
Qualifications
1. A master's degree in computer science from an accredited college or university and three (3) years of progressively more responsible, full-time, satisfactory experience in Information Technology (IT) including applications development, systems development, data communications and networking, database administration, data processing, or user services. At least eighteen (18) months of this experience must have been in an administrative, managerial or executive capacity in the areas of applications development, systems development, data communications and networking, database administration, data processing or in the supervision of staff performing these duties; or
2. A baccalaureate degree from an accredited college or university and four (4) years of progressively more responsible, full-time, satisfactory experience as described in "1" above; or
3. A four-year high school diploma or its educational equivalent, and six (6) years of progressively more responsible, full-time, satisfactory experience as described in "1" above; or
4. A satisfactory combination of education and experience equivalent to "1", "2" or "3" above. However, all candidates must have at least a four-year high school diploma or its educational equivalent and must possess at least three (3) years of experience as described in "1" above, including the eighteen (18) months of administrative, managerial, executive or supervisory experience as described in "1" above.
In the absence of a baccalaureate degree, undergraduate credits may be substituted for a maximum of two (2) years of the required experience in IT on the basis of 30 semester credits for six (6) months of the required experience. Graduate credits in computer science may be substituted for a maximum of one (1) year of the required experience in IT on the basis of 30 graduate semester credits in computer science for one (1) year of the required IT experience. However, undergraduate and / or graduate credits may not be substituted for the eighteen (18) months of experience in an administrative, managerial, executive, or supervisory capacity as described in "1" above.
Additional Information
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.
