Engineers, Software Full Stack

T-Mobile T-Mobile · Telecom · Bethesda, MD

Software Engineers will build Enterprise Data Warehouse and ETL pipelines, modify databases, perform tests, solve database usage issues, turn raw data into dimensional models, monitor API performance, automate data pipeline steps, own the design, development, and maintenance of metrics, reports, analyses, and dashboards, integrate third-party software, research technology implications, and document data models and pipelines. Skills include Python scripting for data transformation and integration, scheduling and managing ETL workflows with Apache Airflow, utilizing AWS S3, Snowflake, and PostgreSQL, designing Tableau dashboards, writing complex SQL queries, and leveraging AWS Secrets Manager.

What you'd actually do

  1. Build the Enterprise Data Warehouse and ETL pipelines to be used by various analytics teams.
  2. Modify databases, perform tests, and solve database usage issues and malfunctions, turning raw structured and unstructured data into dimensional models that are usable by the business.
  3. Own the design, development, and maintenance of ongoing metrics, reports, analyses, and interactive dashboards, using business intelligence software to analyze trends, identify KPIs, and communicate key concepts to executives to drive business decisions.
  4. Automate steps of the data pipeline by performing manipulation and transformation while ensuring the integrity and quality of data in relational/NoSQL databases.
  5. Monitor the performance of APIs and optimize the response time by utilizing database techniques for faster retrieval of data.

Skills

Required

  • Python scripting for data transformation and integration
  • Scheduling and managing ETL workflows using shell scripts and Docker-based Apache Airflow
  • Utilizing AWS S3 for staging, Snowflake for data warehousing and PostgreSQL for operational storage
  • Designing, developing and maintaining Tableau dashboards
  • Utilizing SQL to write, optimize and refactor complex queries in Snowflake and PostgreSQL
  • Leveraging AWS Secrets Manager to securely store and manage sensitive credentials and API keys