Data Engineer

Apexon; United States; Remote; USD 100,000 - 720,000; Full time

Job summary

Apexon is seeking an experienced Data Engineer to develop and maintain ETL pipelines using Matillion and Snowflake. The ideal candidate will have over 10 years of experience in data engineering, with strong SQL and Python skills. This role involves collaborating with cross-functional teams and optimizing data processes to support data-driven initiatives.

Qualifications

• 10+ years of experience in data engineering.
• Strong SQL and Python skills.
• Experience with Snowflake and ETL processes.

Responsibilities

• Design and maintain scalable ETL pipelines using Matillion ETL.
• Optimize SQL queries and stored procedures.
• Collaborate with stakeholders to gather data requirements.

Skills

SQL

Python

Data Engineering

Problem Solving

Communication

Education

Bachelor’s degree in computer science

Information Technology

Tools

Snowflake

SQL Server

AWS

Matillion ETL

Job description

Get AI-powered advice on this job and more exclusive features.

Data Engineer with Matillion Exp: - Princeton, NJ- Remote

We are looking for an experienced Data Engineer with a strong foundation in data engineering, best practices and experience with modern data warehousing and ETL platforms. The ideal candidate will have at least 10 +years of hands-on experience, preferably with Snowflake, SQL Server, AWS and Matillion ETL, to build, optimize, and maintain data pipelines and data integration solutions. This role involves working closely with cross[1]functional teams to support data-driven initiatives across the organization.

Key Responsibilities:

• Data Pipeline Development and Maintenance:
• Design, develop, and maintain scalable and high-performance ETL pipelines using Matillion ETL to ingest, transform, and load data into Snowflake.
• Integrate and manage data from various sources, ensuring data quality, reliability, and performance.
• Optimize SQL queries, scripts, and stored procedures in Snowflake and SQL Server to improve efficiency and reduce processing time.
• Data Warehousing and Modeling:
• Develop and implement data models within Snowflake to support business intelligence and analytics requirements.
• Collaborate with data architects and analysts to design and enhance data warehouse schemas and ensure alignment with reporting and analytics needs.
• Collaboration and Requirements Gathering:
• Work with business stakeholders to understand data requirements and translate them into technical specifications.
• Support data architects and analysts by providing guidance on data ingestion, storage, and retrieval methods.
• Platform Monitoring and Optimization:
• Monitor data pipeline and ETL performance, identifying bottlenecks and making necessary adjustments to ensure optimal system performance.
• Perform troubleshooting and root cause analysis to resolve data issues and prevent future occurrences.

Required Qualifications:

• Experience: At least 10+ years of experience in data engineering, with proficiency in Snowflake, SQL Server, AWS and ETL tools (preferably Matillion).
• Technical Skills: Strong SQL and Python skills with experience in query optimization and performance tuning.
• Education: Bachelor’s degree in computer science, Information Technology, or a related field.
• Soft Skills: Strong analytical, problem-solving, and communication skills.
• Data Engineering Skills: Experience in building, maintaining, and optimizing data pipelines and ETL processes.
• Data Modeling: Knowledge of data warehousing concepts and hands-on experience in data modeling, particularly within Snowflake.

Preferred Qualifications:

• Additional Tools and Platforms: Experience with additional ETL tools, data transformation methods, or cloud platforms is a plus.
• Healthcare and PBM: PBM-specific knowledge and experience with transforming various healthcare data is a plus, but not required.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Software Development

Referrals increase your chances of interviewing at Apexon by 2x

Get notified about new Data Engineer jobs in United States.

United States $170,000.00-$720,000.00 4 days ago

San Francisco, CA $126,100.00-$186,800.00 1 day ago

Washington DC-Baltimore Area $120,000.00-$135,000.00 1 week ago

Data Engineer, Analytics (Technical Leadership)

United States $206,000.00-$281,000.00 1 week ago

United States $114,000.00-$171,000.00 1 week ago

United States $100,000.00-$120,000.00 2 weeks ago

United States $145,000.00-$204,000.00 1 week ago

United States $100,000.00-$720,000.00 3 days ago

Washington DC-Baltimore Area $110,000.00-$120,000.00 2 weeks ago

Machine Learning Software Engineer L4/L5

United States $100,000.00-$720,000.00 5 days ago

United States $184,500.00-$217,100.00 15 hours ago

Software Engineer L4/L5, Model Serving Systems, Machine Learning Platform

United States $100,000.00-$720,000.00 5 days ago

Mountain View, CA $170,000.00-$200,000.00 3 days ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.