Senior Programmer Analyst
Senior Programmer Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
The NYC Department of Sanitation (DSNY) is the worlds 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 longterm analytical capabilities of the Department. Our current projects include:
Developing agency wide data warehouse and very complex data integration solutions
Applications to support the realtime 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 opensource inhouse development in Python Pentaho Kettle JavaScript but we also use offtheshelf 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 backend 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 nontechnical 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 frontend 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 Yorks 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.
COMPUTER SYSTEMS MANAGER 1005D
Qualifications :
1. A masters degree in computer science from an accredited college or university and three (3) years of progressively more responsible fulltime 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 fulltime satisfactory experience as described in 1 above; or
3. A fouryear high school diploma or its educational equivalent and six (6) years of progressively more responsible fulltime 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 fouryear 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 individuals sex race color ethnicity national origin age religion disability sexual orientation veteran status gender identity or pregnancy.
Remote Work :
No
Employment Type :
Fulltime
Employment Type
Full-time
