Sr Business Analyst

Job Description

We are seeking a Sr. Business Analyst for Reporting and Analytics role in the Ameriprise Bank(BCS Analytics). This role will be responsible for developing Power Bi dashboards, develop complex SQL to extract metrics from multiple data sources and delivering actionable insights for strategic decision-making and act as the primary liaison between the Technology Organization, Businesses, and internal teams. Also, the candidate will be responsible for creating and maintain existing reporting structure and introduce automation where possible. Key Responsibilities Must be able to do end-to-end Design, Develop and implement sophisticated Power BI solutions which include ETL, Data models, interactive dashboards / visualizations / Reports that effectively communicate key performance indicators (KPIs) and insights. Create Excel reports and provide automation where possible. Advanced in Data aggregation techniques to consolidate and summarize data from multiple sources. Able to work on all best practices related to Power BI service, including Data Modeling, dashboard/Report Design, writing complex DAX formulas, Power Query and access controls & have a general understanding of the AWS stack. Hands-on experience in SQL/PostgreSQL/AWS datalake skills for data manipulation, ad-hoc Queries, and Star Schema design. Conduct in-depth data analysis to identify trends, patterns, and opportunities for process improvement or business growth. Optimize data models and queries for performance and efficiency, ensuring fast and accurate data retrieval. Able to collaborate with cross-functional teams. Required Qualifications Bachelor s degree in computer science, Data Analytics, or related field. Strong academic background with good analytical and problem-solving skills. 3-6 years of related experience in data management and reporting. Minimum 3 years of experience in Power BI/ Advance DAX functions and Dashboard designing. Minimum 3 years of strong experience of writing complex SQL queries. Experience developing Excel reports and automation of report distribution. Experience in documenting business and technical processes. Self-motivated, ability to work independently and in a team environment. High sense of urgency and ability to adapt to a changing environment. Strong oral and written communication skills. Preferred Qualifications Experience in Python or any other programming language will be a plus. Knowledge of SAS and VBA will be a plus. (2:00p-10:30p)