Data Engineer - Administrative Special Services Staff ...
MSCCN - Detroit, MI
Apply NowJob Description
Data Engineer - Administrative Special Services Staff III - Exempt (ARPA) Print ( Apply  Data Engineer - Administrative Special Services Staff III - Exempt (ARPA) Salary $110,000.00 - $120,000.00 Annually Location CAYMC, MI Job Type Appointed-Directors-Discretion of Mayor/Leg Body Remote Employment Flexible/Hybrid Job Number 20240199929108DJ-DE Department Housing & Revitalization Opening Date 09/10/2024 Closing Date 9/24/2024 11:59 PM Eastern Bargaining Unit 9000-Non Union Salary Regular Service General Description Benefits Questions Description The 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 matters Examples of Duties Build, 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 modelling Develop scripts to clean and integrate data Design data schemas and database architecture Develop work issues and delegating to other team members as needed Meet with team members to ensure alignment and buy in as well as technical feasibility. Identify and implement ways to track and manage data quality Develop new data sources and associated reporting with team members Minimum Qualifications Education and Experience Bachelors 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 required 5+ 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 Skills Skills 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 organization Equivalent combinations of education and experience may be substituted to meet the education and experience requirements of this position. Supplemental Information Appointment is based upon availability of grant funds. Medical Plan Offering for Administrative Special Services Employees The 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 year PAID HOLIDAYS - Granted if paid for 600 straight time hours in the (12) months prior to the holiday 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. 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 Earned Less than 6 months None After 6 months & (1000 work hours)5 days After 1 year An additional 5 days 2-5 years 10 days 6-7 years 11 days 8-9 years 12 days 10-12 years 13 days 15- years15- years PAID HOLIDAYS - Granted if paid for 600 straight time hours in the (12) months prior to the holiday OVERTIME - 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. 01 Do you possess a working knowledge of Github, HTML, markup language, SQL, and Python? YES NO 02 Do 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? Yes No 03 Described what types of systems you have designed. 04 Have you managed Human Services data? Required Question Agency City of Detroit Address Coleman A. Young Municipal Center 2 Woodward Ave ste 316 Detroit, Michigan, 48226 Website Apply Please verify your email address Verify Email
Created: 2024-09-12