AMP Agency Data Specialist in Boston, Massachusetts
AMP Agency ? named one of AdWeek?s 100 Fastest Growing Agencies? is looking for a Data Specialist to join its Analytics team. Having reached a critical point in our evolution, the team is undertaking efforts to become more efficient and effective in how we standardize data sourcing, extraction, storage, staging, and visualization workstreams. The person hired for this role would play an important part in architecting the ways through which we manage and scale our data work.
The Data Specialist will report directly to the Group Director of Analytics; collaborating with him and other team members to evolve our data stack?s scale, power, and ease-of-use. Emphasis will be placed on automating data extraction from multiple sources to a centralized cloud server, staging data in a relational format, and assisting with the creation of visualization templates. Inherent in the role is a need to collaborate with Analytics, Media, and Technology teams, to ensure optimal data practices are upheld throughout; as internal stakeholders and clients alike rely on our data.
Note: Our current stack is a basic one; and so, the person in this role will be given license to build upon our past work, and/or make a case for using different technologies, in order to achieve the desired outcomes.
Manage all central data activities for the Digital Analytics team; including data extraction, transformation, storage, staging, and visualization.
Create, QA, and monitor automated workflows (where applicable).
Work with the Group Director of Analytics to pursue continuous improvement in the technology, processes, and ways-of-working that support the Analytics team.
Collaborate with Analytics leadership to establish a vision for building optimized, automation-driven data practices.
Assist teammates with data-related requests; including business-requirement scoping, ad hoc data extractions, ongoing data refresh, and troubleshooting.
Develop and manage documentation on a rolling basis; ensuring that it reflect the most recent updates to systems, processes, and associated ways-of-working.
Between 2-4 years in data systems architecture or a similar support role.
Bachelor?s Degree or bootcamp certification with demonstrable focus on data systems.
Intellectually curious, analytical, and a systems-oriented thinker.
Possesses strong verbal and written communication skills, to collaborate across teams and ensure clear documentation.
Experience with data processing and management in local (e.g. SQL server) and/or cloud environments (e.g. Azure, AWS) is required.
Experience with data extraction (via APIs, FTP, and native software connectors) and cleaning is required.
Experience with data visualization software (e.g. Tableau, Microsoft PowerBI) is preferred. Experience with PowerBI is a plus.
Experience with Microsoft Office products, particularly Excel, is preferred.
Experience with presentation software (e.g. PowerPoint, Keynote) is preferred.