Data Warehouse Business Analyst

Title: Data Warehouse BA Location: Remote - must reside in the US Timezone: PST Job type: Contract - plan to convert in 9-12 months • Unable to provide visa sponsorship or transfers About the Role: The Data Warehouse Business Analyst will play a pivotal role in the delivery of data and analytics initiatives across the company. As part of a newly formed team building a modern data platform using Databricks and Power BI, the Business Analyst will be the primary liaison between the business and technical teams, forming a bridge to ensure the data products deliver continuous business value. The Business Analyst will work closely with a Technical Project Manager, Business Lead, Architects, and Engineers in an agile development process. They will guide business teams to maximize value from data products including the delivery of core functional dashboards for all business functions and innovative technologies that can create a competitive advantage. Responsibilities: • Elicit and managing requirements and data definitions from various stakeholders. • Evaluate and prioritize business needs from different stakeholders, ensuring that the most critical requirements are addressed first and that the team’s efforts align with business goals. • Create, maintain, and prioritize the product backlog, ensuring that the team is always working on the most valuable and high-quality tasks, and that the backlog reflects the current business priorities. • Ensure that the data warehouse processes continuously deliver high-quality value to the business; identify, champion, and execute opportunities for improvement • Oversee and execute testing including data profiling, transformation testing, usability testing, and user acceptance testing • Develop dashboard mockups that facilitate understanding and ensure a positive user experience • Develop and maintain system documentation including data definitions and support materials • Identify, log, and triage defects and issues to the appropriate team and ensure follow up Qualifications: • Strong Business Acumen: understanding of core processes and needs within finance, supply chain, sales, and marketing for a DTC consumer products company • Data Expertise: 3+ years with data warehouse architecture, data modeling, ETL processes, Power BI Semantic Modeling and proficiency in SQL • Technical Proficiency: 3+ years’ experience operating with core IT development, run, and access control processes such as software development lifecycle (SDLC), ITIL, and DevOps • Understanding of data governance and data quality principles and experience applying these in a project • Agility and Speed: Proven ability to thrive in a fast-paced environment and prioritize rapid learning cycles. Focused on delivering minimum viable products quickly and a bias to action that is balanced with the strategic product vision for reusability, scalability and quality. • Excellent problem-solving skills and attention to detail. • Excellent communication skills, with the ability to work well with both technical and non-technical users. • Ability to work independently and manage multiple tasks simultaneously. Preferred Skills: • Power BI Model and Dashboard development • Proficiency in querying in Azure Databricks • Experience with Dev Ops (Azure DevOps preferred) • Experience with startups and small brands; beauty industry experience preferred • Experience with Enterprise Business Systems including NetSuite ERP and Shopify • Experience with Point of Sale data, Google Analytics, and Media Data • Experience with data security and privacy