Data Engineer II

ASU Enterprise Partners is hiring a Data Engineer II to support secure, reliable data assets across hybrid and cloud environments.

Responsibilities

• Develop and manage data solutions using Microsoft Fabric, Microsoft Azure Cloud, AWS, Google Cloud Platform, Alteryx, Fivetran, and related technologies
• Build and maintain integrations between multiple data sources and environments across ASUEP and ASU data ecosystems
• Ingest data into bronze and silver medallion layers within ASUEP’s data ecosystems
• Provide advanced configuration across Fabric, Azure Cloud, AWS, Google Cloud Platform, Fivetran, and related systems to meet changing business and technical requirements
• Support cross-training for team members
• Lead 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 and cloud environments to ensure uptime, performance, and data integrity
• Respond quickly to system incidents, job failures, and operational disruptions, including potential 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, alumni stories data, etc.)
• Implement Fabric workspace hierarchy, RBAC, and CI/CD for pipelines in collaboration with data and technology leadership
• Migrate on-premises SQL Server data systems and processes to Microsoft Fabric
• Migrate ETL packages from SSIS to Microsoft Fabric Pipelines
• Create processes to manage capacity and performance of data solutions in the cloud
• Develop SQL stored procedures, tables, and views, including complex SQL queries for end-user data investigation
• Validate and clean existing data using SQL; debug complex database processes and implement timely fixes
• 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 and participation in sprint ceremonies
• Complete tasks on time; identify, communicate, and resolve barriers constructively
• Collaborate with institutional stakeholders to support consistency, accuracy, and availability of data
• Establish and maintain effective communication with team members
• Document system architecture, troubleshooting steps, system changes, and process improvements
• Perform other duties and projects as required

Requirements

• 5+ years experience delivering information technology services, including two (2) years with Microsoft Fabric and/or Microsoft Azure cloud technologies
• Expertise designing, managing, and troubleshooting pipelines, jobs, services, and solutions in Microsoft Fabric and Microsoft Azure
• Expertise integrating data from multiple sources into data warehouses, lakehouses, and other environments
• Experience working 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 moving data to support business users
• Proficiency in Microsoft Windows and Office applications
• Ability to quickly learn new tools and technologies as needed
• Knowledge of industry data security best practices, methods, and techniques
• Ability to maintain high 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, 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 with thorough completion of assigned duties and consistent follow-through
• Ability to articulate deliverables, objectives, results, and outcomes
• Highly organized; able to work efficiently on multiple tasks with deadlines
• Proficiency establishing milestones and timetables
• Knowledge of applicable regulatory requirements associated with PII, FERPA, and PCI-DSS
• Certification (or willingness to complete) for Azure Fundamentals or equivalent
• Bachelor’s degree in Information Technology or related field
• Advocate belief in the vision of ASU as the New American University

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 (work from home two days a week)
• Comprehensive benefits package including 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 new areas of interest across the organization
• $30 bi-weekly cell phone reimbursement

Location: Scottsdale, AZ (hybrid)