Data Systems & BI Specialist (SQL, SSIS, Power BI)

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

Benefits offered by this job

Generous benefits package

Health, dental, vision insurance

401(k)

Job summary

Turning Point Ministries seeks a Data Systems Specialist to manage data processing, reporting, and automation. You will develop and maintain SQL Server and ETL processes, build Power BI reports, and ensure data accuracy across reporting systems.

Collaboration with Finance, Customer Service, and Media is essential to support data-driven decisions. Responsibilities include parsing orders, maintaining SSIS, handling imports, and creating paginated reports.

Qualifications

• Proficiency in SQL Server and T-SQL
• Experience with SSIS package development and maintenance
• Experience building Power BI reports and semantic models
• Ability to design data models and BI outputs

Responsibilities

• Scrub, validate, and process orders from multiple channels into Studio Enterprise
• Develop and maintain SSIS packages for data loading and transformation
• Develop and maintain SQL Server processes, stored procedures, views, and validation logic
• Support automated processing of external data and reporting
• Create and validate paginated reports and ad-hoc data extracts
• Develop Power BI reports and data models for stakeholders
• Execute month-end scripts and reports
• Collaborate with Finance, Customer Service, and Media to gather requirements and support imports changes

Skills

SQL Server

T-SQL

SSIS

Power BI

Data modeling

ETL

Excel

Word

PowerPoint

Education

Associate's degree

Tools

Studio Enterprise

Job description

Turning Point Ministries seeks a Data Systems Specialist to manage data processing, reporting, and automation. You will develop and maintain SQL Server and ETL processes, build Power BI reports, and ensure data accuracy across reporting systems.

Collaboration with Finance, Customer Service, and Media is essential to support data-driven decisions. Responsibilities include parsing orders, maintaining SSIS, handling imports, and creating paginated reports.