Data & Reporting Analyst

CAPTIVATE LLC•Lowell, MA

4d•$80,000 - $90,000•Hybrid

About The Position

The Data & Reporting Analyst will help define and visualize the data model for Captivate’s wealth of data. This is a key position reporting directly to the Manager of Business Intelligence, contributing to Captivate’s organizational centralized reporting strategy. This role’s responsibilities will include driving Captivate’s Tableau development and report creation, positioning the company for rapid scalability and enabling data-driven decisions across all business units. This role will utilize complex data to identify insights for a reliable view of the business. Our goal is to be able to make observations and recommendations as subject matter experts in respect to all operations: Ad Sales, Revenue, Real Estate, Finance, Customer Success, Editorial, Marketing, Traffic and other business units with confidence and regularity.

Requirements

A Bachelor’s degree in computer science or related field
3+ years of relevant experience and proven track record of success in data management and leading reporting and business insight initiatives
2+ years of Tableau experience, Tableau Certification(s) a plus
A high-level of emotional intelligence, and an ability to work with and influence a diverse set of internal stakeholders within fast moving entrepreneurial culture
Proven experience working with hybrid (onshore and offshore) development and support teams
Ability to interact with and influence business stakeholders and adapt style as needed for technical or non-technical audiences
An ability to understand business process and requirements and translate them into actionable and reportable metrics
An ability to cleanse and link complicated and disparate data sets from multiple sources
Proficient knowledge of SQL, including the ability to write basic queries and perform application troubleshooting analysis at the database level, experience with Snowflake a plus
Effective verbal and written communication skills
Ability to identify requirement conflicts and bring clarity to business objectives, requirements and priorities.

Nice To Haves

Experience with NetSuite a plus
Knowledge of any ETL product; SSIS is a plus
Automated deployment and release management is a plus
Knowledge of using Atlassian Confluence Wiki and JIRA tools is a plus

Responsibilities

Design, build, and maintain Tableau dashboards to monitor end-to-end business operations
Work with leadership team to clearly define and document reporting requirements and KPI’s to enable data-driven decisions
Meet with business owners and end users to proactively collect business requirements and apply systems analysis techniques and procedures to determine feasibility and sensibility of systems, implementations and lifecycle maintenance.
Lead collaborative efforts across the business to understand processes and pain points, as well as evaluate, recommend, and drive people, process, and technology improvements that align with Captivates strategy
Be proactive in determining pain points and creating interactive dashboards in Tableau to address them
Leverage APIs and iPaaS platforms; monitor data quality, accuracy, and consistency; simplify and automate data extraction, transformation, and load activities wherever possible
Prepare specific data sources based on back-end data depending upon business requests
Identify, manage, resolve, and track client issues as they arise, using various agile development toolsets such as Confluence, Jira.
Support system conversions, upgrades, enhancements through utilizing exception reporting
Troubleshoot technical issues with platforms, data discrepancies, alerts etc.
Perform ad hoc analysis, insight requests, and data extractions to resolve critical business issues
Prepare time and cost estimates for completing tasks and projects
Be resourceful and practical in a dynamic and fast paced environment