Data & Reporting Analyst
CaptivateUnited States1 day ago
Full-timeRemote FriendlyInformation Technology
Track This Job
Add this job to your tracking list to:
- Monitor application status and updates
- Change status (Applied, Interview, Offer, etc.)
- Add personal notes and comments
- Set reminders for follow-ups
- Track your entire application journey
Save This Job
Add this job to your saved collection to:
- Access easily from your saved jobs dashboard
- Review job details later without searching again
- Compare with other saved opportunities
- Keep a collection of interesting positions
- Receive notifications about saved jobs before they expire
AI-Powered Job Summary
Get a concise overview of key job requirements, responsibilities, and qualifications in seconds.
Pro Tip: Use this feature to quickly decide if a job matches your skills before reading the full description.
Who We Are
Captivate is North America’s leading location-based digital video network, reaching millions of professionals where they Work & Live. We connect viewers to the world outside their homes and offices by delivering valuable information and entertainment to influence personal and professional purchase decisions.
The Role
Data & Reporting Analyst
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.
What You’ll Do
Where You'll Be
At Captivate, we "Bring Life to Work" because we recognize the ever-evolving connection between work and life. Employees are invited to be their authentic selves, bring new ideas, and use each experience as an opportunity to learn and grow. We have a strong company culture that offers more than just benefits, leaving our employees with a strong bond with their team and beyond. Captivate also offers competitive benefits to all full-time employees, including:
Captivate celebrates and embraces having a diverse team. We are committed to building a team that represents a variety of experiences, backgrounds, and skills. We do not discriminate on the basis of race, color, religion, marital status, age, gender identity, gender expression, sexual orientation, non-disqualifying physical or mental disability, national origin, veteran status, or other applicable legally protected characteristics.
Captivate is North America’s leading location-based digital video network, reaching millions of professionals where they Work & Live. We connect viewers to the world outside their homes and offices by delivering valuable information and entertainment to influence personal and professional purchase decisions.
The Role
Data & Reporting Analyst
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.
What You’ll Do
- 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
- 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.
- 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
Where You'll Be
- At Captivate, we have a strong office culture and have started to work in-person Tuesdays to Thursdays, with the option to work remote on Mondays and Fridays.
- This role is based in our Lowell, MA office.
At Captivate, we "Bring Life to Work" because we recognize the ever-evolving connection between work and life. Employees are invited to be their authentic selves, bring new ideas, and use each experience as an opportunity to learn and grow. We have a strong company culture that offers more than just benefits, leaving our employees with a strong bond with their team and beyond. Captivate also offers competitive benefits to all full-time employees, including:
- Comprehensive Health Coverage
- Company paid Life Insurance, Short-Term & Long-Term Disability
- Pre-Tax Spending Accounts for Healthcare, Dependent Care & Commuter Expenses
- 401(k) Retirement Savings with Employer Match
- Paid Family Leave & Parental Leave
Captivate celebrates and embraces having a diverse team. We are committed to building a team that represents a variety of experiences, backgrounds, and skills. We do not discriminate on the basis of race, color, religion, marital status, age, gender identity, gender expression, sexual orientation, non-disqualifying physical or mental disability, national origin, veteran status, or other applicable legally protected characteristics.
Key Skills
Ranked by relevanceReady to apply?
Join Captivate and take your career to the next level!
Application takes less than 5 minutes