Key skills
Data visualization toolsAdvanced SQLData ecosystem architectureDigital Marketing dataScripting languagesData extraction toolsGCP experienceOrganizational skillsCommunication skillsProblem-solving skillsJavaScriptSQLLookerBITableauSnowflakeAzureGCPS3SQL ServerCommunication
About this role
DEPT® is a Growth Invention company that helps ambitious brands grow faster at the intersection of technology and marketing. The Senior Data Analyst / BI Engineer will partner with internal and external stakeholders to implement automated reporting and develop analytical tools, focusing on data automation and visualization.
Responsibilities:
- Work with the internal teams, external partners, and the client to assess automation needs
- Take lead on projects and contribute to the evolution of processes by working with the team as well as independently with the goal of driving efficiency
- Lead data quality assurance efforts, proactively validating datasets against sources of truth and implementing checks to detect discrepancies
- Manage creation, implementation, validation and ongoing support of data visualization tools and recurring reports
- Grow credibility with internal and external stakeholders by exceeding expectations and delivering valuable products and services
- Develop and refine best practices and documentation around onboarding and usability
- Design, develop, and maintain automation that supports DEPT’s existing data ingestion, validation, and operational workflows
Requirements:
- Expertise with data visualization tools such as Tableau, Google Sheets, Looker/Data Studio, required
- Advanced experience developing custom SQL & an ability to troubleshoot complex SQL scripts
- Advanced Architectural fluency across complex data ecosystems, with the ability to trace data lineage, understand transformation logic, and assess approach/ impacts
- Experience working with Digital Marketing data
- Fluency in scripting languages (JavaScript, Google Apps Script, etc)
- Requires excellent organizational, written, and communication skills
- Ability to manage multiple tasks to completion within established deadlines
- The ability and strong desire to innovate with strong problem-solving, technical, and communication skills
- 5+ years of relevant work experience
- Experience with MS SQL Server, Big Query, Snowflake, Azure or other data extraction, transformation and storage tools preferred
- Knowledge of collecting and storing data using data transfer tools such as SSIS or Matillion, and experience with Secure Storage (sFTP, S3, etc.)
- Experience with GCP or similar platforms