About Us: At ID Logistics we are dedicated to fostering a dynamic and inclusive work environment where every team member is welcomed and valued. As a leading global 3PL (3rd party logistics) transportation organization with over 35,000 employees in over 400 sites across 18 countries, we pride ourselves on our customer first approach and commitment to operational excellence.
Position Overview: A Business Intelligence (BI) IT Engineer role is to design, develop, and maintain the infrastructure and systems that enable data analysis and reporting, focusing on creating data models, ETL processes, ensuring data integrity, consistency, accuracy, and accessibility for stakeholders.
Work Location: This is a remote position.
Work Schedule: First Shift - Monday - Friday, 8:30am - 5:00pm
Work Travel: Less than 10% domestic travel.
Competitive Total Rewards Package: Attractive annual salary of $100,000-$135,000 plus a performance-based bonus, with benefits including health, dental, and vision insurance, 401(k) matching, and more.
Responsibilities:- Develop, implement, and manage ETL/ELT pipelines using Azure Data Factory (ADF) and Snowflake.
- Design and optimize data models and data warehousing solutions for performance and scalability.
- Create and maintain data integration workflows, ensuring high-quality and reliable data delivery.
- Collaborate with data analysts, business stakeholders, and engineering teams to develop and maintain business intelligence solutions.
- Monitor and troubleshoot data pipelines, ensuring timely data availability and accuracy.
- Develop SQL queries, stored procedures, and scripts to extract, transform, and load data.
- Implement best practices in data governance, security, and compliance.
- Optimize Snowflake storage and compute resources for cost-effective performance.
- Create and maintain dashboards, reports, and visualizations to support decision-making.
- Document technical solutions and provide training/support to end users.
This role is open to individuals who are authorized to work in the United States and do not require immigration sponsorship now or in the future.
Minimum Requirements: - 5+ years of experience in business intelligence, data engineering, or a related role.
- Bachelor's degree in computer science, Information Systems, or a related field.
- Hands-on experience with Azure Data Factory (ADF), Snowflake, and SQL.
- Strong understanding of ETL/ELT development, data warehousing concepts, and data modeling.
- Proficiency in SQL, Python, or other scripting languages.
- Experience with data visualization tools (e.g., Power BI, Tableau) is a plus.
- Familiarity with Azure services such as Azure Synapse, Azure Data Lake, and Azure Databricks is desirable.
- Familiarity with RestAPIs and SQL Server is a plus
Preferred Qualifications: - Excellent problem-solving skills and ability to work in a fast-paced environment.
- Exceptional verbal and written communication skills and interpersonal skills, with the ability to work effectively with both technical and non-technical stakeholders.
- Ability to translate business needs into technical solutions.
- Strong time management, and attention to detail.
- Familiarity with Change Management and can ensure the proper coordination and communication is completed for all production changes.
- Experience in the Distribution Industry preferred.