Associate Software Engineer-Data and Integrations

Job Description

Essential Functions

• Write, modify, and maintain SQL queries and database objects to support applications, integrations, and reporting
• Consume and integrate data from internal and external APIs, handling structured data formats such as JSON or XML
• Support data flows and system integrations between departmental applications and enterprise platforms
• Assist with automation and scripting tasks to improve operational efficiency
• Participate in troubleshooting and resolving data-related or application issues in operational systems
• Collaborate with senior engineers and cross-functional teams on development tasks and system improvements
• Support applications and services running in production environments under established change-management processes
• Maintain clear and accurate technical documentation for code, data flows, and integrations
• Participate in testing, validation, and deployment activities as assigned

Qualifications

• Bachelor’s degree in Information Technology, Computer Science, or a related field
  OR
  Completion of a relevant technical certificate program, military technical training, or equivalent practical experience
• Foundational knowledge of SQL and relational database concepts
• Basic understanding of how applications exchange data through APIs

Competencies, Knowledge, Skills and Abilities

• Foundational understanding of relational databases and SQL
• Basic understanding of software development concepts and data-driven applications
• Familiarity with consuming APIs and working with structured data formats
• Ability to learn new tools, languages, and systems quickly
• Ability to work collaboratively while also managing individual tasks independently
• Strong analytical and problem-solving skills
• Attention to detail, especially when working with production data
• Effective written and verbal communication skills

Additional Information

Salary Range: $65,000-$72,000

Salary cannot exceed $72,000

All applications must include a cover letter. Applications without a cover letter will be considered incomplete. 

Did you know?
● We are a Public Service Loan Forgiveness Program qualified employer : 25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities

● 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

*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 faqpchr @phila.gov. For more information, go to: Human Relations Website:
http://www.phila.gov/humanrelations/Pages/default.aspx