JacksonvilleFLRecruiter Since 2001
the smart solution for Jacksonville jobs

Data Warehouse Analyst-ETL

Location: Jacksonville
Posted on: February 25, 2021

Job Description:

Data Warehouse Analyst is needed in the Enterprise Information Management group to perform data integration (ETL - Extract-Transform-Load) activities. This resource will work on the Clearinghouse to CDW Data Integration project and the CAIS V2 to V3 and Generic Assignment Module project for CDW.



Position Summary:


This position is responsible for design, construction and implementation of ETL (Extract, Transformation and Load) processes for the Data Warehouse solution at. The ETL Developer will work closely with the Lead Data Warehouse Analyst and use their knowledge of Data Warehousing and Business Intelligence from gathering requirements through implementing solutions for retrieving, loading, combining and summarizing data from multiples systems into the Data Warehouse. This is a technical development role, heavily involved in technical design, development, unit and system testing activities relating to Data Warehouse data load utilities and processes.



Essential Functions:


Analyzes source system data to understand the data structure, definitions and anomalies.


Interacts with customers as needed to better define and understand the general reporting requirements.


Interacts with other technical team members to establish ETL requirements and designs.


Designs, develops and implements ETL processes and procedures for an Enterprise Data Warehouse solution.


Ability to program in SQL to perform the data query, extract, transformation and load functions.


Documents ETL designs in a clear and concise manner.


Participates in the testing and implementation of new or enhanced ETL processes and procedures.



Required Knowledge, Skills, and Abilities:


Knowledge of Relational, Star Schema and Dimensional database modeling techniques.


Knowledge of Demoralized and Reporting table database modeling techniques.


Strong ETL Design and Development skills.


Strong SQL query, SQL DML (Data Manipulation Language) and relational database design skills.


Ability to clearly and concisely document all ETL and SQL processes and Job and Scheduling information.


Ability to read, interpret and develop Data Flow Diagrams.



Required Education:


Minimum two years experience in large data warehouse projects from design through production support strongly desired.


Minimum five years of SQL Development and two years of which are in Data Warehouse ETL development experience.


Minimum two years experience with SQL Server 2000 or 2005 RDBMS, required.


Minimum two years experience with SQL Server DTS or SSIS ETL tools, required.


Property & Casualty insurance experience is strongly desired.


Computer literacy in Microsoft Word, Excel and Outlook, required.




We are an equal employment opportunity employer and will consider all qualified candidates without regard to disability or protected veteran status.

Keywords: , Jacksonville , Data Warehouse Analyst-ETL, IT / Software / Systems , Jacksonville, Florida

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Full Stack Software Developer
Description: As a Full Stack Software Developer, you'll join a close-knit team of engineers, product managers, and client services developers to build the future of a platform destined to power immersive digital (more...)
Company: Experis
Location: Jacksonville
Posted on: 02/28/2021

Sr. Outsystems Developer
Description: Ref ID: 01120-0011703257Classification: Software DeveloperCompensation: DOEAre you a talented detail oriented with a demonstrated ability to communicate effectively You could work with Robert Half on (more...)
Company: Robert Half
Location: Jacksonville
Posted on: 02/28/2021

25L Cable Systems Installer/Maintainer
Description: Being able to communicate across the battlefield and around the world is crucial to mission success. As a Cable Systems Installer/Maintainer, you will install the lines and equipment that allow units (more...)
Company: Army National Guard
Location: Jacksonville
Posted on: 02/28/2021


Web Developer
Description: Ref ID: 01120-0011691413Classification: Web DeveloperCompensation: 30.00 to 40.00 hourlyIf you're looking to further your career as a Web Developer, Robert Half Technology currently has an opportunity (more...)
Company: Robert Half
Location: Jacksonville
Posted on: 02/28/2021

Software Developer (.NET)
Description: Software Developer - .Net Core Jacksonville, FL 100 Remote Full time br SUMMARYOne of our top logistic firms is looking for a Software Developer specializing in DOT NET .NET Core to help design, (more...)
Company: Brooksource
Location: Jacksonville
Posted on: 02/28/2021

25B Information Technology Specialist
Description: If you've ever considered a job in IT, become an Information Technology Specialist in the Army National Guard and expand your skills and experience with complex technologies. In this role, you will be (more...)
Company: Army National Guard
Location: Jacksonville
Posted on: 02/28/2021

Java Full Stack Developer
Description: Responsibilities: Write code for the most complex system designs and provides consultative guidance on projects with extensive size, scope, and risk. Write programs that span platforms. Code
Company: SGS Technologie
Location: Jacksonville
Posted on: 02/28/2021

Power BI Developer
Description: RESPONSIBILITIES:Kforce has a client in search of a Power BI Developer in Jacksonville, FL. Key Tasks: Developing visual reports, dashboards and KPI scorecards using Power BI desktop Connecting to (more...)
Company: Kforce Technology
Location: Jacksonville
Posted on: 02/28/2021

Sr. Technical Solution Architect - Java/J2EE
Description: Challenging convention. Trying new things. Reshaping an industry. The team at Duck Creek helps insurance companies bring amazing ideas to life quickly and easily with software that thinks and works like (more...)
Company: Duck Creek Technologies
Location: Jacksonville
Posted on: 02/28/2021

Business Technology Specialist
Description: Job DescriptionThe Business Technology--Specialist is responsible for providing application and hardware installation, support and training for independent and company-owned stores point-of-sale systems. (more...)
Company: Advance Auto Parts
Location: Jacksonville
Posted on: 02/28/2021

Log In or Create An Account

Get the latest Florida jobs by following @recnetFL on Twitter!

Jacksonville RSS job feeds