Role: Junior Data Analyst
Client Location: Rosemont, IL - (Remote)
Employment Type: Full-time
Contract Duration: 18 Months Contract
Tentative Start Date: July 2026
Interview Mode: Virtual + Final Client Round
Working Hours: CST Business Hours
Key Responsibilities
- SQL reporting: Write and optimize queries on financial datasets (deposits, loans, balances, liquidity).
- Dashboard development: Build and maintain Power BI dashboards for treasury and finance teams.
- Data reconciliation: Ensure consistency between systems, data marts, and dashboards.
- Reporting cycles: Participate in monthly and quarterly reporting activities.
- Data validation: Check incoming data from Oracle Financials, FIS, and treasury sources.
- Documentation: Maintain clear records of SQL logic, validation rules, and reporting procedures.
- Ad hoc analysis: Support leadership with quick analysis during audits or quarter-end.
- Collaboration: Work with managers, analysts, and data engineers to resolve issues and define metrics.
Required Skills
- 1–3 years in financial or data analytics.
- Strong SQL skills (joins, aggregations, subqueries, CTEs).
- Experience with Power BI or Tableau.
- Solid Excel skills (pivot tables, lookups, reconciliations).
- Background in banking or finance operations.
- Bachelor’s degree in finance, Accounting, Economics, or Analytics.
- Familiarity with banking compliance.
Technical Environment
- Database: SQL Server, Oracle
- Visualization : Power BI, Tableau
- Financial Systems : Oracle Financials, FIS
- Reporting : SSRS, Excel Reporting Models
- Cloud Exposure : Azure Data Environment
- Ticketing/Workflow : Jira, ServiceNow
- Collaboration : Microsoft Teams, SharePoint
