Senior Data Engineer Consultant Jobs (NOW HIRING)

Our Data Engineering practice is growing! JourneyTeam is looking for a hungry, humble, and smart Senior 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!

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.

What truly sets us apart is how we show up every day-for our customers and for each other. We believe that great outcomes come from great people who are aligned in how they work, collaborate, and take ownership. We succeed by consistently demonstrating our core values:

• A Caring Mindset
• Exceptional Performance
• Being OneTeam
• Making & Keeping Commitments
• Taking Ownership
• Effective Communication
• A Growth Mindset

The Senior Data Engineer Consultant plays a pivotal role in driving technical excellence and business value for our clients. Critical aspects of this role entail the ability to discover business requirements and work alongside our clients as you architect and implement modern data engineering solutions within the Microsoft ecosystem. You will also mentor others and lead the solution design and build process as you meet client expectations and project scope. 

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

• Proven track record with at least 7+ 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. 
• Demonstrate strong alignment with JourneyTeam values.
• Advanced SQL skills. Solid understanding of relational databases, transform logic and dimensional modeling techniques. Ability to write complex SQL. 
• 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. 

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

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

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

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

The base salary range for this role is $126,500 - $176,000 + performance-based bonus program. Eligibility and payout are tied to individual contributions, team performance, and company success.

This is the established pay range for the Senior Data Engineer roles at JourneyTeam on the Data & AI Solutions Practice. 

JourneyTeam offers a wide range of excellent benefits, including comprehensive healthcare and dental coverage, as well as a 401(k) with an approximate 4% employer match-with immediate vesting. We offer flexible time off and provide paid maternity and paternity leave. 

Additional perks include a monthly phone stipend (or the option to join our corporate phone plan) and a monthly gym membership reimbursement of up to $200. 

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