Senior Data Engineer-Expeditors

Job Description

Job Title: Senior Data Engineer

Company: Expeditors

Location: Romulus, MI

Pay: $130000 – 160000 per year

AI Pay Analysis: The hourly rate translated from an annual salary of $130,000 to $160,000 for a Senior Data Engineer in Romulus, MI, ranges from approximately $62.50 to $76.92 per hour. This compensation is generally competitive and aligns well with industry standards, especially for senior roles in data engineering, which typically entail significant expertise in data architecture, ETL processes, and cloud technologies. The average salary for Senior Data Engineers in the Detroit metropolitan area generally falls within this range, although factors such as the specific company, the complexity of projects, and an individual’s experience can influence salary variations. Overall, this compensation offers a strong incentive for skilled professionals in this field within the region.

Job description:

As a Senior Data Engineer, you will be an integral member of our agile analytics team, responsible for leading the design, development, and optimization of sophisticated data infrastructure and pipelines. Your expertise will be essential in delivering impactful reporting, analytics, and machine learning solutions that drive business success. You will utilize your extensive experience to build and maintain vital data systems while mentoring and guiding junior engineers, ensuring the effective translation of complex business requirements into robust and scalable data solutions.

This position falls within the GEO-IS Data Platforms Product Development Team, which supports our comprehensive GEO-IS Solutions data infrastructure. Successful candidates will demonstrate the ability to translate intricate business needs into scalable and trusted data pipelines and models. The ideal Senior Data Engineer will excel in the following key areas:

• Serve as the subject matter expert for data and systems.
• Design, develop, and maintain scalable data pipelines and models, promoting architectural best practices for optimal performance.
• Identify and lead initiatives aimed at enhancing data quality, standardizing, and enriching data to address complex challenges and provide actionable insights.
• Collaborate with cross-functional teams to refine data models and support advanced business intelligence (BI) and analytics initiatives.
• Mentor junior data engineers, lead code reviews, and uphold best practices while fostering skill development.
• Optimize data pipelines for performance and scalability while remaining current with industry trends and technologies.

Major Duties and Responsibilities:

• Translate complex business requirements into aligned data models and architecture.
• Design and implement scalable, high-performance data pipelines and models.
• Optimize data infrastructure to adapt to evolving business and technical demands.
• Monitor and enhance data pipelines for performance and integrity.
• Lead testing and troubleshooting efforts for intricate data issues.
• Drive data quality initiatives and enforce compliance with standards.
• Manage version control, backups, and disaster recovery through meticulous documentation.
• Create and maintain up-to-date technical documentation.
• Document and communicate data lineage and governance effectively.
• Establish and advocate for best practices in data pipeline and model development.
• Train and mentor end-users on data models and business logic.
• Collaborate with stakeholders to refine data models for optimal performance.
• Support agile practices and maintain current work management systems.

Qualifications

Minimum Qualifications:

• Bachelor’s degree in an IT-related field or equivalent experience, coupled with 5-7 years of progressive experience in data engineering.
• Extensive expertise in schema design, dimensional data modeling, and data warehousing, including experience with cloud-based platforms (e.g., AWS, Azure, Google Cloud).
• Proven ability to lead and collaborate effectively with cross-functional development teams, including interactions with stakeholders and executive leadership.
• Demonstrated capacity to independently manage and prioritize complex projects, fulfilling team commitments and achieving strategic objectives.
• Expert-level proficiency in writing, optimizing, and troubleshooting complex SQL queries across various databases.
• Advanced skills in data processing and manipulation using programming languages such as Python, with a focus on developing scalable data solutions.
• Experience with on-premises data engineering tools such as dbt Core.
• Proven track record of automating complex data tasks and workflows, with experience in designing and implementing automation frameworks.

Desired Qualifications:

• A Master’s degree or higher in Computer Science, Data Engineering, or a related field.
• Relevant certifications in cloud platforms (e.g., AWS Certified Data Analytics, Google Cloud Professional Data Engineer, Microsoft Azure Data Engineer Associate).
• Proven experience in migrating data infrastructures from on-premises to cloud environments, including strategy development, execution, and post-migration optimization.
• Familiarity with big data technologies such as PySpark or Kafka for processing and analyzing large-scale datasets.
• Experience with modern data warehousing solutions (e.g., Azure Synapse, Databricks) and their integration with BI tools.
• Knowledge of data governance, data privacy regulations (e.g., GDPR, CCPA), and best practices for ensuring data security and compliance.
• Familiarity with DevOps practices and tools (e.g., Docker, Kubernetes) for deploying and managing data pipelines in a CI/CD environment.
• Proficiency in advanced ETL (Extract, Transform, Load) tools and frameworks (e.g., Apache NiFi, Talend).
• Experience managing and optimizing MS SQL Server environments (e.g., advanced T-SQL, performance tuning, linked servers, proactive maintenance).

Additional Information:

The annual salary for this position ranges from $130,000 to $160,000. This is a full-time position (40 hours per week) scheduled from Monday to Friday in an office environment with a business attire dress code. Applicants must be eligible to work lawfully in the U.S. without the need for employer sponsorship for U.S. work authorization (e.g., H-1B visa).

Expeditors provides a comprehensive benefits package, including:

• Paid vacation, holiday, and sick time
• Health plan offering medical, prescription drug, dental, and vision coverage
• Life and Long-Term Disability Insurance
• 401(k) Retirement Savings Plan (U.S. only)
• Employee Stock Purchase Plan
• Training and personnel development programs

All information will be kept confidential in accordance with EEO guidelines.

Job Posting Date: Tue, 24 Sep 2024 22:01:30 GMT

Apply now!