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

#J-18808-Ljbffr