Database Developer

A. General Description:

In this role, your primary focus will be on fulfilling the organization’s data and analytics requirements. You will play a key role in developing and maintaining robust data extraction and reporting processes, encompassing SQL query writing, stored procedures, views, and SSIS packages. Additionally, you will contribute to ensuring data quality, crafting technical documentation, and undertaking various data stewardship responsibilities. Furthermore, you will be instrumental in offering end-user support, diagnosing issues, implementing solutions, and documenting procedures.

B. Responsibilities:

1. Assistance in utilization of ASHA’s data assets through:
   • Extraction of data using database queries;
   • Data process development using stored procedures, functions, and views;
   • Curation of datasets to support Business Intelligence processes.
2. Assessment and fulfillment of analytics needs including:
   • End-user support for the Association Management System (AMS);
   • Diagnoses and troubleshooting problems with existing queries and reports;
   • Technical assistance to end users.
3. Write and maintain technical process documentation for applications and processes. 
4. Process list requests for end users through the support of a list cutting tool or development of custom queries.  
5. Work in concert with ASHA’s Data Architect to transform data and create and manage SSIS packages between internal applications and ASHA data warehouses or data marts.
6. Assist with creation and maintenance of data pipelines as needed for the transfer of data among ASHA systems, both internal and external.
7. Create and maintain SQL jobs and ETL processes.

C. Contacts:

Personal contacts are with all levels of National Office staff. The purpose of the contact is to determine user programming and data output requirements, diagnose software and hardware problems, and coordinate installations and other projects. Contacts may also be made with outside vendors regarding information technology. You will work closely with ASHA’s Data Architect and Software Development Team to create schedules, set performance thresholds, and control project scope. The incumbent works closely with Business Analysts to develop user requirements and specifications and to conduct application testing.

D. Freedom to Act:

Responsibilities at this level are predicated on a degree of independence and freedom from supervisory control. The individual is free to follow his/her own judgment in structuring and developing assigned programming projects following Information Systems programming and methodologies and in accordance with Web and Information Systems quality assurance standards.

The individual reports to the Director of Software Development who monitors technical performance and provides necessary coaching. The individual takes direction from the Director of Software Development and Data Architect for assignment of tasks, implementation of projects, establishment of work priorities, the review project requests to provide level-of-effort and scheduling estimates, and to identify personal and professional development goals.

Completed work is reviewed for its effectiveness in meeting user requirements, accuracy of estimated time frames and issue resolutions, and achievement of productive and harmonious relationships in coordinating the projects with technical staff, consultants, users, and management.

E. Qualifications – Education, Experience, Knowledge, Skills:

Knowledge and skills typically acquired through:

• Obtaining a bachelor's degree in computer science, Information Systems Management, or a related field,
• A minimum of two (2) years of relevant experience.

Scope and depth of technical skills/knowledge:

• Demonstrated proficiency in writing SQL queries, stored procedures, functions, views and SSIS packages. 
• Experience with any or all of the following programming languages and/or tools: Visual Studio, SQL Server Reporting Services, SQL Server Management Studio, SQL Server Integration services, BIML, Microsoft Azure, C#, and/or Power BI; 
• Experience in data warehouse/data mart development and business intelligence reporting;
• Experience with Microsoft OSs and 365 productivity tools;
• Demonstrated experience supporting a data and analysis life cycle;
• Experience preferred in the curation of data sources for use in BI reporting;
• Demonstrated ability to quickly learn new data storage solutions and approaches;
• Demonstrated ability to analyze and document user requirements;
• Familiarity with Azure Data Factory and pipeline creation or maintenance would be advantageous