Data Engineer II

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 Who we are: Arizona State University has developed a new model for the American Research University creating an institution that is committed to excellence, access and impact. ASU measures itself by those it includes and how they succeed, not by those it excludes. ASU pursues research that contributes to the public good and assumes major responsibility for the economic, social and cultural vitality of the communities that surround it. In order to become that model for the New American University, ASU has undergone some radical changes over the last few years. Like many universities, it has added new buildings, hired new faculty and brought in new students. But, unlike many of its peers, ASU has also undertaken a massive reorganization of the institution. ASU has torn down walls between disciplines and encouraged collaboration among diverse units. ASU has altered the trajectory of the university and reevaluated the role that universities play in society, in the economy and in education at all levels. It has changed the relationship between ASU and the State of Arizona. 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.  Affiliates: The ASU Foundation for a New American University (ASUF) fosters partnerships between ASU and like-minded individuals, corporations and foundations who believe in ASU’s mission and provide resources for ASU to manifest its charter into meaningful impact. The ASU Outreach Hub is a nonprofit organization that supports the outreach and transactional needs of the ASU public enterprise through marketing and engagement solutions that advance the university and strengthen its brand. It specializes in paid media outreach, data-driven insights and outreach to alumni, donors and targeted corporations. ASURE is a nonprofit applied research and development lab component of ASU's public enterprise that partners with faculty across disciplines to extend ASU's reach and impact for national security innovation. NEWSWELL is a nonprofit organization dedicated to supporting and strengthening local news outlets. NEWSWELL is part of the ASU Media Enterprise at ASU. Skysong Innovations is ASU’s exclusive technology transfer and intellectual property management company responsible for the rapid and wide dissemination of ASU’s discoveries and inventions into the marketplace for the public good.   University Realty receives, cultivates, advances and monetizes commercial and residential real estate to support the mission of Arizona State University. The goal of each and every transaction is to bring more resources and more revenue to the table for education. Additionally, ASU Enterprise Partners operates ASU RealmSpark, which acts as the venture capital arm of ASU and invests in charter-aligned sectors. It finds the best technology on the market and brings it to the university. It also sources the most promising ASU-affiliated companies and brings them to market. ASU Enterprise Partners employs a diverse team engaged in meaningful work, including fundraisers, designers, scholars, financial wizards, filmmakers, inventors, entrepreneurs and volunteers. Each member brings a different perspective to our vision, yet we share a mission to advance the most innovative university in the country. Advance your career, too. Professional development is highly valued at ASU Enterprise Partners, where employees are encouraged to look across the organization and nurture new areas of interest. Roles often shift as passions are discovered. Employees and eligible dependents enjoy a comprehensive benefits package, including medical, dental and vision insurance; a 401(k) plan; and significant tuition reductions. Details about our comprehensive benefits are available here.