Developer, Database - Snowflake

About the position

At T-Mobile, we invest in YOU! Our Total Rewards Package ensures that employees get the same big love we give our customers. All team members receive a competitive base salary and compensation package - this is Total Rewards. Employees enjoy multiple wealth-building opportunities through our annual stock grant, employee stock purchase plan, 401(k), and access to free, year-round money coaches. That’s how we’re UNSTOPPABLE for our employees! As a Database Developer within the Credit Risk Management team, you will be required to wear multiple hats. You must have a strong blend of technical, communication, and project management skills. You serve as the technical resources for the department and your ability to develop strong partnership/relationships with key business partners is essential to the role’s success. Your role is to help drive the technology stack for the department, including BI and visualization tools, Data Warehouse solutions, and analytical and modeling software. You must also be able to manipulate large amounts of data and be expected to provide project management plans and timelines, update leadership and guide projects and initiatives to completion.

Responsibilities

• Develop ETL pipelines in and out of data warehouse using combination of Python and Snowflake’s SnowSQL
• Design and develop data movements using Snowflake capabilities like Snow SQL, Tasks, Streams, Time travel, Data sharing and stored procedures
• Use Big Data technologies such as Kafka, Snowflake and related technologies to store, curate, process and publish datasets for consumption by downstream business users and applications
• Integrate on-premise infrastructure with public cloud (AWS, AZURE) infrastructure
• Participates in the development, improvement and maintenance of database applications
• Works with IT partners and user community for project definition; works on multiple platforms and multiple projects concurrently
• Performs independent technical analysis, debugging and troubleshooting as well as code and unit testing for complex scope modules, and projects
• Multidisciplinary work supporting data pipelines, data warehouses and reporting services
• Actively test and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions
• Managing database security, including account administration, password policy, data encryption, network encryption, and firewall rules
• Ability to translate requirements for BI and Reporting to Database design and reporting design
• Ability to understand data pipelines and modern ways of automating data pipeline using cloud based and on-premise technologies
• Collaborate with business and IT partner teams to develop business capability and technology roadmaps, staying abreast of emerging strategic capabilities and data availabilities
• Superior time management skills and project management fundamentals (schedule and resourcing)

Requirements

• Two to five years of programming skills experience in database development - Required
• Experience with Snowflake cloud-based data warehouse - Required
• Experience developing data ingestion processes using DBT - Required
• Experience with Snowflake SnowSQL and writing use defined functions - Required
• Solid understanding of various data formats such as CSV, XML, JSON etc - Required
• 2+ years’ experience developing ETL, ELT and Data Warehousing solutions - Required
• 2+ years’ experience developing SQL scripts and stored procedures that processes data from databases - Required
• 2+ years’ experience in loading source system data extracts into data warehouse - Required
• 2+ years’ experience with batch job scheduling and identifying data/job dependencies - Required
• 3-5 years’ experience AWS cloud, Azure or Google cloud - Preferred
• Ability to learn or existing familiarity with Git-based source code management systems (UI and/or CLI) - Preferred

Nice-to-haves

• Experience developing Python based code that reads/writes data into databases - Preferred

Benefits

• Medical, dental and vision insurance
• Flexible spending account
• 401(k)
• Employee stock grants
• Employee stock purchase plan
• Paid time off and up to 12 paid holidays
• Paid parental and family leave
• Family building benefits
• Back-up care
• Enhanced family support
• Childcare subsidy
• Tuition assistance
• College coaching
• Short- and long-term disability
• Voluntary AD&D coverage
• Voluntary accident coverage
• Voluntary life insurance
• Voluntary disability insurance
• Voluntary long-term care insurance
• Mobile service & home internet discounts
• Pet insurance
• Access to commuter and transit programs