Azure Data Engineer in Tampa, FL at Vaco

Date Posted: 2/2/2021

Job Snapshot

Job Description

The Azure Data Engineer helps build and support enterprise data and analytics enablement solutions in the cloud. As part of an agile DevOps team, the Azure Data Engineer works with business analysts, product owners and data solutionists to implement purpose-built solutions for our stakeholders. The Azure Data Engineer promotes good data governance with an emphasis on industry best practices for maintaining security and privacy over our data.

The Azure Data Engineer reports to the Enterprise Data Management Leader.

Key Responsibilities:

Functional:

  • 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.
  • Perform other duties as assigned.

Technical:

  • 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.

Compliance:

  • 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:

Minimum Requirements:

  • Bachelor's degree in Computer Science or 3+ years of relevant work experience
  • 1 year of professional experience developing in a ETL environment or started their Microsoft Azure Data Engineer Associate (or any Azure equivalent) certification.
  • Working knowledge with DevOps and CI/CD methodologies and tools for automated infrastructure code test, integration, deployment, and assurance.
  • Proficiency with any one of the cloud providers AWS, Azure (Preferred) or Google Cloud Platform.
  • Moderate SQL proficiency.
  • Moderate 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:
  • Accuracy in all tasks.
  • Ability to work on multiple projects.
  • Follow through with project tasks/strict adherence to timelines.
  • Review and analyze source data, analyze, and document data flows, and validate mapping specifications and business rules from data source to target.
  • Develop SQL queries/scripts and similar artifacts to validate the completeness, integrity, and accuracy of data within an ETL process testing cycle.
  • Willingness to explore and employ new technical skillsets.
  • Shows a strong willingness to learn new technology.
  • Ability to be on-call, work nights and weekends as required.
  • Able to support a diverse and inclusive work environment.

Preferred Requirements:

  • Microsoft Azure Data Engineer Associate Certification
  • Pursuit of certification will be expected of this position in either the Azure Data Engineer and/or Azure Architect domains.
  • Expertise in on-prem and cloud database automation and platform automation. Azure experience.
  • Working knowledge of programming languages to code transformations (e.g., C, C++, Java, .Net/C#, PL/SQL, Transact SQL).
  • Exposure with ETL tools like Talend, Informatica, Microsoft SSIS.