Analytics Engineer
Durham, NC or Remote, US
Spreedly
Spreedly is the world's leading Payments Orchestration Platform that lets you connect to payment services in over 100 countries with a single API connection.Responsibilities
- Collaborate with team members to collect business requirements, define successful analytics outcomes, and design data models
- Work with Data Engineering and Business Intelligence to build trusted data models, visualizations, and recommendations that get the highest level of confidence from the business
- Design, develop, and extend DBT in a repeatable, scalable way to progress Spreedly’s overall data maturity
- Create and maintain architecture, systems, design, process and execution documentation
- Work in partnership with the Data team to build and maintain the data dictionary and establish a strong self-service and single source of truth analytics framework to empower business users across Spreedly
- Craft code that meets our internal standards for structure, style, maintainability, and quality best practices
- Maintain and advocate for these standards through code review
- Work with Data Engineering to create and facilitate the code review, approval, and deployment process and serve as a peer reviewer for specific database and data model schema changes
- Provide data modeling expertise to all GitLab teams through code reviews, pairing, and training to help deliver optimal, DRY, and scalable database designs and queries in Snowflake
- Exercise all phases of business analysis, including data quality, data analysis, data visualization, and presentation of results and deliverables
- Partner with Data team members and key stakeholders on KPI development, data collection and building dashboards
- Assist in the development of our SQL Modeling layer written in LookML & DBT ensuring it is performant with big data, organized, and well-implemented
- Utilize data warehousing and code development best practices to enable access to information by creating and maintaining foundational data models
- Participate in the creation and support of BI development standards and best practices
- Encourage internal adoption and self-sufficiency of stakeholders on the Looker platform, including documentation, training users and dashboard organization
- Collaborate with data engineering to mint new dimensions and measures for stakeholder use
- Keep data sources fresh even while requirements and definitions change
- Address data quality issues and build in alerting
- Utilize code (Python/R/SQL) for data analysis
Requirements
- Bachelor's degree in quantitative or technical field; master's degree in Quantitative or technical field preferred
- 5+ years in the data space as an analyst, engineer, or equivalent
- 5+ years experience designing, implementing, operating, and extending commercial Kimball enterprise dimensional models
- 5+ years working with a large-scale (1B+ Rows) data warehouse, preferably in a cloud environment
- 2+ years experience building reports and dashboards in a data visualization tool
- 1+ years creating project plans to identify tasks, milestones, and deliverables
- Experience with Looker, Snowflake, and DBT
- Experience with Fivetran (or similar tools)
- Strong background in data relationships, modeling, and semantic layer
- SQL expert with experience dealing with techniques (windows functions, common table expressions, UDFs, etc.) for data investigation, transformation, analysis, and optimizing for scalability and ease of maintenance
- Familiarity in programming/scripting and knowledge of Python is a plus
- Have solid project management skills including planning work, managing details, keeping multiple tasks/projects on track, working with cross-functional stakeholders, and navigating ambiguity to deliver results
- Enthusiasm for conducting reproducible analysis; code reviews, version control, and solid documentation
What We Offer
- Competitive salary + Equity
- Outstanding Medical and Dental Insurance: Premiums are 100% company paid for employees and families
- Note: We offer two PPO health insurance plans: A traditional copay and a high deductible with HSA. Spreedly contributes $1,200/$2,400 per year to the HSA for those choosing the high deductible plan
- Life and long-term disability insurance
- Optional Vision insurance and various Flexible Spending Accounts (FSA)
- Open Paid Time Off policy + 12 weeks paid leave for new parents
- Matching 401k plan (5% up to $5,000 yearly)
- Monthly digital lifestyle stipend ($150), new MacBook, and $200 accessory reimbursement
- $3,000 annual Professional Development stipend and free LinkedIn Learning subscription
- Flexible, remote friendly work environment
- Quarterly visits to HQ in Durham, NC for remote employees
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Big Data Business Intelligence Data analysis Data Analytics Data quality Data visualization Data warehouse Data Warehousing Engineering FiveTran GitLab Looker LookML Python R Snowflake SQL
Perks/benefits: 401(k) matching Career development Competitive pay Equity Flex hours Flex vacation Gear Health care Home office stipend Insurance Medical leave Startup environment Transparency
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Engineer II jobs
- Open AI Engineer jobs
- Open Senior Data Architect jobs
- Open Power BI Developer jobs
- Open Data Analytics Engineer jobs
- Open Manager, Data Engineering jobs
- Open Senior Business Intelligence Analyst jobs
- Open Sr Data Engineer jobs
- Open Principal Data Engineer jobs
- Open Business Data Analyst jobs
- Open Product Data Analyst jobs
- Open Data Quality Analyst jobs
- Open Data Manager jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open ETL Developer jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Business Intelligence-related jobs
- Open Data quality-related jobs
- Open Privacy-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open Consulting-related jobs
- Open PhD-related jobs
- Open TensorFlow-related jobs
- Open Snowflake-related jobs
- Open NLP-related jobs
- Open Data warehouse-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs
- Open LLMs-related jobs
- Open DevOps-related jobs
- Open CI/CD-related jobs