Elastic is an open source search company that powers enterprise search, observability, and security solutions built on one technology stack that can be deployed anywhere. From finding documents to monitoring infrastructure to hunting for threats, Elastic makes data usable in real time and at scale. Thousands of organizations worldwide, including Barclays, Cisco, eBay, Fairfax, ING, Goldman Sachs, Microsoft, The Mayo Clinic, NASA, The New York Times, Wikipedia, and Verizon, use Elastic to power mission-critical systems. Founded in 2012, Elastic is a distributed company with Elasticians around the globe. Learn more at elastic.co.

Thanks to our ongoing expansion we are now seeking a Sr. SQL Analyst to join our Global Insights & Analytics team, a division within the broader Sales Finance & Strategy team. In this role, you’ll have an opportunity to work alongside our Sales Strategy and IT teams developing key elements of our data warehouse to provide critical insights on the performance of our field operations organization.

What You Will Be Doing:

• Collaborate with our IT integrations and BI team to ensure the data warehouse environment has all the data we need to be successful
• Help the team shift from a reactive analytics motion to a proactive motion: what happened, why it happened, and how to optimize/improve moving forward.
• Balance critical, long-term thinking about how we scale the business with hands-on delivery to ensure what needs to happen today gets done.
• Dig into the data to deliver meaningful insights.
• SQL View Development: create SQL queries and aggregations that help us derive key reports, forecasts, and other operational results inside of Google BigQuery

What You Bring Along:

• You are strong in analytical and process skills, comfortable engaging with senior leadership, effective at collaborating with multiple teams, and building positive relationships with business partners.
• Data Architecture: Design efficient and performant structures that support answering a variety of business questions. The environment requires familiarity with classic warehousing approaches such as star and snowflake schemas, as well as blending these techniques with dynamic views.
• Visualizations: Collaborate with IT and build visualizations (in Kibana and/or a similar tool) that help our Sales team and leaders
• Audit and Enablement: you’ll educate and advise key partners about the data outputs and metrics you generate
• Driving Requirements: help build the requirements for how our Sales Strategy business partners use these insights and their impact
• Standardization and Documentation - The SQL analyst will be encouraged to maintain high levels of standards including documentation

Key Skills:

• Proven track record of 5+ years, and a solid grasp of SQL Databases, with a slight preference for exposure to Google BigQuery or Postgres.
• Expert-level ability to craft SQL queries and create views using data from multiple tables and sources, with a focus on aggregations and statistical functions.
• Proven track record of the full scope of a SQL analyst: from requirements gathering → data modeling → Data QA/peer-reviewing → building visuals → presenting results to partners → enabling self-service tools for the end-user.
• Prior experience working in sales operations
• Have a passion for optimizing process and structure.
• Curious and using data daily to make decisions
• Thrive in navigating ambiguity
• Solid understanding of Microsoft Excel: most of your team members have models in excel that they’re looking to bring into BI
• Incredible attention to detail
• High autonomy. You will be given the chance to create a high impact on the success of the company as a whole and understand the keys to success in a highly transparent multi-functional role.

Bonus:

• knowledge of the Elastic stack, particularly Kibana.
• Prior experience with R for data analysis & statistics and Tableau.

Additional Information - We Take Care of Our People

As a distributed company, diversity drives our identity. Whether you’re looking to launch a new career or grow an existing one, Elastic is the type of company where you can balance great work with great life. Your age is only a number. It doesn’t matter if you’re just out of college or your children are; we need you for what you can do.

We strive to have parity of benefits across regions and while regulations differ from place to place, we believe taking care of our people is the right thing to do.

• Competitive pay based on the work you do here and not your previous salary
• Health coverage for you and your family in many locations
• Ability to craft your calendar with flexible locations and schedules for many roles
• Generous number of vacation days each year
• Double your charitable giving - We match up to $1500 (or local currency equivalent)
• Up to 40 hours each year to use toward volunteer projects you love
• Embracing parenthood with minimum of 16 weeks of parental leave

Elastic is an Equal Employment employer committed to the principles of equal employment opportunity and affirmative action for all applicants and employees. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, protected veteran status, or disability status or any other basis protected by federal, state or local law, ordinance or regulation. Elastic also makes reasonable accommodations for disabled employees consistent with applicable law.

When you apply to a job on this site, the personal data contained in your application will be collected by Elasticsearch, Inc. (“Elastic”) which is located at 800 W. El Camino Real, Suite 350 Mountain View, CA 94040 USA, and can be contacted by emailing jobs@elastic.co. Your personal data will be processed for the purposes of managing Elastic’s recruitment related activities, which include setting up and conducting interviews and tests for applicants, evaluating and assessing the results thereto, and as is otherwise needed in the recruitment and hiring processes. Such processing is legally permissible under Art. 6(1)(f) of Regulation (EU) 2016/679 (General Data Protection Regulation) as necessary for the purposes of the legitimate interests pursued by Elastic, which are the solicitation, evaluation, and selection of applicants for employment. Your personal data will be shared with Greenhouse Software, Inc., a cloud services provider located in the United States of America and engaged by Elastic to help manage its recruitment and hiring process on Elastic’s behalf. Accordingly, if you are located outside of the United States, your personal data will be transferred to the United States once you submit it through this site. Because the European Union Commission has determined that United States data privacy laws do not ensure an adequate level of protection for personal data collected from EU data subjects, the transfer will be subject to appropriate additional safeguards under the standard contractual clauses. You can obtain a copy of the standard contractual clauses by contacting us at privacy@elastic.co. Elastic’s data protection officer is Felix Wittern, who can be contacted at dpo@elastic.co. We plan to retain your data until such time as roles you may be suitable for are filled, as such we cannot estimate the specific time period that will be. We would consider this period to have ended once a candidate accepts our job offer. However, once that period of time is over, we may hold your data for an additional period of time that will not exceed 18 months. We do this to ensure you can be considered for potential future opportunities which you might be better suited for. To see additional information, please review our Elastic Privacy Statement.