305-651-6500

Jobs    Everything

Select a Metro Area
Apply for Job - Data Warehouse Specialist II #3423
First Name*
Last Name*
Email Address*
Phone Number*
Resume URL
Upload Resume

Or email your resume to [email protected]

Apply for this Job below or Call Us at 1-888-743-7782

Data Warehouse Specialist II

Coral Gables, Florida
Job ID: 3423

Job Title: Data Warehouse Specialist II
Location: Coral Gables, FL
3 Month Contract to Hire
Compensation
: $40-45 per hour

SherlockTalent is seeking a Mid-Level Data Warehouse Specialist that can gather, analyze and understand business requirements. Ideal candidate must be efficient with ETL processes and Informatica environments. Must also follow best practices, guidelines / procedures and naming conventions with enterprise-wide data collection and extraction. Serve as a technical lead with multiple data warehouse efforts with no supervision required. 

Responsibilities

  • Act as a mentor to others including junior-level ETL resources; be independent and proficient in determining approaches to solutions, troubleshooting and maintaining ETL processes
  • Be responsible for translating business needs into technical solutions and designing relational and/or dimensional models or flat files to meet project requirements. Perform source system data profiling including structure, data and relationship discovery
  • Develop, manage and update conceptual, logical, and physical data models; evolve existing models to meet new and changing business requirements
  • Design, develop, maintain, test and modify ETL (Extraction, Transformation, and Loading) processes with efficiency, best practices, naming conventions and ease of maintenance in mind
  • Document ETL technical design process, high level, and detailed metadata and reconciliation process
  • Provide production support for all existing DW applications; respond to job failure related text page and/or emails in a timely manner for critical DW applications
  • Scope, plan, prioritize and manage multiple tasks and projects; improve efficiency by working on other assigned tasks/projects while waiting for information on certain project(s)
  • Follow project methodology of DW full development life cycles, prepare estimate and duration for development tasks and activities; provide bi-weekly project status to management on time; adhere to ETL development/migration standards by following ETL code review process on SharePoint and change control policies and procedures by submitting required documents in System Center for Service Manager (SCSM)
  • Plan and support lifecycle of DW infrastructure components including database, operating system, ETL tool, and other vendor products with guidance from team leads and supervisor; participate in migrations and upgrades; monitor performance of ETL processes and implement tuning as needed with guidance from team leads

Qualifications

  • Bachelors Degree in Computer Science or related discipline, or equivalent experience required
  • 10 years of experience in IT with relational database management systems (RDBMSs)
  • 8+ years of experience with Informatica or comparable tool 
  • 8+ years of dedicated end-to-end data warehouse implementation experience
  • Solid experience using SQL, ER Studio, and Unix shell scripting
  • 4+ years of experience with data warehouse or ETL architecture design required
  • Healthcare experience is a major plus

SherlockTalent loves to share a $500 referral bonus!

"U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time."