ETL Developer

3 weeks ago


Nashville, United States StaffSource Full time
Job DescriptionJob Description

***2-3 Days a week HYBRID in Nashville, TN***

 

Data Solutions Developer

The Data Solutions Developer creates and maintains data acquisition, transformation, and integration solutions for operational, reporting, and analytical purposes. The Data Solutions Developer is often called upon to load data from transactional systems into the data warehouse, applying prescribed transformations and business logic. He or she is also responsible for generating source-to-target mapping documents and other metadata necessary to make data assets understandable and easily used. He or she will adhere to the data management fundamentals and best practices defined by TFIC. Duties and responsibilities include the following:

 

Duties and Responsibilities

· Develop and support efficient and reliable processes to extract, transform, clean, and move data from a variety of sources into a data warehouse or data extracts using ETL Tools (SSIS, Data Migrator, etc.) and/or stored procedures

· Support the operation of the conversion process during business hours and as part of an on-call rotation as needed.

· Work in tandem with business and IT subject matter experts to define data extracts as well as process scheduling and issue resolution

· Develop solutions which adhere to development, architecture standards, and best practices as set by the Data Architect and Data Governance committee.

· Optimize database structures and SQL code for maximum performance and reliability

· Document new applications, review and update existing documentation related to data processes and structures

· Provide back-end support and data integration development assistance to other teams and application developers

· Operationalize prototype data solutions developed by other team members or data analysts

· Perform peer review and occasional QA support for solutions developed by other associates within the Data Management group or other functional areas

· Investigate and document current data flow processes between corporate systems, business partners, and downstream data consumers

· Participate in the design and development of target-state analytics ecosystem using traditional and big data tools, as well as a mix of on-premises and cloud infrastructure

· Other duties assigned by management

 

Qualifications and Requirements

· Strong Experience using MS Sql Server and SSIS

· Experience developing high-performing data flows, adhering to established best-practices

· Experience in SQL development - creating complex queries, views, and stored procedures

· Experience with Azure Data Factor and Azure SQL DB

· Experience interfacing with business stakeholders to understand data and analytics needs and deliver solutions

· Understanding of relational and dimensional data structures

· Experience in Agile Scrum and / or Kanban project management frameworks is preferred

