Junior Data Engineer

Job Description

Job Description

Description:

Job Summary 

The Junior Data Engineer supports Vivacity's data infrastructure by helping build, maintain, and document the queries, pipelines, and integrations that connect NetSuite, HubSpot, BigQuery, and related systems. This role reports to the Director of Enterprise Applications and will be trained and mentored by the Senior Data Analytics Manager, building fluency in SQL, ETL/integration patterns, and Vivacity's data architecture.

What We Offer

• $60,000 - 65,000 salary
• 401(k) with generous company match and immediate vesting 
• Medical, Dental, Vision & Voluntary Benefits 
• Company-paid Short-Term Disability, Long-Term Disability, and Life Insurance 
• Non-Accrued Paid Time Off (PTO) policy providing flexibility and work-life balance 
• 80 hours of paid Sick Time annually 
• 10 paid holidays per year 
• 96 paid volunteer hours annually to support causes you care about 
• $1,000 annual Development Reimbursement for continued learning and growth 
• Paid Parental Leave to support growing families 
• Award-winning workplace culture and supportive team environment 
• Opportunities for growth and recognition in a mission-driven organization 
• Employee discounts and additional voluntary benefits including pet insurance, legal insurance, and more

Essential Functions

• Support and collaborate with stakeholders in the design, implementation, and maintenance of data systems, dashboards, and reporting frameworks.
• Write and maintain SQL queries (BigQuerySQL, PostgreSQL, SuiteQL, LookML) to support reporting, reconciliation, data requests
• Assist with monitoring and troubleshooting data pipelines
• Assist in testing and validating data queries and reports as needed
• Contribute to view and column documentation to improve data usability and query accuracy
• Maintain organized documentation of work performed, issues encountered and resolutions in the support ticketing platform for knowledge continuity
• Perform other duties as assigned

Knowledge, Skills & Abilities

• Coachability; able to work under supervision while building toward independent ownership of tasks
• Strong attention to detail and a methodical approach to data validation
• Excellent verbal and written communication skills
• Ability to document work clearly for technical and non-technical audiences
• Ability to manage multiple priorities and tasks in a fast-paced environment
• Working knowledge of SQL and eagerness to learn
• Some exposure to Python or another scripting language preferred
• Familiarity with ETL/data pipeline concepts
• Proficiency in Google Workspace and spreadsheets 
• Exposure to Celigo, Fivetran, BigQuery, Netsuite, Looker are a plus

Values 

• Carry passion. 
• Desire excellence.
• Keep dreaming. 
• Build community. 
• Be Vivacious.  

Education & Experience 

• 0-2 years relevant experience. Internships, coursework, and related formal education are acceptable in lieu of professional experience.
• Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field preferred; equivalent self-directed learning or certification (e.g., BigQuery, SQL certifications) will be considered.
• Experience working with relational databases and writing SQL queries to retrieve, transform, validate, or analyze data, preferred.
• Experience working with cloud-based data platforms or data warehouses, such as BigQuery, Snowflake, or similar technologies, preferred.

Additional Requirements

• Prolonged periods of sitting or standing at a desk and working on a computer 
• Ability to bend, sit, and lift up to 50 lbs
• Less than 10% travel

Requirements: