Data Analyst/BI Engineer

About Us

We are a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, we create what is next by pioneering ideas, acting fast, and moving further because standing still just is not in our DNA. We are drawn to people who stay curious, move with intent, and never stop inventing. Our culture runs on three values: better together, relentlessly curious, and get sh*t done. It is how we work, how we grow, and how we make things that matter.

At DEPT®, you will find the freedom to explore, the space to collaborate, and the trust to make a real impact for our clients, for each other, and for the world we are helping to build.

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
• Ingest data in our database from multiple sources using API calls and ETL tools, manipulate data for reporting using SQL to consolidate dimensions and metrics across tables, link the SQL view to a variety of visualization tools, and customize the reports to meet the customers’ needs
• Work with Python to automate pipelines and transform data
• Act as a subject matter expert and be a partner to our internal teams

Requirements

• Expertise with data visualization tools such as Tableau, Google Sheets, Looker/Data Studio
• 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)
• Experience with MS SQL Server, Big Query, Snowflake, Azure or other data extraction, transformation, and storage tools
• 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
• Excellent organizational, written, and communication skills
• Ability to manage multiple tasks to completion within established deadlines
• Strong problem-solving, technical, and communication skills with a desire to innovate
• 5+ years of relevant work experience

Benefits

• Healthcare, Dental, and Vision coverage
• 401k plan, plus matching
• PTO
• Paid Company Holidays
• Parental Leave

Pay

US Remote Range: $85,000—$110,000 USD (based on a 40-hour workweek and leveling).