City of New York
Data Engineer
City of New York, New York, New York, us, 10261
Company Description
Job Description
The Bronx District Attorney's Office in New York City serves a multicultural, international community of 1.4 million residents. Led by District Attorney Darcel D. Clark, the Bronx District Attorney's Office is one of the country's leading prosecutorial offices. The Office's mission of "Pursuing Justice With Integrity" captures its commitment to pursue a safer Bronx through fair justice.
BXDA's Strategic Planning and Analytics Unit serves as the internal management consulting arm of the Office. The unit uses cutting-edge data science and research analytics to support the Office's application of data-driven policies and practices. This unit is responsible for measuring office performance on prosecution indicators, evaluating the effects of policies and initiatives, conducting strategic analysis, and promoting transparency. The unit also manages the Office's grants, which provide critical funding to support prosecutorial practices and victims of crime in the Bronx.
The data engineer will be an integral member of our data analytics team working collaboratively with a diverse team of analysts and alongside information technology and justice system practitioners. This position demands strong SQL and data management skills to assist with the expansion and maintenance of workflows in a Microsoft Azure data analytics and reporting pipeline. This position offers an opportunity to apply strong technical and analytic abilities to inform the implementation of fair and objective public safety policies and procedures.
JOB RESPONSIBILITIES:
Helping lead a system of reporting and analytic operations including database queries, updating and expanding stored procedures by leveraging programming languages (e.g., SQL, R, Azure data factory) to support reports and Power BI dashboards;
Develop, implement, and document data management procedures and standards to ensure data quality and accuracy in the Unit's reporting;
Use advanced data transformation techniques (i.e., ETL) to standardize, check, clean, merge, and integrate disparate datasets from complex criminal justice databases;
Work closely with data analysts conducting quantitative data analysis and research or evaluation projects using a range of criminal justice administrative data sources;
Collaborate with members of the Information Technology Unit in support of the goals of the Strategic Planning & Analytics unit;
Help identify relevant data for measuring office performance and outcomes, and for use in statistical analysis to assess impacts and trends where accuracy is paramount;
Perform all other related duties and projects as assigned.
QUALIFICATIONS:
Minimum of a Masters degree in Computer Science, Information Systems, Information Technology, Data Science, or a related field
Minimum of four years of proven experience with SQL databases, ORACLE, XML, JSON or similar data systems a related; master's degree may substitute for two years
Experience using SQL, Azure Data Factory, SSIS, or similar database pipeline solutions
Experience with data analysis programming languages such as R, SAS, PYTHON, Stata or similar.
Excellent interpersonal, organizational, and communication skills
Strong project management skills in a team-oriented environment
Strong analytic ability with knowledge of research and statistical analyses
Prefer knowledge of the criminal justice system and criminal justice databases
Ability to multi-task and meet deadlines.
Qualifications
1. For Assignment Level I (only physical, biological and environmental sciences and public health) A master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological or environmental science or in public health.To be appointed to Assignment Level II and above, candidates must have:1. A doctorate degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and one year of full-time experience in a responsible supervisory, administrative or research capacity in the appropriate field of specialization; or2. A master's degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and three years of responsible full-time research experience in the appropriate field of specialization; or3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least a master's degree in an appropriate field of specialization and at least two years of experience described in "2" above. Two years as a City Research Scientist Level I can be substituted for the experience required in "1" and "2" above.
NOTE:Probationary PeriodAppointments to this position are subject to a minimum probationary period of one year.
Additional Information
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.
Job Description
The Bronx District Attorney's Office in New York City serves a multicultural, international community of 1.4 million residents. Led by District Attorney Darcel D. Clark, the Bronx District Attorney's Office is one of the country's leading prosecutorial offices. The Office's mission of "Pursuing Justice With Integrity" captures its commitment to pursue a safer Bronx through fair justice.
BXDA's Strategic Planning and Analytics Unit serves as the internal management consulting arm of the Office. The unit uses cutting-edge data science and research analytics to support the Office's application of data-driven policies and practices. This unit is responsible for measuring office performance on prosecution indicators, evaluating the effects of policies and initiatives, conducting strategic analysis, and promoting transparency. The unit also manages the Office's grants, which provide critical funding to support prosecutorial practices and victims of crime in the Bronx.
The data engineer will be an integral member of our data analytics team working collaboratively with a diverse team of analysts and alongside information technology and justice system practitioners. This position demands strong SQL and data management skills to assist with the expansion and maintenance of workflows in a Microsoft Azure data analytics and reporting pipeline. This position offers an opportunity to apply strong technical and analytic abilities to inform the implementation of fair and objective public safety policies and procedures.
JOB RESPONSIBILITIES:
Helping lead a system of reporting and analytic operations including database queries, updating and expanding stored procedures by leveraging programming languages (e.g., SQL, R, Azure data factory) to support reports and Power BI dashboards;
Develop, implement, and document data management procedures and standards to ensure data quality and accuracy in the Unit's reporting;
Use advanced data transformation techniques (i.e., ETL) to standardize, check, clean, merge, and integrate disparate datasets from complex criminal justice databases;
Work closely with data analysts conducting quantitative data analysis and research or evaluation projects using a range of criminal justice administrative data sources;
Collaborate with members of the Information Technology Unit in support of the goals of the Strategic Planning & Analytics unit;
Help identify relevant data for measuring office performance and outcomes, and for use in statistical analysis to assess impacts and trends where accuracy is paramount;
Perform all other related duties and projects as assigned.
QUALIFICATIONS:
Minimum of a Masters degree in Computer Science, Information Systems, Information Technology, Data Science, or a related field
Minimum of four years of proven experience with SQL databases, ORACLE, XML, JSON or similar data systems a related; master's degree may substitute for two years
Experience using SQL, Azure Data Factory, SSIS, or similar database pipeline solutions
Experience with data analysis programming languages such as R, SAS, PYTHON, Stata or similar.
Excellent interpersonal, organizational, and communication skills
Strong project management skills in a team-oriented environment
Strong analytic ability with knowledge of research and statistical analyses
Prefer knowledge of the criminal justice system and criminal justice databases
Ability to multi-task and meet deadlines.
Qualifications
1. For Assignment Level I (only physical, biological and environmental sciences and public health) A master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological or environmental science or in public health.To be appointed to Assignment Level II and above, candidates must have:1. A doctorate degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and one year of full-time experience in a responsible supervisory, administrative or research capacity in the appropriate field of specialization; or2. A master's degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and three years of responsible full-time research experience in the appropriate field of specialization; or3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least a master's degree in an appropriate field of specialization and at least two years of experience described in "2" above. Two years as a City Research Scientist Level I can be substituted for the experience required in "1" and "2" above.
NOTE:Probationary PeriodAppointments to this position are subject to a minimum probationary period of one year.
Additional Information
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.