BI Developer and Reporting Analyst

The posting, as SPS North America wrote it

Job Title : BI Developer and Reporting Analyst
Reports To : The BI Developer and Reporting Analyst will report to IT Supervisor/Manager, IT Director, or equivalent leadership.

Job Overview

The BI Developer & Reporting Analyst designs, develops, and supports scalable reporting and analytics solutions that enable informed business and operational decision-making. The role partners with technical and non-technical stakeholders to define reporting requirements, establish consistent metrics, and translate complex data into accurate, actionable insights. Using SQL, Microsoft Power BI, SharePoint, AWS QuickSight, and related data platforms, the position integrates and validates data from multiple sources; develops dashboards, reports, and semantic models; resolves data and reporting issues; and improves reporting performance and automation. The role also supports data quality, security, governance, documentation, and visualization standards while recommending enhancements to the BI environment for SPS clients and internal stakeholders.
The position is expected to deliver accurate, timely, understandable reporting and analytics while maintaining appropriate data quality, confidentiality, and service standards.

Duties and Responsibilities

• Develop, maintain, and distribute recurring and ad hoc reports, dashboards, and visualizations for business and operational stakeholders.
• Extract, cleanse, validate, and manipulate data from multiple sources to ensure reporting accuracy and integrity.
• Use SharePoint, Microsoft Power BI, and AWS QuickSight to build user-friendly reporting solutions and data views.
• Partner with stakeholders to gather reporting requirements, define metrics, and translate business needs into technical deliverables.
• Analyze trends, performance results, and operational data to identify insights and support decision-making.
• Ensure reports are delivered on time, are easy to interpret, and meet audience needs across multiple functions.
• Troubleshoot reporting issues, resolve data discrepancies, and recommend process improvements to enhance reporting efficiency.
• Maintain documentation for report logic, data sources, calculations, and distribution processes.
• Support ongoing enhancements to reporting tools, governance, and data visualization standards; recommend tools, systems, or databases that could strengthen the BI program for SPS clients and stakeholders.
• Support report and dashboard quality assurance, appropriate access controls, and consistent use of approved metrics and definitions.
• Communicate findings, limitations, risks, and recommended actions clearly to technical and non-technical audiences.
• Test and validate reports, dashboards, calculations, and data outputs before publication and following updates to help ensure results are accurate, consistent, and aligned with business requirements.
• Monitor data refreshes and report performance, investigate recurring failures or slow-running reports, and coordinat

[…]
sex, sexual and reproductive health choices, national origin, age, disability, genetics, military status, gender identity or expression, sexual orientation and/or any other status protected by applicable law.

Colorado only: We accept applications for an expected minimum of 5 days from the date it is posted. The posting may remain open longer as needed to ensure a robust and inclusive applicant pool.

To ensure a fair and authentic interview process, applicants may not use AI tools or any other form of real-time assistance during interviews. SPS team members may use transcription or note-taking technology solely to support accurate interview documentation. No AI or automated decision-making tools are used to screen, assess, or select candidates for this role. SPS uses the Greenhouse Applicant Tracking System to facilitate application management and recruiting workflows. Human recruiters and hiring managers review applications and exercise independent judgment throughout the hiring process.

SPS offers reasonable accommodations in the hiring and employment process for individuals with disabilities. If you need assistance in the application or hiring process to accommodate a disability, you may request an accommodation at any time.

To view our privacy policy, click on the link below: Data Privacy Statement

Acknowledgement Section: By submitting an application, by hitting "Submit Application", you certify that the information contained in this application is true and complete. You attest to the fact that the answers provided are correct to the best of your knowledge and ability. You certify that you have not knowingly withheld any information that might affect your chances for hiring. You understand that any false information or omission (including any misstatement) on this application or on any document used to secure this employment can be grounds for rejection of application or, if you are employed by SPS can be grounds for immediate termination from this company.