RESPEC
Achieving the impossible. Transforming our clients' visions into reality.
Business Intelligence Analyst – Contractor
Location
New Mexico
Posted
44 days ago
Salary
Not specified
Bachelor DegreeEnglishSQL
Job Description
• 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.
• 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).
Job Requirements
- 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.
- 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.
Benefits
- Health insurance
- 401(k) matching
- Flexible work arrangements
- Professional development
- Paid time off