BI Developer (Contractor)
RESPEC 正在聘请一个 BI 开发人员来通过管理，开发和维护报告和分析解决方案支持公共部门合作伙伴。这个角色是实践性和高度技术的，重点放在 Google Looker (LookML) 和 SQL Server 上。你将在数据商场，仪表板和报告中工作，验证数据质量，实施业务规则，并培训技术和非技术用户。这是一个能够移动企业需求与技术执行之间的人非常适合，喜欢故障排除，并且可以独立地与中小企业和利益相关者密切协作而工作的人。关键责任 ·管理，开发，维护 Google Looker: · 用户管理，模型，仪表板，用户属性 · LookML 开发，仪表盘设计，可视化 · 构建简单/复杂的外观，并查和调整性能 · 创建和维护 SQL Server 报告服务 (SSRS) 报告。· 开发和维护 SQL Server 对象和逻辑：· T-SQL,视图，CTE,函数，存储程序 · SQL 进程/脚本将数据移动和转换到数据中心之间 · 执行数据分析和验证：· 分析数据以求质量/完整性 · 与源业务系统进行数据中心和仪表盘验证 · 实施和记录规则和流程 · 为数据和报告要求创建和执行测试案例 · 解决数据，仪表板和报告问题；响应调查请求。· 针对数据市场，仪表盘和报告的要求并记录文件。· 创建技术和最终用户文档；培训用户学习 Looker 的能力和最佳实践。· 应用适当处理敏感数据，包括识别和掩盖 PII. · 根据需要承担团队领导活动 （指导，任务分配，代码审查，优先级）. · SQL Server 强大的技能：SQL/T-SQL,视图，CTEs,功能，存储程序。· 强大的 GoogleLocker 经验，包括：· LookML 模型化 ·工具管理和用户属性 ·仪表板设计和正确的可视化选择 · 融合查询和性能调整 · 培训技术用户和非技术用户的能力 · 创建和维护 SSRS 报告的经验。·强大的数据分析技能 （业务规则，验证，测试，数据完整性）. ·已证明故障解决和根源分析能力。·优秀的沟通技巧能将业务需求转换为技术要求并解释信息。
查看英文原文
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 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, 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