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!
The OpportunityThe 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 JourneyTeam 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.
Qualifications- 3+ 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 JourneyTeam'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 structure.
- Solid understanding of modern data lakehouse concepts, such as medallion architecture, combining the best of data lakes and data warehouses.
- Ability to take ownership of assigned work and issues and see them through to resolution. Strong problem-solving abilities as well as excellent collaboration skills.
- Ability to build rapport with client teams and communicate technical concepts clearly.
- The ideal team member is an analytical problem solver with solid technical skills, a strong grasp 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.
- Exposure to real-time or near-real-time data, such as Fabric Real-Time Intelligence or Eventstreams.
- Experience with Git, CI/CD, and Azure DevOps or GitHub for data solutions
- Relevant industry certifications, especially Microsoft (e.g., DP-700 Fabric Data Engineer Associate).
CompensationThe base salary range for this role is $100,000 - $120,000 + performance-based bonus program. Eligibility and payout are tied to individual contributions, team performance, and company success.
This is salary range is within the established pay range for the Data Engineer role at JourneyTeam on the Data & AI Solutions Practice.
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 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.
