Azure Data Engineer II
Enterprise Data Management Leader
Date Last Revised:
Title IV Position:
Purpose of the Position:
The Azure Data Engineer II helps design, build and support UMA's enterprise data and analytics enablement solutions in the cloud. As part of an agile DevOps team, the Azure Data Engineer II works with business analysts, product owners and data solutionists to implement purpose-built solutions for our stakeholders. The Azure Data Engineer II promotes good data governance with an emphasis on industry best practices for maintaining security and privacy over our data.
The Azure Data Engineer II reports to the Enterprise Data Management Leader.
Collaborate on the development of new cloud data stores and migration of existing data.
Work collaboratively to develop, document, and ensure continue improvements of Software Development Life Cycle (SDLC) best practices for data in the cloud.
Be an advocate for quality and security though data quality and accuracy validations.
Focus on understanding business problems and determine how to optimize the solutions for the same.
Deploy with automation data platforms in a cloud environment with Continuous integration/Continuous delivery (CI/CD) processes.
Partner with architecture, security, infrastructure, and application teams to design and implement automation data and database platforms and tools.
Assist with problem resolution for cloud automation issues.
Create and update automation to eliminate routine management processes.
Have a working understanding of standard extract, transform, and load (ETL) tools and techniques, sourcing, maintaining, and updating data, data warehousing, data cleansing, and other analytical techniques required for data usage.
Build Data Service Application Programming Interfaces (API)s.
Develop and maintain data warehouse schematics, layouts, architectures and relational/non-relational databases for data access and Advanced Analytics.
Delivery of architectures for transformations and modernizations of enterprise data solutions using Azure cloud data technologies.
Implement effective metrics and monitoring processes.
Support the root cause analysis on all failed processes and resolve assigned production issues.
Provide coaching to Azure Data Engineer staff and mentor in best practices for ETL quality and assurance.
Provide expertise in deploying Azure Data Factory pipelines in a DevOps environment
Perform other duties as assigned.
Development of big data pipeline using Azure Data Factory V2 (ETL) and Azure Data Lakes
Proficiently utilize Microsoft SQL Server (PaaS and on-prem) in a hybrid mode
Proficiently understand the CDS model for Microsoft Dynamics CRM
Proficiently develop solutions that primarily utilize Azure Cloud Services
Possess database fluency, including an optimal understanding of SQL and a robust understanding of multiple database concepts.
Create and maintain legacy database procedures and processes that support daily data loading and report generation.
Support Institutional Initiatives
Keep current on institutional goals, objectives, and progress.
Engage in institutional sponsored activities and initiatives as appropriate.
Lead with courage in support of change initiatives that impact organization.
Manages and assists in coordinating efforts between departments within UMA.
Demonstrates knowledge of, and carefully follows all applicable federal and state compliance requirements and regulations including those prescribed by the Department of Education, accrediting agencies, CIE, and internal UMA policies and procedures.
Effectively communicates compliance requirements to students and other staff as appropriate and quickly escalates any compliance concerns to the Compliance department.
Work Experience, Skills & Abilities:
Bachelor's degree in Computer Science or 5+ years of relevant work experience
3 years of professional experience developing in a ETL environment or started their Microsoft Azure Data Engineer Associate (or Azure equivalent) certification.
Working-level Proficiency with DevOps and CI/CD methodologies and tools for automated infrastructure code test, integration, deployment, and assurance.
Expertise in on-prem and cloud database automation and platform automation. Azure experience being preferred.
High Proficiency with Azure Cloud Services.
High SQL proficiency.
Demonstrated expertise in programming languages to code transformations (e.g., C, C++, Java, .Net/C#, PL/SQL, Transact SQL).
Experience with ETL tools like Talend, Informatica, Microsoft SSIS.
Experience with Database modeling tools like Erwin.
Moderate experience in designing and authoring reports using SQL Server Reporting Services, Crystal Reports, as well as other report authoring tools.
Moderate proficiency in SSAS setup and use.
Strong Microsoft Server filesystem and file transfer knowledge.
Strong problem-solving skills.
Strong collaboration skills and excellent verbal and written communication skills. Able to professionally communicate fluently in verbal and written English.
Proficient in MS Office (Word, Excel, PowerPoint) and other business tools such as Skype and Microsoft Teams.
Data Analytics and Quality Control:
o Accuracy in all tasks.
o Ability to work on multiple projects.
o Follow through with project tasks/strict adherence to timelines.
o Review and analyze source data, analyze and document data flows, and validate mapping specifications and business rules from data source to target.
o Develop SQL queries/scripts and similar artifacts to validate the completeness, integrity, and accuracy of data within an ETL process testing cycle.
Has demonstrated the ability to learn new technology and employ the same in a production environment. Must seek out and recommend new technologies and techniques that represent industry-level innovations in data management especially in the Azure cloud environment.
Be able to identify and mitigate risks to projects.
Self-Starter with a strong propensity towards innovation.
Able to support a diverse and inclusive work environment.
Ability to be on-call, work nights and weekends as required.
Microsoft Azure Data Engineer Certification
Pursuit of certification will be expected of this position in either the Azure Data Engineer and/or Azure Architect domains.
Office Environment – Must be able to work in the UMA Office
Flexibility to work evenings and weekends as needed.
Requires long periods of sitting at a desk working on a computer.
Requires occasional bending, stooping, and squatting
Requires occasional lifting of up to 10 lbs.
Our institutional values are shaped and validated by our team members. They describe how we strive to operate and are the standards of behavior we look to embody.
ACT WITH INTEGRITY
We operate honestly and ethically in an industry-compliant fashion. We are fair and trustworthy in our interactions with all we serve. Our team members, at all levels, lead by example and strive to do the right thing for our students and for each other. We are disciplined professionals who strive to be straightforward and dependable.
CHAMPION STUDENT OUTCOMES
We live by a strong commitment to our students and are passionate about preparing them for meaningful careers. We are deeply dedicated to ensuring students' educational and career success. We excel at building our students' confidence and empowering them to reach their full potential.
COMMIT TO TEAM MEMBER SUCCESS
We are committed to our team members' success and to each other's success. We strive to create an environment that attracts and retains the best talent while offering continuous learning, professional development and career growth opportunities. We recognize and reward our team members for their contributions to the organization and to our students.
PURSUE RESULTS WITH PURPOSE
We pursue results with a sense of urgency and purpose. We take responsibility for achieving ambitious, measurable results and hold each other accountable. We think strategically and critically, greet new ideas and challenges openly, and look for innovative solutions to challenges.
HAVE FUN. BUILD ENERGY
Enjoying what we do is central to achieving our goals. Building energy, having fun, being optimistic and creating a positive working environment are all critical to our success and that of our students. We strive to be inspired and to inspire others. We consistently show appreciation and celebrate our successes, both large and small.
WORK AS ONE
We believe that diverse, inclusive teams produce breakthrough results. We strive to build and maintain positive relationships with colleagues from all types of backgrounds by showing respect and humility when interacting with each other and resolving conflicts in a constructive manner. By working together, we win together - as one - ensuring that the goals of the company are the focal point of our efforts.
This job description is intended to be an accurate reflection of the current position. It may not include every job responsibility. Job duties may fluctuate based on needs of the business. UMA reserves the right to revise the job or require that additional or different tasks be performed.
I have read and understand all the responsibilities and accountabilities in my job description. This job description is a tool used by me and management to help assess, evaluate and provide guidelines and expectations for the position named herein. I understand that it is not a contract and it does not constitute any guarantee of future employment.
To Apply, send resume to: