BI Developer and Reporting Analyst

SPS North America • El Paso, TX

1d

About The Position

The BI Developer and 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. Local travel may be required up to 10% of the time. Duties and responsibilities may change at any time with or without notice.

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 optimization.
• Experience manipulating and analyzing large datasets from multiple systems and sources.
• Strong Excel and data-management skills.
• Ability to define and maintain KPI and metrics dictionaries to ensure consistent definitions across reports and stakeholder groups.
• Experience with report and dashboard governance, including version control, access management, row-level security, quality assurance, and documentation.
• Understanding of data privacy, security, and compliance requirements, particularly for client, operational, or financial data.
• Ability to manage multiple priorities and deliver accurate work within established timelines.
• Ability to work assigned hours determined by the manager and adhere to company policies and procedures.

Nice To Haves

• Strong working knowledge of SharePoint and AWS QuickSight.
• Experience with data warehousing or cloud data platforms such as AWS Redshift, Snowflake, SQL Server, Dataverse, or similar platforms.
• Working knowledge of ETL/ELT concepts, data pipelines, data integration, and data-transformation processes.
• Experience enabling self-service analytics by training business users, creating reusable templates, and helping stakeholders interpret dashboards.
• Experience with Agile, project intake, or requirements management, such as user stories, acceptance criteria, backlog prioritization, or report-request workflows.
• Experience supporting multiple business stakeholders or client groups with tailored reporting needs.
• Understanding of data governance, data quality, and reporting controls.
• Experience working in cross-functional environments with operations, IT, and business teams.
• Relevant certifications, such as Microsoft Certified: Power BI Data Analyst Associate or AWS analytics or QuickSight-related training.

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 enhancements to reporting tools, governance, and data visualization standards, and recommend tools, systems, or databases that could strengthen the BI program.
• 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.
• Monitor data refreshes and report performance, investigate recurring failures or slow-running reports, and coordinate with technical teams to resolve underlying issues.
• Support report publishing, distribution, and appropriate user access; gather stakeholder feedback and provide guidance on interpreting and using reporting solutions.

Benefits

• Career growth opportunities and opportunities to learn or use a variety of skills.
• Learning and development opportunities.
• Recognition programs for employees at all levels.
• Paid time off: full-time employees receive a minimum of 80 hours per calendar year; part-time and temporary employees receive a minimum of one hour per 30 hours worked. Amounts may increase based on tenure or assigned account, and approved PTO may be used for any reason.
• Employee and client referral bonuses for current employees.
• Medical, dental, and vision coverage.
• Health care and dependent care flexible spending accounts (HCFSA and DCFSA), and health savings account (HSA).
• Commuter transit and parking pre-tax plans.
• Supplemental life insurance, life insurance, accident insurance, critical illness insurance, hospital indemnity, and short-term disability.
• Legal program and identity theft protection.
• Pet discounts and pet insurance.
• Group home and auto insurance.
• Employee assistance program (EAP).
• Education discounts.
• 401(k) with matching.
• Entertainment discounts.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level