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:
- an expert in Python and SQL, and familiar with NoSQL like MongoDb
- familiar with back-end API development
- familiar with ETL tools like Informatica, Pentaho Kettle, Talend etc
- familiar with reporting tools like Power BI and Oracle BI
- familiar with web application development using ASP, .Net , C #
- capable of producing both rapid prototypes and optimized, readable code
- used to writing unit tests and documenting projects
- able to communicate complex ideas to non-technical personnel
- comfortable collaborating with and being a resource for less experienced programmers

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:
- Improving queries, ETL for use in numerous data integration solutions
- Building reliable data pipelines to inform reports and analyses
- Working with front-end developers to create responsive web applications that assist operational personnel

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.

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.

In addition to the skills and qualifications listed above, the following would also be helpful: - Fluency with Javascript - Our primary need is for a Python programmer, but full-stack abilities are definitely a plus. - Familiarity with Python data science libraries, such as NumPy, Pandas, and Scikit-learn. - Experience with ETL tools like Informatica , Pentaho Kettle , Talend etc. - Familiarity with reporting tools like Power BI and Oracle BI. - Experience with virtualization and containerized deployment (e.g. Docker, Kubernetes). - Familiar with distributed data/computing tools: Map/Reduce, Hadoop, Hive, Spark. - Ability to handle multiple projects simultaneously under tight deadlines.

This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/

New York City Residency is not required for this position

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.