Job Description
RESPEC 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).