Position Type :
Full time
Type Of Hire :
Experienced (relevant combo of work and education)
Education Desired :
Bachelor of Computer Science
Travel Percentage :
1 – 5%
Job Description
The world of finance moves fast. At FIS, we’re faster. Our teams are empowered to learn, grow, and make an impact–in their careers and communities. We deliver innovation that advances the way the world pays, banks and invests. If you want to grow personally and professionally, we’d like to know: Are you FIS?
NOTE: If candidates are located in Milwaukee, WI or Jacksonville, FL locations then expectations are to be hybrid (3 days in office).
About the team:
The ETO (Enterprise Technology Office) Reporting team is a small dedicated group of professionals who work to provide accurate and timely data analysis and reporting across the Enterprise Technology Office. Our team specializes in extracting insights from large and complex datasets to support strategic decision-making in regards to the Client Portal and Infinity IdP products. We use advanced data visualization tools to present information in a clear and concise manner. Our goal is to empower our colleagues and stakeholders with the information they need to make informed decisions. We are committed to delivering high-quality results and continuously improving our processes.
What you will be doing:
• As a Database Analyst, your daily responsibilities will include maintaining, supporting, and documenting the integration between our Oracle and Postgres operational databases and Snowflake.
• You will be responsible for maintaining the health and stability of our Snowflake database warehouse and generating reports using BI tools such as ThoughtSpot, WebFocus, and other tools.
• Additionally, you will be tasked with fulfilling data requests by running SQL queries against existing databases or creating new SQL queries for partner teams.
• Participates in quality assurance and develops test application code in client server environment.
• Provides expertise in devising, negotiating and defending the tables and fields provided in the database.
• Adapts business requirements, developed by business systems analysts/modeling/development staff and develops data, database specifications and table and element attributes for an application.
• Models databases and develops tables, stored procedures, views, triggers and other database objects.
• Maintains database dictionaries, monitors overall database standards and procedure, and integrates systems through database design.
• Works closely with other developers to integrate databases with other applications.
What you will need:
• The ideal candidate will have strong SQL knowledge and capable of writing new scripts across a complex dataset.
• The candidate will also be able to consult on database best practices, performance tuning, and triage incidents with developers and colleagues.
• The role expands beyond just SQL; the candidate must be able to learn new technologies, knowledge share, and be able to integrate with companion technologies such as AWS S3, Azure, BI tools, Python scripting, and cross platform data movement.
• Knowledge of end-to-end systems development life cycle
• Proficiency to create and support database technical environments
• Ability to estimate work effort for project sub-plans or small projects and ensure the project is successfully completed
Added Bonus if you have:
• Experience with writing Python/KSH scripts
• Experience with using Linux command line tools
• Experience with using BI tools
• Knowledge of Oracle Golden Gate
• Knowledge of FIS Products and Services
• Knowledge of Fintech industry.
What we offer you:
At FIS, we hire the best. In return, you receive exceptional benefits including:
• Opportunities to innovate in fintech
• Tools for personal and professional growth
• Inclusive and diverse work environment
• Resources to invest in your community
• Competitive salary and benefits
NOTE: If candidates are located in Milwaukee, WI or Jacksonville, FL locations then expectations are to be hybrid (3 days in office).
FIS is committed to providing its employees with an exciting career opportunity and competitive compensation. The pay range for this full-time position is $77,100.00 – $125,680.00 and reflects the minimum and maximum target for new hire salaries for this position based on the posted role, level, and location. Within the range, actual individual starting pay is determined additional factors, including job-related skills, experience, and relevant education or training. Any changes in work location will also impact actual individual starting pay. Please consult with your recruiter about the specific salary range for your preferred location during the hiring process.
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 Online Privacy Notice.
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
Tagged as: Database analyst