Lead Data Warehouse Developer

About this Position:

Job Title: L ead 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.