Current Job Openings

4. ETL Software Engineer – Azure Data Factory

Apply Now Back to Search Results

KORE1, a nationwide provider of staffing and recruiting solutions, has an immediate opening for ETL Software Engineer- Azure Data Factory 
  • ETL Software Engineer- Azure Data Factory
  • Location: Carmel, IN
  • Onsite Requirements: Hybrid/ (Wednesday Onsite) /4 Remote 
  • No sponsorship
  • No 3rd Parties
  • Compensation: $105K-$110K

Job Description:

  • Migrate existing Pentaho ETL integrations to Azure cloud platform

  • Develop and maintain data pipelines using Azure Data Factory and other relevant Azure technologies

  • Optimize ETL processes for performance and scalability, leveraging Azure services such as Azure Data Factory Mapping Data Flows, Azure Data Lake Analytics, or Azure Synapse Pipelines

  • Extract data from various sources, transform it into a usable format, and load it into Azure data storage solutions such as Azure SQL Database, or Azure Synapse Analytics

  • Collaborate with cross-functional teams to understand data requirements and design scalable and efficient ETL processes using Azure services

  • Identify, design and implement ETL solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis

  • Analyze business and technical requirements, as well as data warehouse data models, to understand the detailed data management requirements

  • Administer, maintain, develop and recommend policies and procedures for ensuring the performance, availability, security and integrity of the company's databases and systems

  • Architect solutions to help implement the physical data model for the development and/or production environments

  • Perform regular deployments, scheduled maintenance and housekeeping

  • Work with business and analysts and solution architects to identify, design and implement custom user interface programs for data management and extraction purposes

  • Manage job and activity schedules to promote optimal performance, maximum availability and minimize data latency and data load durations

  • Implement data quality checks, data validation, and data cleansing techniques to ensure accuracy and reliability of the data

  • Collaborate with data analysts to understand their data needs and provide them with clean, reliable, and well-structured data sets for analysis and modeling

  • Ability to Extract, Transform, Load, Manage and Troubleshoot daily transaction files from various processors

  • Ability to identify and validate data needs and/or information from external clients and internal staff

  • Ability to extract and prepare data for analysis across multiple platforms

  • Perform data quality analysis to ensure data integrity and accuracy of production data

  • Ability to proactively identify areas for improvement in data performance, quality, and processing

What we require from you:

  • Bachelor's degree in Computer Science or related field plus 0-2+ years of relevant work experience; or a Master's degree plus 2+ years of relevant work experience

  • In lieu of a degree, qualified candidates would require 4+ years of relevant professional experience

  • Proven experience being accountable for the data /analytics architecture solutions for a given business area -how all the components, subsystems, platforms, and integrations fit together to meet the business needs and how the solution fits in with the greater enterprise context

  • Strong experience in data extract transform load (ETL) processes using Azure services, such as Azure Data Factory, Azure Databricks, Azure Data Lake Storage, Azure SQL Database, or Azure Synapse Analytics

  • Proficiency in SQL and scripting languages such as Python or PowerShell for data manipulation and transformation

  • Technologies include Azure SQL, Cosmos DB, Azure Synapse, Power BI

  • Familiarity with data modeling concepts and best practices

  • Solid understanding of data integration patterns and techniques

  • Experience with data quality management and data governance principles

  • Strong problem-solving skills and ability to work in a fast-paced, collaborative environment

  • Excellent communication skills to effectively convey technical concepts to both technical and non-technical stakeholders

  • Experience with legacy ETL tools such as Pentaho, Informatica.

Specializing in professional and technical recruiting, KORE1 is committed to supporting top IT, Engineering, Creative, Scientific, Accounting and Finance professionals in their career paths. We build deep relationships with leading companies, connecting them to exceptional talent every day. With extensive industry expertise and unmatched opportunities, our goal is to provide a unique experience for our contractors and consultants as they prepare for their next role. We are passionate about matching the right people with the right companies.

Kore1 provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Kore1 complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Kore1 expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Kore1's employees to perform their job duties may result in discipline up to and including discharge.

Salary Range:

$ 105000.00 - $ 110000.00