RESPEC · 12 hours ago
Business Intelligence Analyst (Contractor)
United States
Full-time, Contract
Remote
Mid LevelRESPEC is an employee-owned company that tackles complex challenges in energy transition, infrastructure resilience, digital transformation, and sustainability. They are seeking a Business Intelligence Analyst to support a public sector partner by administering, developing, and maintaining reporting and analytics solutions, with a strong focus on Google Looker and SQL Server.
Management Consulting
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)
Qualification
Required
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
Preferred
Experience assisting with data mart design and data validation frameworks
Prior lead/mentor experience in BI or analytics teams
Company
RESPEC
RESPEC is a geoscience, engineering, data, and integrated technology solutions for major industry sectors.
Founded in 1969
501-1000 employees
H1B Sponsorship
RESPEC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2023 (2)
2020 (3)
Funding
Current Stage
Late StageLeadership Team
Todd Kenner
President / CEO
Phil Welling
Chief Financial Officer
Recent News
2025-11-10
Company data provided by crunchbase