Sr. Data Warehouse Engineer II

GROW WITH US:

Tandem Diabetes Care creates new possibilities for people living with diabetes, their loved ones, and their healthcare providers through a positively different experience. We'd love for you to team up with us to "innovate every day," put "people first," and take a "no-shortcuts" approach that has propelled us to become a leader in the diabetes technology industry.

STAY AWESOME:

Tandem Diabetes Care is proud to manufacture and sell the t:slim X2 insulin pump with Control-IQ technology. We're also so much more than that. Our company's human-centered approach to design, development, and support delivers innovative products and services for people who use insulin. Since many of our own team members live with type 1 diabetes, or have a loved one impacted by diabetes, the work is personal, and we are committed to the cause. Learn more at tandemdiabetes.com.

A DAY IN THE LIFE:

The Sr Data Warehouse Engineer II designs and builds ETL workflow according to Tandem's data technology architecture and solutions. Will play a key role in designing, developing, testing, maintaining, and monitoring ETL process, primarily focusing on data processing/modeling using SQL and programming languages such as Python and Spark. This position will extract, transform, and load structured and unstructured data from internal and external sources.

The engineer will assist the team with the collection of specifications and develop documentation required for implementing solutions according to the department SDLC. Will help develop processes and data infrastructures based on business and technical requirements to channel data from multiple sources, route appropriately and store within our enterprise data warehouse. The engineer will be comfortable collaborating cross-functionally with technical and non-technical stakeholders. They will also be an integral contributor to the migration of our data warehouse to a modern cloud-based platform.

• Responsible for the development and implementation of ETL/ELT workflows to support the enterprise data warehouse following department standards.

• Provides ongoing support for the EDW, such as maintaining ETL and SQL packages, procedures, and jobs.

• Performs ETL performance tuning, data validation and job monitoring.

• Assists in migration of legacy SQL code to modern cloud-based arc

• Collaborates with data analysts and stakeholders to deploy reusable data models for dashboards and reports.

• Ensures proper design and development documentation is completed according to the department SDLC.

• Ensures compliance with company policies, including Privacy/HIPAA, and other legal and regulatory requirements.

• Provides subject matter expertise in data infrastructure, data warehouse and data quality controls.

YOU'RE AWESOME AT:

• Demonstrated proficiency in ETL/ELT, data modeling, and Datamart development using SQL Server and SSIS; Databricks preferred.

• Proficiency in best ETL practices and logging mechanisms.

• Expert T-SQL skills including proven ability to read, write and debug complex SQL queries.

• Demonstrated proficiency working with extremely large datasets and disparate data source systems.

• Working knowledge of Power BI or other data visualization software.

• Proficiency in development using Python and Spark is a plus.

• Experience with OLTP (online transaction processing) data sources (MS Dynamics AX & CRM preferred).

• Change Management Systems experience required; JIRA preferred.

• T-shaped: strong in data warehouse engineering, but also strong capabilities to deliver actionable results in a collaborative environment; excellent pragmatic problem solving, attention to detail, strong written and verbal communication skills, curiosity, and a demonstrated ability to learn and grow new skills.

WHAT YOU'LL NEED:

• B.S. in computer science or equivalent combination of education and applicable job experience.
• 6 years of experience working on data infrastructure.

WHAT'S IN IT FOR YOU?

In addition to innovative technology, we have a culture that fosters the idea that the happiest people are the most productive people. Not only do we hire forward-thinking achievers to join our workforce; we reward, develop, and retain them too. Just one of the many reasons of how we #StayAwesome! To learn more about our culture and benefits please visit https://www.tandemdiabetes.com/careers.

BE YOU, WITH US!

Tandem is firmly committed to being an equal opportunity employer and maintaining a diverse and inclusive environment. We value and embrace that every single one of us brings value to the table. But sometimes we forget that when we don't meet 100% of a job description's criteria - maybe you're feeling that way right now? We encourage you to apply anyway. Because we want you to be you, with us.

COMPENSATION & BENEFITS:

The starting base pay range for this position is $126,200 to $143,500 annually. Base pay will vary based on job-related knowledge, skills, experience and may also fluctuate depending on candidate's location and the overall job market. In addition to base pay, Tandem offers a competitive compensation package that includes bonus, equity, and a robust benefits package.

Tandem offers health care benefits such as medical, dental, vision, health savings accounts and flexible saving accounts. You'll also receive 10 paid holidays per year, a minimum of 20 days of paid time off (starting in year 1) and have access to a 401k plan with company match. Learn more about Tandem's benefits here!

YOU SHOULD KNOW:

Potential new employees must successfully complete a drug screen (excludes marijuana) and background check which includes criminal search, education certification and employment verification prior to hire.

APPLICATION DEADLINE: The position will be posted until a final candidate is selected for the requisition or the requisition has a sufficient number of applications.

REFERRALS:

We love a good referral! If you know someone that would be a great fit for this position, please share!

If you are applying for this job and live in California, please read Tandem's CCPA Notice: https://www.tandemdiabetes.com/careers/california-consumer-privacy-act-notice-for-job-applicants.

#LI-Remote #LI-KS1