SQL Server/Applications Developer

Ministry Support Division

Reports to: Director, Systems & Data Integration 

FLSA Exempt Employee

Monday-Friday; 8-5

Summary. The SQL Server/Applications Developer supports the strategic goals of the ministry across multiple SQL based systems including VOM's Donor Management System. This position also provides reporting, problem solving and data export in support of SDI goals, enabling the ministry to make informed decisions, solve problems, identify inefficiencies and assess performance over time.

Subordinate Titles and Scope of Supervisory Responsibility. None.

Core Duties

1. Maintain mission critical database systems.
2. Assist the Senior Software Engineer in supporting enterprise applications: Donor Management System, shipping system, receiving system, accounting system, other enterprise SQL based systems. This includes applying maintenance modifications, creating additional modules and automating manual tasks as needed.
3. Analyze complex problems and implement solutions and/or workarounds.
4. Work with architecture, application development, IT security, and operations to help achieve a state-of-the-art environment that meets current and future ministry objectives.
5. Assist with database support and maintenance.
6. Assist in the integrity, security and availability of multiple SQL server databases and systems.
7. Review business data requirements, database designs and database access.
8. Create and maintain SQL stored procedures for reporting, data analysis and modification. Fine-tune stored procedures for optimal performance.
9. Verify the integrity of the data, finding any inconsistencies, and perform data cleaning.
10. Assist with the importing of bulk data into the Donor Database.
11. Support the following SDI data reporting and data extraction processes and research.
12. Utilize the existing reporting tools and custom segmentations to collect and analyze large, complex sets of data from multiple sources; then reorganize/report/present data to stakeholders at their level of understanding or to an automated process in an easily interpreted format.
13. Provide historical data reporting by developing new and maintaining existing reports.
14. Respond to ad hoc information requests, assisting with the evaluation/summary of data, and communicate results to other VOM departments.
15. Provide support for data exports and mailings from the Donor Database.
16. Support VOM Marketing strategies through best practices and communication.

a. Brainstorm with SDI team/VOM staff for best practices/processes in support of marketing strategies.

b. Promote use of and assist in maintaining the SDI ticket system.

Skills and Experience  

1. [Required] Bachelor's degree in Computer Science or related field.
2. [Required] 2 years of experienced designing and implementing SQL-based applications. 
3. [Required] Must be able to prioritize multiple projects, meet multiple overlapping deadlines, adapt to change and work efficiently under pressure with excellent attention to detail.
4. [Desired] Knowledge of database design, terminology and structures. Ability to write and troubleshoot SQL-stored procedures, use temp tables and resolve data issues. 
5. [Desire] Proficient using SQL scripting and Microsoft Excel to analyze data, create reports and extract data from database systems. Knowledge of SQL reporting services, C#, Powershell, web development, Power BI, Statistical Software and data warehousing.
6. [Desired] Ability to create queries, reports and summaries from accumulated data. Ability to read, analyze and interpret requirements, technical procedures, and ministry project specifications

Working Conditions

1. Typical office environment and hours with some flexibility. Ability to support after hours implementations.
2. [Required] Must live in the Tulsa area and office at VOM’s headquarters. 

Special Requirements. 

1. Discreet and careful communication with respect to keeping VOM work- and personnel-related information confidential. Donor PII and PCI confidentiality and compliance is required.
2. Must be a biblical disciple.
3. Must participate in the spiritual life of the organization.
4. Agree with and adhere to the VOM Statement of Faith.
5. As allowed under the Americans with Disabilities Act, the employee must be able to perform the essential functions of the job with or without accommodation.