Data engineer Jobs in Pasadena, CA

WHY DEPT®?

We are pioneers at heart. What this means is that we are always leaning forward, thinking of what we can create tomorrow that does not exist today. We were born digital and we are a new model of agency with a deep skillset in tech and marketing. That’s why we hire curious, self-driven, talented people who never stop innovating.

Our culture is big enough to cope and small enough to care. Meaning that with people across 20+ countries, we’re big enough to provide you with the best tools, global opportunities, and benefits that help you thrive. While acting small by investing in you, your growth, and your team, giving you the autonomy to solve our clients' problems, no matter where you are in the world.

This is a fully remote role but you must be located within the US to be considered.

THE ROLE

The Senior Business Intelligence 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 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 BI Engineer role will require work with Python to automate anomaly detection. 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
• Build tools that expand upon automation via DEPT’s existing systems
• 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
• Manage creation, implementation, validation and ongoing support of data visualization tools and recurring reports
• Serve the client as an expert on data visualization best practices
• 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
• Contribute to the company's knowledge base by creating and sharing case studies and POVs
• Develop logic to create an alert system for anomaly detection using Python

WHAT YOU'LL BRING

• Expertise with data visualization tools such as Tableau, Google Sheets, Data Studio is required.
• Advanced experience developing custom SQL
• Experience with MS SQL Server, 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 Secured Storage (sFTP, S3, 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
• 3-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
• 401k plan, plus matching
• PTO
• Paid Company Holidays
• Parental Leave

The anticipated salary range for this position is $106,900 - $125,000. 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.

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 company passionate about . 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 pioneering technology and marketing services company that creates integrated end-to-end digital experiences for brands such as Google, KFC, Philips, Audi, Twitch, Patagonia, eBay and more. Its team of 2,500+ digital specialists across 30+ locations on 5 continents delivers pioneering work on a global scale with a boutique culture.

DIVERSITY, EQUITY, & INCLUSION

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.

Not sure you meet all qualifications? Apply, and let us decide! Research shows that women and members of underrepresented groups tend not to apply for jobs when they think they may not meet every requirement, when in fact they do. We believe in giving everyone a fair chance to shine.

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.

Want to know more about our dedication to diversity, equity, and inclusion? Check out our efforts .

#LI-Remote