Description

Design and maintain business intelligence solutions, data models, and automated reporting systems to support organizational analytics.

Responsibilities

• Translate business requirements into technical specifications for extracting, transforming, and integrating data from disparate sources.
• Design, build, and deploy Power BI dashboards, SSRS reports, and data extracts.
• Create and manage ETL processes and stored procedures to automate data integration.
• Develop comprehensive data views, functions, and triggers to support analytics and reporting.
• Document solutions, maintain data dictionaries, and ensure high system availability through testing.

Required Skills

• 3+ years of experience with MS SQL Server (2012+), T-SQL, SSIS, and SSRS.
• Proficiency in Microsoft Power BI and SAP Business Objects or Oracle BI.
• Strong knowledge of data warehouse design, dimensional modeling, and OLAP.
• Experience with dynamic SQL, triggers, functions, stored procedures, and constraints.
• Understanding of query optimization and enterprise database concepts.
• Bachelor’s degree in computer science, information management, or equivalent experience.
• 3+ years of banking industry experience with knowledge of lending/deposit products.

Preferred Skills

• Familiarity with data mining techniques.
• Ability to collaborate with business analysts to define reporting requirements.

Key Skills

Education

Bachelor's degree