Bi Developer

[RESPEC](https://himalayas.app/companies/respec) is hiring a **BI Developer** 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. ### Big challenges need bold thinkers. If you’re someone who sees problems as opportunities, you’ll thrive here. **[RESPEC](https://himalayas.app/companies/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](https://himalayas.app/companies/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.** Originally posted on [Himalayas](https://himalayas.app)