Business Intelligence Analyst (Contractor)

RE/SPEC Inc.•Albuquerque, NM

About The Position

RESPEC is hiring a Business Intelligence Analyst (PED) to support a public sector partner by administering, developing, and maintaining reporting and analytics solutions. This role is hands-on and highly technical, with a strong focus on Google Looker (LookML) and SQL Server. You’ll work across data marts, dashboards, and reports—validating data quality, implementing business rules, and training both technical and non-technical users. This is a great fit for someone who can move between business needs and technical execution, enjoys troubleshooting, and can work independently while collaborating closely with SMEs and stakeholders.

Requirements

Strong SQL Server skills: SQL/T-SQL, views, CTEs, functions, stored procedures.
Strong Google Looker experience, including:
LookML modeling
Tool administration and user attributes
Dashboard design and correct visualization selection
Merge queries and performance tuning
Ability to train both technical and non-technical users
Experience creating and maintaining SSRS reports.
Strong data analysis skills (business rules, validation, testing, data completeness).
Proven troubleshooting and root-cause analysis ability.
Excellent communication skills—able to translate business needs into technical requirements and explain technical concepts clearly.
Detail-oriented, self-directed, quick to learn new systems, and team-oriented.

Nice To Haves

Experience assisting with data mart design and data validation frameworks.
Prior lead/mentor experience in BI or analytics teams.

Responsibilities

Administer, develop, and maintain Google Looker
User administration, models, dashboards, user attributes
LookML development, dashboard design, visualizations
Build simple/complex Looks, merge queries, and tune performance
Create and maintain SQL Server Reporting Services (SSRS) reports.
Develop and maintain SQL Server objects and logic
T-SQL, views, CTEs, functions, stored procedures
SQL processes/scripts to move and transform data between data marts
Perform data analysis and validation
Analyze data for quality/completeness
Validate data marts and dashboards against source systems
Implement and document business rules and processes
Create and execute test cases for data and reporting requirements
Troubleshoot data, dashboards, and reporting issues; respond to investigation requests.
Elicit and document requirements for data marts, dashboards, and reporting.
Create technical and end-user documentation; train users on Looker capabilities and best practices.
Apply appropriate handling of sensitive data, including recognizing and masking PII.
Take on team leadership activities as needed (mentoring, task assignment, code reviews, prioritization).