What are the responsibilities and job description for the Data Engineer position at City of New York?
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 bachelor’s 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.
COMMUNITY COORDINATOR - 56058
Minimum Qualifications
As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/
Residency Requirement
City Residency is not required for this position
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.
, $70,022.00 – $94,000.00
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 bachelor’s 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.
COMMUNITY COORDINATOR - 56058
Minimum Qualifications
- A baccalaureate degree from an accredited college and two years of experience in community work or community centered activities in an area related to the duties described above; or
- High school graduation or equivalent and six years of experience in community work or community centered activities in an area related to the duties as described above; or
- Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least one year of experience as described in "1" above.
As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/
Residency Requirement
City Residency is not required for this position
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.
, $70,022.00 – $94,000.00
Salary : $70,022 - $94,000
