Data Analyst/BI Engineer

Dept Holding B.V.; Northern (KY); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Healthcare

Dental

Vision

PTO

Paid holidays

Job summary

DEPT® is a Growth Invention company that blends technology and marketing to help ambitious brands grow. The Senior Data Analyst / BI Engineer partners with stakeholders to implement automated reporting, unify data sources, and evolve automation and reporting services.

The role focuses on ingesting data from multiple sources via API and ETL tools, transforming data with SQL, and linking to visualization platforms while building Python-based pipelines for automation.

Qualifications

• 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 and transformation logic.
• 5+ years of relevant work experience.

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 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.

Skills

Tableau

Looker

Data Studio

SQL scripting

Advanced SQL

Tools

MS SQL Server

BigQuery

Snowflake

Azure

SFTP

S3

Job description

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.

THE ROLE

The Senior Data Analyst / BI Engineer role will require partnering with key internal (intra-team and cross-disciplinary) stakeholders to implement automated reporting deliverables and work with our broader team to contribute to and evolve our automation and reporting services. The ideal candidate will be able to help support the team in development work by unifying multiple data sources and evolving our process to create and maintain reporting and analytical tools. The Senior Data Analyst / BI Engineer will be responsible for interacting with internal and external stakeholders to develop products and services focused on data automation. They will 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. Additionally, the Senior Data Tech Engineer role will require work with Python to automate pipelines and transform data. Additionally, they will be able to act as a subject matter expert and be a partner to our internal teams.

WHAT YOU’LL DO

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

WHAT YOU’LL BRING

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

WHAT DO WE OFFER?

We are a collaborative, open-door, best-idea-wins environment that fosters personal and company growth and has fun doing it. Here is a snapshot of our benefits package:

• Healthcare, Dental, and Vision coverage
• PTO
• Paid Company Holidays

WE SUPPORT YOU BEING YOU:

DEPT® is an equal opportunity employer (EOE). We believe our work is its best when our people feel safe and free to be themselves. We’re committed to an inclusive and barrier-free recruitment and selection process and workplace, regardless of anyone’s identity, background, beliefs, lifestyle or disabilities. So tell us about any accommodations you need. It’s totally confidential and only used to make sure you feel fully supported at every step.

DEPT® participates in E-Verify, meaning your Form I-9 information will be sent to the federal government to confirm you are authorized to work in the U.S.

We are a B Corp-certified company passionate about purpose-driven work . Our hope is that you can feel good about the contributions DEPT® is making to the world and we always have an open door for your ideas in making the world a better place.

DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specialists deliver growth invention across Brand & Media, Experience, Commerce, CRM, and Technology & Data. We’re 50|50 tech and marketing, partner-led, and first to move. Clients include Google, Lufthansa, Coach, eBay, and OpenAI.

At DEPT®, we take pride in creating an inclusive workplace where everyone has an equal opportunity to thrive. We actively seek to recruit, develop, nurture, and retain talented individuals from diverse backgrounds, with varying skills and perspectives.

We also encourage you to reach out to us and discuss any reasonable adjustments we can make to support you throughout the recruitment process and your time with us.

The anticipated salary range for this position is listed below. Salary is based on a range of factors that include relevant experience, expertise, physical location, and organizational impact. This is based on a 40-hour workweek and leveling. Keep in mind, we’re flexible.

US Remote Range

$85,000 — $110,000 USD

Be part of our digital future

We may be spread across the world, but we all work together as one team. Inspiring each other, collaborating, innovating, and creating together.