Big challenges need bold thinkers.
If you’re someone who sees problems as opportunities, you’ll thrive here. RESPEC is 100% employee-owned, which means we take ownership of every challenge. Here, your ideas drive real solutions. Since 1969, we’ve tackled complex challenges in energy transition, infrastructure resilience, digital transformation, and sustainability.
At RESPEC, you’ll work alongside clients to take on critical problems. Depending on your expertise, you might design infrastructure in remote locations, develop renewable energy solutions for global projects, or apply data-driven technology to improve mining and water systems.
We bring deep technical knowledge, real-world experience, and a commitment to work that matters. If you're looking for a place where your contributions have real impact, you’ll fit right in.
We do not accept unsolicited resumes from third-party recruiters.
Job DescriptionRESPEC 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.
Key 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).
- 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 Have
- Experience assisting with data mart design and data validation frameworks.
- Prior lead/mentor experience in BI or analytics teams.
What Success Looks Like
- Reliable, accurate dashboards and reports that reconcile to source data.
- Well-structured Looker models and dashboards that perform efficiently and are easy for users to navigate.
- Clear documentation and effective training that increases adoption and reduces support burden.
- Consistent, secure handling of sensitive data (PII) across reports and analytics products.
All your information will be kept confidential according to EEO guidelines.
Top Skills
What We Do
In a world where one superhero can handle almost any problem, our entire team of award-winning technology experts is on a mission to make your business better.
With extra vision to see solutions that others can’t and vast knowledge to bridge the gaps that others don’t, we’re transformers with the know-how to solve the world’s hardest problems. At RESPEC, we thrive on technology and making our clients successful. This is why we do what we do.
From the depths of a cavern to the heights of a volcano, from an antiquated computer system to a business in dire need of re-engineering, our technical and business experts find solutions for extreme situations... like the time we cleansed and migrated 100 million rows of legacy data or the time we protected Mt. Rushmore.
Know-How is Everything.
We use our resourcefulness and vast experience to solve problems. It’s called know-how. And when you have it, problems aren’t problems at all. Know-how defines the core of who we are. It is how our clients see us. Know-how speaks to ingenuity, aptitude, and skill—it is not merely knowledge; it is knowledge on how to get things done. Imagine having access to a think tank with hundreds of diversely talented engineers, scientists, programmers, and developers under one roof—that’s RESPEC. Each team member is highly trained and skilled in understanding and applying the laws of a specific universe to solve any kind of problem. That’s why we have to talk about our team in terms of superheroes.
