est. per hourExperian • 3h ago Just posted
Data Warehouse Analyst II
About this job
Position Type :Full time
Type Of Hire :Experienced (relevant combo of work and education)
Travel Percentage :0%
FIS Management Services, LLC seeks Data Warehouse Analyst II in Pasadena, CA to provide support for data warehousing initiatives and monitor data warehousing system to ensure reliability and accuracy of information loaded into databases. Analyze logical and physical database models ensuring models are in accordance with standards. Perform analysis and testing of relational databases and investigates any data load failures or data retrieval issues. Design, develop and implement data mining tools and analysis to shift through large amounts of data stored in a data warehouse or data mart to find relationships and patterns. Conduct analysis and designs sessions with business as well as other technology teams. Generate and prepare reports to support business objectives. Assist in identifying and prioritizing business information needs and defining business benefit of data warehousing. Provide advice and guidance on data warehousing approaches and solutions and use of data warehousing methodology. Responsible for supporting architecture and design of data warehouse, data marts and business intelligence reports and integration in support of various data initiatives. Identify data warehousing issues and assists in their resolution. Identify process improvements and provides strategic direction. Provide onsite or remote, Data Warehouse training and consulting services to various client(s) and their IT team to generate to implement and maintain data warehousing products. Provide leadership and guidance to other technical professionals
SALARY: Offered salary is between $116,085.00 and $116,085.00 per year
REQUIREMENTS: Bachelor’s degree or foreign equivalent in Computer Science, Mathematics, Computer Engineering, or related field and six (6) years of experience in the job offered or a related occupation: developing PL-SQL code, tuning System Analysis, Design, Coding, Testing, Development and Documentation; designing data structures/dimensional models in all areas of data warehouse; creating, updating, and maintaining project documentations including requirement specifications, functional design, data mapping, and report specifications; defining detailed business rules for validating and transforming data for end-user reports; analyzing source data systems to identify and document complex data mapping, business rule analysis, functional and non- functional requirements; trouble-shooting, identifying, understanding, assessing, prioritizing, documenting, and communicating requirements, risks, dependencies, and potential roadblocks in data warehousing. In the alternative, the employer will accept three (3) years of study towards a Bachelor’s degree in the above or related fields and two (2) years of work experience to satisfy the Bachelor’s degree requirement. Telecommuting and/or working from home may be permissible pursuant to company policies. 10% of travel required.
QUALIFIED APPLICANTS: Please apply directly through our website by clicking on “Apply Now.”
.View our benefits here: https://cdn.phenompeople.com/CareerConnectResources/FIGLUS/documents/2021BenefitsSnapshot-1611561721803.pdf The posted range describes the minimum to maximum range for this job description. The salary range is provided for locations which require such disclosure. The range for this same position may be lower or higher in markets outside of these locations.$96,170 - 161,570
FIS is committed to protecting the privacy and security of all personal information that we process in order to provide services to our clients. For specific information on how FIS protects personal information online, please see the .
FIS is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, marital status, genetic information, national origin, disability, veteran status, and other protected characteristics. The EEO is the Law poster is supplement document
For positions located in the US, the following conditions apply. If you are made a conditional offer of employment, you will be required to undergo a drug test. ADA Disclaimer: In developing this job description care was taken to include all competencies needed to successfully perform in this position. However, for Americans with Disabilities Act (ADA) purposes, the essential functions of the job may or may not have been described for purposes of ADA reasonable accommodation. All reasonable accommodation requests will be reviewed and evaluated on a case-by-case basis.
Recruitment at FIS works primarily on a direct sourcing model; a relatively small portion of our hiring is through recruitment agencies. FIS does not accept resumes from recruitment agencies which are not on the preferred supplier list and is not responsible for any related fees for resumes submitted to job postings, our employees, or any other part of our company.