Banking Data Analytics Specialist | SQL & BI Dashboards

Techwave Technologies; United States; On-site; USD 75,000 - 110,000; Full time

Job summary

Techwave Technologies Inc. is seeking a Data Analyst to support a banking analytics project. You will work with large financial datasets, build analytical reports, and provide insights to guide business decisions.

Key duties include creating SQL queries, validating data, and developing Power BI/Tableau dashboards for financial KPIs, while collaborating with analysts, data engineers, and business stakeholders to deliver timely, accurate reporting.

Qualifications

• Hands-on experience with SQL, Excel, Power BI/Tableau, Python, data analysis, financial reporting and data quality.
• Experience analyzing large banking and financial datasets and delivering actionable insights.
• Ability to develop analytical reports, dashboards and automated workflows.

Responsibilities

• Analyze large banking and financial datasets using SQL, Python, Excel, and Power BI.
• Develop complex SQL queries with CTEs, joins, subqueries, window functions, aggregations, and case statements.
• Analyze customer accounts, transactions, payments, deposits, loans, and financial activity.
• Develop interactive Power BI/Tableau dashboards for KPIs.
• Perform data cleansing, validation, reconciliation, and quality checks across multiple sources.
• Identify data discrepancies and root causes; prepare reports daily, weekly and monthly.
• Automate recurring reporting processes using SQL, Python, Excel, and BI tools.
• Collaborate with stakeholders to gather requirements and translate them into reports and dashboards.
• Create requirements, data mapping docs, and reporting specifications; support UAT and document defects.
• Document SQL logic, data sources, business rules, KPI definitions and reporting processes.

Skills

SQL

Python

Excel

Power BI/Tableau

Data analysis

Financial reporting

Data quality

Tools

Power BI

Tableau

SQL-based tools

Job description

Techwave Technologies Inc. is seeking a Data Analyst to support a banking analytics project. You will work with large financial datasets, build analytical reports, and provide insights to guide business decisions.

Key duties include creating SQL queries, validating data, and developing Power BI/Tableau dashboards for financial KPIs, while collaborating with analysts, data engineers, and business stakeholders to deliver timely, accurate reporting.