Data Engineer II

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

What you’ll do

• Develop and manage data solutions using Microsoft Fabric, Microsoft Azure Cloud, AWS, Google Cloud Platform, Alteryx, Fivetran and other related technologies
• Develop and manage integrations between multiple data sources and environments across the ASU Enterprise Partners and ASU data ecosystems
• Develop and manage data ingestion into bronze and silver medallion layers within ASUEP’s data ecosystems
• Perform advanced configuration in Microsoft Fabric, Microsoft Azure Cloud, AWS, Google Cloud Platform, Fivetran, and other related systems to support evolving business and technical requirements
• Provide cross-training to team members
• Perform migration of systems, code, data sources, and processes to Microsoft Fabric to support the ongoing digital transformation of ASUEP’s data architecture
• Monitor pipelines, jobs, and other scheduled events within organization’s data warehouses/lakehouses/cloud environments and related systems to ensure uptime, performance, and data integrity
• Provide rapid response and resolution of system incidents, job failures, and operational disruptions; this may include 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.)
• In collaboration with and at direction of 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 data solutions in the cloud
• 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 using project management applications/methods and participation in sprint ceremonies
• Complete tasks in a timely manner; identify, communicate, and resolve barriers in a productive and positive manner
• Collaborate with other institutional parties to ensure consistency, accuracy, and availability of data
• Establish and maintain effective communications with other team members
• Document system architecture, troubleshooting steps, system changes, and process improvements.
• Perform other duties and projects as required

What you'll need  

• Expertise with designing, managing, and troubleshooting pipelines, jobs, services, and solutions in Microsoft Fabric and Microsoft Azure
• Expertise with 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
• Compelling interest in data, data warehouses, data integrity, and the movement of data to support business users
• Proficiency in Microsoft Windows and Office applications
• Capacity 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
• A drive to optimize current processes and improve quality
• Able to communicate effectively in person, writing, and by phone
• Ability to work both independently and as part of a team
• Ability to foster and instill trust through interpersonal interactions
• Capable of fostering cooperative work-teams by developing mutually beneficial relationships
• Attention to detail and thoroughness in completing assigned duties with consistent follow through
• Able to articulate deliverables, objectives, results, and outcomes
• Highly organized and able to work efficiently on multiple tasks simultaneously with deadlines
• Proficient at establishing 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) five years’ experience delivering information technology services which includes two (2) years with Microsoft Fabric and/or Microsoft Azure cloud technologies with demonstrated critical thinking and problem-solving skills
• Experience with the development of integrated strategies and solutions addressing differing needs, understandings, and objectives;
• OR any equivalent combination of experience and/or education from which comparable knowledge, skills, and abilities have been achieved

Preferred skills and abilities     ​​

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

Benefits  

• Hybrid work schedule. We 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 is highly valued at ASU Enterprise Partners, where employees are encouraged to look across the organization and nurture new areas of interest 
• $30 bi-weekly cell phone reimbursement 

About ASU Enterprise Partners

ASU Enterprise Partners is a nonprofit organization whose mission is to provide an ecosystem of services to create solutions and generate resources to extend Arizona State University’s reach and advance its charter. ASU Enterprise Partners supports ASU and several affiliates, including the ASU Foundation for a New American University, ASU Outreach Hub, ASURE, NEWSWELL, Skysong Innovations and University Realty.  

ASU Enterprise Partners is home to several Centers of Excellence whose purpose is to provide professional services to its affiliates. The Centers of Excellence include Finance, General Counsel, Investments, Public Relations and Strategic Communications, Human Resources, Facilities and Operations, Data Analytics and Insights Planning, Budgeting and Strategy, and Technology and Solutions.  

At ASU Enterprise Partners

We serve

ASU and one another with integrity, trust and compassion

We engage

step up, own it, collaborate

We innovate.

continuously, fearlessly, make decisions and take risks

We care

that everyone feels respected and valued for who they are

ASU Enterprise Partners is an Equal Opportunity Employer