Data Analyst/BI Engineer

DEPT® is a Growth Invention company operating at the intersection of technology and marketing to help ambitious brands grow faster. The Senior Data Analyst / BI Engineer will partner with internal teams, external stakeholders, and clients to develop automated reporting, data visualization, and data automation solutions. The role involves ingesting and transforming data from multiple sources, maintaining reporting tools, ensuring data quality, and automating data workflows using SQL, Python, APIs, and ETL tools.

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)
• 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
• 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