SSIS / SSRS / PowerBI Developer @ NYC Careers - Manhattan, NY

Job Overview

11 days ago

SSIS / SSRS / PowerBI Developer

NYC Careers - Manhattan, NY

**Only permanent employees in the title and those that are reachable on the civil service list are eligible to apply.**

The New York City Department of Youth and Community Development (DYCD) invests in a network of community-based organizations and programs to alleviate the effects of poverty and to provide opportunities for New Yorkers and communities to flourish. The SSIS / SSRS / PowerBI developer will report to the Deputy Director of the Data Portfolio and will be responsible for working with the team to develop and support the data needs of the agency. The candidate will be responsible for:
  • Analyzing user specifications and requirements that reflect business program needs, and subsequently delivering high-quality software solutions that meet those needs.
  • Design, develop, test, maintain and modify software programs according to specifications, verifying logic, and provide guidance to other developers, performing necessary debugging, and writing related documentation.
  • Perform impact analysis on large and complex projects by analyzing and evaluating interrelationships of programs to determine how changes in one program will affect another.
  • Work very closely with the DYCD IT project management group to assist in solving project related technical issues whether it pertains to custom development or evaluation of platforms and products.
  • The candidate may also be called upon to perform a variety of duties to insure the proper operation of systems, to meet IT commitments to the business, and to leverage the strengths and skills of individuals within the overall team effectively.
  • Performs code reviews and unit testing to identify problems, facilitate change, simplify integration, and improve documentation and design for assigned systems and/or projects.
  • Critically review programs prior to implementation to verify consistency and conformance with established IT guidelines, policies and practices as well as industry standard guidelines.
  • Work within the underlying architecture for all software related projects assigned.
  • Use various ETL tools and techniques to solve problems that arise from transporting data to and from different sources.
  • Implement quantitative analysis and statistical modeling techniques to evaluate the impact of City policy.
  • Write clean SQL queries, functions, and stored procedures. Optimize and improve existing code.

Minimum Qual Requirements

(1) A baccalaureate degree from an accredited college, including or supplemented by twenty-four (24) semester credits in computer science or a related computer field and two (2) years of satisfactory full-time software experience in designing, programming, debugging, maintaining, implementing, and enhancing computer software applications, systems programming, systems analysis and design, data communication software, or database design and programming, including one year in a project leader capacity or as a major contributor on a complex project; or
(2) A four-year high school diploma or its educational equivalent and six (6) years of full-time satisfactory software experience as described in “1" above, including one year in a project leader capacity or as a major contributor on a complex project; or
(3) A satisfactory combination of education and experience that is equivalent to (1) or (2) above. College education may be substituted for up to two years of the required experience in (2) above on the basis that sixty (60) semester credits from an accredited college is equated to one year of experience. A masters degree in computer science or a related computer field may be substituted for one year of the required experience in (1) or (2) above. However, all candidates must have a four year high school diploma or its educational equivalent, plus at least one (1) year of satisfactory full-time software experience in a project leader capacity or as a major contributor on a complex project.
NOTE: In order to have your experience accepted as Project Leader or Major Contributor experience, you must explain in detail how your experience qualifies you as a project leader or as a major contributor. Experience in computer operations, technical support, quality assurance (QA), hardware installation, help desk, or as an end user will not be accepted for meeting the minimum qualification
requirements.
Special Note
To be eligible for placement in Assignment Level IV, in addition to the Qualification Requirements stated above, individuals must have one year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration, database management systems, operating systems, data communications systems, capacity planning, and/or on-line applications programming.

Preferred Skills

Note: Computer Specialist (Software) Civil Service Title Required

  • 4-8 years of experience in development of enterprise level software using .NET technologies. Strong familiarity with MVC, ASP.NET, C#, AngularJS, Angular 7+, .Net Core, HTML5, CSS, JQuery, JavaScript, ADO .Net Entity Framework, Design Patterns such as Dependency Injection, T-SQL, MS SQL Server, stored procedures, web services and Bootstrap.
  • Experience working on data integration and interface development related projects.
  • Knowledge of, and experience working with, cloud-service providers such Azure or Amazon Web Services.
  • Experience with REST, web services and service-based architectures using WCF and ASP.Net WEB API; a strong foundation of object oriented programming.
  • Candidates must be highly analytical and effectively able to troubleshoot and prioritize needs, requirements and other issues. Aside from technical skills, prospective candidates should have excellent communications, teamwork and conflict management skills. Because of the constant developing nature of information systems and cyber-attacks, candidate must be committed to continuous learning and system development.
  • Familiarity in development of enterprise level software using Microsoft Dynamics CRM is a plus.
  • Experience of working collaboratively with multidisciplinary cross functional teams with a focus on delivery.
  • Experience working with a shared services provider and operating environment.
  • PREFERRED SKILLS: WCF, WEB API, MVC, Azure DevOps

To Apply

Search for the Job ID #535363
External Candidates please go to www.nyc.gov/careers Current NYC employees please go to www.nyc.gov/ess
ALL APPLICATIONS MUST BE SUBMITTED VIA THE ONLINE PORTALS MENTIONED ABOVE.
SUBMISSION OF AN APPLICATION DOES NOT GUARANTEE AN INTERVIEW. ONLY CANDIDATES UNDER CONSIDERATION WILL BE CONTACTED.
*If you do not have access to a personal computer, please visit your local library*

