This site uses cookies. To find out more, see our Cookies Policy

Lead ETL/Business Intelligence Developer in New York, NY at ConsultNet

Date Posted: 11/18/2018

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    New York, NY
  • Job Type:
  • Experience:
    At least 5 year(s)
  • Date Posted:
    11/18/2018
  • Job ID:
    18-01227

Job Description

TITLE:  Lead ETL/Business Intelligence Developer
LOCATION:  New York, NY (Midtown)
SALARY: DOE ( Depends on Experience)
DIRECT HIRE w/CLIENT

JOB DESCRIPTION:
  purpose of position Leads the design, development, enhancement and support of data acquisition from various source systems into a centralized repository used for reporting by the Business Intelligence team and Data Analysts.Works under general supervision.   responsibilities Leads Data Warehouse design including new subject area development and integration with existing data model.  Develops ETL routines based on established guidelines and best practices. Creates/modifies data extraction routines into a standardized approach that can be repeatable and reusable. Develops proper standards which will allow for a framework that can be used by all ETL Developers when acquiring data. Works closely with key stakeholders, business representatives and technical resources to get a good understanding of the source to ensure a full understanding of business processes and rules that need to be applied to the data. Establishes controls to monitor and confirm job completion with procedures in place in case of failure. Addresses performance issues with appropriate technical solutions. Implements a robust enterprise wide repository designed to ensure analysts will be able to access the data for final presentation to end users. Works with Bi staff to ensure modeling requirements meet  reporting needs. Participates in requirements gathering ensuring technical solutions meet stated business objectives. Provides technical leadership and mentoring to other members of the team to assist in their technical growth. Maintains knowledge of software tools, languages, scripts, and cloud solutions that effectively support the data warehouse environment in different operating systems. Performs unit and system testing of ETL jobs; ensures standard Quality Assurance practices are followed. Promotes the fully tested and qualified code into production environment. Participates in special projects and performs other related duties as required.       QUALIFICATIONS Education: Bachelor's degree in Computer Science, Information Systems, a related field or equivalent work experience required. 
 
Experience: Minimum of five years of experience in Data Integration projects working on ETL framework for Data Warehouse projects and writing ETLs using SQL scripts and/or ETL tools (Informatica,Glue, Matillion) required. Working knowledge of databases such as Oracle, SQL Server, Postgres or Redshift required. Experience with query performance tuning techniques required. Hands on experience in performance tuning of SQL scripts required. Experience with Scheduling tools such as Autosys, Control-M or Tivoli etc. required. Working knowledge of data modeling (BI Snowflake/3NF, Star, Slowly Changing Dimensions) and experience with data modeling tools such as Erwin or ER/Studio required. Demonstrated understanding of how best to store the data for reporting (BI Snowflake/3NF, Star, Dimensional models), making certain that a best approach solution is used to achieve optimized performance required. Understanding various data stores (database, files, XML, etc.) and how best to extract data required. Understating various aspects of logical, conceptual and physical modeling of data warehouse projects required.  Ability to work independently, take initiative and contribute to new ideas required. Enterprise BI Experience preferred. Healthcare experience preferred. Exposure to Microstrategy preferred. AWS Ecosystem experience preferred. Big Data experience (Cloudera, Horton, HIVE, Impala) preferred.  






Be a part of the ConsultNet difference. As a leading national provider of IT staffing and solutions, ConsultNet delivers exceptional services to startup, midmarket and Fortune 1000 companies across North America. Since 1996, we've partnered with clients to create rewarding opportunities for our consultants, successfully building teams that have surefire results.
In the past two years alone, we have placed more than 1,500 consultants in contract, contract-to-hire, or direct placement opportunities. We understand communication is key to finding the right job that matches your skills and career goals. For us, it's not just the work that we do; it's how we do the work. Our breadth of offerings extends to multiple IT positions in major markets throughout the country, see more at www.consultnet.com.