Azure Data Engineer

About PrePass

PrePass® is North America's most utilized and technologically advanced weigh station bypass and toll payment platform. Proven PrePass technologies enable safe, qualified motor carriers to bypass inspection facilities at highway speeds, saving them time, fuel, and money while reducing emissions. As the top provider to offer bypass and tolling solutions, PrePass technology allows fleets to regain control of toll costs, eliminate toll violations, and automatically resolve max toll disputes. PrePass is the only preclearance system developed, owned, and operated in the United States of America as well as the American Trucking Associations’ only Endorsed Corporate Partner. That’s why more than 130,000 fleets subscribe over 750,000 commercial vehicles to PrePass services.

Position Description

We are seeking a talented and experienced Azure Data Engineer to join our team. With a minimum of 6 years of relevant experience, you will play a pivotal role in designing and implementing scalable, secure, and reliable cloud-based solutions using Microsoft Azure. As an integral member of our team, you will participate in data strategy and roadmap exercises, data architecture definition, business intelligence/data warehouse product selection, design, and implementation. You will also play key roles in large projects, serving as a Senior Data Modeler, Technical Lead, and Data Architect. This is a hybrid role absed in Phoenix, AZ.

Your Key Responsibilities

• Solution Design: Collaborate with multiple Software Engineering teams to understand their business goals, technical requirements, and constraints. Design scalable and cost-effective cloud architectures leveraging Microsoft Azure services. Develop solution blueprints, architectural diagrams, and technical specifications.
• Architecture Development: Ensure solutions align with industry best practices, security standards, and compliance regulations. Provide technical guidance and recommendations to development teams throughout the development lifecycle.
• Data Management: Define standards for how data will be stored, consumed, integrated, and managed across the organization. Work through all stages of a data solution lifecycle: analyze/profile data, create conceptual, logical & physical data model designs, architect and design ETL, reporting, and analytics solutions. Serve as a subject matter expert for the organization on various data warehouse products available in Azure.
• Data Accuracy and Accessibility: Implement measures to ensure data accuracy and accessibility, constantly monitoring and refining the performance of data management systems.
• Technical Leadership: Participate and provide technical leadership in all phases of a project from discovery and planning through implementation and delivery. Work closely with DBAs, Developers, and Project Managers.

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
• Minimum of 6 years of relevant experience.
• Hands-on experience with modern enterprise data architectures and data toolsets (e.g., data warehouse, data marts, data lake, 3NF and dimensional models, modeling tools, profiling tools).
• Proficiency in data analytics and visualization tools such as Power BI, SSIS, and SSRS.
• Experience in data integration using tools such as Azure Data Factory, SSIS, and Azure Synapse.
• Strong experience in architecture design and development using Microsoft Azure Data Services such as Azure SQL, Azure Data Lake, Azure Data Factory, Azure Databricks, and no-SQL platforms.
• Relevant Azure certifications (e.g., Azure Solutions Architect Expert, Azure Data Engineer Associate).
• Knowledge of data architecture and design patterns and the ability to apply them.
• Ability to learn and adapt quickly to new business domains and technologies.
• Strong problem-solving skills and ability to conceptualize and articulate ideas clearly and concisely.
• Excellent communication, presentation, and interpersonal skills.
• Transportation industry experience is a plus.
• Experience working with Agile Teams utilizing Scrum.

How We Will Take Care of You

• Robust benefit package that includes medical, dental, and vision that start on date of hire.
• Paid Time Off, to include vacation, sick, holidays, and floating holidays.
• 401(k) plan with employer match.
• Company-funded “lifestyle account” upon date of hire for you to apply toward your physical and mental well-being (i.e., ski passes, retreats, gym memberships).
• Tuition Reimbursement Program.
• Voluntary benefits, to include but not limited to Legal and Pet Discounts.
• Employee Assistance Program (available at no cost to you).
• Company-sponsored and funded “Culture Team” that focuses on the Physical, Mental, and Professional well-being of employees.
• Community Give-Back initiatives.
• Culture that focuses on employee development initiatives.