55-a Program

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.

Hours/Shift

35 Hours Per Week (Minimum)

Work Location

2 Lafayette St., N.Y.

Residency Requirement

New York City Residency is not required for this position

Similar Jobs

- Holtec Security International -Full Stack Developer Programmer

HOLTEC INTERNATIONAL

Camden, NJ

To manage all aspects of systems development and systems integration supporting law enforcement operations and public safety.

Power BI Developer

Snappy Hires

Madison, NJ

7 years of experience in data preparation, data gateway and data warehousing projects. *Deep understanding and experience in utilization of Pharmaceutical Data…

Lead .Net Developer

Veridian tech solutions

East Texas, PA

At least 7 years of hands-on experience on C#, ASP. Net, Web Services, SSIS, SSRS and SQL Servers, . Should have a thorough understanding of the .

.NET Architect

GalaxE.Solutions

Somerset, NJ

NET Architect – Working with development teams to ensure that all development efforts and architectural designs are being produced in accordance with…

Power BI Developer

fluxtek solutions inc

Madison, NJ

Experience in data preparation, data gateway and data warehousing projects. Deep understanding and experience in utilization of Pharmaceutical Data assets:…

Power BI Developer

Snappyhires

Madison, NJ

7 years of experience in data preparation, data gateway and data warehousing projects. *Deep understanding and experience in utilization of Pharmaceutical Data…

Jr Data Analyst

Veracity Software

Iselin, NJ

The Jr. Data Analyst will be engaged in coordinating and delivering the following services: Create and maintain metrics and reports to monitor the business and…

Power BI Developer , W2 Only

Digital iTechnology

Madison, NJ

Culture/Environment: Collaborative; ability to work well with commercial/business and technical functional areas (IT, sales operations etc.).

SYSTEM DATA ASSOCIATE

NYC Careers

Manhattan, NY

The Office of Accountability Strategies (OAS) is responsible for providing strategic operational, analytical, and systems support services to the DSS-AO …

BI Data Engineer-Work from home-eviCore

Cigna

Hartford, CT

Build ETL processes to allow data to flow seamlessly from source to target using tools like DataBricks, Azure Data Factory and SSIS. Master’s Degree is a plus.

Data Engineer

Services For The Underserved, Inc.

New York, NY

The Strategic Information and Business Intelligence (“SIBI”) Department is looking for an experienced SQL Server, Python/C# and data platform developer who is…

.Net Lead Developer

Synergy Global Technologies Inc.

New York, NY

This hands-on individual (Technical Lead) will contribute to the engineering capacity during various aspects of the product development and SDLC.

System Engineer II

Services For The Underserved, Inc.

New York, NY

The selected candidate will report to the Director of Information Systems who reports to the Vice President of SIBI. Host in-person/remote live trainings.

Senior Data & Reporting Analyst, Customer Services Business

Spectrum

Stamford, CT

JOB SUMMARY: Identify and correct ongoing database maintenance issues. Coordinate database space and Stored Procedures.

Sr. SQL Database Administrator

Penmark Group

Parsippany, NJ

The Senior Database Administrator will provide database administration expertise as well as operational support to Production, UAT, and Test environments.

Senior Database Administrator

PMA Companies

Blue Bell, PA

In this position, you will utilize your prior Information Systems work experience to primarily support our Microsoft SQL Server environments.

Analytics Engineering Lead Engineer

Cigna

Hartford, CT

This role is part of the Analytics Engineering team in the Enterprise Data Office, and reports to an AE Manager. Strong experience in dimensional modeling.

Senior Development DBA (SQL)

Aramark

Philadelphia, PA

ARAMARK Enterprise Systems Development is seeking an application development DBA to lead database activities supporting ARAMARK’s Food Management systems.

Sr. Associate Data Engineer (SQL, SSIS, Qlikview)

The Travelers Companies, Inc.

Hartford, CT

The annual base salary range provided for this position is a nationwide market range and represents a broad range of salaries for this role across the country.

Enterprise Reporting Associate - Chinatown - IT

Charles B. Wang Community Health Center

New York, NY

Develop and maintain data collection with MS stored procedures/SSIS gathered from EHR and various data sources. Maintain database stability and availability.

Business Intelligence Analyst

LaBella Associates

Orange, CT

We provide services that take a project from start to finish—from an initial study to determine a project's feasibility to construction administration and start…

Contract .Net Python Developer

TRF Group Inc.

Jersey City, NJ

Systems Design, Development and Support. Design and development of software applications used in various areas of the bank (such as Customer Reporting, Workflow…

Full Stack Software Engineer, Team Lead

Synergy Global Technologies Inc.

New York, NY

Experience developing trade processing, accounting, general ledger, profit and loss, security, and position management platforms.

Data Engineering Manager - Remote

MyEyeDr.

New York, NY

The ideal candidate should possess an analytical mindset and have a proven track record working with cross-functional business and technology teams.