BI Developer (Contractor)

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.