Business Intelligence Analyst Intern

Full Time
9 months ago

We’re UserTesting, a leader in experience research and insights; we believe the path to human understanding and great experiences start with a shared understanding—seeing and hearing how another person engages with the world around them and taking in their perspective. Working at UserTesting, you will be empowered to help organizations  discover the human side of business–transforming how they work, collaborate, innovate, and bring new products and experiences to market. This is what inspires us, and it’s how we enable companies to connect with their audiences naturally and organically through an experience that is uniquely, and intentionally human.

A trusted company by top brands for 15+ years, UserTesting, recently merged with UserZoom, has over 3,400 customers in 50 countries, including 75 of the Fortune 100 companies. Joining our team means being part of a passionate group focused on transforming how companies learn from and understand their customers. Come join us and help us build the engine for human understanding.

Our internship is not only an opportunity for you to learn, develop and gain experience in a market-leading, global software company, it’s an opportunity for you to bring diversity, ideas and energy to UserTesting. If you’d like to hear more about it, watch our short video:

https://usertesting.wistia.com/medias/j5be6ao9mq

The Team

The Business Intelligence (BI) team is responsible for calculating and reporting on the key metrics that help gauge company performance. We work closely with both the senior executive team and operational leaders to build an integrated metric framework, which gives us insight into the health of the company’s core activities. This is an ever-evolving process that requires a deep understanding of the operations of each department and the ability to measure the most important leading and lagging indicators of performance.

We are an analytical and open-minded team. The breadth of our work requires us to be flexible collaborators as we switch gears across our many initiatives. We scale the impact of our work by taking a process driven approach. We invest in building repeatable metrics and business processes that are robust enough to forecast our long-term business health as well as address the ad-hoc opportunities of the day-to-day.

 

Job Summary:

The BI Analyst Intern will be responsible for working with technical/functional teams to understand their data & reporting needs and delivering required information using suitable optimized solutions. You will work with technical/functional SMEs to document business requirements, convert them to reporting specifications, and develop reporting processes to derive required metrics. You will also work with BI developers to modernize the data platform to make the data more findable, interoperable, and reusable.

The BI Analyst Intern will design & build data artifacts (e.g. SQL scripts, data models, ETL) to enhance data accessibility and scalability for the reporting needs of the company. Beyond ensuring the validity and timeliness of data, you will also work on key reports and dashboards delivered to functional leadership to measure the company’s health and progress against key goals.

Duties/Responsibilities:

  • The primary focus will be on building data engineering solutions & reporting dashboards by modernizing and streamlining the data platform and collaborating with various technical/functional teams within the organization to fulfill their reporting needs.
  • Work with technical/functional leads to gather reporting requirements, document business logic, prepare technical specifications, and confirm/validate data to assess business needs.
  • Design, construct, and sustain BI data models to enhance data accessibility and scalability
  • Develop tools & pipelines to collect, clean and transform data modes to feed reporting
  • Minimize technical debt and focus on reproducibility (keep docs/code up to date, prepare/design for future use cases)
  • Use data quality best practices to ensure the integrity of the data being used and the thoroughness of results 
  • Design and monitor alerts on data fluctuations and deviations to proactively catch and address data issues and anomalies.
  • Support and contribute to the BI team knowledge base by focusing on documentation, data mapping, and delivery methods to better design and build metrics that enhance our analytical capabilities.
  • Help assess the effectiveness and accuracy of new data sources, data points, and data-gathering techniques

 

Required Skills/Abilities:

  • Ability to perform efficient data analysis, data modeling, and database development for reports/visualization.
  • Comfortable working with large data sets across multiple sources, conducting validation, and ensuring data accuracy & relevance.
  • Proficiency in technical skills including SQL development, writing complex queries, and ETL concepts for data extraction
  • Well-versed with data visualization techniques including familiarity with Tableau, Looker & similar tools
  • Meticulous attention to detail and an intuitive understanding of query optimization and high-performance data pipelines.
  • Strong communication and organizational skills to collaborate with multiple stakeholders
  • Demonstrates UserTesting’s values through work product and within day-to-day team interactions.
  • Excellent verbal and written communication skills.
  • Excellent interpersonal and customer service skills.
  • Excellent time management skills with a proven ability to meet deadlines.
  • Ability to function well in a high-paced and at times stressful environment.
  • Organized, flexible and proactive in responding to changes in business needs

Good-to-have skills: 

  • Familiarity with Python, dBT for data analysis and modeling
  • Good understanding of cloud database services like Snowflake, AWS including familiarity with dimension modeling & data warehouse concepts would be a value add.
  • Understanding of statistical methods for data analysis and evaluating key reporting metrics

Education and Experience:

  • Enrolled in Bachelor’s or Master’s degree in Computer Science, Business or Information Systems type of equivalent degree.
  • Previous technical internship experience(s) or certifications, if applicable

To learn more about our team, culture, and customers, check out our careers page, company blog, and press/awards. Aside from a great work environment and the opportunity to make an impact, we’re also growing the team quickly–join us!

At UserTesting, we are committed to providing more inclusive and accessible experiences for our candidates. We pride ourselves on building empathy; diverse perspectives, which we believe are the key values to creating exceptional experiences for everyone. Our commitment to providing accessible experiences is driven by this belief and our core values. If you require any accommodations or have any specific requests about how we could tailor our interview process to better suit your needs please contact us on: talentexperience@usertesting.com.If you need to speak to someone please ask!

******

UserTesting is an Equal Opportunity Employer and a participant in the U.S. Federal E-Verify program.  Women, minorities, individuals with disabilities and protected veterans are encouraged to apply.  We welcome people of different backgrounds, experiences, abilities and perspectives.  

UserTesting will consider qualified applicants with criminal histories in a manner consistent with the San Francisco Fair Chance Ordinance, as applicable.  

We welcome candidates with physical, mental, and/or neurological disabilities. If you require assistance applying for an open position, or need accommodation during the recruiting process due to a disability, please submit a request to People Operations by emailing askPeopleOps@usertesting.com.