Database Developer

Description

The purpose of this position is to help support the Data Analytics (DA) Team with report development and support for ASHA databases, including designing and developing queries, stored procedures, views, datasets for analysis, and data warehouse development. This position also assists the Data Analytics Team with data quality assurance, development of technical documentation, and other data stewardship tasks.  The incumbent will also provide end-user support, including problem diagnosis, correction, and documentation. To be successful in the position a candidate will require strong SQL skills, the ability to work both independently and as part of a team, and be excited to utilize data for decision-making.

Responsibilities

1. Assist the DA Team in utilizing ASHA’s data assets through:
   1. Extraction of data using database queries;
   2. Data process development through the use stored procedures, functions, and views;
   3. Curation of datasets to support BI processes.
2. Provide end-user support for the Association Management System (AMS), including fielding requests and gathering requirements from end users for advanced database queries and reports.
3. Work closely with the DA Team to assess and meet data analytics needs including:
   1. End-user support for the Association Management System (AMS);
   2. Diagnoses and troubleshoots problems with existing queries and reports;
   3. Technical assistance to end users.
4. Write and maintain technical process documentation for DA Team applications and processes.
5. Assist the DA Team in processing list requests for end users through the support of a list cutting tool or development of custom queries.
6. Work in concert with ASHA’s Data Architect to convert data and create SSIS packages between internal applications and ASHA data warehouses or data marts.
7. Assist the DA Team with data stewardship and data management efforts as a subject matter expert.