Software Engineer – Reporting tool SQL
| Company | Mitsubishi UFG |
|---|---|
| Location | Tampa, FL, USA, Tempe, AZ, USA, New York, NY, USA |
| Salary | $120000 – $150000 |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Senior, Expert or higher |
Requirements
- 7+ years technology industry experience in Banking & Financial Services sector
- 5+ years’ experience in Regulatory Reporting function using Axiom SL or similar tool
- 5+ years of experience in data management, data analytics
- Bachelor’s degree in computer science or related technology
- Must have experience in Data analysis, including creating complex SQL queries
- Must have experience in Reg Reporting concepts and cross reporting analysis
- Must have experience in Data warehousing and/or Data Lakes, and Data Marts
- Working knowledge of 3NF data models, dimensional data models, etc.
- Experience with data models associated with financial data domains
- Experience with GL and other reconciliations
- Must have experience in Reg Reporting tools like Axiom SL, Suede, Vermeg or any BI tools
- Must have experience in Jira, Confluence, MS office
- Must have familiarity with Data Integration/ETL tools
- Proficiency in SQL, Handling Files using Python, Hive Query Language
- Must have Cloud technologies such as AWS, Azure, etc.
- Must have experience with relational Databases such as Oracle, MS SQL Server etc.
- Must have experience in one or more domains including Risk Reporting, Regulatory Reporting, GL and Customer & Product Profitability
- Expertise in business requirements analysis, design, functional & detail design
- Strong understanding of regulatory requirements (e.g. BCBS 239, GDPR, etc.)
- Understanding of data pipelines associated with Risk & Regulatory Reporting
- Experience preparing user stories, data flows, and product technical specifications
Responsibilities
- Develop and maintain a deeper understanding of data & reporting needs for US Regulatory Reports (FFIEC call reports, FR Y 2052a, etc.) and General Ledger
- Develop and maintain strong, trust-based relationships with key stakeholders to understand their business challenges and identify how Data Solutions can support their objectives
- Engage with business stakeholders to solicit and manage requests that equitably handle competing priorities across business teams
- Determine what can realistically be completed based on resource capacity and budgets
- Evaluate multiple scenarios to identify the optimal mix of projects and work
- Manage incremental deliverables while centralizing important information so that everyone’s always on the same page
- Spotlight issues that need attention
- Proactively manage changes and issues
- Visualize dependencies across programs, projects and BAU work, and applications – understand relationships and optimize delivery
- Lead the initial discovery process for prioritized scope of work by uncovering high-level business requirements
- Develop deep understanding of upstream dependencies / origins of data products and generate meaningful data-driven insights, present findings to various partners, identify potential issues with the data, build quality checks and continually track enhancements required to maintain data consistency
Preferred Qualifications
-
No preferred qualifications provided.