Data Analyst

Office of the New York State Attorney General · New York, NY

Data + Analytics
Public Infrastructure
Public Service & Civic Engagement
$90,097 - $93,497 Per Year
Posted 3 weeks ago

Excel
Linux
Pandas
Matplotlib
Tableau
Python
SQL
Report an Issue
Featured Job

Executive Division

Research and Analytics Department – New York City

Data Analyst

Reference No. RAD_DAT_NYC_6326

Application Deadline is July 12, 2024 

Goal 

The Research and Analytics Department (RAD) in the Office of the New York State Attorney General (OAG) is seeking candidates for a full-time Data Analyst position to explore, analyze, and create new datasets for information pertinent to OAG investigations. The goal of the data analyst at the OAG is to support a range of investigations and initiatives with consistent, high quality, reproducible research that is communicated in clear and compelling ways.   

Purview 

As part of an innovative team housed in the Executive Division, you will work with staff and divisions throughout the OAG to support the OAG's major initiatives, investigations, and policy development. Our team researches and writes analytical reports garnering national attention, directs multi-million-dollar grant programs, and supports the office’s major investigations. See for example our work, fighting fraud that undermines our democratic process, investigating policing that impacts free speech, lawsuits protecting tenants from lead poisoning, on Opioid litigation, and consumer price gouging. Utilizing a vast collection of public and confidential information, you will work with data covering the breadth of the OAG’s purview building analytic tools to inform investigations that affect the lives of all New Yorkers.  

Employing over 1,800 people across New York State, the OAG is both the “People's Lawyer” and the State's chief legal officer. The Data Analyst will support OAG work in numerous legal and regulatory arenas, including protecting the rights of investors and consumers, coordinating state-wide criminal investigations, promoting civil rights, economic and social justice, encouraging harm-reducing public health strategies, and preserving the State’s environment. The OAG also advises the Executive branch of State government and defends actions and proceedings on behalf of the State. 

 

Responsibilities of the Data Analyst include, but are not limited to, the following 

Data can and does play a pivotal role in decisioning on a wide range of the OAG’s work. The Data Analyst will work closely with both RAD and other staff to support the work of the OAG.  

Exploring and analyzing data: 

  • Synthesizing pertinent facts and issues from large amounts of information/data
  • Using standard, reproducible methodology 
  • Condensing large/complicated information to key points
  • Communicating findings and methodology through written reports, verbal presentations, and visualizations 
  • Creating visually compelling and informative graphics or maps
  • Understanding and identifying limitations of sources or analysis

Developing or programming new databases or datasets: 

  • Aggregating disparate data and developing original datasets
  • Identifying and cleaning “dirty” data
  • Creating functions to flag/separate/segregate/filter/aggregate data
  • Troubleshooting data and calculations for errors/omissions 

Qualifications/Skills: 

  • Bachelor’s degree or equivalent work experience required
  • Demonstrated qualitative and/or quantitative research abilities
  • Experience with scripting, querying, or statistical programming (SQL and/or Python preferred) 
  • Advanced Excel experience (pivot tables, vlookups, conditionals) 
  • Strong oral, written, and presentation communication skills
  • Ability to communicate technical concepts and results to a non-technical audience
  • Highly organized, self-directed, and curious
  • Personable and positive, with a high level of integrity
  • Interest in public policy and social/economic justice

Preferred Skills/Experience: 

  • Python data stack (pandas, numpy, scipy) 
  • Advanced SQL (e.g. subqueries, window functions) or database management 
  • Obtaining data from API’s, web-sites, PDF’s or other difficult sources
  • Data visualization or front-end software (e.g. plotly, matplotlib, bokeh, altair, streamlit, Tableau, d3)
  • Comfort with linux command line tools and git/GitHub

The hiring rate for this position is $86,697 + $3,400 in location pay. As an employee of the OAG, you will join a team of dedicated individuals who work to serve the people of our State through a wide variety of occupations. We offer a comprehensive New York State benefits package, including paid leave, health, dental, vision, and retirement benefits, and family-friendly policies. Additionally, the OAG offers a robust Workplace Flexibilities Program with multiple options for employees, including telecommuting (up to two days per week) and alternative work schedules. 

 

HOW TO APPLY 

Applications must be submitted online. To apply, please click on the following link: RAD_DAT_NYC_6326

To ensure consideration, applications must be received by close of business on July 12, 2024. 


Applicants must be prepared to submit a complete application consisting of the following: 

  • Cover Letter 
    • You may address your letter to the Legal Recruitment Unit.
    • Indicate why you are interested in this position and what makes you a strong candidate. You may wish to include information about what life experiences you will bring to the position that will enhance the OAG’s ability to better serve the diverse population of this state.
  • Resume
  • Writing Sample
    • In lieu of a writing sample, please provide a code sample (data ETL and/or analysis in python and/or SQL; this can be a link to a public github/gitlab repo).
    • If needed, please include a cover page to provide the reviewer with any relevant context or background information.
  • List of three (3) references 
    • Only submit professional references, supervisory references are preferred. 
    • For each reference, indicate the nature and duration of your relationship. 
    • Include contact information and email addresses for each reference.
    • Please note that your references will not be contacted until after you interview for the position.
       

If you have questions regarding a position with the OAG and the application process or need assistance with submitting your application, please contact Legal Recruitment via email at [email protected] or phone at 212-416-8080.  

For more information about the OAG, please visit our website: www.ag.ny.gov 

Related Jobs

Data Analyst - Civic Nation
Washington, DC/Remote (USA) - Posted 2 weeks ago
Technical Operations Analyst - Promise
New York, NY - Posted 4 days ago
Data Engineer - Good Party
Remote (USA) - Posted 2 weeks ago
View more open Data Analyst jobs
View more open tech jobs in New York, NY
Be the first to see new Data Analyst jobs

Save this search to get an email when new jobs match this search.

Create Email Alert