Application Development and Business Intelligence Manager

Self-Help

37d

About The Position

WHO We Are: Self-Help started in 1980 with a focus on economic inequality especially in communities that have faced systemic barriers in building wealth. At the core of what Self-Help does is a drive to create and protect ownership and economic opportunity. In other words, we’re committed to economic justice! Economic Justice means that all communities have the basic infrastructure they need to thrive, from high quality schools to grocery stores selling fresh foods resources that support opportunity at a neighborhood level regardless of demographics, income, or wealth. Since our founding, we’ve constantly sought to find new ways to pursue greater economic justice: from providing fair and affordable loans, to working with partners to demand that lawmakers change unjust policies. We're seeking an Application Development and Business Intelligence Manager to join our team in Durham! Self-Help is a national community development financial institution with a mission to create economic opportunity by providing financial services and lending to working families, small businesses, and communities in historically underserved markets. Data collection, analysis, and reporting are critical to our success. We are passionate about using data to measure the effectiveness of our impact on individuals and communities, to guide our designs on new financial product innovations, and to benchmark operational efficiencies. This manager will lead other developers that support business and operational teams with these challenges and will have a meaningful impact on the growth and effectiveness of the organization. The successful candidate will also be responsible for supervising and participating in the development and support of a critical insourced business intelligence database. You will work in a supportive and collaborative team environment that promotes individual growth. If you are interested in this challenge and meet half or more of the requirements and are excited to and capable of learning the rest, then we encourage you to apply. We would love to talk with you.

Requirements

Bachelor’s degree in Computer Science, Software Engineering, Data Science, or equivalent related experience.
3 years’ experience with SQL development and SQL Server administration.
Experience with MySQL running on a Linux variant a plus.
Programming experience in .NET (C# or VB.NET) or a minimum of 3 years’ experience in other mainstream language (Python, Ruby, Java, C/C++, PHP).
Development and administration experience in ASP.NET MVC or Blazor on IIS, or significant experience in another web development platform (Java, PHP on LAMP).
Recent experience with Agile development methodology and scrum techniques.
Understanding of business intelligence and data warehousing concepts and best practices, and general database design principles.
Prior supervisory experience a plus.
Ability to build and maintain productive relationships throughout the organization.
Ability to effectively hire, develop, and motivate staff.
Strong commitment to our mission – creating economic opportunity for traditionally underserved communities.
Preference for working in organizations that place priority on teamwork and collaboration.
Willingness and ability to learn basic concepts around lending and financial services.
Ability to balance concurrent projects and provide leadership in a decentralized environment.
Strong project management and problem-solving skills.

Responsibilities

Database Management Be an active participant in the ongoing development and operation of in-house business intelligence data warehouses and reporting platforms, and supervise staff with the below responsibilities.
Design database schema based on business data requirements.
Implement security controls to protect member sensitive information.
Add and manage internal and external data feeds from new source systems, including identifying data elements, building and maintaining ETL processes, and utilizing master data management (MDM) for quality control.
Provide operational database support, including ensuring sufficient performance and capacity, and data protection via backups and disaster recovery planning.
Maintain an SSRS and Power BI reporting platform.
Author ad hoc and recurring operational Power BI dashboards and reports per business specifications.
Software Development Be an active participant in the development of the code base supporting a key in-house MySQL application, and supervise staff with the below responsibilities.
Gather requirements for new features from the business team.
Maintain an application architecture and author code within that framework.
Test new code, build client install packages, and implement into production.
Maintain code in a secure source code repository.
Plan and schedule work using a development roadmap.
Provide operational and system administration application support, including patching and upgrading MySQL.
Supervisory Hire, develop, and motivate staff to provide highest level of commitment to Self-Help.
Interface with key system and database stakeholders on internal teams to identify and translate requirements into database and application design.
Manage the software vendors that are key to the applications.