BI Developer (Contractor)

Summary

RESPEC is a 100% employee-owned company that tackles complex challenges in energy transition, infrastructure resilience, digital transformation, and sustainability. They are seeking a BI Developer to administer, develop, and maintain reporting and analytics solutions, focusing on Google Looker and SQL Server while collaborating closely with stakeholders.

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)

Skills

• 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
• Experience assisting with data mart design and data validation frameworks
• Prior lead/mentor experience in BI or analytics teams

Qualifications

Must Haves

• 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