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 for a Senior Data Engineer position in Romulus, MI, translating to an annual salary of approximately $130,000 to $160,000, is generally competitive and aligns well with industry standards. According to various salary data sources, the average salary for Senior Data Engineers in the United States typically ranges from $120,000 to $180,000, depending on factors such as experience, skill set, and the specific industry. Furthermore, considering the cost of living in Michigan, this salary range is attractive and reflects the demand for skilled professionals in data engineering, emphasizing the need for expertise in big data technologies and analytics.

Job description:
As a Senior Data Engineer, you will be integral to 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 our business objectives. You will utilize your extensive experience to not only construct and maintain essential data systems but also to mentor and guide junior engineers, ensuring seamless translation of intricate business requirements into robust and scalable data solutions.

This position is situated within the GEO-IS Data Platforms Product Development team, which supports our entire GEO-IS Solutions data infrastructure. Successful candidates will be adept at interpreting complex business requirements and transforming them into scalable and reliable data pipelines and models. The ideal Senior Data Engineer will excel in the following areas:

– Act as the subject matter expert for data and systems.
– Design, develop, and maintain scalable data pipelines and models, establishing architecture and best practices for high performance.
– Identify and lead initiatives for data quality improvements, standardizing and enriching data to address complex challenges and provide insights.
– Collaborate with cross-functional teams to enhance data models and support advanced business intelligence and analytics efforts.
– Mentor junior data engineers, conduct code reviews, and promote best practices and skill development.
– Optimize data pipelines for performance and scalability while staying informed on industry trends and technologies.

Major Duties and Responsibilities include:

– Translating complex business needs into aligned data models and architecture.
– Designing and implementing scalable, high-performance data pipelines and models.
– Optimizing data infrastructure to meet evolving business and technology requirements.
– Monitoring and enhancing data pipelines for performance and integrity.
– Leading testing and troubleshooting efforts for complex data issues.
– Driving data quality initiatives and enforcing standards.
– Managing version control, backups, and disaster recovery with meticulous documentation.
– Creating and maintaining up-to-date technical documentation.
– Documenting and communicating data lineage and governance.
– Establishing and promoting best practices for data pipeline and model development.
– Training and mentoring end-users on data models and business logic.
– Collaborating with stakeholders to refine data models for optimal performance.
– Supporting agile practices and maintaining current work management systems.

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, 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 stakeholders and executive leadership.
– Demonstrated capability to independently manage and prioritize complex projects, driving team commitments and achieving strategic objectives.
– 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, with a focus on developing scalable data solutions.
– Experience with on-premises data engineering tools such as dbt core.
– Proven track record in automating complex data tasks and workflows, with experience in 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.
– 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 with advanced ETL (Extract, Transform, Load) tools and frameworks (e.g., Apache NiFi, Talend).
– Experience with managing and optimizing MS SQL Server environments (e.g., advanced T-SQL, performance tuning, linked servers, proactive maintenance).

The annual salary for this position ranges from $130,000 to $160,000. This is a full-time position (40 hours per week) with a schedule of Monday through Friday (in-office). We maintain a business attire dress code. Applicants must be eligible to work lawfully in the U.S. immediately; the employer does not sponsor applicants for U.S. work authorization (such as an H-1B visa) for this opportunity.

Expeditors offers an excellent benefits package, including:

– Paid vacation, holidays, and sick time.
– Health plans, including 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 provided will be kept confidential in accordance with EEO guidelines.

Job Posting Date: Tue, 24 Sep 2024 22:21:41 GMT

Apply now!