Data Analyst – Strategy & Operations

Summary

Join IntelliPro's Strategy & Operations team as a Data Analyst II and contribute to the success of our advertising sales leaders. You will play a vital role in streamlining and optimizing our data infrastructure, ensuring data accuracy and timeliness. Responsibilities include daily monitoring of service-level objectives (SLOs), quality assurance and testing, data mart evolution, Tableau dashboard management, quarterly rollovers, and table and data deprecation. This 6+ month contract position (with potential for extension) requires 2-3 years of experience in a similar analytical role and expertise in SQL, Python, and Tableau. The ideal candidate will possess strong data quality management skills and excellent communication abilities. Remote work is available for candidates located in the EST (US) time zone.

Requirements

• Experience: 2-3 years in a similar analytical role, with a proven track record of managing and maintaining large datasets
• Technical Skills: Expertise in analytics technologies such as SQL, Python, and Tableau, along with experience in ETL tools and pipeline development
• Data Quality: Strong understanding of data quality management and continuous improvement processes
• Adaptability: Demonstrated ability to succeed in a fast-paced, complex environment
• Attention to Detail: Meticulous with a strong focus on achieving strategic outcomes
• Communication: Excellent written and verbal communication skills, with the ability to translate broad data questions into clearly defined objectives

Responsibilities

• Daily SLO Monitoring: Conduct proactive daily monitoring of service-level objectives (SLOs) for core dashboards and tables, ensuring data availability by 9 AM. Track and log refresh statuses, communicate any delays, and coordinate with the SS&O and upstream data engineering and BI teams via Slack for timely resolutions. Implement manual workarounds or refresh downstream jobs as needed to maintain effective communication
• Quality Assurance and Testing: Assist with quality assurance and testing for changes to our core infrastructure, leveraging established frameworks and your expertise to execute validation steps while minimizing the impact on broader team resources
• Data Mart Evolution: Contribute to the development and enhancement of the Sales Ops data mart, adapting to evolving business needs and technologies
• Tableau Dashboard Management: Implement tactical data access changes across our Tableau dashboards, adjusting data sources to align with new sales data access controls (row level security). Coordinate the manual setup process for dashboard republishing to accommodate organizational changes
• Quarterly Rollovers: Support end-of-quarter archive and restatement activities, focusing on quality assurance and reconciliation work to ensure a smooth transition and accuracy in quarterly data reporting
• Table and Data Deprecation: Manage the data lineage tracing and oversee the deprecation of obsolete XFN team and predefined SalesOps tables. Work collaboratively with teams to ensure smooth deprecation processes by identifying and liaising with downstream users and facilitate communications to encourage cross-functional teams to seamlessly transition to new or alternative tables, minimizing disruptions

Preferred Qualifications

Industry Knowledge: Familiarity with sales and digital advertising platforms, as well as a working knowledge of sales systems and tools, is a plus

Benefits

Additionally, IntelliPro provides a comprehensive benefits package, all subject to eligibility