Senior Data Engineer

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 DataA/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.

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 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 Have (Not Required)

• Bachelors or masters 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 employees 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:

The base salary range for this role is $126500 $160000 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. Final compensation is dependent on demonstrated skills relevant experience and alignment with the roles general new employees can expect to start at the lower end of the range (with opportunity to grow and expand within the organization)

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 matchwith immediate vesting. We offerflexible time off with employees averaging3.75 weeks per year and providepaid maternity and paternity leave.

Additional perks include amonthly phone stipend(or the option to join our corporate phone plan) and amonthly gym membership reimbursementof up to$200.

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

JOB CODE: