Job Summary
With the extreme growth rate of our company, teams, and customer base, we are looking for a Data Analyst to help our Business Intelligence team keep up with the needs of the business by providing data and reports to our various functional areas in a timely manner.
As part of this team, you’ll work with your team members, our Data Architect, as well as stakeholders throughout the company to build and maintain new reports and dashboards in Power BI and Salesforce, providing better access and visibility to our business data. You’ll be working within our CRM looking at Sales, Marketing, as well as with our billing data and product usage data.
This position requires a consistent work ethic, strong attention to detail, the ability gather requirements, and a customer-centric mindset.
Responsibilities
• Design, Develop, and maintain reports and dashboards within Power BI and Salesforce in a timely manner based on the needs of the business.
• Build and maintain Power BI data models, including relationships, calculated columns, and measures. Automate data refresh schedules and ensure the reports are up-to-date with the latest information.
• Work with data sources such as SQL databases, Excel, Share Point, and other external APIs to gather, transform, and load data for reporting.
• Work tickets assigned to you via Jira through our Analytics Sprint planning process. Providing visible progress and closed-loop communication through updates on the tickets.
• Work with stakeholders to solve through requirements and achieve a clear understanding on requests.
• Managing and manipulating data and views to meet the needs of the business
• Working backwards through metrics and reports to understand filters for the purpose of recreating, improving upon and/or consolidating them
• Help maintain our data dictionary, reporting index, and any other internal documentation used to provide visibility to our reporting stack to our internal teams
• Provide feedback to our Data and Operations teams on the states of our data and data sources for opportunities to improve data integrity or gain efficiencies in gathering data.
• Conduct training sessions or provide support to end-users on using Power BI reports effectively.
• Stay updated on Power BI updates, best practices, and new features to improve the efficiency and effectiveness of reporting processes.
• Will be working various cloud software including Salesforce, Net Suite, Hubspot and more.
Requirements
• Bachelor’s degree in Business Analytics, Computer Science, Information Systems, Mathematics, Statistics, Data Science, or a related field; equivalent practical experience will be considered.
• 4+ years of professional experience in analytics, business intelligence, reporting, or a related data-focused role.
• Advanced SQL skills, including joins, CTEs, window functions, aggregations, query optimization, and working with relational databases such as Postgre SQL.
• 2+ years experience using Snowflake as a cloud data warehouse to query, transform, and analyze business data using advanced SQL.
• 5+ years of experience building, publishing, and maintaining Power BI reports, dashboards, semantic models, DAX measures, and Power Query transformations.
• Strong understanding of data modeling concepts, including star schemas, relationships, calculated measures, data quality controls, and performance considerations for BI solutions.
• Hands-on experience with Python for data analysis, automation, and data preparation using common libraries such as pandas, Num Py, or similar tools.
• Experience with modern data warehousing, ETL/ELT concepts, and cloud data platforms or services such as AWS S3, AWS Glue, AWS RDS, Snowflake, Redshift, Big Query, or similar technologies.
• Familiarity with analytics engineering practices such as reusable data models, documentation, data lineage, version control, testing, and governed self-service reporting.
• Ability to gather requirements, define success metrics, translate business questions into analytical approaches, and communicate trade-offs clearly to technical and non-technical stakeholders.