Reporting/Database Manager

Reporting to the Senior Data Manager, the Reporting Manager works as a member of the Research, Evaluation, and Data team to maintain, oversee, and improve comprehensive program data infrastructure, systems, and reporting capabilities and to work with other members of the Data Team as well as staff members from other departments to implement an overarching strategy for data collection, integration, management and analytics. These responsibilities include managing quality in data collection and reporting, conducting quantitative analyses, and creating and running descriptive reports, in collaboration with internal teams and external stakeholders, including consultants, funders, program officers, community-based partners, government representatives, and the general community. This position is full time and exempt.

Essential Functions:

Reporting to the Senior Data Manager, the Reporting Manager will:

• Develop and maintain relevant reporting using business intelligence and data visualization tools (e.g. SSRS, Crystal Reports, Excel Power Pivot, Power BI, Tableau, or Qlik) to meet program needs.
• Develop and maintain documentation of data collection via ETL process, data cleansing, application/user maintenance, reporting processes, and reporting nomenclature
• Monitor data quality, and lead collaborative efforts with service providers and internal staff to improve quality.
• Participate in data collection efforts from health records systems.
• Conduct analyses to assess program impact and inform program development using data manipulation language in MS SQL Server, analysis (e.g. SAS, SPSS) or mapping (e.g. ArcGIS) software tools.
• Work with both data and program team members to identify issues related to data, as well as to propose and develop upgrades to deal with technical issues and enhance efficiency as needs evolve.

KNOWLEDGE, SKILLS, AND ABILITIES

• Database Administration: Experience performing variety of DB Administration tasks, including performance optimization, indexing, table constraints, and managing user permissions and DB security.
• Data Warehousing: Demonstrable knowledge of data warehousing concepts such as Dimensional Modeling, Slowly Changing Dimensions, and Git concepts and terms, among others.
• Reporting: Experience working with SQL Server Reporting Services (SSRS), report browser deployment and maintenance, and creating complex parameterized reports.
• ETL: Demonstrable advanced knowledge of SQL Server Integration Services (SSIS), data migration concepts, data profiling and cleansing, and implementing complex script tasks via visual studio and c#. Experience working with variety of data sources and targets including but not limited to: Flat files, Excel, ADO NET, ODBC, and OLE DB.
• Other Specialized Data Platforms, Applications, and Software: Prefer knowledge and experience with relevant programs including Javascript/jQuery, Python/Django, PostgreSQL, Amazon Web Services (AWS) such as RDS, VPC, EC2, and Security Groups, among others.
• Demonstrated knowledge and experience with HIPAA security and privacy guidelines strongly preferred, along with experience working with Medical and Public Health records and different EMR systems.