Consultant, Data & Analytics - Data Engineering

Pioneer Management Consulting • Denver, CO

1h • $84,000 - $126,000

About The Position

As a Consultant, Data Engineer, you will be a part of a fast-paced environment helping clients solve complex issues and delivering exceptional results. The primary responsibility will be leading strategic initiatives to design and implement end-to-end data solutions, establishing and improving data analytics platform and data warehousing capabilities, and optimizing data flow to automated reporting and visualization tools. You will work closely with the technology infrastructure teams, business intelligence, functional stakeholders, and business leaders.
What You'll Do:
While each day and project will be different, below is a list of some of the typical activities that our Data Engineers perform on our various project teams:
Align: Work with leaders to define success and prioritize business problems that will lead to high business impact when solved.
Engage: Dig in with business leaders in business intelligence and technology to uncover core problems, leading with curiosity and humility to unearth issues related to data and how analytics is used.
Design: Lead clients through a collaborative process to design solutions underlying data issues including data warehouse architecture, real-time data delivery, and workflow automation
Execute: Manage engineering programs/projects with a hyper focus on delivery excellence – we dive into data analytics projects “with our sleeves rolled up.”
Sustain: Equip teams with an actionable plan for using data more effectively, resulting in deeper insights, data-informed decisions, and an elevated culture of applying analytics.
Client Resolution: Proficient at recognizing and diagnosing client problems
Relationship Building: Proactively cultivate and expand your professional network

Requirements

• 5+ years of professional experience working in corporate settings, notably in data engineering or infrastructure engineering/development role
• 2+ years consulting experience
• Experience with data engineering tools that cover integration, ETL and validation; specific tools and methodologies will vary by client
• Proficiency in building Azure cloud data platforms (Synapse, Fabric, Databricks, etc.)
• Proficiency in applying network security and user access models to Azure data platforms
• Proficiency in applying replication validation, error notification, and ETL optimization
• Proficiency in writing SQL and working with relational databases (TSQL, MSSQL,, etc.)
• Proficiency with at least one data science programming language (Python (preferred), R, PySpark, etc.)
• Experience with Azure cloud data platform
• Experience with Azure ETL tools (Azure Data Factory, LogicApps, Synapse, etc.)
• Familiarity with reporting tools like Power BI or Tableau
• Ability to communicate complex ideas effectively (verbal and written)
• Ability to work both independently and in a collaborative team environment
• Comfort handling ambiguity and managing multiple assignments
• Ability to work effectively with people at all levels in an organization
• Proven skills in the identification and resolution of client challenges
• Demonstrated ability to effectively expand professional networks through strategic relationship building and engagement

Responsibilities

• Align: Work with leaders to define success and prioritize business problems that will lead to high business impact when solved.
• Engage: Dig in with business leaders in business intelligence and technology to uncover core problems, leading with curiosity and humility to unearth issues related to data and how analytics is used.
• Design: Lead clients through a collaborative process to design solutions underlying data issues including data warehouse architecture, real-time data delivery, and workflow automation
• Execute: Manage engineering programs/projects with a hyper focus on delivery excellence – we dive into data analytics projects “with our sleeves rolled up.”
• Sustain: Equip teams with an actionable plan for using data more effectively, resulting in deeper insights, data-informed decisions, and an elevated culture of applying analytics.
• Client Resolution: Proficient at recognizing and diagnosing client problems
• Relationship Building: Proactively cultivate and expand your professional network

Benefits

• meaningful time off and paid holidays
• parental leave
• 401(k) including employer match
• tuition reimbursement
• a broad range of health and welfare benefits including medical, dental, vision, life, long and short-term disability, etc.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 51-100 employees