Data Engineer II

ASU Enterprise Partners • Scottsdale, AZ

1d • Hybrid

About The Position

The Data Engineer II is a member of the Technology & Solutions department at ASU Enterprise Partners (ASUEP). The role supports the integrity, augmentation, integration, security, and stewardship of ASUEP data assets. Working closely with teams at ASUEP and ASU, the position supports technologies and processes that ensure data is accurate, complete, and available in a timely manner for business decisions, processes, and reporting. The position reports to the Associate VP of Technology & Solutions.

The role develops and manages data solutions, integrations, and ingestion across ASUEP and ASU data ecosystems, using Microsoft Fabric, Microsoft Azure Cloud, AWS, Google Cloud Platform, Alteryx, Fivetran, and related technologies. It contributes to ASUEP’s digital transformation by migrating systems, code, data sources, processes, on-premises SQL Server systems, and SSIS ETL packages to Microsoft Fabric. The position also monitors and supports data pipelines, jobs, warehouses, lakehouses, and cloud environments, including responding to incidents and disruptions that may occur at night or on weekends.

The Data Engineer II develops SQL database objects and queries, validates and cleans data, supports data governance and security, and documents systems and processes. The role works with data and technology leadership, other institutional parties, and team members; handles multiple assignments; and participates in agile project management and sprint ceremonies.

Requirements

• Bachelor’s degree in Information Technology or a related field, and at least five years of experience delivering information technology services, including two years with Microsoft Fabric and/or Microsoft Azure cloud technologies, with demonstrated critical-thinking and problem-solving skills; or an equivalent combination of experience and/or education that provides comparable knowledge, skills, and abilities.
• Expertise designing, managing, and troubleshooting pipelines, jobs, services, and solutions in Microsoft Fabric and Microsoft Azure.
• Expertise integrating data from varied sources into data warehouses, lakehouses, and other environments.
• Experience with database technologies in a hybrid multi-cloud and 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 in support of business users.
• Proficiency with Microsoft Windows and Office applications.
• Ability to learn new tools and technologies quickly as needed.
• Knowledge of industry best practices for data security principles, methods, and techniques.
• Ability to maintain confidentiality and responsibility regarding information related to ASUEP, its subsidiaries, university business, and confidential prospect information.
• Ability to create technical documentation.
• Drive to optimize existing 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 through interpersonal interactions and develop mutually beneficial relationships that support cooperative work teams.
• Attention to detail, thoroughness, and consistent follow-through.
• Ability to articulate deliverables, objectives, results, and outcomes.
• Strong organization and ability to work efficiently across multiple tasks and deadlines.
• Proficiency in establishing milestones and timetables.
• Knowledge of regulatory requirements associated with PII, FERPA, and PCI-DSS.
• Azure Fundamentals certification or willingness to complete certification, or equivalent.
• Belief in and advocacy for ASU’s vision as the New American University.
• Experience developing integrated strategies and solutions that address differing needs, understandings, and objectives.

Nice To Haves

• Experience with Salesforce CRM, Salesforce Marketing Cloud, Salesforce Commerce Cloud, Fivetran, and related technologies is highly preferred.

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 ASUEP and ASU data ecosystems.
• Develop and manage data ingestion into bronze and silver medallion layers within ASUEP data ecosystems.
• Configure Microsoft Fabric, Microsoft Azure Cloud, AWS, Google Cloud Platform, Fivetran, and related systems to support changing business and technical requirements.
• Provide cross-training to team members.
• Migrate systems, code, data sources, and processes to Microsoft Fabric in support of ASUEP’s digital transformation.
• Monitor pipelines, jobs, and scheduled events in data warehouses, lakehouses, cloud environments, and related systems to ensure uptime, performance, and data integrity.
• Respond to and resolve system incidents, job failures, and operational disruptions, potentially including nights and weekends.
• Load new data sources into Salesforce to augment constituent records, including non-degreed alumni, student organization, study abroad, and alumni stories data.
• Implement Fabric workspace hierarchy, role-based access control (RBAC), and CI/CD for pipelines in collaboration with and at the direction of data and technology leadership.
• Migrate on-premises SQL Server data systems and processes to Microsoft Fabric.
• Migrate SSIS ETL packages to Microsoft Fabric Pipelines in the cloud.
• Create processes to manage capacity and performance of cloud data solutions.
• Develop SQL stored procedures, tables, and views, including complex queries to investigate data for end users.
• Validate and clean existing data using SQL; debug complex database processes and implement fixes promptly.
• Coordinate with data and technology leadership to classify, tag, and manage data across the data ecosystem.
• Manage multiple projects and assignments concurrently.
• Participate in agile project management, document progress using project management applications or methods, and participate in sprint ceremonies.
• Complete tasks promptly and identify, communicate, and resolve barriers constructively.
• Collaborate with institutional parties to ensure data consistency, accuracy, and availability.
• 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.

Benefits

• Hybrid work schedule with work from home two days per 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 the employee’s birthday.
• Parental leave.
• Significant tuition reductions.
• Professional development opportunities; employees are encouraged to explore interests across the organization.
• $30 bi-weekly cell phone reimbursement.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level