Data Engineer III+ (Analytics Focus)-Expeditors

Job Description

Job Title: Data Engineer III+ (Analytics Focus)

Company: Expeditors

Location: Romulus, MI

Pay: $100000 – 150000 per year

AI Pay Analysis: The annual salary range of $100,000 to $150,000 for a “Data Engineer III+ (Analytics Focus)” in Romulus, MI, is generally competitive and aligns well with industry standards for similar roles. Data engineers, particularly at a mid-level to senior level, typically earn between $90,000 and $160,000 in the U.S., depending on factors such as experience, education, and specific technical skills. In Michigan, salaries may be slightly lower than national averages, but this range offers a robust compensation for the region, especially considering the growing demand for data professionals in analytics. Overall, this salary range appears attractive and should appeal to qualified candidates in the field.

Job description:

As a Data Engineer with an analytics focus, you will serve as a vital link between data engineering and data analysis by developing robust data models and creating data pipelines that support analytics and reporting. You will collaborate closely with data engineers, analysts, and business stakeholders to ensure data accuracy, performance, and accessibility within our data infrastructure.

This role is situated within the GEO-IS Data Platforms Product Development team, where you will contribute to our GEO-IS Solutions data infrastructure. Currently, the data pipelines and infrastructure are on-premises, with plans to transition to the cloud later this year. As part of this transition, you will assist in designing, optimizing, and migrating data pipelines to the cloud, in addition to creating new, scalable, and efficient data models.

We are seeking a candidate with experience in optimizing Power BI performance and integrating Power BI with Azure-based data solutions. The successful candidate will play a key role in ensuring efficient data processing, optimal report performance, and seamless integration between our data infrastructure and Power BI.

An effective Data Engineer III will possess the following qualities:

• A strong problem-solving mindset focused on optimizing data processes.
• The ability to communicate technical concepts effectively to non-technical stakeholders.
• A proactive approach to collaboration with cross-functional teams to ensure data accuracy and accessibility.
• A commitment to continuous learning and adaptation to emerging data technologies and best practices.

Major Responsibilities:

• Design and develop data models to support business intelligence (BI) and analytics needs, with an emphasis on performance and scalability.
• Build and maintain data pipelines that transform raw data into clean, usable datasets.
• Perform data transformations utilizing SQL and scripting languages such as Python.
• Collaborate with data engineers to ensure data availability and integrity.
• Validate data outputs for accuracy and consistency through thorough testing.
• Implement data quality checks and maintain comprehensive data documentation.
• Work with stakeholders to define metrics, key performance indicators (KPIs), and reporting requirements.
• Facilitate the migration of on-premises solutions to cloud environments.
• Enhance BI tools, specifically Power BI, by building efficient data models that improve performance.
• Participate in code reviews and contribute to the establishment of team best practices, including documenting data models and processes and enforcing data governance and security.
• Monitor pipeline performance and resolve data inconsistencies and bottlenecks.
• Collaborate with the team to optimize database performance and storage solutions.

Qualifications:
Minimum Requirements:

• Bachelor’s degree in an IT-related field or equivalent experience.
• 3-5 years of experience in data transformation, data modeling, and analytics engineering.
• Strong experience in SQL and query optimization across multiple databases.
• Proficiency in Python for data processing and automation tasks.
• Experience with Airflow or similar workflow orchestration tools.
• Hands-on experience with Azure cloud-based data solutions.
• Familiarity with ETL/ELT frameworks and workflow automation tools.
• A strong understanding of data modeling and schema design for analytics and reporting.
• Proven experience in migrating on-premises data pipelines to the cloud, including strategy, execution, and optimization.
• Experience optimizing Power BI performance and integrating Power BI with Azure solutions.
• Capacity to collaborate effectively with cross-functional teams and stakeholders.

Desired Qualifications:

• Experience with Azure Fabric, Azure Synapse, or Databricks.
• Knowledge of infrastructure-as-code tools (Terraform, ARM templates).
• Familiarity with data transformation tools such as dbt.
• An understanding of data governance and compliance (GDPR, CCPA, etc.).
• Experience working in Agile environments with CI/CD processes.
• Certifications in Azure Data Engineering or related cloud technologies.
• Understanding of data visualization best practices.

Additional Information:
The annual salary for this position ranges from $100,000 to $150,000. This is an onsite position, and candidates must be able to commute to the office. Expeditors offers 26 remote days per year that can be utilized as needed. The team operates onsite, fostering collaboration and employee growth.

This position is available in one of our offices located in Atlanta, GA, Detroit, MI, Edison, NJ, Los Angeles, CA, or Dallas, TX. It is a full-time role requiring 40 hours per week, Monday through Friday (in-office). Business attire is expected.

Applicants must be eligible to work in the U.S. immediately, as the employer is unable to sponsor work authorization (such as H-1B visas) for this opportunity.

Expeditors offers a comprehensive benefits package, including paid vacation, holidays, and sick time, as well as a health plan comprising medical, prescription drug, dental, and vision coverage, life and long-term disability insurance, a 401(k) retirement savings plan (U.S. only), an employee stock purchase plan, and a training and personnel development program. All information will be kept confidential according to EEO guidelines.

Internal applicants interested in this position are encouraged to discuss this opportunity with their supervisor.

Job Posting Date: Sat, 12 Apr 2025 22:33:12 GMT

Apply now!