Remote Data Engineer Consultant (SQL & BI)

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

Job summary

EMW Staffing Solutions LLC is seeking an experienced Data Engineer Consultant to join our client team. The role focuses on designing, building, and optimizing data infrastructure, with strong SQL, data visualization, and dimensional modeling skills to deliver high-quality data solutions.

The position is mainly remote for candidates near the Denver area, with occasional on-site work in Denver. You will collaborate with clients, data scientists, and analysts to translate business needs into

Qualifications

• Bachelor's degree in computer science, Information Technology, or a related field.
• 3+ years of experience in data engineering, data warehousing, or a related 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.

Responsibilities

• Data Infrastructure Development (ETL, SQL): design, build, and maintain scalable data pipelines.
• Develop and optimize complex SQL queries for data extraction, transformation, loading.
• Diagnose data issues and provide quick resolutions.
• Analyze data workflows and identify areas for improvement to optimize performance.
• Utilize a proactive approach to foresee potential problems and address them before impact.
• Dimensional Modeling and Data Modeling: design and implement dimensional models for data warehousing and BI.
• Design and implement data modeling techniques to meet business data demands.
• Develop and maintain data schemas ensuring data integrity.
• Create and maintain dashboards and reports using data visualization tools; train clients on best practices.

Skills

SQL

Data visualization

Dimensional modeling

ETL

Data pipelines

Cloud data platforms

Communication

Education

Bachelor's degree in computer science or IT

Job description

EMW Staffing Solutions LLC is seeking an experienced Data Engineer Consultant to join our client team. The role focuses on designing, building, and optimizing data infrastructure, with strong SQL, data visualization, and dimensional modeling skills to deliver high-quality data solutions.

The position is mainly remote for candidates near the Denver area, with occasional on-site work in Denver. You will collaborate with clients, data scientists, and analysts to translate business needs into