Data Analyst / BI Developer
Position Location: Pittsburgh, PA, 15222 or Strongsville, OH, 44136
Required 5 days onsite
Pay Rate: $70 to 80/hr. on W2 ONLY
Intended length of Assignment: 12 Months Contract to Hire role
Function of the Group/Initiatives/Projects: Liquidity Risk Management (LRM)/FR 2052A (Banking-Regulatory Submissions ). We are several crews that support our 2052A application for the bank.
Industry background: Financial/Banking background. Background in Banking-Regulatory Submissions (specifically FR-2052A), Liquidity Risk Management (LCR, NSFR) applications a huge plus.
Roles/Responsibilities:
Proficiency in Business Intelligence Tools: Hands-on experience with Tableau Desktop, Tableau Prep, and other BI platforms such as Client Power BI for developing advanced dashboards and analytical reports.
Data Warehouse Expertise: Strong understanding of data warehouse concepts, data modeling techniques, and end-to-end ETL processes.
Advanced SQL Proficiency: Ability to write, optimize, and troubleshoot complex SQL queries for data manipulation and analysis. Experience with very large data sets in Oracle.
Experience with Multiple Databases: Practical experience working with major relational database systems such as Oracle, Teradata, SQL Server, and others.
Prior knowledge of Banking (pref Regulatory) applications dealing with large data sets.
MUST HAVE SKILLS (8+ Years of Experience Required):
1. Tableau,
2. Tableau Prep,
3. Banking experience,
4. Strong understanding of data warehouse concepts, data modeling techniques, and end-to-end ETL processes,
5. Advanced SQL Proficiency.
FLEX SKILLS:
Liquidity/14A Regulation; Regulatory Submissions (specifically FR-2052A)
Power BI
Python Programming: Basic to intermediate Python coding skills for automation, data transformations, or advanced analytics.
Axiom
Knowledge and experience with DevOps Tools a plus
ETL (Informatica) experience
Education: Bachelor s degree or will look at equivalent experience in lieu of education (8+ years)
Interview Process:
" 1st round technical interview with manager/team ~1 hour
" 2nd round conversation with other manager/team lead ~1 hour
" Possible 3rd round with hiring manager if needed
HM Stack Ranking (Most Important to Least Important):
1. Must have skills
2. Location
3. Bill Rate
4. Former Client Exp.