A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact. 
As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else. We offer a vibrant work environment, comprehensive health care and benefits, and the experience you need to grow and excel. If you’re interested in working with a passionate team of people who care about the future of Philadelphia, start here.

What We Offer:
•    Impact - The work you do here matters to millions. 
•    Growth - Philadelphia is growing, why not grow with it? 
•    Diversity & Inclusion - Find a career in a place where everyone belongs.
•    Benefits - We care about your well-being.
 

The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia headed by the Chief Information Officer (CIO). OIT oversees all major information and communications technology initiatives for the City of Philadelphia - increasing the effectiveness of the information technology infrastructure, where the services provided are advanced, optimized, and responsive to the needs of the City of Philadelphia’s businesses, residents, and visitors. OIT responsibilities include: identifying the most effective approach for implementing new information technology directions throughout city government; improving the value of the city’s technology assets and the return on the city’s technology investments; ensuring data security continuity; planning for continuing operations in the event of disruption of information technology or communications services; and supporting accountable, efficient and effective government across every city department, board, commission and agency.

The SQL Developer/.NET Developer plays a crucial role in automating processes, maintaining and updating data systems using SQL Server 2019 and up, and supporting ongoing development for a jail management application. This position requires expertise in SQL Server database administration, ETL processes, and .NET development to create efficient, reliable solutions. The successful candidate will be proficient in writing complex SQL queries and developing applications using the .NET framework. 

Essential Functions
•    Monitor, safeguard, and optimize the ETL process to extract data from various sources into a data warehouse staging area using SSIS/.NET.
•    Implement additional data sets from new sources and move data from the staging area into the data warehouse star schema.
•    Maintain and enhance business rules and transformations to cleanse and standardize data for reporting and analysis.
•    Database Design & Data Warehousing:
•    Design and implement aggregate tables, views, and virtual tables to optimize query performance.
•    Perform ongoing data modeling and maintenance of the data warehouse, ensuring alignment with business needs.
•    SQL Server Database Administration:
•    Perform database administration tasks to support optimal performance of SQL Server 2019 or later databases.
•    Handle routine operational issues related to the data warehouse.
•    Work with MIS staff to implement backup and recovery procedures.
•    SSIS & SSRS Development:
•    Design and develop SSIS packages to manage ETL processes, including complex data transformations and load procedures.
•    Build and enhance SSRS reports using Visual Studio, ensuring they meet business reporting requirements.
•    .NET Application Development:
•    Develop and maintain applications using the .NET framework, integrating with SQL Server databases to deliver scalable business solutions.
•    System & Server Support:
•    Provide support for Windows Server 2019-2022 operating environments and maintain compatibility with the IJMS (ATIMS) system.
•    Ensure optimal performance of Microsoft SQL Server 2019 or later.
•    Collaboration & Training:
•    Collaborate with team members and stakeholders to translate business needs into technical solutions.
•    Provide training and technical guidance to MIS support staff.
•    Offer feedback on software licensing needs for database and development tools.
•    Performance Monitoring & Optimization:
•    Monitor the performance of reports and data processing, resolving issues to ensure accurate and timely delivery of data.

Competencies, Knowledge, Skills and Abilities
•    Microsoft SQL Server 2017 or later (Database administration and development)
•    Microsoft SQL Server SSIS (Data Transformation Services)
•    Standard Query Language (SQL) (Query writing and optimization)
•    PowerBI
•    SQL Server Backup and Recovery
•    PostgreSQL 12
•    ODBC connectivity
•    Technical Documentation (Writing and maintaining documentation)
•    Extract, Transform, and Load (ETL) (Design and process management)
•    Data access management using Active Directory (Securing data and reports)
•    Query writing based on business requirements
•    Data governance (Ensuring data quality and compliance)
•    .NET Framework and C# (Application development and maintenance)
•    ASP.NET (Web application development)
•    Experience with Visual Studio (Development environment)
 

•    Establish and maintain effective working relationships with associates, departmental officials, and outside consultants.
•    Analyze and present complex data structures.
•    Learn the operations, functions, data, reporting needs, and business requirements.
•    Learn the regulations, ordinances, policies, and procedures related to the work of the Prisons.
•    Read, interpret, and understand technical information and apply cross-functional knowledge.
•    Effectively present information and respond to questions from managers, co-workers, and system users.
•    May assist with planning, organizing, and directing the work activities of outside consultants and/or systems analysts and programming personnel assigned to a team.
•    Advise OIT and Prisons management with respect to systems development projects and/or enhancements.
•    Job Scheduling (creation, modifying, and monitoring).
•    Microsoft SQL Server 2017 or later (Preferred).
•    .NET application development with knowledge of C# (Preferred).

Salary Range: $75,000 - $85,000

Important: To apply, candidates must provide a cover letter and resume.

Work Setting: in-person (onsite)

Discover the Perks of Being a City of Philadelphia Employee:
•    We offer Comprehensive health coverage for employees and their eligible dependents
•    Our wellness program offers eligibility into the discounted medical plan
•    Employees receive paid vacation, sick leave, and holidays
•    Generous retirement savings options are available
•    Pay off your student loans faster - As a qualifying employer, City of Philadelphia employees are eligible to participate in the Public Service Loan Forgiveness program. Join the ranks of hundreds of employees who have already benefited from this program and achieved student loan forgiveness.
•    Enjoy a Free Commute on SEPTA - Starting September 1, 2023, eligible City employees will no longer have to worry about paying for SEPTA public transportation. Whether you're a full-time, part-time, or provisional employee, you can seize the opportunity to sign up for the SEPTA Key Advantage Program and receive free Key cards for free rides on SEPTA buses, trains, trolleys, and regional rails.
•    Unlock Tuition Discounts and Scholarships - The City of Philadelphia has forged partnerships with over a dozen esteemed colleges and universities in the area, ensuring that our employees have access to a wide range of tuition discounts and scholarships. Experience savings of 10% to 40% on your educational expenses, extending not only to City employees but in some cases, spouse and dependents too!
Join the City of Philadelphia team today and seize these incredible benefits designed to enhance your financial well-being and personal growth!

*The successful candidate must be a city of Philadelphia resident within six months of hire

Effective May 22, 2023, vaccinations are no longer required for new employees that work in non-medical, non-emergency or patient facing positions with the City of Philadelphia. As a result, only employees in positions providing services that are patient-facing medical care (ex: Nurses, doctors, emergency medical personnel), must be fully vaccinated.

The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race, ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at 215-686-4670 or send an email to [email protected].