Principal Data Engineer Consultant

Our Data Engineering practice is growing! JourneyTeam is looking for a hungry, humble, and smart Principal Data Engineer Consultant to join our world-class team and continue building out our best-in-class solutions. If you are ready for growth, love designing and building Microsoft data solutions and have a passion for helping people and businesses, we would love to hear from you!

About JourneyTeam

JourneyTeam helps companies implement business solutions and improvements through Microsoft technologies. JourneyTeam is an award-winning Microsoft Partner specializing in all three Microsoft Clouds: Modern Workplace, Microsoft Azure, and Microsoft Business Applications, including Microsoft Dynamics 365, Power Platform and Data A/I.

The Opportunity

The Principal Data Engineer Consultant plays a pivotal role in driving technical excellence and business value for our clients. In this role, you will discover business requirements and work alongside our clients, as you architect and implement modern data engineering solutions within the Microsoft ecosystem. It is critical that you are able to work independently and create plans and direction for yourself and your team. We expect that you have the ability to lead strategically, direct technical projects, delegate work, assist with the pre-sales process, and mentor others. You will play a integral in the success of our practice as you lead the solution design, build, and implementation process to deliver on client expectations and project scope.

Key Responsibilities

• Help set vision, strategy and roadmap for JourneyTeam data engineering. Incorporate both Microsoft and industry best practices.  
• Architect and implement enterprise data strategies that align with client objectives including analytics, migrations and data integrations. 
• Collaborate with cross-functional teams, including business intelligence developers, Azure cloud administrators, business analysts, and others, to develop comprehensive data solutions. 
• Develop “best-in-class” data engineering solutions that provide data quality, reliability, automation, notification, scalability, modularity, security.  
• Design, develop, and optimize complex dimensional models for reporting (star schemas). 
• Lead out on design sessions with client teams, conduct workshops and training both internally and externally, including webinars.  
• Lead and mentor data engineers, provide technical guidance, share best practices, and foster a culture of continuous learning and growth. 
• Go-to resource for understanding client problems and responding with appropriate methods anchored around best practice, repeatable patterns, and “crush-it” mentality.  
• Diagramming and documentation champion. 
• Excellent leadership, communication, and project management skills. 

Required Qualifications:

• Proven track record with at least 15 years hands-on experience in data engineering, preferably within the Microsoft ecosystem.  
• 3 years’ experience working with Azure technologies, such as Data Factory, ADLS, Azure Databricks, Spark, Synapse Analytics, Azure SQL Database, Fabric. 
• Advanced SQL skills. Solid understanding of relational databases, transform logic and dimensional modeling techniques. Ability to write complex SQL. 
• Strategic leadership and technical expertise in the design, development, and optimization of client solutions using Microsoft Azure, Databricks or Fabric. 
• Experience innovating capabilities, collaboration with executive stakeholders to define the organization's long-term data strategy, and mentorship of a team of data engineers. 
• Collaboration with executive stakeholders to define the organization's long-term data strategy, vision, and roadmap.
• Experience establishing and enforcing data engineering standards, guidelines, and best practices to ensure data accuracy, performance, and usability.
• Experience presenting in webinars and conferences, conduct requirement gathering and architectural solutioning on client calls.
• Architectural design and experience building data orchestration and pipelines using metadata driven techniques.  
• Experience with connecting to and ingesting from API sources, including using OAuth 2. Additionally, experience with standardizing and/or flattening and/or normalizing JSON to a flavor of SQL structure. 
• In-depth understanding and practical application of modern data and security architecture principles, combining the best of data lakes and data warehouses for robust and scalable data management. 
• Successful management of data engineering projects, including planning, execution, and delivery. 
• Demonstrated ability to take ownership and responsibility of critical issues and provide resolution. Strong problem-solving and decision-making abilities as well as excellent collaboration skills. 
• Ability to create great rapport with client teams and exercise a knack for driving the adoption of data strategies that move the needle in improving business outcomes.  
• The ideal team member is an analytical problem solver with extensive technical expertise, a deep understanding of data engineering concepts, and a passion for modern data lakehouse technologies. 

Nice To Have (Not Required)

• Bachelor’s or master’s degree in computer science, informatics, data science or related technical discipline. 
• Experience dealing with high-volume and high-velocity data streams and designing systems that can handle the demands of real-time or near-real-time analytics. 
• Azure Databricks experience. 
• Relevant industry certifications, especially Microsoft. 

Here at JourneyTeam, we care about our employee’s growth. Here is what success looks like your first year: 

30 Days: 

• Read and review “The Data Warehouse Toolkit” by Ralph Kimball
• Participate and contribute to group training plan
• Shadow other data engineers to learn the implementation process and tasks required throughout our projects.
• Be assigned to a project and support tasks.

90 Days: 

• Independently own, architect and implement customer solutions.  
• Build data standards and templates and train team on value and adoption.

6 months: 

• Fully involved in project and support efforts and be a contributing member of project teams and long-term client support
• Achieve a Microsoft certification
• Achieve a 75% customer engagement rate by the beginning of six-month period.

Compensation

$155,000 -$180,000, dependent on demonstratable skills and experience

Benefits

JourneyTeam offers a wide range of excellent benefits including healthcare and dental options, as well as a 401k with an approximate 4% employer match with funds that vest immediately. We enjoy flexible time off and our employees average 3.5 to 4 weeks off a year. We also provide a monthly phone stipend of $25 as well as a gym membership monthly reimbursement of up to $200. We enjoy a culture of collaboration and creative responsibility to solve problems with autonomy.

JourneyTeam is an Equal Opportunity Employer.  This position is not open to C2C, H1B's or third-party agencies.  

Salary : $25