[Hiring] Data Engineer @Synoptek

Role Description

We are seeking a highly skilled Senior Analyst, BI & Data Insights to join our growing team. In this critical role, you will play a key role in building and maintaining a best-in-class data platform that drives innovation and growth for our transportation and logistics business. You will leverage your expertise in end-to-end Azure data engineering, Snowflake, and a variety of data engineering tools to design, develop, and implement scalable data pipelines for ingesting, transforming, and loading (ETL/ELT) large datasets. You will partner closely with stakeholders across the organization to understand their needs and translate them into clear and concise data visualizations through Data engineering solution.

Responsibilities

• Design and implement end-to-end data pipelines utilizing Azure services, including Data Factory, Databricks, Synapse Analytics, and Event Hubs, to ingest, process, and transform data from various sources (e.g., Oracle Mercury Gate, D365, NetSuite, telematics systems, sensors).
• Leverage Kafka and StreamSets to ensure real-time data ingestion and low latency processing for critical operational insights.
• Develop and maintain data models that optimize data storage, retrieval, and performance within Azure Data Lake Storage and Snowflake.
• Write, optimize, and troubleshoot SQL queries within the Snowflake environment.
• Collaborate with business stakeholders to understand data requirements and translate them into actionable data solutions.
• Implement data governance best practices to ensure data quality, consistency, and compliance with industry regulations.
• Monitor and optimize data pipelines for performance, scalability, and cost-effectiveness.
• Develop and maintain data quality checks and data cleansing routines to ensure data integrity throughout the data lifecycle.
• Develop reports and visualization using Tableau to communicate data insights effectively to technical and non-technical audiences.
• Stay current with the latest advancements in Azure data services, data management practices, and transportation & logistics data solutions.

Qualifications

• 4+ years of experience as a Data Engineer with a strong focus on Microsoft Azure data technologies.
• Proven experience with data pipelines, data ingestion, transformation, and loading (ETL/ELT) processes.
• In-depth knowledge of data architecture, data modeling, and data governance principles.
• Proficiency in SQL Server, MySQL, PostgreSQL, and NoSQL databases (DynamoDB, MongoDB).
• 2+ Years of experience with Snowflake data warehouse.
• Experience with Python for data manipulation and automation.
• Expertise in cloud-based data warehousing solutions like Snowflake.
• Working knowledge of data streaming technologies like Kafka and StreamSets.
• Familiarity with data visualization tools (Tableau, Power BI, Qlik Sense) a plus.
• Experience working in the transportation and logistics domain is highly preferred.
• Excellent communication and collaboration skills to work effectively with cross-functional teams.
• Strong analytical and problem-solving skills with a passion for data-driven solutions.

Requirements

• Education: Bachelor’s degree in Computer Science, Information Technology or related field from an accredited college or university preferred.
• In lieu of undergraduate degree, the ratio is 1:1 - meaning one year of college equals one year of work experience and vice versa.
• Experience: Customarily has at least 1 year(s) of job-related experience.
• Familiarity with acquiring and managing data from various sources, including primary and secondary data sources.

Skills/Attributes

• Clarity: Possesses excellent communication skills, makes a concentrated effort to speak the customer’s language. Ability to field questions with concise, well-constructed responses.
• OwnIT: Shows integrity, innovation, and accountability in completing daily assignments.
• Results: Solutions focused and driven to resolve conflict quickly and precisely. Proactively looks for opportunities to contribute to the company’s business goals.
• Growth: Willing to learn and ask questions. Constantly looking for new ways to improve yourself. Ability to adapt and grow in a fast-paced environment.
• Team: Embraces both customers and colleagues as team members. Ability to be flexible, respectful, engaged and collaborative.

Working Conditions

We live by the motto ‘work hard, play hard’ and strive to support our employees in both their professional and personal goals. We believe that by hiring the right people, leading process improvement, and leveraging technology, we achieve superior results. Work is performed primarily in an office or remote environment. May be subject to time constraints and tight deadlines. May require occasional travel.

EEO Statement

We are proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, veteran status, sexual orientation, gender identity, marital status, pregnancy, genetic information, or any other characteristic protected by law and will not be discriminated against on the basis of disability. It is our intention that all qualified applicants are given equal opportunity and that employment decisions be based on job-related factors.