Consultant, Data & Analytics - Data Engineering

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 

What You'll Bring:  

• 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.) 

• Experience with  

• 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 

Location: 

• Pioneer Minneapolis Office: 729 Washington Ave N, Suite 600, Minneapolis, MN 55401 

• Pioneer Denver Office: 2500 Walnut St. Suite 401; Denver, Co 80205

Pioneer Benefit Info: 

The estimated salary range for this role is $84,000-$126,000 annually. This is based on a wide array of factors unique to each candidate, including but not limited to skillset and years and depth of experience. This may differ from location to location. Bonuses and other incentives are awarded at the Company’s discretion and are based upon individual contributions and overall company performance. Pioneer is proud to offer a comprehensive benefits package that includes meaningful time off and paid holidays, parental leave, 401(k) including employer match, tuition reimbursement, and a broad range of health and welfare benefits including medical, dental, vision, life, long and short-term disability, etc.