Log In
Sign Up
Position Summary:
The Database Developer is responsible for maintaining Blackbaud CRM (SAND) to ensure data consistency, including local and hosted environments. The Developer will gather, collect, transform, process, and model data to suit Federation’s needs.
Essential Duties and Responsibilities:
· Responsible for creating, updating, and maintaining database solutions related to reporting, data security, marketing and communications including but not limited to:
o Create Marketing Mail lists for use via telemarketing, direct mail, snail mail, and email.
o Create advanced query/selections/smart query/KPI’s/Dashboard.
§ Aggregates data for management analysis using SQL and SSRS
o Creates export definitions.
o Handles security for users, including permissions, roles, and defining security groups.
o Advanced query reporting for management analytics.
o Test and validate underlying report data.
· Write SQL scripts to update data that cannot be done using a global process in CRM; write SQL or other querying code to extract and manipulate data from database systems.
· Utilize .NET Framework to edit reports in CRM (V4.0+).
· Design, develop, and implement customized reports based on limitations in CRM.
· Responsible for yearly rollover process in CRM, including solicitation and donor owner team updates.
· Assist with the implementation and integration of third-party applications as they relate to CRM.
· Proactively optimize data reporting performance and data quality.
· Document, track changes, resolve issues, and maintain all required report design, enhancement, and/or modifications to CRM accordingly.
· Ensure database optimization, integrity, consistency, and security.
· Responsible for working with users and analysts to identify/interpret business needs and user requirements in order to develop proper data solutions; gather and analyze raw data from various systems and reports.
· Other duties as assigned.
Qualifications and Success Factors:
· Associate degree in a computer related field required, Bachelor’s degree in a computer related field preferred.
· Minimum of 5+ years of relevant work experience in analytics, data engineering, BI or related field required, or equivalent combination of education, experience and skills required.
· Experience with PowerBI, advanced Excel required; experience with Blackbaud CRM a plus.
· Excellent oral and written communication skills and the ability to communicate effectively with non-technical people.
· Strong organizational, time management, and workload management skills required.
· Knowledge of object oriented, relational database concepts and design and of relational database theory and structured query language (SQL).
· .Net experience.
· Experience building reports, scorecards, and dashboards.
· Ability to be productive when working independently or collaboratively.
· Ability to conduct research into systems issues and products as required.
· Analytical, problem solving, and conceptual skills.
· Attention to detail; ability to work efficiently with minimal errors.
· Ability to follow instructions and standard guidelines.
· Must be able to work off-shift hours including nights and weekends, as needed.
Work Environment:
Position is eligible to work from home at times in accordance with Federation policies. When working from home, employee must:
· Follow all Federation policies and procedures,
· Be available to other employees during Federation’s normal business hours,
· Not work from a public place (e.g. coffee shop, library, etc.) and/or join a public, unsecure wi-fi network when working with sensitive or confidential information,
· Coordinate with IT department to maintain appropriate computer equipment and connectivity.
Job Type: Full-time
Pay: $82,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Vision insurance
Schedule:
COVID-19 considerations:
Security clearance:
Work Location: Remote
