Job Description
Our client is seeking a Business Analyst to help them translate business requirements into data warehouse designs. The Data team is both a support function and strategic partner and will be a key area of investment in the future. Data is used to drive effective planning and decision making all the way from exploration of opportunities, to hypothesis testing and goal setting, the measurement of results and iteration. We will invest heavily in the coming years to make data more accessible to our internal teams and to leverage it within our application to provide our practitioners and patients with data-driven tools and experiences.
Reporting to the VP of Data Analytics, the Business Analyst will be responsible for gathering, defining and documenting business requirements to guide data warehouse development releases. The successful candidate will have strong attention to detail, good project management skills and be a confident communicator. The Business Analyst will be responsible for providing project management oversight for Data Warehouse projects such as new reporting requirements and the evolution of existing infrastructure and will write the reporting requirements for major projects and releases.
What you’ll do:
- Lead data warehouse architecture discovery and planning, interviewing stakeholders to understand business needs and collect data requirements.
- Coordinate the prioritization and execution of the data warehousing roadmap as it relates to company needs and overall data strategy.
- Provide project management for Data Warehouse releases and maintenance requests from inception through delivery, including data mapping, scoping of releases, timeline estimates, adherence to requirements, and delivery expectations.
- Research and troubleshoot downstream Data Warehouse issues, providing Level 1 support to our internal data teams including querying Data Warehouse tables, confirming data values in various source systems and analyzing source to target mappings.
- Develop a high-level understanding of our organization’s internal data systems and sources to identify opportunities for additional data integrations and enhancement of existing architecture.
- Work with internal data teams to build and maintain high-quality documentation of database architecture, including business requirements, entity-relationship diagrams, technical specifications, and data dictionaries.
- Assist in the warehouse QA process, reviewing test cases and performing user acceptance testing.
What you bring to the team:
- 3+ years of related experience in a Data Warehouse business analyst role, including researching, requirement gathering, testing and documentation of Data Warehouse systems.
- Working knowledge of enterprise data architectures and toolsets, including relational, non-relational, 3NF, dimensional and event-based models.
- Excellent knowledge of the designs and functions of effective Data Warehouse solutions.
- Experience with data governance and data quality management.
- Ability to write intermediate SQL queries and to understand technical specifications to ensure proposed solutions meet business requirements.
- Demonstrated knowledge of project management life cycle and business analysis best practices. Proven ability to gather requirements effectively, document and report requirements effectively.
- Proven ability to work independently in a fast-paced environment, managing competing priorities on multiple simultaneous projects.
- Strong written and verbal communication skills with the ability to effectively communicate with both technical and non-technical audiences.
Bonus if you have:
- Experience in B2B or SaaS, working in a high-growth environment.
- Experience working with an ERP system, such as Netsuite.
- Experience with a CRM tool such as Salesforce.
- Interest or experience in Health Tech, Integrative Medicine, or supplements.
*Our Wherever You Work Well philosophy means our teammates get to pick their own office — whether that’s in-office, at home, or a bit of both.
Our client is committed to diversity in its workforce and is proud to be an equal opportunity employer. We are excited to work with talented people, period. All employment decisions are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion or belief, national or ethnic origin, gender, age, disability, sexual orientation, gender identity and/or expression, marital or civil status, political affiliation, family or parental status, or any other status protected by the laws or regulations in the jurisdictions in which we operate. Accommodations are available on request for candidates taking part in all aspects of the selection process.
Our team handles both personal information and personal health information, which means candidates that receive and accept employment offers must undergo a background check.
