Twilio is seeking a Data Analyst for BI with an industry experience and a deep understanding of data usage and lifecycles across a SaaS-based organization. We are looking for someone to build the data visualization layer, used by our various business teams and business applications, in a way that enables the wide variety of downstream reporting required (from real-time, to daily/weekly/monthly summaries).

About the job:

The person in this role will be responsible for the design and implementation of the data models, dashboards & reports that will involve building star schema structures, querying the data warehouse data and building visualization using BI/reporting tools. This individual will work closely with other members of the Business Intelligence team, as well as the analysts from various business teams, to ensure the solutions that are developed and implemented are tightly aligned to enterprise business standards and principles. The individual will act as a subject matter expert for the data models, dashboards, reports and overall analytics provided by Business Intelligence team.

Responsibilities:

• Acquire data from data warehouse system by writing complex SQL queries.
• Collaborate with business users and other analysts in Finance, Marketing, Sales etc. to support their data needs.
• Work closely with data engineers in BI team to provide business rules that need to be built up in ETL solutions.
• Design and build dimensional data models using star schemas for data warehouse.
• Build data visualizations with dashboards and reports for various business departments using one of the BI/reporting tools like Looker, Domo, Tableau etc.
• Build internal data quality measures and processes to ensure the accuracy of data models, reports and dashboards.
• Build self service analytics environment which given easy drill down/up capabilities to business users and other analysts.
• Participate in defining and standardizing business metrics and key performance indicators.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Identify trends in large data sets and validate expected and unexpected trends in the data to assist in identifying solutions to resolve the unexpected.

Requirements:

• BS or MS in Computer Science, Information Management or related fields.
• Experience in building self service analytics solutions for business users across multiple domains like finance,marketing, sales etc.
• Experience in building dimensional data models using star schemas.
• Experience working with various database systems and thorough understanding of database and SQL optimization techniques.
• Experience with one of the Business Intelligence and dashboarding/reporting tools, including Looker, Domo, Hyperion, Informatica, etc.
• Experience writing complex SQL queries in a data warehouse environment.
• Experience dealing with large, scalable, or high performance data systems.
• Familiarity or basic knowledge of one of the scripting languages like Python, Scala etc.
• Strong analytical skills with the ability to collect, organise, analyse, and disseminate significant amounts of information with attention to detail and accuracy.
• Excellent oral and written communication skills and an ability to translate complicated technical issues for a non-technical audience.

Bonus points:

• Experience working in AWS environment.
• Experience working with distributed systems like Spark, Hive etc.