Data Systems Specialist: SQL, SSIS & Power BI

Turning Point for God; San Diego (CA); On-site; USD 45,000 - 50,000; Full time

Benefits offered by this job

Comprehensive benefits package

Health Savings Account (HSA)

Company-sponsored long-term disability

Company-sponsored life insurance

403(b) retirement plan with employer

Eleven paid holidays

Accrued vacation and sick time

Yearly paid time off

Job summary

Turning Point Ministries in Lakeside, CA is seeking a Data Systems Specialist to support operational data processing, reporting, and automation. You will manage inbound order and donor data, develop ETL via SSIS, and maintain SQL Server processes to ensure data accuracy across reporting systems.

You will also create Power BI reports, maintain documentation, and collaborate with internal departments to support data-driven decision-making and reporting needs.

Qualifications

• 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.

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

Skills

Spiritual leadership

Teamwork

Integrity

Education

Associate's degree in data processing or equivalent experience

Tools

SQL Server

T-SQL

SSIS

Power BI

Job description

Turning Point Ministries in Lakeside, CA is seeking a Data Systems Specialist to support operational data processing, reporting, and automation. You will manage inbound order and donor data, develop ETL via SSIS, and maintain SQL Server processes to ensure data accuracy across reporting systems.

You will also create Power BI reports, maintain documentation, and collaborate with internal departments to support data-driven decision-making and reporting needs.