Pivotal Consulting
Join to apply for the
Sr. BIA Consultant
role at
Pivotal Consulting Join to apply for the
Sr. BIA Consultant
role at
Pivotal Consulting Get AI-powered advice on this job and more exclusive features. Sr Business Intelligence Analyst
Seattle, WA (W2 Hourly; Hybrid - not fully remote) 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
Key Tools/Technologies
SQL and other relational database concepts and languages required Alteryx Tableau Power BI Python SQL Server Management Studio Azure Synapse Advanced Excel, Word and PowerPoint Data ingestion/ETL tools such as Informatica, SSIS, Matillion, Talend, etc. Data warehouses, Data Lakes, and other data products such as Snowflake, Databricks, etc. Finance/Fintech applications, systems, processes and best practices
What Makes You a Good Fit
Bachelor’s degree in Computer Science, Math, IT, Business or equivalent work or educational experience required. Minimum 7 years of experience in a related position working with data management solutions. Experience as Data/Business Intelligence Power User and Data Consumer required. Strong demonstrated experience acting as a business liaison and delivering both strategic and operational solutions to technical teams required. Experience owning, supporting and delivering the full data life cycle development and its various phases required. Advanced level knowledge of SQL and Data Modeling for SQL and NoSQL Repositories required. Advanced level knowledge of data manipulation languages and tools such as Python, Alteryx etc. preferred. Advanced knowledge of multiple business intelligence and data discovery tool such as Tableau, Alteryx or Power BI required. Understanding of Cloud Computing required. Understanding of data engineering vocabulary and data architecture. Includes experience working with Azure, DataOps, JIRA or other Agile development team tools required. Ability to plan, organize, schedule, and implement projects in accordance with established project management methodologies required.
Why Our Employees Love Working At Pivotal
We believe our strength comes from our differences, and as a Certified Minority-Owned Business (MBE) and a majority women-led firm, we are committed to fostering and promoting a culture of diversity and inclusion. We believe our team and our community are our greatest assets and we strive to promote both daily.
From providing our employees the time to pursue company-sponsored certifications to supporting and partnering with multiple non-profit organizations brought forth by our employees (such as Food Lifeline, United Way, and the Seattle Humane Society), we are proud to support both our fellow Pivotalites and the causes close to their hearts.
As we grow, we are anchored and driven by our Four Core Values:
Be Engaged – We are present, committed, and accountable to our clients and to each other Consistently Deliver – We are dedicated and reliable by consistently delivering excellence Always Better – We continuously evolve, inspired to drive beyond the everyday norm Do Happy – Be passionate and bring fun and creativity into everything you do
Compensation, Diversity and Benefit Information:
The pay range for this position in Washington is $50-$70/hr.; however, base pay offered may vary depending on job-related knowledge, skills, candidate location, and experience.
Pivotal Consulting is committed to creating and supporting a diverse and inclusive team and serving all communities. All qualified applicants will be considered for employment regardless of race, gender, gender identity or expression, sexual orientation, religion, national origin, disability, age, or veteran status.
Pivotal Consulting offers a comprehensive benefit package, including medical, dental and vision insurance, 401k, and paid time off. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Consulting, Information Technology, and Sales Industries Business Consulting and Services Referrals increase your chances of interviewing at Pivotal Consulting by 2x Sign in to set job alerts for “Senior Consultant” roles.
senior manager, Card & Gifting Growth! (In Office/US – Seattle)
Seattle, WA $115,600.00-$193,000.00 5 days ago Senior Consultant, Practice Management & Teams
Seattle, WA $85,000.00-$165,000.00 1 hour ago Seattle, WA $126,000.00-$134,327.00 15 hours ago Seattle, WA $140,000.00-$170,000.00 1 month ago Senior Professional Services Consultant, West
Seattle, WA $119,000.00-$155,000.00 2 weeks ago Bellevue, WA $173,900.00-$250,010.00 6 days ago Bellevue, WA $173,900.00-$250,010.00 3 weeks ago Seattle, WA $173,000.00-$220,000.00 1 week ago Redmond, WA $100,000.00-$140,000.00 1 month ago Institutional Client Management Consultant
Seattle, WA $155,000.00-$217,000.00 1 week ago Senior Manager, Business Development - Aviation
Seattle, WA $130,000.00-$150,000.00 19 hours ago Senior Manager, Customer Success & Onboarding
Renton, WA $121,900.00-$182,900.00 2 weeks ago Seattle, WA $120,000.00-$190,000.00 1 week ago Senior B2B Marketing Manager, Amazon Key
Bellevue, WA $66,900.00-$143,100.00 2 weeks ago Seattle, WA $173,000.00-$242,500.00 1 week ago Bellevue, WA $66,900.00-$143,100.00 1 week ago Seattle, WA $135,100.00-$148,600.00 5 days ago Senior Client Manager Team Lead, Employee Benefits - Small Group
Seattle, WA $100,000.00-$120,000.00 1 week ago Bellevue, WA $66,900.00-$143,100.00 2 weeks ago Bellevue, WA $50,200.00-$107,400.00 2 weeks ago Senior Manager, Corporate Accounting - GL
Seattle, WA $169,000.00-$237,000.00 3 days ago Seattle, WA $109,000.00-$185,000.00 1 week ago Bellevue, WA $106,400.00-$185,000.00 1 week ago Bellevue, WA $101,200.00-$188,000.00 1 week ago Senior Business Analyst - Asset Protection - Seattle
Seattle, WA $125,000.00-$150,000.00 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Sr. BIA Consultant
role at
Pivotal Consulting Join to apply for the
Sr. BIA Consultant
role at
Pivotal Consulting Get AI-powered advice on this job and more exclusive features. Sr Business Intelligence Analyst
Seattle, WA (W2 Hourly; Hybrid - not fully remote) 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
Key Tools/Technologies
SQL and other relational database concepts and languages required Alteryx Tableau Power BI Python SQL Server Management Studio Azure Synapse Advanced Excel, Word and PowerPoint Data ingestion/ETL tools such as Informatica, SSIS, Matillion, Talend, etc. Data warehouses, Data Lakes, and other data products such as Snowflake, Databricks, etc. Finance/Fintech applications, systems, processes and best practices
What Makes You a Good Fit
Bachelor’s degree in Computer Science, Math, IT, Business or equivalent work or educational experience required. Minimum 7 years of experience in a related position working with data management solutions. Experience as Data/Business Intelligence Power User and Data Consumer required. Strong demonstrated experience acting as a business liaison and delivering both strategic and operational solutions to technical teams required. Experience owning, supporting and delivering the full data life cycle development and its various phases required. Advanced level knowledge of SQL and Data Modeling for SQL and NoSQL Repositories required. Advanced level knowledge of data manipulation languages and tools such as Python, Alteryx etc. preferred. Advanced knowledge of multiple business intelligence and data discovery tool such as Tableau, Alteryx or Power BI required. Understanding of Cloud Computing required. Understanding of data engineering vocabulary and data architecture. Includes experience working with Azure, DataOps, JIRA or other Agile development team tools required. Ability to plan, organize, schedule, and implement projects in accordance with established project management methodologies required.
Why Our Employees Love Working At Pivotal
We believe our strength comes from our differences, and as a Certified Minority-Owned Business (MBE) and a majority women-led firm, we are committed to fostering and promoting a culture of diversity and inclusion. We believe our team and our community are our greatest assets and we strive to promote both daily.
From providing our employees the time to pursue company-sponsored certifications to supporting and partnering with multiple non-profit organizations brought forth by our employees (such as Food Lifeline, United Way, and the Seattle Humane Society), we are proud to support both our fellow Pivotalites and the causes close to their hearts.
As we grow, we are anchored and driven by our Four Core Values:
Be Engaged – We are present, committed, and accountable to our clients and to each other Consistently Deliver – We are dedicated and reliable by consistently delivering excellence Always Better – We continuously evolve, inspired to drive beyond the everyday norm Do Happy – Be passionate and bring fun and creativity into everything you do
Compensation, Diversity and Benefit Information:
The pay range for this position in Washington is $50-$70/hr.; however, base pay offered may vary depending on job-related knowledge, skills, candidate location, and experience.
Pivotal Consulting is committed to creating and supporting a diverse and inclusive team and serving all communities. All qualified applicants will be considered for employment regardless of race, gender, gender identity or expression, sexual orientation, religion, national origin, disability, age, or veteran status.
Pivotal Consulting offers a comprehensive benefit package, including medical, dental and vision insurance, 401k, and paid time off. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Consulting, Information Technology, and Sales Industries Business Consulting and Services Referrals increase your chances of interviewing at Pivotal Consulting by 2x Sign in to set job alerts for “Senior Consultant” roles.
senior manager, Card & Gifting Growth! (In Office/US – Seattle)
Seattle, WA $115,600.00-$193,000.00 5 days ago Senior Consultant, Practice Management & Teams
Seattle, WA $85,000.00-$165,000.00 1 hour ago Seattle, WA $126,000.00-$134,327.00 15 hours ago Seattle, WA $140,000.00-$170,000.00 1 month ago Senior Professional Services Consultant, West
Seattle, WA $119,000.00-$155,000.00 2 weeks ago Bellevue, WA $173,900.00-$250,010.00 6 days ago Bellevue, WA $173,900.00-$250,010.00 3 weeks ago Seattle, WA $173,000.00-$220,000.00 1 week ago Redmond, WA $100,000.00-$140,000.00 1 month ago Institutional Client Management Consultant
Seattle, WA $155,000.00-$217,000.00 1 week ago Senior Manager, Business Development - Aviation
Seattle, WA $130,000.00-$150,000.00 19 hours ago Senior Manager, Customer Success & Onboarding
Renton, WA $121,900.00-$182,900.00 2 weeks ago Seattle, WA $120,000.00-$190,000.00 1 week ago Senior B2B Marketing Manager, Amazon Key
Bellevue, WA $66,900.00-$143,100.00 2 weeks ago Seattle, WA $173,000.00-$242,500.00 1 week ago Bellevue, WA $66,900.00-$143,100.00 1 week ago Seattle, WA $135,100.00-$148,600.00 5 days ago Senior Client Manager Team Lead, Employee Benefits - Small Group
Seattle, WA $100,000.00-$120,000.00 1 week ago Bellevue, WA $66,900.00-$143,100.00 2 weeks ago Bellevue, WA $50,200.00-$107,400.00 2 weeks ago Senior Manager, Corporate Accounting - GL
Seattle, WA $169,000.00-$237,000.00 3 days ago Seattle, WA $109,000.00-$185,000.00 1 week ago Bellevue, WA $106,400.00-$185,000.00 1 week ago Bellevue, WA $101,200.00-$188,000.00 1 week ago Senior Business Analyst - Asset Protection - Seattle
Seattle, WA $125,000.00-$150,000.00 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr