Data Engineer

Pyramid Consulting, Inc; Merrimack (NH); Hybrid; USD 92,299 - 99,187; Full time

Benefits offered by this job

Health insurance (medical, dental, vision)

401(k) plan

Paid sick leave

Job summary

A leading consulting firm is seeking a Data Engineer for a 12+ month contract in Merrimack, NH (Hybrid). This role requires strong experience in data modeling, SQL, and data integration platforms including Azure Data Factory and Snowflake. The candidate should have a Bachelor's or Master's degree in a technology-related field and at least 6 years of related experience. The position offers a competitive pay range of $67 to $72 per hour, with benefits including health insurance and a 401(k) plan.

Qualifications

• 6+ years of related experience in data engineering and analysis.
• Strong experience with relational database technologies.
• Proven track record of delivering high-quality data solutions.

Responsibilities

• Build and manage data pipelines using Azure Data Factory.
• Perform deep data analysis and deliver insights.
• Collaborate with a geographically diverse team.

Skills

Data Modeling

Basic PL/SQL and SQL knowledge

Data integration platforms

Microsoft Power Platform

ETL/ELT processes

Agile development practices

Outstanding SQL skills

Data modeling techniques

Education

Bachelors or Masters in technology-related field

Tools

Azure Data Factory

Oracle SQL

Snowflake

AWS Lambda

PowerDesigner

Job description

Immediate need for a talented Data Engineer. This is a 12+ Months Contract opportunity with long-term potential and is located in Merrimack, NH / Westlake, TX (Hybrid). Please review the job description below and contact me ASAP if you are interested.

Pay Range: $67 - $72/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Requirements and Technology Experience:

• Data Modeling
• Basic PLSQL and SQL knowledge - perform analysis
• Data integration platforms
• Power automate through SAAS
• Bachelors or Masters in a technology related field (e.g. Computer Science, Engineering etc.) required.
• 6+ years of related experience in data engineering, analysis, data warehouses, data lakes. Specialist understanding and experience of methodologies like data warehousing, data visualization and data integration.
• Strong experience with relational database technologies (Oracle SQL & PL/SQL or similar RDBMS), preferably Snowflake or other Cloud Data warehousing services.
• Strong expertise in all aspects of data movement technologies (ETL/ELT) and experience with schedulers, specifically with Azure Data Factory.
• Strong expertise with building and managing data pipelines in Azure Data Factory; using various Data Sources and APIs.
• Experience in Microsoft power platform and developing power automate flows for data integration would be advantageous.
• Proven experience in understanding multi-functional enterprise data, navigating between business analytic needs and data, and being able to work hand-in-hand with other members of technical teams to complete product roadmaps to enable new insights with our data.
• Experience with DevOps, Continuous Integration and Continuous Delivery. Developing and deploying pipelines. Deploying within a cloud native infrastructure would be advantageous.
• Able to work collaboratively with a geographically diverse team.
• Proven track record of working in collaborative teams to deliver high quality data solutions in a multi-developer agile environment following design & coding best practices.
• Outstanding SQL skills and experience performing deep data analysis on multiple database platforms.
• Knowledge and expertise of data modelling techniques and best practices (Relational, Dimensional), plus any prior experience with data modelling tools (eg. PowerDesigner).
• Experience in working with AWS, MS Azure or other cloud providers.
• Experience with AWS services such as Lambda or S3, AWS Certification.
• Experience in Data Architecture (Database design, performance optimization) would be advantageous.
• Strong Focus on resiliency & reliability.
• You have excellent written and oral communication skills.

Our client is a leading Financial Industry, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.