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 translating to an annual salary of $130,000 – $160,000 for a Senior Data Engineer in Romulus, MI, is competitive and generally aligns with industry standards for this role. According to various salary data sources, the average annual salary for Senior Data Engineers in Michigan typically ranges from approximately $120,000 to $150,000, depending on experience and company size. The offered range suggests that the role is positioned at the higher end of the market spectrum, making it an attractive opportunity, particularly in a location like Romulus, which may not have the same demand or cost of living as larger urban centers. In summary, this compensation package appears to be above average, making it a compelling offer for potential candidates.

Job description:

As a Senior Data Engineer, you will be an integral member of our agile analytics team, spearheading the design, development, and optimization of complex data infrastructure and pipelines. Your expertise will be vital in delivering impactful reporting, analytics, and machine learning solutions that contribute to business success. You will utilize your extensive experience to build and maintain critical data systems while mentoring and guiding junior engineers, ensuring that intricate business requirements are effectively translated into robust and scalable data solutions.

This role resides within the GEO-IS Data Platforms Product Development team, which supports our entire GEO-IS Solutions data infrastructure. Successful candidates will demonstrate their ability to convert complex business requirements into scalable and reliable data pipelines and models. The essential competencies of a successful Senior Data Engineer include:

• Serving as a subject matter expert for data and systems.
• Designing, developing, and maintaining scalable data pipelines and models, while advocating for architecture and best practices geared toward high performance.
• Identifying and leading initiatives to enhance data quality, standardizing and enriching data to address complex challenges and provide valuable insights.
• Collaborating with cross-functional teams to optimize data models and support advanced business intelligence and analytics.
• Mentoring junior data engineers, leading code reviews, and promoting best practices and skill development.
• Optimizing data pipelines for performance and scalability while remaining current with industry trends and technologies.

Major Duties and Responsibilities:

• Transform complex business needs into aligned data models and architecture.
• Design and implement scalable, high-performance data pipelines and models.
• Optimize data infrastructure to address evolving business and technology requirements.
• Monitor and enhance data pipelines for performance and integrity.
• Lead testing and troubleshooting efforts for complex data issues.
• Drive data quality initiatives and enforce established standards.
• Manage version control, backups, and disaster recovery, ensuring meticulous documentation.
• Create and maintain comprehensive technical documentation.
• Document and communicate data lineage and governance effectively.
• Establish and promote best practices for 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, with a minimum of 5-7 years of progressive experience in data engineering.
• Extensive expertise in schema design, dimensional data modeling, and data warehousing, with experience in cloud-based platforms (e.g., AWS, Azure, Google Cloud).
• Proven ability to lead and collaborate effectively with cross-functional development teams, including stakeholders and executive leadership.
• Demonstrated capability to independently manage and prioritize complex projects, ensuring team commitments are met and strategic objectives are achieved.
• Expert-level proficiency in writing, optimizing, and troubleshooting complex SQL queries across multiple databases.
• Advanced skills in data processing and manipulation using programming languages such as Python, focusing 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, including designing and implementing automation frameworks.

Desired Qualifications:

• 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 business intelligence tools.
• Strong understanding 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 with 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), Monday through Friday (in office), and the company maintains a business casual dress code. Applicants must be eligible to work in the U.S. without sponsorship for visa authorization.

Expeditors offers an excellent benefits package, which includes:

• Paid vacation, holiday, and sick time
• Comprehensive health plan: 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 program

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

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

Apply now!