Business Intelligence Analyst (Contractor)
Share
Job Location:
Albuquerque, NM - USA
Monthly Salary:
Not Disclosed
Posted on:
2 hours ago
Vacancies:
1 Vacancy
Job Summary
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. Youll work across data marts dashboards and reportsvalidating 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).
Qualifications :
- 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 skillsable 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.
Additional Information :
All your information will be kept confidential according to EEO guidelines.
Remote Work :
Yes
Employment Type :
Contract
Key Skills
- Business Intelligence
- Cognos
- SQL
- Power BI
- QlikView
- Data Visualization
- ssrs
- Tableau
- SSIS
- Data Modeling
- Data Warehouse
- Data Analysis Skills
About Company
RESPEC seeks a Principal Consultant for our office in Albuquerque, NMFounded in 1969, RESPEC is a global, 100 percent employee-owned consulting and services company dedicated to delivering innovative solutions to complex challenges for private and public clients. Operating in 15 U.S. ... View more