· Knowledge of applicable data privacy practices and laws is preferred



  • Nashville, United States eTeam Full time

    Should have 10+ Years of experience into IT and Strong experience with C# with SSIS + ETL Integration tasks. Required Skills: Extensive experience on full stack development using C# & SSIS technologies Should have experience with SSIS ETL Integration tasks as mandatory. Must have hands on experience on SQL Server & Postgres databases Should be able to...


  • Nashville, United States Atechstar Full time

    Job DescriptionResponsibilities Setup transfers of data feeds from source systems into location accessible to Foundry. Debug issues related to delayed or missing data feeds. Write transformations and derive new datasets using Spark for distributed computation. Monitor build progress and debug build problems. Using Foundry’s application development...


  • Nashville, Tennessee, United States Atechstar Full time

    Job DescriptionResponsibilities Setup transfers of data feeds from source systems into location accessible to Foundry. Debug issues related to delayed or missing data feeds. Write transformations and derive new datasets using Spark for distributed computation. Monitor build progress and debug build problems. Using Foundry's application development framework...


  • Nashville, United States The Cigna Group Full time

    HEDIS experience requiredStrategy SummaryOur team is an MA-focused group that provides direct and matrixed technology support for Cigna's Medicare Advantage and CareAllies business units. Our goal is to simplify how business gets technology delivered. We act as the accountable point of contact with the other shared service organizations across Cigna's...

  • Data Engineer II

    1 week ago


    Nashville, United States LP Building Solutions Full time

    Louisiana-Pacific Corporation (LP Building Solutions) is a leading provider of high-performance building solutions that meet the demands of builders, remodelers, and homeowners worldwide. We manufacture engineered wood building products that include an extensive offering of innovative and dependable building materials and accessories. LP's values-driven...


  • Nashville, United States Summit Human Capital Full time

    Summit Human Capital is seeking a highly motivated Hybrid-Remote Data Analyst in Nashville, TN to support one of our growing clients in the area. This role will be focused on understanding stakeholder needs and creating insightful data bi dashboards for them. The ideal candidate will meet the following criteria: Requirements: 3+ years of experience in...


  • Nashville, United States Amazon.com Services LLC Full time

    Have you ever ordered a product on Amazon and when that box with the smile arrived you wondered how it got to you so fast? Have you wondered where it came from and how much it cost Amazon to deliver it to you? If so, the Worldwide (WW) Amazon Logistics, Last Mile team is for you. We manage the delivery of tens of millions of products every week to Amazon’s...


  • Nashville, United States ClientSolv Full time

    Company Description ClientSolv Technologies is an IT solution firm with over a decade of experience serving Fortune 1000 companies, public sector and small to medium sized companies. ClientSolv Technologies is a woman-owned and operated company that is certified as a WMBE, 8a firm by the Federal government's Small Business Administration. Job DescriptionWe...


  • Nashville, United States ClientSolv Full time

    Company Description ClientSolv Technologies is an IT solution firm with over a decade of experience serving Fortune 1000 companies, public sector and small to medium sized companies. ClientSolv Technologies is a woman-owned and operated company that is certified as a WMBE, 8a firm by the Federal government's Small Business Administration. Job DescriptionWe...


  • Nashville, United States Programmers.io Full time

    Title- Senior Data Engineer Location- Nashville, TN (Onsite)Terms- Full-timeSCOPE OF WORKDesign, build, and maintain scalable data pipelines using Azure Data Factory (ADF) and other Azure servicesAdminister, monitor, and troubleshoot SQL Server databases, ensuring high performance and availabilityDevelop and optimize SQL queries and stored procedures to...


  • Nashville, United States Programmers.io Full time

    Title- Senior Data Engineer Location- Nashville, TN (Onsite)Terms- Full-timeSCOPE OF WORKDesign, build, and maintain scalable data pipelines using Azure Data Factory (ADF) and other Azure servicesAdminister, monitor, and troubleshoot SQL Server databases, ensuring high performance and availabilityDevelop and optimize SQL queries and stored procedures to...


  • Nashville, United States LexisNexis Risk Solutions Full time

    LexisNexis Risk Solutions Group Explore our passion for discovery Global companies and governmental entities rely on us to solve their most complex data challenges. Our employees collaborate to reduce risks and create opportunities for customers in more than 100 countries. We’re adaptable, curious and ambitious. That’s why here, you’ll have the freedom...


  • Nashville, United States Oscar Full time

    As a Senior Database Administrator (DBA III), you will undertake advanced tasks in database administration, particularly focusing on databases utilized by applications with intricate data models, workflows, and reporting systems. This role involves collaborating with cross-functional teams to create and maintain logical and physical data models within an...


  • Nashville, United States programmers.io Full time

    Title: Sr. Data EngineerLocation: Nashville, TN (onsite)Duration: Full-timeOverview:We're looking for an experienced Azure Data Engineer with 8-12 years of experience in SQL Server, Power BI, and Azure data services. The candidate should be skilled in building data pipelines, scripting, and data modeling. Strong problem-solving, communication, and...


  • Nashville, United States Programmers.io Full time

    Title: Sr. Data EngineerLocation: Nashville, TN (onsite)Duration: Full-timeOverview:We're looking for an experienced Azure Data Engineer with 8-12 years of experience in SQL Server, Power BI, and Azure data services. The candidate should be skilled in building data pipelines, scripting, and data modeling. Strong problem-solving, communication, and...

  • Senior Data Engineer

    23 hours ago


    Nashville, United States Programmers.io Full time

    We have an opportunity for Senior Data Engineer with one of our clients for Nashville, TN If interested, please send me a copy of your resume, your contact details, your availability, and a good time to connect with you. Title- Senior Data Engineer Location- Nashville, TN Terms- Full-time SCOPE OF WORKDesign, build, and maintain scalable data pipelines...


  • Nashville, United States Programmers.io Full time

    Title: Sr. Data EngineerLocation: Nashville, TN (onsite)Duration: Full-timeOverview:We're looking for an experienced Azure Data Engineer with 8-12 years of experience in SQL Server, Power BI, and Azure data services. The candidate should be skilled in building data pipelines, scripting, and data modeling. Strong problem-solving, communication, and...

  • Senior Data Engineer

    19 hours ago


    Nashville, United States Programmers.io Full time

    We have an opportunity for Senior Data Engineer with one of our clients for Nashville, TN If interested, please send me a copy of your resume, your contact details, your availability, and a good time to connect with you. Title- Senior Data Engineer Location- Nashville, TN Terms- Full-time SCOPE OF WORKDesign, build, and maintain scalable data pipelines...


  • Nashville, United States Programmers.io Full time

    Title: Sr. Data EngineerLocation: Nashville, TN (onsite)Duration: Full-timeOverview:We're looking for an experienced Azure Data Engineer with 8-12 years of experience in SQL Server, Power BI, and Azure data services. The candidate should be skilled in building data pipelines, scripting, and data modeling. Strong problem-solving, communication, and...


  • Nashville, United States Oscar Full time

    As a Senior Database Administrator (DBA III), you will undertake advanced tasks in database administration, particularly focusing on databases utilized by applications with intricate data models, workflows, and reporting systems. This role involves collaborating with cross-functional teams to create and maintain logical and physical data models within an...