Senior Data Analyst, Marketing
United States
Full Time Senior-level / Expert USD 1K - 2K
Aurora Solar
The #1 solar software to design and sell advanced PV systems. See why installers use Aurora to create over 100,000 PV designs every week.About Aurora Solar
Aurora is on a mission to create a future of solar for all. Our award-winning software puts the power of data and technology into the hands of every solar professional to make solar adoption simple and predictable. Our software has designed millions of solar projects so far, empowering solar companies to sell, design, and install residential and commercial solar arrays accurately, seamlessly, and at scale.
We are a remote-first collaborative team of sustainable energy enthusiasts who love what we do. We’ve been named one of "The Best Mid-Sized Remote Companies To Work for in 2024" by BuiltIn.com and have been recognized for the second time as a Certified Green Business (CGB) with the city of San Francisco. We’re in this together to support the world’s transition to solar.
About the Team
You’ll be joining a team of seasoned data professionals covering data engineering, analytics engineering, and analytics. We’re collaborative, curious, and passionate about applying data to solve one of society’s most pressing issues.
About the Role
In this role, your main focus will be marketing analytics - through the design of dbt data models, the building of compelling dashboards, and the sourcing of relevant data from various parts of the martech stack. You will not only draw insights from disparate data sets through compelling visualizations but also partner with the Marketing team to drive campaign execution and martech investment. You’ll partner with data engineering to ensure data is available and work closely with analytics engineers and analysts to follow dbt and Looker best practices. You will report to the Director of Analytics.
Your Impact
Translate marketing data in insightful dashboards to drive decision-making
Design and evolve logical and scalable dbt data models that reflect core marketing KPIs
Run and maintain departmental reporting in Looker
Work with marketing leaders to help answer questions like “are we measuring the right things?” “is our analysis helping us effectively come to the right conclusions?” and “do changes based on data insights have the anticipated impact?”
Partner with other analysts to ensure adherence to dbt/Looker best practices, QA dashboards/models, educate the team on Marketing data, and learn/support other domains’ data needs
Engage with cross-functional teams to understand their data requirements; help scope and prioritize these requirements to develop analytics projects and dashboards
What You Bring
3+ years of experience with integrated martech stacks, developing and delivering marketing data and insights
1+ years of experience working with Hubspot, Looker, and dbt
Experience with Google Analytics 4
Solid experience designing and optimizing dbt and Looker models based on business and performance requirements
High-level SQL proficiency
Advanced problem-solving skills
Proven ability to communicate clearly to technical and non-technical audiences
A passion for full-stack data modeling and owning the end-to-end process ensuring data quality with a focus on back-end data modeling
A can-do attitude towards examining issues, opportunities, and problems, with the ability to work under their own initiative
A collaborative mentality with a proven record of engaging with multiple collaborators across different business areas
What We Offer
🏖️Flexible PTO - Take the time when you need it
🍼Parental Leave - 16 weeks with 100% base salary + gradual return to work
💰WFH Stipend - An initial $500 (Non-engineers) or $750 (Engineering roles)
🏢 Coworking Stipend - $300 / month if you prefer to be at a coworking facility near you
☀️Energize Fridays - Company-wide days to log off and recharge
📶Connectivity Stipend - Up to $75 / month towards internet or phone
🩺Medical, Dental, and Vision - Premiums are 100% covered for Aurorans and 90% for dependents
Please take a look at our 2024 U.S. Benefits Booklet for a deeper dive into our offerings
Where Aurorans are: Aurora currently has teams within the US, Canada, Mexico, and Germany with additional locations on the horizon. We’re united in our work to support the world’s transition to solar!
Aurora is dedicated to building a diverse and inclusive workforce of people who believe in and are passionate about creating a future of solar energy for all. We are an equal opportunity employer, we welcome and consider qualified applicants regardless of gender identity, sexual orientation, race, religion, age, national origin, citizenship, pregnancy status, veteran status, or any other differences. We encourage you to apply even if you believe that you do not meet all of the above criteria!
Aurora is committed to creating an inclusive and accessible experience for all candidates. If you require a reasonable accommodation that would better enable your success during the application or interview process, please complete this form.
For San Francisco applicants: Pursuant to the San Francisco Fair Chance Ordinance, we will consider qualified applicants with arrest and conviction records for employment.
Tags: Data quality dbt Engineering HubSpot KPIs Looker SQL
Perks/benefits: Flex hours Flex vacation Health care Home office stipend Medical leave Parental leave
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 MLOps Engineer jobs
- Open Data Science Manager jobs
- Open Data Manager jobs
- Open Lead Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Sr Data Engineer jobs
- Open Data Scientist II jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Junior Data Engineer jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Product Manager jobs
- Open Data Quality Analyst jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open DevOps-related jobs