Hybrid Consultant, Data & Analytics – Data Engineering

at Pioneer Management Consulting

• Job title: Consultant, Data & Analytics – Data Engineering
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: $84,000 - $126,000 per year
• Degree requirement: Bachelor's Degree
• Tech skills: Azure, Cloud, ETL, PySpark, Python, SQL, Tableau
• Location requirements: Hybrid, Denver, United States

About the role

• Consultant, Data Engineer leading end-to-end data solutions and analytics. Collaborating with clients to improve data strategies and deliver actionable insights.

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

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
• Bachelor’s Degree preferred

Benefits

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