Senior Data Engineer Consultant Job at JOURNEYTEAM, Draper, UT

TU85TGkvamx4L2hPY0UvUWhZTTcrRUJL
  • JOURNEYTEAM
  • Draper, UT

Job Description

Please Note: Our Data Engeering team is a hybrid team and while remote is an option, we are giving preference to candidates based in Utah. 

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.

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 Growth Mindset
    • Effective Communication
    • Taking Ownership
    • Making & Keeping Commitments
    • Being OneTeam
    • Exceptional Performance
    • A Caring Mindset

Nice To Have (Not Required)

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

Here at JourneyTeam, we care about our employee’s 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

Base pay: $135,000 -$160,000, dependent on demonstratable skills and experience, base pay is part of a total compensation package that may include monthly stipends for health, wellness and tech spending, and benefits (see benefits outline below).

Benefits

JourneyTeam offers a wide range of excellent benefits including healthcare and dental options, as well as a 401k with an approximate 4% employer match with funds that vest immediately. We enjoy flexible time off and our employees average 3.5 to 4 weeks off a year. We also provide a monthly phone stipend of $25 as well as a gym membership monthly reimbursement of up to $200. We enjoy a culture of collaboration and creative responsibility to solve problems with autonomy.

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

Job Tags

Immediate start, Remote job, H1b, Flexible hours,

Similar Jobs

PriceLabs

Talent Recruiter - Sales & Success (Remote) (Contractual - 1 year) Job at PriceLabs

 ...We are looking for an experienced Talent Recruiter (Non-Tech) to join our team. This is a 1-...  ...Tracking Systems ~ Sense of integrity, strong work ethic, and ability to maintain a high...  ...-first organization and accept work from home as the norm. Work with an industry-... 

TechnologyAdvice

Remote Email Marketing Coordinator Job at TechnologyAdvice

 ...to remote work unless otherwise specified in the requirements below. The opportunity Were looking for an enthusiastic Email Marketing Coordinator to be an integral part of our Email Newsletter Team! Youll assist in building, scheduling and optimizing email... 

Sanford Health

CNA - Certified Nursing Assistant - Part Time - Rotating Shifts Job at Sanford Health

 ...commitment to quality care and service in a Christian environment. Facility: GSS KS...  ...people who live here but also those that work here. We are hiring a PT Certified CNA...  ...generous time off package to maintain a healthy home-work balance. For more information about... 

Smart Arches Dental Implant Centers

Dental Lab Technician Job at Smart Arches Dental Implant Centers

 ...Job Title: Dental Lab Technician Department: Clinical/Operations Reports to: Chief Clinical Officer FLSA Status: Non Exempt Starting at $25/hour (Full Time, 35+ hours/week) Target Start: Flexible (Q4 2025) Company Overview Smart Arches Dental... 

TEL Staffing & HR

Staffing Agency Office Administrator Job at TEL Staffing & HR

 ...The Office Administrator plays a key role in supporting daily operations within our staffing agency. This position ensures smooth office functions, provides administrative support to recruiters and management, and helps maintain an organized, efficient, and professional...