Sr. Data Engineer

Senior Data Engineer

Join our team at American Tire Distributors! As the nation's premier tire distributor, ATD's coast-to-coast distribution network provides approximately 80,000 customers across the U.S. and Canada with rapid and frequent delivery of high quality tires, custom wheels and shop supplies.

Job Duties:

• Identify, analyze, and interpret trends or patterns in complex datasets to uncover insights.
• Manage master data across multiple domains such as Customer, Product, Contact, Asset, and Finance.
• Utilize data science skills to automate data management processes and enhance efficiency.
• Design, develop, and maintain data pipelines to extract, transform, and load (ETL) data from various sources into data warehouses or data lakes.
• Develop and implement databases, data collection systems, data analytics, and strategies to optimize statistical efficiency and data quality.
• Acquire, profile, and clean data in collaboration with data stewards to ensure accuracy and completeness.
• Discover and define new opportunities for process improvements based on data insights.
• Define and implement data quality rules and standards to maintain data integrity.
• Proactively analyze data to enhance quality across dimensions including accuracy, completeness, consistency, integrity, timeliness, conformity, and validity.
• Communicate findings and insights effectively to internal stakeholders and external partners through reports and presentations.
• Partner with data architects and business stakeholders to define and implement data models that directly support business requirements.
• Data modelling and segmentation to design database objects and maintain Master Data Management Solutions.
• Work on Data Architecture to support these solutions.
• 100% telecommuting allowed from any location in the U.S.

Requirements:

• Bachelor's degree, or foreign equivalent, Computer Science, Computer Engineering, or related field and five (5) years of experience as a Data Engineer, Integration Engineer, or related field.
• Alternatively, Master's degree, or foreign equivalent, Computer Science, Computer Engineering, or related field and two (2) years of experience as a Data Engineer, Integration Engineer, or related field.
• Must possess two (2) years of demonstrated experience with the following skills:
• Conducting benchmarking and market analysis using workflow modeling languages – Talend, Python, and SQL.
• Designing data architectures, incorporating system/service requirements using Google Cloud Platform, Azure, Terraform, CI/CD pipelines, and DBT.
• Using DBT, data models, database-design development, and SQL to perform business data modeling.
• Delivering multi-mode communications using JIRA and Confluence for documentation and Microsoft Teams for communications.
• Analyzing and researching customer and market conditions using BigQuery, Snowflake.
• Designing, implementing, administering, maintaining, and managing databases using PostgreSQL, BigQuery, Snowflake, and MDM (Master Data Management).
• Performing data collection and analysis using Talend, Python, SQL, and streaming services like Kafka or Google Pub/Sub.
• Conducting business forecasting using DBT, Python, SQL, and BigQuery or Snowflake.
• Validating and verifying data systems, processes, and workflows using CI/CD, DBT, JIRA, Confluence, Terraform, and Linux operating system to ensure correctness, efficiency, and security.
• Performing gap analysis between current and future states using JIRA, Confluence, data models, MDM, and version-control tools such as GitHub or Bitbucket.

Offered Wage: $155,645 – $165,645/year