Data Engineer - Administrative Special Services Staff III - Exempt (ARPA)Print ( Engineer - Administrative Special Services Staff III - Exempt (ARPA)Salary$110,000.00 - $120,000.00 AnnuallyLocationCAYMC, MIJob TypeAppointed-Directors-Discretion of Mayor/Leg BodyRemote EmploymentFlexible/HybridJob Number20240199929108DJ-DEDepartmentHousing & RevitalizationOpening Date09/10/2024Closing Date10/2/2024 11:59 PM EasternBargaining Unit9000-Non Union Salary Regular Service GeneralDescriptionBenefitsQuestionsDescriptionThe City of Detroit's Housing and Revitalization Department is seeking a Data Engineer - Administrative Special Services III-Exempt (ARPA). This role will provide the chance to design and build a CRM for the public sector. The small and collaborative nature of the team would allow for an individual to participate in all aspects of this project.As a Data Engineer- Administrative Special Services III-Exempt (ARPA), you are responsible for managing the data pipelines, written in Python and executed using a tool such as Airflow or Prefect, which extract data from departmental/vendor source systems into the data warehouse/CRM. These pipelines further transform the data into models which are usable by end users or user-facing systems. The Data Engineer is responsible for integrating a diverse number of datasets to improve delivery to internal customers, and allow for data-led decision making.You will be required to help solve the technical and organizational challenges that will arise as a part of the data integration process. The Data Engineer also keeps the supervisor informed of progress and of potentially controversial mattersExamples of DutiesBuild, design, and maintain database and CRM. This position would likely require an equal amount of meetings and heads down work time.Contribute directly to pipeline development and database modellingDevelop scripts to clean and integrate dataDesign data schemas and database architectureDevelop work issues and delegating to other team members as neededMeet with team members to ensure alignment and buy in as well as technical feasibility.Identify and implement ways to track and manage data qualityDevelop new data sources and associated reporting with team membersMinimum QualificationsEducation and ExperienceBachelors in computer science, data science, information management, or database administration.3-4 years of experience in systems analysis, computer science engineering, programming, information security management, data analysis, information science, or geographical information systems analysis is preferred but not required5+ years of experience with Data Warehousing: proven relational database design & build. Experience in the context of a social services agency is preferred.1-2 years of experience with human services type data.Required Technical SkillsSkills in both Python and SQL (ideally PostgreSQL)Experience with a pipeline/job scheduling/orchestration framework (Airflow, Prefect)Experience integrating large disparate data sources in a variety of formats.Experience working with REST APIs (typically as a source of data)Experience with a cloud data warehouse such as Snowflake or BigQuery in the context of a large organizationEquivalent combinations of education and experience may be substituted to meet the education and experience requirements of this position.Supplemental InformationAppointment is based upon availability of grant funds.Medical Plan Offering for Administrative Special Services EmployeesThe City of Detroit is pleased to continue to provide a medical plan option to our Administrative Special Services Employees for the 2020 plan year. This plan is provided by Blue Care Network of Michigan and utilizes their PCP Focus Network. This plan provides you with the opportunity to receive an enhanced level of benefits and pay less out of your paycheck for your medical plan. There are two important requirements that you should consider and understand if you should decide to enroll in this plan. You will have to choose a primary care physician that serves within the PCP Focus network. This primary care physician coordinates your care. The network includes over 22,000 Primary Care Physicians. There are also Wellness Requirements that you (the subscriber) must meet in order to remain in the enhanced level of benefit.Administrative Special Services Staff (Exempt) are eligible for the following benefits:CURRENT SICK LEAVE – Granted (3) months of continuous service. (1) day per month, not to exceed (12) days per year.VACATION – Granted (1) day per pay period, not to exceed 20 days per fiscal yearPAID HOLIDAYS – Granted if paid for 600 straight time hours in the (12) months prior to the holidayMILEAGE REIMBURSEMENT - Granted on same basis as regular employees.WORKERS COMPENSATION – Covered by applicable laws.UNEMPLOYMENT COMPENSATION - Covered by applicable laws.HOSPITALIZATION – You are eligible to purchase healthcare benefits for yourself and your dependents under a group rate. You will be responsible for the full premium, no employer contribution will be applied. Please review the Health Care Plan Options Booklet for more detailed information.This position is not eligible for the City Pension Plan, dental, vision, optical, death, life, disability, funeral, reserve sick or jury duty.Administrative Special Services Staff (Non-Exempt) are eligible for the following benefits:CURRENT SICK LEAVE – Granted (3) months of continuous service. (1) Day per month, not to exceed (12) days per year.VACATION – Granted on the following basis:Terms of Service Vacation leave EarnedLess than 6 months NoneAfter 6 months & (1000 work hours)5 daysAfter 1 year An additional 5 days2-5 years 10 days6-7 years 11 days8-9 years 12 days10-12 years 13 days15- years15- yearsPAID HOLIDAYS – Granted if paid for 600 straight time hours in the (12) months prior to the holidayOVERTIME - Granted on same basis as regular employees.MILEAGE REIMBURSEMENT - Granted on same basis as regular employees.WORKERS COMPENSATION – Covered by applicable laws.UNEMPLOYMENT COMPENSATION - Covered by applicable laws.HOSPITALIZATION – You are eligible to purchase healthcare benefits for yourself and your dependents under a group rate. You will be responsible for the full premium; no employer contribution will be applied. Please review the Health Care Plan Options Booklet for more detailed information.This position is not eligible for the City Pension Plan, dental, vision, optical, death, life, disability, funeral, reserve sick or jury duty.01Do you possess a working knowledge of Github, HTML, markup language, SQL, and Python?YESNO02Do you possess a bachelor's degree from an accredited college or university, with major course of work in computer science, information systems, programming, systems analysis, geographic information science, engineering, communications, or other related field of study?YesNo03Described what types of systems you have designed.04Have you managed Human Services data?Required QuestionAgencyCity of DetroitAddressColeman A. Young Municipal Center 2 Woodward Ave ste 316 Detroit, Michigan, 48226Website verify your email address Verify Email