Description

Overview

This role provides expertise in business intelligence and data governance. Including: data mapping and ETL, reports, dashboards, vendor imports/exports, data architecture, QA/QC, and all other agency and client data-related initiatives. This work may include building visualizations/dashboards, assisting with data analysis, developing and maintaining imports and exports, ensuring data quality, troubleshooting issues, creating documentation, and fielding user questions/feedback. You will also have direct client interaction and provide status updates.

22squared believes that each employee plays an integral role in the overall success of our agency. Because of that, an employee's contributions should not be limited by the responsibilities listed in a job description. This job description is designed to outline the primary duties, qualifications and job scope, Not limit the employee to just the key responsibilities identified.

Responsibilities
• Oversee Business Intelligence outputs and mind for opportunities to exceed expectations and iterate
• Manage data streams and other data resources from an array of media and business landscapes
• Building automation and queries
• Building client-ingestible, creative dashboards and visualizations
• Implementing quality control procedures and guidelines
• Ensure that collected data is relevant and exhaustive while also interpreting the analytics results
• Oversee data audits and put remedial solutions in place, and actively participating in audit and QA procedures
• Support dashboard initiatives through quality assurance and user acceptance testing
• Prioritize, plan, and track project progress
• Work with a variety of stakeholders and data sources from across the organization and beyond to draw strategic conclusions
• Develop an understanding of each department's role within the company; maintain advanced knowledge of their needs
• Identify/Anticipate departmental challenges/needs through employee and client communication
• Research and analyze areas of interest to the company which will allow the company to gain a competitive advantage in the business intelligence landscape
• Document and catalog findings for future reference or additional investigation

Minimum Qualifications
• Bachelor's Degree
• Strong attention to detail and excellent time management
• Strategic thinker with the ability to operate without strict oversight
• 12+ years business intelligence or data analytics experience, plus 5-7 years of management experience
• Ability to create dashboards and build custom visualizations, when needed using Datorama, Tableau and/or Google Data Studio
• Experience with data retrieval and manipulation (ETL) platforms like Excel, SQL, Tableau Prep
• Understanding of web analytics tools (i.e., Google Analytics, Adobe Analytics, etc.)
• Strong understanding of media platforms (i.e., Search Ads, DoubleClick Campaign Manager, Facebook Ads Manager)
• Familiarity with Agile as a project management approach and related software (JIRA Smartsheets, Slack)
• Bonus: Experience with Python