Data Engineer

Our Data and AI practice is growing and we are eager to find our next Data Engineer for our world-class team as we 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 Journey Team Journey Team helps companies implement business solutions and improvements through Microsoft technologies. Journey Team 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 and AI. 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 One Team Making  & Keeping Commitments Taking Ownership Effective CommunicationA Growth Mindset The Opportunity The Data Engineer plays a key role in delivering technical excellence and business value for our clients. Critical aspects of this role entail the ability to understand business requirements and work alongside our clients as you build and implement modern data engineering solutions within the Microsoft ecosystem, with a focus on Microsoft Fabric.

You will contribute to the solution design and build process alongside senior team members as you meet client expectations and project scope.

Key Responsibilities Build and implement data solutions that align with client objectives including analytics, migrations and data integrations, primarily in Microsoft Fabric, with additional work in Azure Databricks and other Azure data services.
Collaborate with cross-functional teams, including Power BI developers, Azure cloud administrators, business analysts, and others, to deliver comprehensive data solutions. Our Power BI developers own reporting, and this role focuses on the data engineering that powers it.  Develop “best-in-class” data engineering solutions that provide data quality, reliability, automation, notification, scalability, modularity, security. Design, develop, and optimize dimensional models (star schemas) that support Power BI reporting.
Participate in design sessions with client teams and contribute to workshops and internal knowledge sharing.  Apply Journey Team and Microsoft best practices, and contribute ideas to improve our data engineering patterns.
Understand client problems and respond with appropriate methods anchored around best practice, repeatable patterns, and “crush-it” mentality.  Create and maintain clear diagrams and documentation.
Strong communication, organization, and time management skills.
Qualifications3+ years hands-on experience in data engineering, preferably within the Microsoft ecosystem.
Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, Data Pipelines, Notebooks) and Azure technologies such as Data Factory, ADLS, Azure SQL Database, Synapse Analytics. Demonstrated passion and commitment to Journey Team’s values, and customer priorities. Strong SQL skills with a clear understanding of relational databases, transform logic and dimensional modeling techniques.

Ability to write and optimize complex SQL.  Working knowledge of Spark (PySpark and/or Spark SQL) in notebooks.
Experience building data orchestration and pipelines. Exposure to metadata driven techniques is a plus.  

Experience with connecting to and ingesting from API sources, including using OAuth
2. Additionally, experience with flattening and/or normalizing JSON to a flavor of SQL…