Data Systems Specialist

Position Summary:

The Data Systems Specialist reports directly to the Director of Data Systems & Insights and supports operational data processing, reporting, and automation functions. This position manages inbound order and donor data; develops and maintains SQL Server and ETL processes; supports automated import and reconciliation workflows; and ensures data accuracy across reporting systems.   This position also develops Power BI reports, maintains documentation, executes operational tasks, and collaborates with internal departments to support business processes and data-driven decision-making.

Responsibilities:

• Scrub, validate, and process orders from the web, mail, and external call centers into Studio Enterprise
• Develop and maintain SSIS packages for loading, validating, and transforming raw operational files
• Develop and maintain SQL Server processes used in imports automation, including stored procedures, views, and validation logic
• Support automated processing of external call center data, including media attribution, discount handling, premium/purchase classification, and offer-rule logic
• Process Bi-monthly Autopay
• Support daily imports operations, including order cancellations, exception handling, and ETL reconciliation

• Keep all documentation up to date
• CC5/EFT5 Auto-giving processing and related reporting. Create, maintain, and validate paginated reports, ad-hoc data extracts, and downloadable report files for internal departments
• Develop and maintain Power BI reports, semantic models, and business intelligence outputs, including data modeling, data validation, and user-facing report support
• Execute and validate assigned month-end scripts and reports
• Collaborate with Customer Service, Finance/Accounting, and Media to gather report requirements, resolve process issues, and support imports changes

Core Competencies:

• Spiritual Leadership: Demonstrates a Christ-centered approach to work and relationships.
• Teamwork: Builds positive and supportive relationships within the ministry, including employees, partners, and the community.
• Integrity: Maintains a high standard of ethical and moral conduct.

Qualifications and Experience:

• Associate's degree in data processing or equivalent experience
• Proficiency in understanding assigned operational processes
• Proficiency in Microsoft Office products – Excel, Word, PowerPoint
• Proficiency in SQL Server and T-SQL
• Proficiency in SSIS package development, maintenance, and troubleshooting
• Proficiency in Power BI Report development, semantic models, dataset optimization, and business intelligence reporting
• Must be able to follow complex Boolean logic sequences and know resident data sufficiently for self-checking extracts and reports for accuracy

Working for Turning Point – What to Expect:

Turning Point for God is committed to creating a dynamic culture that reflects our traditional Christian values and supports our employees’ God-given and unique abilities and skills. Our organization hires employees who share our Christian values and hold to beliefs that are not in conflict with Turning Point’s Employee Statement of Faith.

Other:

• Position is non-exempt, full-time at Turning Point International Headquarters in Lakeside, CA.
• The expected salary for this position is $33 to $36 an hour. The actual compensation offered will depend on a variety of factors, including qualifications, experience, skills, and location. In addition to base salary, we offer a comprehensive benefits package.
• Must be a like-minded believer and share our passion to deliver the unchanging Word of God to an ever-changing world.

Benefits:

• Generous medical, dental, and vision insurance, with voluntary supplemental plans
• Health Savings Account (HSA) option
• Company-sponsored long-term disability insurance and short-term (outside of CA)
• Company-sponsored life Insurance
• 403(b) retirement savings plan with employer contribution
• Eleven paid holidays
• Accrued vacation and sick time
• Yearly paid time off