Lead Data Warehouse Developer Job at Elegant Enterprise-Wide Solutions, Inc., Albany, NY

YnhpVGZ1ZkxlQTJuenUxdFdqcm94aWh3NVE9PQ==
  • Elegant Enterprise-Wide Solutions, Inc.
  • Albany, NY

Job Description

About this Position:

Job Title: Lead Data Warehouse Developer

Duties include:

  • Acquiring data from various sources including cloud services and utilizing Secure FTP and other transfer protocols.
  • Maintaining and developing PL/SQL for several data analytics initiatives currently in production.
  • Serving as a database architect to review current data analytics infrastructure and making recommendations on how to structure going forward.
  • Providing technical support for interfacing between the backend data and the front end tools such as Tableau.
  • Leveraging existing in-house technology to support ETL such as Attunity Compose.
  • Reviewing current architecture and systems with the goal of integrating the data analytics environment with enterprise standards and best practices.
  • Parsing XML files into meaningful datasets that can be consumed by analysts.
  • Creating documentation for current environment and any changes going forward.
  • Offering guidance when reviewing user stories as to the best mechanism/platform to use that will meet user needs.
  • Creating or assisting with the creation of dashboards and visualizations in Tableau or similar data visualization products.

Minimum Qualifications:

  • Availability to begin work on the Anticipated Commencement of Work Date stated and for a minimum of six months.
  • At least five years’ experience troubleshooting complex technical problems involving networking, database, application, and associated servers.
  • At least three years’ experience modeling data for reporting and analytics.
  • At least five years’ experience in tuning SQL for performance.
  • At least three years’ experience providing technical guidance to a team of software developers to implement solutions to multiple concurrent complex technical problems.
  • At least three years’ experience providing technical guidance to a team of software developers regarding all aspects of performance tuning an enterprise data warehouse reporting and analytics system.
  • At least five years’ experience performing Oracle database development using SQL and PL/SQL.

Note: For H-1B and OPT cases, we are seeking candidates from recognised organizations.

"No phone calls please."

Job Tags

H1b,

Similar Jobs

Career Group

Personal Assistant Job at Career Group

Our client, a family office in New York, is seeking an organized and proactive Personal Assistant to provide support to two presidents. The ideal candidate is detail-oriented, resourceful, and professionalism. This is a wonderful opportunity to grow within a firm and gain...

SR Staffing

Attorney Job at SR Staffing

 ...Pre-Litigation Personal Injury Attorney Needed! Are you looking to make a meaningful impact in personal injury law ? A well-established...  ...insurance ~401(k) with employer match ~ Profit-sharing plan ~ Life insurance ~ Tiered PTO structure ~ Flexible hybrid... 

Decision Critical

Registered Nurse Dementia Specialist Job at Decision Critical

 ...Company Description Decision Critical is a nurse-owned and operated concierge agency founded in 2014, specializing in private duty nursing...  ...also involve conducting patient assessments, monitoring ongoing health needs, and ensuring that care meets evidence-based dementia care... 

Fortify Experts

Security Operations Manager Job at Fortify Experts

 ...As a Security Operations Center Manager, you will collaborate with public and private partners to create cutting-edge cybersecurity guidance and reports. This role offers a unique opportunity to network with top security specialists from various organizations within a... 

Connect Search, LLC

Medical Coder Job at Connect Search, LLC

 ...associate or bachelors degree in Health Information Management or related field preferred. Certification required: CCA, CCS, CPC, or RHIT/RHIA . Minimum of 2 years of inpatient coding experience in a hospital or acute care setting preferred. Strong knowledge of...