Data Engineer II

The Data Engineer II role at ASU Enterprise Partners supports the integrity, augmentation, integration, security, and stewardship of ASUEP data assets. This hybrid position in Scottsdale, AZ focuses on building and operating cloud and hybrid data solutions, including ingestion into medallion layers, pipeline monitoring, incident response, and migration work to Microsoft Fabric.

Responsibilities

• Develop and manage data solutions using Microsoft Fabric, Microsoft Azure Cloud, AWS, Google Cloud Platform, Alteryx, Fivetran, and related technologies
• Develop and manage integrations between multiple data sources and environments across ASU Enterprise Partners and ASU data ecosystems
• Build and manage data ingestion into bronze and silver medallion layers within ASUEP’s data ecosystems
• Perform advanced configuration across Microsoft Fabric, Microsoft Azure Cloud, AWS, Google Cloud Platform, Fivetran, and related systems to address evolving business and technical requirements
• Provide cross-training to team members
• Support migration of systems, code, data sources, and processes to Microsoft Fabric as part of ASUEP’s digital transformation
• Monitor pipelines, jobs, and scheduled events in organizational data warehouses/lakehouses/cloud environments to ensure uptime, performance, and data integrity
• Provide rapid response and resolution for system incidents, job failures, and operational disruptions, including nights and weekends
• Load new data sources into Salesforce to augment existing constituent records, including non-degreed alumni records, student organization data, study abroad data, and alumni stories data
• In collaboration with data and technology leadership, implement Fabric workspace hierarchy, RBAC, and CI/CD for pipelines
• Migrate on-premises SQL Server data systems and processes to Microsoft Fabric
• Migrate ETL packages from SSIS to Microsoft Fabric Pipelines in the cloud
• Create processes to manage capacity and performance of cloud-based data solutions
• Develop SQL stored procedures, tables, and views, including complex SQL queries to investigate data for end users
• Validate and clean existing data using SQL; debug complex database processes and implement fixes in a timely manner
• Coordinate with data and technology leadership to classify, tag, and manage data stored throughout the data ecosystem
• Manage multiple projects and assignments concurrently
• Participate in agile project management, including documentation of progress and participation in sprint ceremonies
• Complete tasks on time, identify, communicate, and resolve barriers, and maintain productive and positive collaboration
• Collaborate with institutional parties to ensure consistency, accuracy, and availability of data
• Establish and maintain effective communications with team members
• Document system architecture, troubleshooting steps, system changes, and process improvements
• Perform other duties and projects as required

Requirements

• Expertise designing, managing, and troubleshooting pipelines, jobs, services, and solutions in Microsoft Fabric and Microsoft Azure
• Expertise integrating data from various sources into data warehouses, lakehouses, and other environments
• Experience with database technologies in a hybrid multi-cloud/on-premises model
• Experience working within an agile team, or willingness to do so
• Competency with ETL tools such as Alteryx, Microsoft Azure Data Factory, Microsoft Fabric pipelines, and SSIS
• Strong interest in data, data warehouses, data integrity, and data movement that supports business users
• Proficiency in Microsoft Windows and Office applications
• Ability to quickly learn new tools and technologies as needed
• Knowledge of best practice industry data security principles, methods, and techniques
• Ability to maintain a high degree of confidentiality and responsibility regarding information related to ASUEP, its subsidiaries, University Business, and confidential Prospect information
• Ability to create technical documentation
• Drive to optimize current processes and improve quality
• Ability to communicate effectively in person, in writing, and by phone
• Ability to work independently and as part of a team
• Ability to foster trust and build cooperative work-teams through interpersonal interactions
• Attention to detail and thoroughness with consistent follow-through
• Ability to articulate deliverables, objectives, results, and outcomes
• Highly organized with the ability to work efficiently on multiple tasks simultaneously with deadlines
• Ability to establish milestones and timetables
• Knowledge of applicable regulatory requirements associated with PII, FERPA, and PCI-DSS
• Certification, or willingness to complete certification, for Azure Fundamentals or equivalent
• An advocate’s belief in the vision of ASU as the New American University

Relevant Qualifications

• Bachelor’s degree in Information Technology or related field AND
• At least five (5) years’ experience delivering information technology services, including two (2) years with Microsoft Fabric and/or Microsoft Azure cloud technologies, with demonstrated critical thinking and problem-solving skills
• Experience developing integrated strategies and solutions that address differing needs, understandings, and objectives

Alternative combinations of experience and/or education may be considered if they provide comparable knowledge, skills, and abilities.

Preferred Skills and Abilities

• Experience with Salesforce CRM, Salesforce Marketing Cloud, Salesforce Commerce Cloud, Fivetran, and related technologies

Technologies

• Microsoft Fabric, Microsoft Azure Cloud, AWS, Google Cloud Platform
• Alteryx, Fivetran
• Microsoft Azure Data Factory, Microsoft Fabric Pipelines
• SSIS, Salesforce
• SQL Server, SQL
• Azure Fundamentals, CI/CD, RBAC

Benefits

• Hybrid work schedule, including working from home two days per week
• Comprehensive benefits package with medical, dental, and vision insurance
• 401(k) plan with matching employer contribution
• 22 days of vacation time
• 11 holidays, including your birthday
• Parental leave
• Significant tuition reductions
• Professional development valued at ASU Enterprise Partners, with encouragement to explore interests across the organization
• $30 bi-weekly cell phone reimbursement