The Data Systems Specialist manages inbound order and donor data, develops and maintains SQL Server and SSIS ETL processes, and supports automated import and reconciliation workflows. Responsibilities include scrubbing and validating orders, creating Power BI reports and semantic models, executing month-end scripts, and collaborating with internal departments on data accuracy and reporting. The role requires proficiency in SQL Server, T-SQL, SSIS package development, Power BI, and Excel, with an emphasis on data validation, documentation, and operational troubleshooting.

This role leads enterprise-level analytics and visualization initiatives, requiring 7+ years of BI and data visualization experience. The candidate will design executive dashboards and scorecards using Power BI and Tableau, establish visualization standards and governance, translate business requirements into actionable insights, and mentor analysts on best practices. The position requires deep expertise in data modeling, SQL, dashboard architecture, and data storytelling, with strategic responsibility for the organization's long-term visualization strategy and potential evolution into a Visualization Architect role.