Elegant Enterprise-Wide Solutions, Inc.

Lead Data Warehouse Developer

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Lead Data Warehouse Developer with a contract length of over six months, offering a pay rate of "unknown." Key skills required include SQL, PL/SQL, data modeling, and experience with Tableau and ETL processes.
🌎 - Country
United States
πŸ’± - Currency
$ USD
-
πŸ’° - Day rate
Unknown
-
πŸ—“οΈ - Date
November 20, 2025
πŸ•’ - Duration
More than 6 months
-
🏝️ - Location
Unknown
-
πŸ“„ - Contract
Unknown
-
πŸ”’ - Security
Unknown
-
πŸ“ - Location detailed
Albany, NY
-
🧠 - Skills detailed
#Oracle #EDW (Enterprise Data Warehouse) #Data Warehouse #Tableau #Datasets #Documentation #XML (eXtensible Markup Language) #Cloud #"ETL (Extract #Transform #Load)" #Stories #Visualization #SQL (Structured Query Language)
Role 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."