Database Analyst II

JOB DESCRIPTION Position Type : Full time Type Of Hire : Experienced (relevant combo of work and education) Education Desired : Bachelor of Computer Science Travel Percentage : 5 - 10% Job Description Are you curious, motivated, and forward-thinking? At FIS you'll have the opportunity to work on some of the most challenging and relevant issues in financial services and technology. Our talented people empower us, and we believe in being part of a team that is open, collaborative, entrepreneurial, passionate and above all fun. About the team: Risk, Information Security, and Compliance (RISC) Reporting is the reporting and analysis arm of RISC Shared Services, delivering accurate and auditable reports in support of the board, senior management, and the RISC organization. As a Shared Services function, we work on captivating initiatives from enterprise risk management framework to crisis management support. To accomplish this spectrum of reporting, we leverage business intelligence solutions such as on-demand Power BI applications powered by a tabular cube infrastructure. What you will be doing: Ensure that our reporting environment and infrastructure can stay ahead of the growing demand. Review our current SQL database to identify areas for improvement, develop plans, and execute. Accomplish data requests from building out connections to new sources to problem-solving unexpected results. Elevate current SQL databases to support the multi-function requirement of granular research to aggregated archives. Models databases and develops tables, stored procedures, views, triggers and other database objects. Management of SQL Server jobs with development of quality control to identify variances in data Advise and execute on the addition of tables, integration of outside sources, or opportunities for automation based on business requirements. Maintains database dictionaries, monitors overall database standards and procedure What you bring: Bachelor's degree from Information Systems, Computer Science, or Data Science Advance SQL database design knowledge with 2 years of practical experience Knowledge of advanced extract, transform and load operations for integrating and normalizing data from disparate sources Excellent communication and interpersonal skills Self-motivated and willingness to learn Added bonus if you have: Experience working with SSAS Tabular models and Power BI Experience with RSA Archer Integrated Risk Management platform Previous industry knowledge or certifications What we offer you: A multifaceted job with a high degree of responsibility and a broad spectrum of opportunities The chance to work on some of the most challenging, relevant issues in financial services & technology A work environment built on collaboration, flexibility, inclusion, and respect . Vaccination Requirements All employees must be fully vaccinated against COVID-19 on or before December 31, 2021. Individuals with a disability (including a medical condition) or sincerely held religious beliefs or practices that prevent them from getting the vaccine may request an exemption from the vaccine requirement. Privacy Statement 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 . EEOC Statement 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 available here supplement document available here 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. Sourcing Model 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. pridepass 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 available here: http://www1.eeoc.gov/employers/upload/eeoc self print_poster.pdf For positions located in the US, the conditions below apply. If you are made a conditional offer of employment, you will be required to undergo a drug test and background check (including criminal record check) 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. Minimum Salary: 31200.00 Maximum Salary: 31200.00 Salary Unit: Yearly