Kloudhire

IT Data Warehouse Dev Sr Location: Cleveland, OH

Posted on : 09-08-2023
Job Type : Full Time only
Salary : 100,000 - 200,000

Job Description:

Role: IT Data Warehouse Dev Sr
Location: Cleveland, OH
ESSENTIAL FUNCTIONS

Develops Data Warehouse Extract, Transformation and Load (ETL) processes using an ETL software tool (e.g. Informatica, DataStage).
Monitors and tunes data warehouse ETL processes to ensure optimal load performance.
Provides production support of the data warehouse environment.
Assists in the maintenance and upgrades of data warehouse software.
Oversees large and complex projects, including planning, monitoring, and reviewing progress and accuracy of work and evaluating results.
Provides production support and performance monitoring of critical production systems.
Coordinates with other departments and/or external vendors to resolve critical system production problems and implementation of software release to production.
Makes recommendations in product evaluations and buy \'versus\' build recommendations.
Responsible for developing application architectural design and code for new applications and/or enhancements to existing applications.
Assists in establishing and maintaining code standards and application development policy procedures.
Generates complex application code that is traceable to technical specifications.
Makes recommendations toward the development of new code or reuse of existing code.
Devises sample input data to test accuracy of the program, writes unit test scripts and debug code using reliable test data, modify steps and sequence as required; obtains end user approval to promote to production.
Performs critical work of a complex technical and business nature.
Responsible for providing accurate and timely communication of the status of assignment, job responsibilities, and the resolution of problems to the appropriate parties following established policies and procedures.
Creates estimates for large and complex assignments and tracks progress against major milestones following software development life cycle methodology and documentation standards.
Ensures appropriate documentation is created and maintained and adherence to project management methods. Keeps current on new software releases, investigates emerging technologies, and advises management for strategic and tactical planning.
May lead moderate complex project or development phase of a project; may lead technical review meetings with IT team. Coaches and mentors less experienced developers; performs code reviews.
Adheres to NYCB policies, procedures and standards. Performs special projects and additional duties and responsibilities as required.
Where applicable and when performing the responsibilities of the job, employees are accountable to maintain Sarbanes-Oxley compliance and adhere to internal control policies and procedures.

EDUCATION AND EXPERIENCE

Bachelor\'s degree in a computer science, business or finance related field or equivalent relevant experience.
Seven years or more experience in system analysis, design, coding and testing. Five years of experience in IT data warehouse.

KNOWLEDGE, SKILLS AND ABILITIES

Strong knowledge of data warehouse concepts and methodologies.
Strong knowledge of database concepts.
Strong knowledge of multiple structured coding languages and distributed systems development techniques.
Strong knowledge of system development life cycle concepts, practices and procedures.
Strong knowledge of business and system workflow documentation methods.
Strong analytical and organizational skills.
Strong verbal and written communication skills, good negotiation skills.
Strong team player. Detail oriented.
Exercises sound judgment.
Ability to work well with others, as well as independently.
Ability to manage multiple tasks simultaneously and meet established deadlines.
Ability to lead system designs, development projects or problem solving efforts.
Ability to maintain confidentiality with regard to customer information and employee records.