• Develop a deep understanding of the firm’s operations, departments, and technology stack. • Design, build, and maintain advanced Power BI dashboards and reports tailored to various departments (e.g., legal, marketing, HR, finance). • Manage Power BI Service: publish reports, configure data gateways, manage workspace permissions, and schedule data refreshes. • Integrate and transform data from multiple sources, including: Legal and CRM platforms: Filevine, LeadDocket, HubSpot Microsoft 365 tools: Excel, SharePoint, Teams, OneDrive HR and productivity tools: BambooHR, ActiveTrack. • Conduct in-depth data analysis to support strategic decisions by attorneys, directors, and executive leadership. • Automate reporting processes and build scalable, reusable data models. • Monitor and analyze KPIs, providing monthly/quarterly executive summaries. • Ensure data quality, consistency, and accuracy through regular audits and validation. • Collaborate with stakeholders to gather requirements and translate them into actionable insights. • Maintain comprehensive documentation of data sources, definitions, dashboards, and reporting standards. • Provide ad hoc analysis and support for special projects and operational needs.

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description The Staff Data Analyst - Sales will lead major sales analytics initiatives, driving data-driven decisions to optimize sales strategies and improve revenue generation. You will collaborate closely with the sales team to analyze sales performance, identify trends, and provide insights that shape sales strategies. In this role, you will leverage advanced data science techniques, mentor junior analysts, and ensure the seamless integration of data insights into the broader sales operations. This is a remote-first role and is open to applicants located within Canada and the United States where we comply with our legal hiring entities. In this role, you will report to the Senior Manager, Analytics. What You'll Do - Lead Major Sales Analytics Projects: Oversee and lead high-impact sales analytics projects, providing in-depth analysis of sales performance, sales forecasting, and revenue optimization to drive business decisions. - Advanced Data Analysis & Modeling: Use predictive analytics, regression modeling, and machine learning techniques to analyze sales data, identify patterns, and forecast future sales trends. - Sales Performance Reporting & Dashboard Creation: Develop and maintain comprehensive dashboards and reports that track key sales KPIs such as revenue growth, conversion rates, sales cycle optimization, and customer acquisition cost. - Cross-Functional Collaboration: Work closely with sales leadership, marketing, product teams, and finance to ensure alignment between sales strategies and business objectives, providing insights that inform key decisions and improve sales outcomes. - Mentor Junior Analysts: Guide and mentor junior team members, helping them develop technical and analytical skills, and ensuring best practices in data analysis, reporting, and insights delivery. - A/B Testing & Experimentation: Lead the design and execution of A/B tests and other experimentation initiatives to validate sales strategies, measure the effectiveness of campaigns, and refine sales tactics. - Customer Segmentation & Lead Generation Optimization: Conduct in-depth analysis of customer and lead data to develop insights into customer segmentation, improving lead targeting and marketing efforts. - Ensure Data Integrity & Best Practices: Oversee data quality checks and audits to ensure the accuracy, consistency, and integrity of sales data across systems, ensuring adherence to best practices for data management and analysis. Qualifications - 5-7 years of experience in data analytics, with a focus on sales analytics or related fields. - Strong proficiency in SQL for data extraction, manipulation, and reporting. - Deep expertise in sales analytics platforms such as Salesforce and the related sales cycle is required. - Advanced proficiency in data visualization tools (e.g., Tableau, Power BI) to create actionable reports and dashboards. - Experience with predictive modeling, forecasting, and regression analysis to support strategy development around new customer acquisition, expansion signal generation, and customer retention risk. - Strong ability to manage stakeholders and to work with cross-functional teams to ensure alignment between sales, marketing, and product strategies. - Proven ability to mentor junior analysts, providing technical guidance and support for their development. - Exceptional communication skills, with the ability to present complex insights to both technical and non-technical stakeholders. Who You Are - Tenacious: You are determined to succeed, and you are motivated by the success of customers, colleagues, and the community. - Curious: You are always learning and seeking ways to make things better. - Conscientious: You keep your promises, taking your commitments to others seriously, and you have strong integrity. - Humble: You lead with humility and empathy, respecting and learning from the perspectives of others. Guiding Principles - Step Up: Dare to go beyond the expected to achieve greatness. #StepUp - One Team: Make Hootsuite a place we soar together by respecting each other's individuality, building trust, and showing up for the team. #OneTeam #FreeToBeMe - Customer Obsessed: Focus relentlessly on helping our customers succeed. #CustomerObsessed - Go Fast, Be Agile: Widen our competitive advantage by committing to speed and simplicity over perfection and complexity. #GoFastBeAgile - Play to Win: Commit to building an incredible, profitable company for our customers, our employees, and our stakeholders. #PlayToWin #NoExcuses - Neighbours & Allies: Give back to our communities and be an ally. #SocialForGood #Allies Accommodations will be provided as requested by candidates taking part in all aspects of the selection process. This posting is for a current vacancy for which we are actively hiring.

• Help to drive strategic Enterprise Data Warehouse projects. • Follow and advise on industry standards and advances on data driven technologies and tools. • Analyze data to determine relationships between large datasets. • Create complex end-to-end data flow diagrams and logical data models. • Develop basic - intermediate SQL scripts for various reporting and ad-hoc analysis. • Document data requirements, source to target data mapping, collaboration with technology teams, design, development, testing, and deployments. • Document system of record data models and map to business process. • Data mapping specification designs, data feed specifications, data analysis and data comparison. • Develop and document data remediation requirements and plans. • Adhere to Agile principles and philosophies (Scrum or Kanban, as applicable) in fulfillment of the role. • Responsible for reporting risks that are identified to the appropriate team and/or management. • Additionally, responsible for managing, monitoring and reporting risks within the scope of your work area, to include, but not limited to Information Security risks. • Must be detailed focus with the ability to detect patterns and possible solutions from large volumes of data. • Mentor less tenured data analysts. • Perform other duties as assigned.

• Lead strategic Enterprise Data Warehouse projects. • Mentor less tenured data analysts. • Follow and advise on industry standards and advances on data driven technologies and tools. • Analyze data to determine relationships between large datasets. • Create complex end-to-end data flow diagrams and logical data models. • Develop complex SQL scripts for various reporting and ad-hoc analysis. • Document business requirements, source to target data mapping, collaboration with technology teams, design, development, testing, and deployments. • Document System of Record data models and map to business process. • Data mapping specification designs, data feed specifications, data analysis and data comparison. • Develop and document data remediation requirements and plans. • Regular and reliable attendance. • Responsible for reporting risks that are identified to the appropriate team and/or management. • Responsible for managing, monitoring and reporting risks within the scope of your work area, to include, but not limited to Information Security risks. • Ability to coach and mentor less tenured data analysts. • Perform other duties as assigned.