Data Analyst

Description

Job Description:

The Transportation and Financial Solutions Division is looking for a Data Analyst to join the DC Curbside Asset Management project team. The candidate will be responsible for performing tasks relating to Database Management System applications, including definition, design, structure, documentation, upgrades, long-range requirements, operational guidelines, and protection

Primary Responsibilities Include:
  • Perform database administration tasks including installation, configuration, monitoring, maintenance, tuning, and backup/recovery using Microsoft SQL Server.
  • Perform database maintenance tasks such as dumps/uploads and upgrades.
  • Import data into a Microsoft SQL environment using scripts or other automated methods.
  • Monitor data integrity, manage data cleaning/quality control, and perform data validation and integrity checks.
  • Write and manage complex SQL data queries, stored procedures, schema, trigger, etc. from end user requirements.
  • Work with SAS and Microsoft Access in conjunction with SQL to merge datasets from various formats and sources into a single cohesive repository for the synthesis of project specific datasets.
  • Maintain compliance with applicable security protocols.
  • Ensure database availability.
  • Consistently meet task deadlines while maintaining high quality of deliverables.
  • Author procedural and standards documents for databases.
  • Promote adherence to database policies within the program.
  • Perform troubleshooting investigations of databases and coordinate resolution of problems.
  • Stay abreast of Microsoft SQL server updates and implement plan for rolling out relevant features and upgrades.
  • Transfer paper-based records from external sources onto computerized systems.
  • Build and manipulate analytic datasets.
  • Perform basic data analyses independently and support senior NSMRL staff on complex analyses, including data modeling.
  • Interact and effectively communicate both written and orally with a wide variety of people.
  • Perform other administrative, analytic, and database duties as needed to support DC Curbside Asset Management Contract.
  • Adhere to security procedures to protect the database from accidental or intentional damage or loss. Perform backup of databases, as needed.
  • Development and implementation of applications for data retrieval and entry.
  • Document database design and development.
  • Design and distribute free standing as well as ad hoc reports.


Required Qualifications:
  • Bachelor's degree related to Computer Science, Information Systems, or equivalent; and have a minimum of 4+ years hands-on experience in a database developer role.
  • Server Database development, design and implementation; cloud drives and storage (e.g. Amazon Web Service); and data analysis.
  • Relational database experience within a multi-tiered environment.
  • Microsoft SharePoint (Knowledge Sharing Network), Microsoft Excel, and Microsoft Access experience.
  • Candidates must demonstrate the ability to interact and effectively communicate both written and orally with a wide variety of people.


Preferred Qualifications:
  • Proficient with programming languages such as Structured Query Language (SQL) and/or Python.
  • Some knowledge of CityWorks platform and Tableau Analytic software.


Pay Range: