BI Developer (Contractor)

Job DescriptionRESPEC 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 ResponsibilitiesAdminister, develop, and maintain Google LookerUser administration, models, dashboards, user attributesLookML development, dashboard design, visualizationsBuild simple/complex Looks, merge queries, and tune performanceCreate and maintain SQL Server Reporting Services (SSRS) reports.Develop and maintain SQL Server objects and logic:T-SQL, views, CTEs, functions, stored proceduresSQL processes/scripts to move and transform data between data martsPerform data analysis and validation:Analyze data for quality/completenessValidate data marts and dashboards against source systemsImplement and document business rules and processesCreate and execute test cases for data and reporting requirementsTroubleshoot 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 PIITake on team leadership activities as needed (mentoring, task assignment, code reviews, prioritization).QualificationsStrong SQL Server skills: SQL/T-SQL, views, CTEs, functions, stored procedures.LookML modelingTool administration and user attributesDashboard design and correct visualization selectionMerge queries and performance tuningAbility to train both technical and non-technical usersExperience 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 HaveExperience assisting with data mart design and data validation frameworks.Prior lead/mentor experience in BI or analytics teams.What Success Looks LikeReliable, 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.Additional InformationAll your information will be kept confidential according to EEO guidelines.J-18808-Ljbffr