Data Engineer

EMW Staffing Solutions LLC; Denver (CO); On-site; USD 80,000 - 125,000; Full time

Job summary

EMW Staffing Solutions LLC is seeking an experienced Data Engineer Consultant to design, build, and optimize data infrastructure for client projects in the Denver area with a mainly remote role and occasional onsite work. You will leverage strong SQL development, data visualization, and dimensional modeling skills to deliver scalable pipelines and BI solutions.

The ideal candidate has 3+ years in data engineering, experience with cloud data platforms, and excellent collaboration skills to work

Qualifications

• Bachelor's degree in computer science, Information Technology, or a related field.
• 3+ years of experience in data engineering, data warehousing, or a similar role.
• Strong proficiency in SQL
• Proven experience with data visualization tools and theory.
• In-depth knowledge of dimensional modeling concepts and techniques.
• Familiarity with ETL tools and processes.
• Strong problem-solving skills and attention to detail
• Experience with cloud-based data platforms
• Excellent communication and collaboration skills, with the ability to work effectively with clients.

Responsibilities

• Data Infrastructure Development (ETL, SQL): Design, build, and maintain scalable data pipelines and ETL processes tailored to client needs.
• Develop and optimize complex SQL queries for data extraction, transformation, and loading.
• Diagnose and troubleshoot data-related issues, providing quick and effective resolutions.
• Analyze data workflows and identify areas for improvement, recommending and implementing solutions to optimize performance.
• Utilize a proactive approach to foresee potential problems and address them before they impact clients' operations.
• Dimensional Modeling and Data Modeling: Design and implement dimensional models to support data warehousing and BI initiatives.
• Design and implement different data modeling techniques to meet business' data demands that align with data architecture design.
• Develop and maintain data schemas, ensuring data integrity and consistency for clients.
• Create and maintain dashboards and reports using data visualization tools to provide actionable insights.
• Train clients on best practices for using data visualization tools to maximize value.
• Client Consultation: Engage with clients to understand their data needs and business objectives.
• Conduct detailed requirements analysis and provide recommendations for data infrastructure improvements.
• Work closely with client teams, data scientists, analysts, and other stakeholders to understand data needs and provide technical support.
• Communicate complex technical concepts to non-technical stakeholders in a clear and concise manner.

Skills

SQL Development

Data Visualization

Dimensional Modeling

Cloud Data Platforms

Client Collaboration

Problem Solving

Education

Bachelor's degree in CS / IT or related field

Tools

SQL

ETL Tools

Data Visualization Tools

Cloud Platforms

Dimensional Modeling

Job description

Term: Full Time

Location: Around the Denver CO area--Mainly but not a 100% remote role.

$: 90-140k/year, Neg.

Vertical: Services

Level: Mid or Mid to Senior

Dashboard: Data engineers with data visualization experience or a BI analyst that shows a strong understanding of data engineering are the ideal candidate. This position is for a consulting practice specializing in big data/cloud solutions. This is a technical role, not just a reporting one.

Please note this group is unable to sponsor or take over sponsorship of an employment Visa at this time

Customer is looking for an experienced Data Engineer Consultant to join the team. The ideal candidate will possess strong SQL development skills, expertise in data visualization, and solid knowledge of dimensional modeling. As a Data Engineer Consultant, you will work closely with their clients to design, develop, and optimize their data infrastructure, ensuring the delivery of high-quality data solutions that meet business requirements.

This role is a mainly remote one for candidates who are relatively close to the Metro Denver area. Intermittent/occasional onsite work in Denver should be expected.

Please also note that the group is somewhat stack agnostic, so those with classically defined data engineering skills (ETL Modeling and Design, Data Pipelines, Relevant Builds, etc.) are encouraged to apply regardless of tech stack.

Key Responsibilities:

Data Infrastructure Development (ETL, SQL):

Design, build, and maintain scalable data pipelines and ETL processes tailored to client needs.

Develop and optimize complex SQL queries for data extraction, transformation, and loading.

Diagnose and troubleshoot data-related issues, providing quick and effective resolutions.

Analyze data workflows and identify areas for improvement, recommending and implementing solutions to optimize performance.

Utilize a proactive approach to foresee potential problems and address them before they impact clients' operations.

Dimensional Modeling and Data Modeling:

Design and implement dimensional models to support data warehousing and business intelligence initiatives.

Design and implement different data modeling techniques to meet business' data demands that align with data architecture design.

Develop and maintain data schemas, ensuring data integrity and consistency for clients.

Create and maintain dashboards and reports using data visualization tools to provide actionable insights.

Train clients on best practices for using data visualization tools to maximize value.

Client Consultation:

Engage with clients to understand their data needs and business objectives.

Conduct detailed requirements analysis and provide recommendations for data infrastructure improvements.

Work closely with client teams, data scientists, analysts, and other stakeholders to understand data needs and provide technical support.

Communicate complex technical concepts to non-technical stakeholders in a clear and concise manner.

Qualifications:

Bachelor's degree in computer science, Information Technology, or a related field.

3+ years of experience in data engineering, data warehousing, or a similar role.

Strong proficiency in SQL

Proven experience with data visualization tools and theory.

In-depth knowledge of dimensional modeling concepts and techniques.

Familiarity with ETL tools and processes.

Strong problem-solving skills and attention to detail

Experience with cloud-based data platforms

Excellent communication and collaboration skills, with the ability to work effectively with clients.

The desired salary range for this position is $80,000 - $125,000 per year. This is a full time role with the practice.

The customer works with their clients to transform their enterprise through the use of modern compute technologies and proven deployment processes providing cost effective durable solutions for the competitive world.