This job has expired, please see additional jobs below
Data Solutions Manager
Union Bank
San Diego, CA, United States
Job Details - this job has expired, please see similar jobs below
Responsible for data modeling and design, ETL development and processing, performance tuning, and administration for a Business Intelligence environment. Developer will be responsible for end to end design, coding, testing, review and implementation data interfaces into and existing data warehouse. Additional responsibilities include troubleshooting, maintenance, and optimization or enhancement of existing processes.
This is a senior level database developer and will be required to lead project teams and estimate scope and cost. A substantial amount of business unit interaction will also be required when leading these projects.
Major Responsibilities
• Prepares functional requirements, feasibility studies, program specifications, user test plans, user documentation, and user training plans.
• Assists in the installation and overall testing of bank developed or vendor supplied packages.
• Identifies areas in bank operations which may be improved or which may offer new opportunities to improve the business.
• Provides formal and informal user training and general user support.
• Examines and improves business models and data flow processes.
• Designs application and technical solutions to enhance end-user efficiencies and increase productivity in their job functions.
• Acts as a consultant to user management in planning and implementing system and operational changes, and assists in the preparation of business plans.
• Considered highly versatile, and as such, may be called upon to fulfill a variety of functions, which may be deemed necessary by management.
• Performs testing and problem resolution on a 24 hour basis.
• Regularly provides guidance and training to less experienced staff.
• Regularly works under deadlines and may be subject to extreme workloads.
• Possesses a high level of analytical skills as recognized by industry standards, as well as extensive bank operations knowledge.
Required Skills/Responsibilities:
ANALYSIS
• Leads the preparation of business plans, prepares functional requirements and conducts feasibility and cost benefit studies.
• Conducts user interviews, contacts vendors, and performs independent research as required.
• Resolves system, and technical problems, and makes recommendations to improve application functions.
• Prepares formal proposals for management outlining alternative and recommended system solutions.
• Defines project scope and objectives.
• Demonstrates an expert level of understanding of the systems development life cycle process.
• Validates and ensures that functional requirements are met.
• Conducts formal implementation reviews.
• Anticipates and circumvents problems where possible.
COORDINATION
• Prepares project plans, compiles estimates, and reports status.
• Coordinates the work being performed by various system and user areas to ensure that project plans and functional requirements are met.
• Exhibits an expert knowledge of the techniques of problem solving, resolving conflicting priorities, and reporting issues requiring resolution to management.
TESTING
• Prepares test plans, documents test cases, reviews results of tests, and identifies further testing required.
• Exhibits an expert knowledge of testing techniques and the scope needed in a test plan.
IMPLEMENTATION
• Assists in technical implementation.
Qualifications
• SQL Server 2008 / SQL Server 2005
• Stored Procedures / T-SQL / P-SQL
• ETL / Bulk Load / Data Transformation
• SSIS / SQL Server Integration Services / Integration Services
• VLDB / Very Large Database
• SQL CLR
• Data Modeling and Design
• Database Administration
• Performance Optimization / Performance Tuning / Sql Profiler
• Indexes / Keys / Foreign Keys / Unique Keys / Clustered Keys
• Relational Database
• Data Warehousing / Date Warehouse Design
• 3rd Normal Form / Third Normal Form / 3NF
• Star Schema / Snowflake Schema
• Type II Dimension / Type 2 Dimension / SCD / Slowly Changing Dimensions
• OLTP / OLAP / Cubes
• Oracle 9i / Oracle 10g / Oracle
• SSMS / SQL Server Management Studio
The above statements are intended to describe the general nature and level of the work being performed. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.
We are proud to be an Equal Opportunity / Affirmative Action Employer and committed to leveraging the diverse backgrounds, perspectives, and experience of our workforce to create opportunities for our colleagues and our business. We do not discriminate in employment decisions on the basis of any protected category.
A conviction is not an absolute bar to employment. Factors such as the age of the offense, evidence of rehabilitation, seriousness of violation, and job relatedness are considered in all employment decisions. Additionally, it’s the bank’s policy to only inquire into a candidate’s criminal history after an offer has been made. Federal law prohibits banks from employing individuals who have been convicted of, or received a pretrial diversion for, certain offenses.