Data Engineer, Office of Special Enforcement

$81,083 - $150,000/Yr

City of New York - New York, NY

Full-time - Mid Level

New York, NY

Executive, Legislative, and Other General Government Support

About the position

The Data Engineer for the Office of Special Enforcement (OSE) is responsible for developing and maintaining the data infrastructure that supports the operations of the office. This role involves ensuring data accessibility, improving system reliability, and creating databases and reporting systems to address agency needs. The Data Engineer will also develop data tools and APIs, manage special projects, and collaborate with stakeholders to leverage data effectively.

Responsibilities

• Build and maintain the data infrastructure for optimal extraction, transformation, and loading of data from a wide variety of sources.
• Ensure data accessibility at all times and implement agency data policies regarding data privacy and confidentiality.
• Improve data systems reliability and performance.
• Create optimal databases, pipelines, and reporting systems to solve agency business problems.
• Provide platforms that enable OSE data consumers to analyze and gain insights from data.
• Convert data from primary and secondary sources into formats that can be easily utilized by Dynamics, OSE researchers, and other data consumers.
• Develop data tools and APIs for data analysis to streamline manual processes.
• Maintain code and documentation using DevOps.
• Collaborate with stakeholders to understand how data can be leveraged to meet OSE's needs.
• Develop algorithms to transform data into useful, actionable information.
• Manage special projects and initiatives as assigned.

Requirements

• A baccalaureate degree from an accredited college including or supplemented by 24 credits in the field of voice and/or data telecommunications or in a pertinent scientific, technical, electronic or related area, and four years of satisfactory full-time experience in analytical, planning, operational, technical, or administrative duties in a voice and/or data telecommunications or closely related electronics planning, management, and/or service organization, one year of which must have been in a highly specialized capacity and 18 months must have been in an executive, managerial, or administrative capacity or in the supervision of staff performing work in the voice and/or data telecommunications field.
• An associate degree from an accredited college including or supplemented by 12 credits in the field of voice and/or data telecommunications or in a pertinent, scientific, technical, electronic or related area and five years of experience as described above.
• Education and/or experience equivalent to the above, with at least a four-year high school diploma or its educational equivalent and one year of specialized experience as described above, including 18 months of executive, managerial, administrative or supervisory experience.

Nice-to-haves

• Significant experience as a developer using SQL (MS-SQL Server, Oracle and/or Postgres), SSIS, Visual Studio, C#, Python, Web APIs, SharePoint, JSON and CSV files.
• 3 years working with Microsoft Dynamics CRM Online.
• Experience in developing, deploying and customizing Microsoft Dynamics CRM Solutions.
• Experience automating data pipelines using Visual Studio, SSIS, SQL and Python scripts.
• Experience with NYC Open Data.
• Experience with SSRS Reports Development and Power Apps.
• Experience with Azure DevOps.
• Experience with Unit testing and Integration testing.
• Experience creating technical and user documentation.
• Strong communication, analysis, and problem-solving skills.

Benefits

• Public Service Loan Forgiveness eligibility
• Potential for civil service exam opportunities
• Diversity and inclusion initiatives
• Opportunities for professional development