Senior Data Engineer

Journeyteam • Draper, UT

24d • $126,500 - $160,000

About The Position

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

Requirements

• 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.
• 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.
• Embrace and live the JourneyTeam Values: A Caring Mindset Exceptional Performance Being OneTeam Making & Keeping Commitments Taking Ownership Effective Communication A Growth Mindset

Nice To Haves

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

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.

Benefits

• 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, with employees averaging 3.75 weeks per year, 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level