Jobs and Careers

Sr. BIA Consultant

United StatesRemotefull_timeVerifiedPosted 16 Dec 2024

💰 $140,000/yr($100,000/yr – $140,000/yr)

About the role

Sr Business Intelligence Analyst
Seattle, WA (W2 Hourly; Hybrid - not fully remote)

Why clients choose Pivotal Consulting:
We are a technology management consulting firm helping Fortune 500 companies improve their performance – we specialize in making People, Process, and Technology work together! Our clients count on us to deliver excellence and seek our guidance on business and technology strategy, technology modernization, and cloud transformation initiatives. Simply put, by listening to our clients closely and focusing on delivering quality, we bring them peace of mind. After guiding and helping numerous clients from global enterprises to mid-market firms to non-profit organizations, we are now experiencing breakthrough growth!

What you will do:

Responsible for identifying opportunities for improving Business Intelligence Solutions
Works on complex projects/teams and acts as a mentor and lead to other Analysts
Lead liaison between business units and IT departments to translate business needs and objectives into Business Information solutions
Create user stories and write acceptance criteria
Identify Data Sources, calculated measures, and other transformations (lookups)
Establish processes and automation for the enterprise-grade Data & BI platform
Develop source to target mapping documentation
Deliver Business Requirements for the “consumption layer” (Datamart, etc.)
Serve as a lead for Data Q&A – liaison between business, developers, and other technical teams
Provide data and analytics support (i.e., SQL queries, Alteryx workflows, Tableau, PowerBI reports and dashboards)
Perform functional testing and data validation
Develop and execute testing plans, scenarios and validate data accuracy
Test data services (data pipelines, APIs) that feed downstream requirements (Dashboards, Models, etc.) to ensure that the data transferred correctly to the client application tools
Liaison with Data Governance team regarding the data catalog
Lead and participate in user acceptance testing (UAT)
Ensure Security, Governance, Enterprise Architecture guidance and protocols are adhered
Communicate progress, risks, and issues to the project team

Outcomes:
Following are some of the key deliverables expected from this role:

Functional requirements documents (BRD) – with business requirements, dashboards and views, calculated measures, algorithmic inputs, SLAs, etc.
Source to Target mapping documents
Technical specifications documents (TSD) – with architecture, data dictionary definitions, data model specifications, wireframes, computations/formulae for calculated measures, etc.
Test strategy, test plan and test cases for testing and data validation
Create data testing/validation scripts/Alteryx workflows
Produce operational support documentation (and runbooks with dev team’s help)
Produce release notes/documentation
Create documentation for change control.
Provide end-user adoption support
Other project documentation and artifacts as defined and assigned by Project Manager or Data & BI leadership