Data Analyst (Area Agency on Aging)

Summary

The hiring salary range for this position is $3,195.66 - $3,992.23/semi-monthly or $6,391.32 - $7,984.46/month or depending on qualifications.

DRCOG serves as a visionary leader along Colorado’s front range. We tackle the BIG issues, like growth and development, transportation and meeting the needs of older adults. Our success is built on, and defined by, long-standing partnerships and serving as a forum for discussing these and other emerging issues in an effort to collectively find innovative solutions. DRCOG is a Regional Planning Commission per Colorado state statute, is the federally designated Area Agency on Aging (AAA), and the Metropolitan Planning Organization (MPO) for the Denver region. Our culture and values fuel and inform the work we do, and employees are rewarded with competitive compensation, generous benefits and an adaptable work environment. Sound like a good fit? We’d love to meet you!

Description of Work

This class specification represents only the core areas of responsibilities; specific position assignments will vary depending on the needs of the Division.

• DATA ANALYSIS: Organizes and maintains inputs and outputs for various internal data systems;
  
  

investigates appropriate data for specific uses; develops data pipelines and data system architecture to

standardize the data production process; safeguards protected and other confidential information; applies statistical, spatial and other analytical techniques to discover quantitative insights from data.

• VISUALIZATION AND REPORTING: Visualizes data through graphs, charts, tables, and maps to help
  
  

examine and present data as easy-to-interpret information; recommends appropriate visualization methods based on the audience and intended use; creates and maintains dashboards and other interactive visualizations that serve information to internal and external audiences. Works with subject matter experts to determine what data and analysis supports certain messages and ensures that data is used appropriately for story-telling and case-making.

• DOCUMENTATION: Documents methodology for performing calculations and measurements required formreporting to ensure exact replication; maintains data sheets and citations for all reports so they can be validated and reproduced; tracks evolving needs across programs for reporting and provides recommendations.
• SYSTEM ADMINISTRATION: Serves as the system administrator for various data systems. Assists staff with any technical issues. Works with contracted vendors to support the development system enhancements. Assists with resolving bugs and any other issues that may arise.
• Performs other duties of a similar nature and level as assigned.
• Serve as the Salesforce administrator for the Area Agency on Aging’s Salesforce Database ASPIRE.
• Serve as a regional administrator for the state’s Salesforce data system SUDS.
• Serve as an administrator for DRCOG’s Grant management system, WebGrants.
• Maintain the integration between the state’s Salesforce data system SUDS and the Salesforce ASPIRE system with support as needed by contracted Salesforce developers.
• Manage the contract between DRCOG and its contracted Salesforce developers to make updates to the Salesforce ASPIRE system.
• Prepare data reports and dashboards in various data systems for the use of internal and external partners for presentations and advocacy.
• Serve as the primary point of contact for data requests from internal staff and external partners and ensures consistency and accuracy in data presented.
• As needed, work with DRCOG Regional Planning and Development staff to develop maps and other data visualization tools.
• Monitor to ensure accuracy of data, reports, and dashboards for systems including but not limited to ASPIRE, WebGrants, and SUDS.
• Assists with monitoring the data reporting of DRCOG’s contracted service providers into the state’s data system SUDS to ensure accuracy.
• Work with compliance specialists to address any repeat compliance issues with data reporting requirements in the SUDS system.
• Assist the Manager AAA Business Operations in developing additional data reporting requirements and needs for the Federal Transit Administration Section 5310 program.
• Work on special projects and other duties of a similar nature and responsibility as assigned.
  
  

Knowledge, Skills And Abilities

• Principles and methods of qualitative and quantitative research
• Principles of statistics and forecasting
• Advanced data visualization techniques
• Effective communication techniques
• Familiarity with the needs of older adults and individuals with disabilities
• Salesforce, MySQL, or other similar databases
• Attention to detail; ability to follow documented processes for repeatable results
• Professional verbal and written communication tailored to technical and non-technical audiences
• Critical thinking, using logic and reason to solve problems
• Exceptional customer service and building rapport
• Adapting to changing needs including learning new techniques, software and scripting languages
• Working both independently and collaborating with others
• Accessing data from a variety of locations, sources, and file formats (e.g. relational databases, flat files, application programming interfaces)
• Compiling, organizing, and standardizing disparate data
• Adapting tools or developing and documenting procedures to collect, process, monitor or visualize data
• Using business intelligence tools and interactive visualization platforms
• Familiarity with basic concepts of digital accessibility, including techniques for accessible writing, presenting, remote meetings, and document creation.
  
  

Education and Experience

Bachelor’s degree in statistics, mathematics, economics, data science or another closely related field; and three years of experience OR An equivalent combination of education and experience sufficient to successfully perform the essential duties of the job such as those listed above, unless otherwise subject to any other requirements set forth in law or regulation.

STATUS: Full-time, Exempt

Licensing/Certifications

Valid Colorado Driver’s License and access to an automobile or to substantively equivalent alternative transportation.

https://www.drcog.org/sites/default/files/acc/HR-BR-BENEFITS-EN-ACC-85X11-24-05-03-V1.pdf

01

Which best describes your level of education?

• High School or GED
• Some College
• Associates Degree
• Bachelors Degree
• Masters Degree
  
  

02

How many years of statistics, mathematics, economics, data science or another closely related field experience do you have?

• Less than one year
• One to less than two years
• Two to less than three years
• Three to less than four years
• Four to less than five years
• Five to less than six years
• Six to less than seven years
• Seven or more years
  
  

03

Please describe your experience working as a Salesforce administrator. Please include information on major projects or implementation work you headed up. If you don’t have Salesforce Administrator experience, what skills do you have that would help you be successful in this role?

04

Please describe your experience with data analytics and data visualization. What tools are you familiar with and what programming languages are you familiar with, etc.?

05

Please describe a time when you had to pull data from multiple databases and compile it into a single report. How did you accomplish this task and what steps did you take to ensure the data was accurate in the final product/

06

What experience do you have working with contracted software developers to make enhancements to systems? Please include any experience working with program staff to put together requirements documentation for a scope of work and follow through to ensure the product is completed to specifications.

• Required Question