Data Engineer
Data Engineer
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
Position Summary
This is professional and technical work in the field of data engineering and enterprise systems integration. Employees in this class are responsible for the design development and maintenance of scalable data pipelines enterprise integrations and workflow automation tools that support citywide operations and publicfacing services. Work involves analyzing complex datasets developing and implementing data models and enhancing data infrastructure using modern technologies and best practices in software engineering and data management. Employees serve as technical liaisons between departmental data producers and consumers working to standardize enrich and optimize data for operational use reporting and public transparency.
Work is performed as part of a multidisciplinary team and requires independent judgment technical expertise and the ability to communicate complex concepts clearly to both technical and nontechnical stakeholders. Assignments are performed with considerable independence and evaluated based on overall data platform performance successful delivery of integration services and support of enterprise data initiatives. This position reports to the First Deputy of PhillyStat360.
Essential Functions
- Develop an intimate understanding of the Citys diverse data and contribute to improving the Citys data engineering infrastructure pipelines models and integrations.
- Use a blend of open source custom developed and offtheshelf tools including Python Bash SQL DBT GIS Docker Terraform Apache Airflow Jenkins Postgres PostGIS AWS GitHub MuleSoft as an iPaaS and SAS API provides like ArcGIS Online and CARTO.
- Design develop and maintain robust data pipelines and workflows using Python Apache Airflow and related tools.
- Build and support scalable data integrations between diverse systems of record centralized databases and cloudbased platforms (AWS SaaS tools etc.).
- Collaborate with City departments and agencies to understand business needs and deliver data integrations that improve public services and residentfacing applications.
- Design and maintain data pipelines that promote equitable access to information by supporting the publication of open datasets and GIS tools that inform the public on key City initiatives.
- Document technical procedures system architectures and operational workflows in a clear and organized manner for internal reference and audit purposes.
- Communicate effectively with both technical and nontechnical stakeholders ensuring alignment between system capabilities and departmental needs.
- Work with departments to improve data quality and integrity particularly for datasets used in service delivery to underrepresented and historically marginalized communities.
- Ensure integration solutions meet accessibility and inclusion standards when applied in publicfacing tools and systems.
- Collaborate with business partners and stakeholders to understand technical needs create integration solutions and make data more accessible to internal departments and the public.
- Analyze complex datasets to identify trends correlations and data anomalies.
- Write technical documentation data dictionaries and integration specifications; effectively communicate technical information to nontechnical stakeholders.
- Apply DevOps practices using tools like Docker GitHub and Terraform to support CI/CD pipelines.
- All other duties as assigned.
Required Competencies Knowledge Skills and Abilities
Knowledge of:
- Python programming and scripting for automation and data workflows.
- SQL and relational databases (PostgreSQL preferred).
- Modern data engineering tools such as Apache Airflow DBT and Terraform.
- Cloud infrastructure and services (especially AWS).
- Git and GitHub for version control and CI/CD.
- Docker and Linuxbased server environments.
- Geospatial data and tools (PostGIS ArcGIS Online CARTO) preferred.
Skill in:
- Data modeling and integration design.
- Writing clear maintainable code and documentation.
- Analyzing large diverse datasets to extract meaningful insights.
- Managing multiple concurrent workflows and priorities.
- Troubleshooting technical issues and implementing solutions independently.
Ability to:
- Collaborate effectively across departments with varying levels of technical expertise.
- Design and implement secure scalable and maintainable data systems.
- Communicate technical concepts clearly to both technical and nontechnical audiences.
- Learn new tools platforms and programming languages as needed.
- Thrive in a hybrid work environment and contribute to a collaborative innovative team.
Qualifications :
Bachelors degree in Computer Science Data Science Information Systems Engineering or a related field. Equivalent experience may be considered.
At least three or more years of experience in data engineering software development or enterprise system integration.
Additional Information :
TO APPLY: Interested candidates must submit a cover letter and resume.
Salary Range: $81000 $90000
Discover the Perks of Being a City of Philadelphia Employee:
- Transportation: City employees get unlimited FREE public transportation all year long through SEPTAs Key Advantage program. Employees can ride on SEPTA buses subways trolleys and regional rail for their daily commute and more.
- Parental Benefits: The City offers its employees 8 weeks of paid parental leave.
- 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.
- 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 wellbeing 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 nonmedical nonemergency or patient facing positions with the City of Philadelphia. As a result only employees in positions providing services that are patientfacing 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 ator send an email to
For more information go to: Human Relations Website: Work :
No
Employment Type :
Fulltime
Employment Type
Full-time
