Business Systems Analyst
Core
Conducts business process analysis, needs assessments, and cost/benefits analysis to align IT solutions with business initiatives; develops, optimizes, and maintains complex SQL queries, stored procedures, and data extraction processes.
Role type
Business Systems Analyst (SQL Data Analyst)
Builds
Operating software programming applications, data extraction processes, reports, and dashboards
Domain
Banking/Financial Services + Data Engineering/Analytics
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Business process analysis, SQL (complex joins, CTEs, window functions, subqueries, aggregations), data validation, root cause analysis, data profiling, data migration/integration, documentation of business rules
Preferred skills
Banking/financial services industry experience, application support/troubleshooting, business intelligence tools, relational databases (SQL Server, Oracle, PostgreSQL, MySQL, Snowflake), data visualization (Power BI, Tableau, Looker), Excel
Technologies
SQL, SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, Power BI, Tableau, Looker, Excel
Responsibilities
Formulate/define specifications for operating software applications; analyze and evaluate existing or proposed systems; prepare charts, diagrams, and coding logic flowcharts; encode, test, debug, and install operating programs; develop, optimize, and maintain complex SQL queries and data extraction processes; analyze and compare large datasets to identify discrepancies and trends; perform data reconciliation and root cause analysis; create reports and dashboards to support business decisions; collaborate with stakeholders to translate data requirements into analytical solutions.
Seniority
Mid-Senior level (7 years exp or Bachelor's + 3 years exp)
