Data Associate, Municipal Data and Analytics

Job Type

Full Time

Salary

Minimum: $44,744
Maximum: $50,303

Published

08/27/2018

Address

660 North Capitol Street Northwest
Washington
District of Columbia
20001
United States

Description


Position Summary

Responsible for responding to staff support ticket requests for netFORUM/SQL queries and reports and uploading contact and related information via SQL. Activities may also include data entry and developing processes to identify and eliminate duplicate records. Opportunity to contribute to NLC’s overall data and analytics strategy and vision. Work closely with Municipal Data and Analytics and netFORUM database administrator to support NLC’s mission to help city leaders build better communities.


Essential Duties and Responsibilities

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  1. Support day-to-day responses to staff netFORUM support tickets
  2. Develop netFORUM and SQL queries based on staff needs, and supporting documentation
  3. Develop standardized processes to upload batches of contact and related information using SQL
  4. Develop processes to identify and eliminate duplicate records and improve overall data quality
  5. Contribute to long-term data strategy and vision including organizational analytic capabilities
  6. Support development of on-going staff training

 

Supervisory Responsibility

This position has no direct supervisory responsibilities, but does serve as a coach and mentor for other positions in the department.

 

Work Environment

This job operates in a professional office environment. This role routinely uses standard office equipment such as laptop computers and smartphones.

 

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

While performing the duties of this job, the employee is regularly required to talk or hear. This is largely a sedentary role; however, some filing is required. This would require the ability to lift files, open filing cabinets and bend or stand on a stool as necessary.

 

Expected Hours of Work

This is a full-time position. Days and hours of work are Monday through Friday, 8:30 a.m. to 5 p.m. This position regularly requires long hours and occasional weekend work as job duties demand.

 

Travel

Travel is primarily local during the business day, although some out-of-area travel may be expected.

 

Preferred Education and Experience

1.     A Bachelor's degree in computer science, operations information management, statistics, or related degree is required;

2.     1-2yrs experience as associate management system (AMS) administrator with systems such as netFORUM, Salesforce, or Aptify;

3.     1-2yrs developing queries and manipulating data using SQL;

4.     Experience with business intelligence tools such as PoweBI or Tableau and data visualization;

5.     Experience with developing and delivering user training;

6.     Demonstrated understanding of data quality assurance and techniques to improve data quality

7.     Strong qualitative and quantitative research skills;

8.     Excellent oral, written, and interpersonal communication skills as well as ability to interact effectively with NLC members, representatives of other organizations, consultants, and all levels of NLC staff.

9.     Experience with Higher Logic online community platforms such as Informz and managing mailing lists a plus;

10. Experience with Intacct or similar accounting system a plus;

11. Experience developing and maintaining SharePoint sites a plus;

12. Familiarity with data analysis tools and software packages such as SAS, Stata, R, Python, ArcGIS, and other similar tools a plus;

13. Familiarity with API development a plus

 

AAP/EEO Statement

National League of Cities is committed to creating a diverse environment and is proud to be an equal opportunity workplace and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

 

National League of cities is also committed to compliance with all fair employment practices regarding citizenship and immigration status.

If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation

 


Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. 

 

Physical Requirements

This is largely a sedentary position that requires the ability to speak, hear, see, and lift small objects up to 20 lbs. Requires the ability to travel locally, regionally and nationally for 3-4 trips annually.

 

Professional Level

Professional

Minimum Education Required

4-year degree


Share:

Share: