Sr. Business Data Analyst - ETL, Tableau

Job Title: Business Intelligence Developer

Duration: 2 Months (W2)

Location: Denver, Colorado (remote)

Project Overview

The client is seeking a Business Intelligence Developer to support the Information Management Services and Accountability and Continuous Improvement teams.

The ideal candidate will have a strong technical background in data analysis and coding and demonstrate the ability to communicate effectively with both technical and non-technical stakeholders.

Key Responsibilities

1. Code and Data Review

• Analyze existing data processes and code for SPF reports.
• Identify and address inefficiencies, inconsistencies, and errors.
• Collaborate with technical teams to optimize ETL processes.
• Recommend improvements for performance and data accuracy.

2. Business Process Mapping & Documentation

• Engage with program staff to understand reporting-related business processes.
• Document business rules and create detailed process maps and workflows.
• Align business requirements with technical solutions.

3. Requirements Gathering & Documentation

• Lead requirement-gathering sessions with stakeholders and technical teams.
• Translate business needs into functional and technical specifications.
• Maintain comprehensive documentation of both current and future states.

4. Collaboration & Stakeholder Management

• Act as a liaison between business and technical teams.
• Facilitate stakeholder meetings to review and refine requirements.
• Support continuous communication and alignment of project goals.

Additional Expectations

• Work closely with IMS teams regarding coding standards, security, QA, and data warehouse integration.
• Prioritize tasks to meet deliverables and deadlines.
• Ensure all deliverables are high-quality, complete, and error-free.
• Submit deliverables for review, revise as needed, and gain formal acceptance.
• Respond to communications within 1 business day.
• Exchange documentation using Microsoft Office 365-compatible formats.
• Retain project documentation through acceptance and provide upon request.

Tools & Technologies

• Databases & Tools: Oracle, Toad, Informatica, Tableau
• Languages: SQL, Python, R
• Platforms: Microsoft Office 365

Qualifications

• Strong technical expertise in data management, ETL processes, and data warehousing.
• Experience with business process analysis and documentation.
• Excellent written and verbal communication skills.
• Ability to work independently with minimal technical support.
• Prior experience in education or public sector domains is a plus.