Data Warehouse Architect

For more details, please connect with Afra Aleem at 609-371-5400 Ext 112 or email her at afraa@vgroupinc.com • • Local to NY or nearby candidates required (5 days Onsite role) • • Job Title: Lead Data Warehouse Developer Duration: 60 Months Start Date: ASAP Location: Albany, New York (onsite) Position Type: Contract Interview Type: In person/WebCam Ceipal ID: SNY_DWH001_AF Required Skills: • 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. Description: The Lead Data Warehouse Developer will work with OSC staff to (a) maintain existing processes and systems as well as assist with implementing new data sources as requested by OSC, and (b) transform, combine, and load data into OSC infrastructure. The Lead Data Warehouse Developer will support the Initiative. Responsibilities: • 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 OSC 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; and • creating or assisting with the creation of dashboards and visualizations in Tableau or similar data visualization products. V Group Inc. is a New Jersey-based IT Services and Products company, strategically organized into multiple business units: Public Sector, Enterprise Solutions, Ecommerce, and Digital. Within our Public Sector unit, we specialize in delivering IT Professional Services to Federal, State, and Local governments. We hold multiple contracts across 30+ states across US, which include NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, MN, NM, VT, and WA. If you're considering a career opportunity with V Group or exploring a partnership, I welcome you to reach out to me with any questions about our services and the unique advantages we offer to consultants. And please feel free to share my contact information with others who may benefit from connecting with us. Website: https://www.vgroupinc.com/publicsector LinkedIn: https://www.linkedin.com/company/v-group/ Facebook: https://www.facebook.com/VGroupIT Twitter: https://www.twitter.com/vgroupinc