Data Engineer

Job Summary

Optomi, in partnership with a leading telecommunications company, is seeking a data engineer to join their team. You will play a key role in transitioning legacy SQL Server processes to Snowflake, managing ETL jobs, and ensuring data pipelines are efficient, scalable, and reliable.

Qualifications Required:

Strong hands-on experience with SQL and Snowflake.

Solid understanding of ETL processes and data pipeline orchestration.

Experience with Azure cloud services.

Familiarity with Infoworks as a data ingestion/scheduling platform.

Self-motivated, curious, and able to thrive in a fast-moving, collaborative environment.

Excellent communicator and team player—confident but humble.

Job Responsibilities:

Manage and maintain data ingestion jobs using Infoworks for scheduling.

Build and optimize scalable data pipelines and ETL processes from various sources into Snowflake.

Migrate existing processes from SQL Server to Snowflake, including stored procedures.

Collaborate with data analysts, engineers, and stakeholders to define and deliver clean, well-modeled datasets.

Take ownership of your work—always looking for the next challenge and opportunities to improve.

Ensure flexibility and reliability in scheduling and data operations.

Nice to Haves:

Experience with broader Snowflake ecosystem (e.g., Snowpipe, SnowSQL).

Domain knowledge in HR, HRIS, or People Analytics.

Previous experience building in modern cloud data environments.