Description

You will design, develop, and maintain business intelligence solutions, data models, and organizational reports.

Responsibilities

• Translate business needs into technical specifications to develop automated ETL solutions for extracting, transforming, and integrating data.
• Design, build, and deploy BI solutions including dashboards, reports, and data extracts.
• Develop comprehensive views, functions, and stored procedures to support data analytics.
• Create and manage ETL processes to automate integration between disparate data sources.
• Support ad hoc business data requests by developing queries and SSRS reporting.

Required Skills

• 3 years of experience with MS SQL Server (2012 or greater).
• 3 years of banking industry experience with knowledge of lending and deposit products.
• Proficiency in T-SQL, SSIS, and SSRS.
• Experience with Microsoft Power BI and SAP Business Objects.
• Strong expertise in SQL Server development including dynamic SQL, triggers, functions, and stored procedures.
• Practical knowledge of data modeling, query optimization, and dimensional modeling.
• Understanding of ETL frameworks and online analytical processing (OLAP).
• Experience with database design including tables, views, constraints, and flow control.
• Bachelor’s degree in computer science, information management, or equivalent experience.

Preferred Skills

• Familiarity with Oracle BI.

Key Skills

Education

Bachelor's degree