• Move and transform data from various sources so that it can be easily analyzed, visualized, and acted upon by a senior data analyst or business user
• Design, build, and maintain scalable ELT pipelines using SQL and DBT. Build, automate, deploy and maintain data models and workflows. Develop and maintain documentation for data models, workflows, and processes
• Implement data quality and validation checks to ensure the accuracy and reliability of data. Implement CI/CD practices for version control and automated deployments.
• Collaborate with stakeholders, collecting requirements and writing the code that results in secure, timely, accurate, trusted, and extensible data models
• Implement data quality and validation checks to ensure the accuracy and reliability of data.
• Leverage tools (including Python Boto3/Botocore, Pandas) for scripting, data processing, and automation tasks in AWS Lambda. Work with AWS services such as S3, Lambda, and IAM to manage and secure data infrastructure.
• Proactively perform data exploration and analytical deep dives to discover insights or future opportunities
• Deliver data insights and work towards adoption through tools (e.g. dashboards, self-serve reporting), memos and presentations (Tableau etc.)
• Collaborate with business and data analysts to model data structures that meet business requirements.

Requirements:

• 3+ years of hands-on experience as an analytics engineer, data analyst, data engineer, or equivalent
• Significant experience in data modeling and data warehouse architecture
• Experience with cloud data platforms such as Snowflake, Redshift, or BigQuery
• 1+ year of hands-on experience working with dbt
• Business acumen and experience with one or more functional areas such as Product, GTM, Finance, Marketing, Customer Experience
• Exceptional verbal, written and listening skills and the ability to bring consensus and communicate with a diverse audience

Tool experience preferred:

• SQL Snowflake preferred, DBT: position utilizes Cloud, but Core experience is great, Fivetran: 2+ years of experience, Data Warehousing, Data Lake (AWS S3), GitHub, Performance Tuning & Optimization + Governance, Data Modeling tools, BI Visualization (Tableau/Looker/etc)

Our competitive total rewards package includes cash compensation within the range provided below. Actual pay for this position may vary based on the hired candidate’s location, experience and relevant incumbent pay position.

Vectra provides a comprehensive total rewards package that supports the financial, physical, mental and overall health of our employees and their families. Compensation includes competitive base pay, incentive plan eligibility, and participation in the employee equity plan (stock options). Specific benefits offered varies by location, but commonly include health care insurance, income protection / life insurance, access to retirement savings plans, behavioral & emotional wellness services, generous time away from work, and a comprehensive employee recognition program.

Vectra is committed to creating a diverse environment and is proud to be an equal opportunity employer.

We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status.