BI Developer and Reporting Analyst

spsnorthamerica; El Paso (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

The BI Developer & Reporting Analyst at SPS North America designs, develops, and supports scalable reporting and analytics to enable informed decisions. You will partner with technical and non-technical stakeholders to define metrics and translate complex data into actionable insights using SQL, Power BI, SharePoint, and AWS QuickSight.

The role focuses on building dashboards, validating data from multiple sources, and maintaining data quality while supporting governance, security, and

Qualifications

• Bachelor's degree in IT/CS/Business Analytics or related field, or equivalent practical experience.
• 3–5 years in BI/reporting or data analytics.
• 2–3 years hands-on Power BI and SQL experience, with intermediate-advanced SQL proficiency.
• Power BI data-modeling including Power Query, DAX, semantic models and measures.

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.
• Build user-friendly reporting solutions using SharePoint, Power BI, and AWS QuickSight.
• Partner with stakeholders to gather requirements, define metrics, and translate business needs into technical deliverables.
• Analyze trends and performance data to identify insights and support decision-making.
• Ensure reports are timely, easy to interpret, and meet audience needs across functions.
• Troubleshoot reporting issues, resolve data discrepancies, and propose improvements to reporting efficiency.
• Maintain documentation for report logic, data sources, calculations, and distribution processes.
• Support enhancements to reporting tools, governance, and data visualization standards.

Skills

Analytical thinking

Translate business questions into data

Written and verbal communication

Data storytelling and visualization

Organization and time-management

Data confidentiality and governance

Independent work

Customer/stakeholder management

Continuous-improvement mindset

Education

Bachelor's degree in Information Technology/Computer Science/Business Analytics or related field

Tools

Power BI

SQL

SharePoint

AWS QuickSight

Job description

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 coordinate with relevant technical teams to resolve underlying issues.
• Support report publishing, distribution, and appropriate user access; gather stakeholder feedback and provide guidance that helps users interpret and effectively use available reporting solutions.

Competencies

• Strong analytical thinking, attention to detail, and problem-solving skills.
• Ability to translate business questions and reporting needs into accurate, practical data solutions.
• Strong written and verbal communication skills, including the ability to explain technical information and data insights in clear, accessible language.
• Data storytelling and visualization skills, including the ability to summarize trends, risks, and recommended actions for stakeholders.
• Strong organization and time-management skills, with the ability to manage multiple requests and priorities in a fast-paced environment.
• Commitment to data accuracy, confidentiality, documentation, governance, and responsible handling of client, operational, and financial information.
• Ability to work independently while collaborating effectively with cross-functional teams.
• Service-oriented approach, responsiveness, and professional stakeholder management.
• Continuous-improvement mindset, with an interest in automation, reusable reporting solutions, and reporting efficiency.

Qualifications and Education Requirements

• Bachelor's degree in Information Technology, Computer Science, Business Analytics, Data Analytics, or a related field, or equivalent practical experience.
• 3 to 5 years of experience in report writing, business intelligence, or data analytics roles.
• At least 2 to 3 years of hands-on Power BI and SQL experience, with intermediate to advanced SQL proficiency, including joins, aggregations, stored procedures, query optimization, and troubleshooting data discrepancies.
• Power BI data-modeling experience, including Power Query, DAX, semantic models, measures, calculated columns, and report-performance optimizati