Analytics Engineer
- Write and maintain dbt models.
- Debug tricky SQL logic.
- Work with the Data team in a highly collaborative environment.
- Translate ambiguous business requirements into dependable datasets.
- Build logical data models and automated data quality checks.
- Partner with data engineers, analysts, and stakeholders to ensure data is accurate and actionable.
- Data Modeling and Transformation:
- Use dbt and software engineering best practices to build, maintain, and document business data models that facilitate in-depth analysis.
- Translate complex business requirements into precise technical specifications that support well-formed data models and efficient data analysis.
- Develop scalable, efficient data marts that support self-service analytics.
- Author Efficient, Well-Written SQL Queries
- Craft clean, modular, and well-documented code using CTEs and dbt best practices, creating a codebase that is easy for the entire team to understand and maintain.
- Troubleshoot and refactor existing data models, identifying logical errors or performance bottlenecks and implementing elegant solutions.
- Optimize queries for performance and cost-effectiveness.
- Collaborate with the Data Team and External Stakeholders
- Maintain open and clear communication with teammates and stakeholders from diverse teams. We regularly work with teams such as Finance, Marketing, Sales, Customer Experience, and Engineering.
- Provide technical expertise and support to stakeholders utilizing self-service data.
- Present complex technical concepts to non-technical stakeholders in clear, actionable terms.
- Guide business users on best practices and analytics capabilities.
- Pipeline Maintenance and Optimization:
- Work with tools like Census to integrate data models seamlessly into our analytics workflows.
- Monitor data quality and resolve anomalies to ensure reliable data for analysis.
- Collaborate with data engineers to optimize data pipelines to deliver accurate, timely data.
- Documentation and Best Practices:
- Create and maintain thorough documentation of data models and analytical processes.
- Advocate for best practices in data modeling, data governance, analysis methodologies, and model testing.
- 5+ years of experience in analytics, data science, or equivalent analytical functions.
- Advanced proficiency in SQL, including concepts such as window functions, CTEs, and User-Defined Functions.
- Hands-on experience with dbt or an equivalent tool.
- Experience with data warehousing platforms and tools like Databricks, Snowflake, BigQuery, or Redshift.
- A good understanding of Git and version control.
- A collaborative mindset with the ability to work effectively alongside data engineers, analysts, and business teams.
- Strong analytical skills with comfort in exploratory and descriptive data analysis.
- Experience integrating dbt into cloud-based data pipelines.
- Experience with data orchestration tools like Airflow or Dagster.
- Familiarity with reverse ETL using tools like Census or HighTouch.
- Understanding of data warehousing concepts and modern data architectures.
- Experience with data documentation (e.g., creating data dictionaries, data catalogs, or stakeholder-facing documentation in tools like Notion).
- Familiarity with using AI tools, such as Claude Code, Cursor, or ChatGPT, to accelerate development and enhance coding productivity.
- Competitive and fair compensation: We believe in fair pay--equal pay for equal work. For each title, we consistently apply competitive salary bands based on market data and benchmarks which are reviewed twice a year. What you've been paid before, fear of conflict, or willingness to negotiate does not play a part in determining your pay.
- The annual base salary range for this position is $136,000 - $152,000. Placement within the range is determined by a variety of factors, including but not limited to: knowledge, skills, years & depth of experience, and equity with internal team members.
- 401(k) retirement plan : We offer both a Traditional and Roth 401(k) with a company match.
- Company-paid medical : Our medical, dental and vision premiums are covered 100% for you and your dependents.
- Paid parental leave : Welcoming new family members is exciting, but it can also be challenging. We offer twelve weeks paid leave for primary caregivers and four weeks for secondary caregivers.
- Unlimited vacation : At Storyblocks, we believe in the importance of taking time off when you need it. Typically, employees take about three or four weeks each year. Plus, two company-wide week breaks in July and December.
- Flexible work options As a fully remote company, we've got you covered no matter where you are. Remote work stipend? Check. Company and team events? Check.
- Flexible work options : All of our work is virtual. As long as you deliver results, you are welcome to get your work done during unusual times when desired.
- Company-sponsored mentorship and growth : We encourage attending virtual meetups and are happy to host them as well. We also have a leadership coach, on staff, available to all employees to enhance your professional development.
- Employee perks : We help employees maintain work-life balance and honor their contributions to the organization by offering resources such as a financial wellness program, a subscription service that offers unlimited deliveries from thousands of eligible restaurants with $0 delivery, and a recognition and rewards program that celebrates their accomplishments.
Recommended Jobs
Veterinarian
Corban Veterinary Services in Charlotte Court House, Virginia, is growing and looking for a new GP Veterinarian to add to our team! ** Open to New Grads -- Great Mentorship Program!! **$100 …
Recreational Therapist
A certified recreation Therapist is responsible for the delivery of services to patients within the Recreation Therapy Departments scope of service. The Recreation Therapist is responsible for assign…
Tester Senior
Tester Senior Position Responsibilities Locals Only! In-Person Interview Required! ServiceNow Tester Mclean VA / Plano TX - 5 Days Onsite (100% Onsite) 6 + Months …
HR Shared Services - Principal Associate
HR Shared Services - Principal Associate **Main Responsibilities:** + Partner with Risk Advisors and business SMEs to support design, identification, implementation, and documentation of controls to m…
Early Childhood - Lead Two's Teacher
Summary Beach Montessori is looking for you! Do you love working with children? Imagine spending your days providing high quality learning experiences for children ages 6 weeks to 5 years old.…
Senior Structural Engineer, Natrium
Requisition ID: 287959 ~ Relocation Authorized: National - Family ~ Telework Type: Part-Time Telework ~ Work Location: Reston, VA Extraordinary teams building inspiring projects: …
Breakfast Leader- Hampton Inn & Suites San Juan
A Breakfast Supervisor is responsible for staffing and the service and quality of the hotel's breakfast service in the hotel's continuing effort to deliver outstanding guest service and financial pro…
Engineering Technician III
Responsibilities for this Position Location: USA VA Norfolk Full Part/Time: Full time Job Req: RQ212311 Type of Requisition: Regular Clearance Level Must Currently Possess: Non…
Customer Support Data Center Technician - Cohort Hiring Q1' 2026 - Military Talent Programs
Who are we? Equinix is the world’s digital infrastructure company®, shortening the path to connectivity to enable the innovations that enrich our work, life and planet. A place where bold idea…
Porter
LR Associates, LLC is a Veteran owned federal government contractor providing facilities management and other services to various government customers. We support our customers with highly skilled pe…