Sr. Data Analyst
Job Description
Key Accountabilities
Fulfill Core Senior Data Analytics Developer Accountabilities
• Deliver on large data projects by leading planning, execution, and completion of projects through peer leadership, cross-functional team collaboration, and consensus building with functional and senior stakeholders and implementing logical solutions.
• Build, develop, and maintain data models, dashboards, reports, data automation systems, and performance metrics support that support key business decisions.
• Proactively evaluate data & data technology trends to guide business partners on emerging opportunities.
• Ensure data accuracy, quality, and consistent reporting by designing and creating optimal analytics code with data controls defined as defined within the policy, procedure, and standards.
• Tasks and deliverables are often time-sensitive and require a proactive approach to ensure deadlines are consistently met.
Develop And Implement Power BI Reports
• Create consistent dashboards, reporting, and analytics experiences for business users.
• Elicit and understand business requirements from stakeholders; transform into the BI context and design a data model to transform raw data into meaningful insights.
• Convert business requirements into technical specifications and implement them through reports that support decision-making.
• Perform DAX queries and functions in Power BI.
ETL, Data Extracts & Ad-Hoc Reporting
• Partner with business users to derive requirements, identify data sources, wrangle data and/or transform data via SQL and/or SAS to produce file extracts for use within PowerBI Dashboards or distribution to other systems.
• Partner closely with data engineering and data movement teams on ETL processes and to develop and enhance databases/schemas/tables and implement data solutions to move data from and to other internal and external systems and vendors.
• Drive efforts on ad-hoc, time-sensitive exploratory data analysis and/or qualitative analysis to provide insights on trends, client behaviors, system troubleshooting or non-recurring reporting needs.
• Creating customized diagrams and user-defined calculations as needed.
• Design, develop and deploy business intelligence solutions with SQL queries for best results, filters, and graphs to better understand your data at all levels for performance improvements and suggestions.
Qualifications And Education Requirements
• Bachelor’s degree in related field; advanced coursework/training related to computer science, management information systems, and mathematics/statistics, Master’s degree preferred.
• Exceptional analytic ability and problem-solving skills.
• 6-10 years’ experience in banking and finance with a thorough knowledge of the retail bank business line.
• Demonstrated ability in data retrieval from multiple databases and systems.
• 5+ years’ experience in developing analytics reports and dashboards, preferably PowerBI.
• 5+ years’ experience working with and creating data extracts.
• 5+ years’ experience programming skills with querying languages: SQL, SAS, R, Python, etc.
• 5+ years’ experience in Data Visualization.
• Experience integrating multiple components of the Microsoft Fabric / BI Stack, with specific emphasis on Power BI, Power Apps, Power Automate, and Azure services.
• Experience with both on-prem SQL server and Azure Databricks cloud data environments.
• Experience using analytics techniques to contribute to company growth efforts, increasing revenue and other key business outcomes.
• Exceptional written, verbal, and interpersonal communication skills.
• Strong project management skills and experience with agile methodologies preferred.
• Demonstrated ability to communicate and support data culture change initiatives.
• Client-centered approach to working with line of business stakeholders.
• Demonstrated ability to engage directly with C-level executives when sharing data, reports, and presentations.
• Working knowledge of common banking core systems and tools (Fiserv Signature, MeridianLink/LoansPQ, Encompass, Velocify, Marquis Executrax MCIF, Salesforce) preferred.
•
• We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, ethnic origin, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
•
•
Job Description
Key Accountabilities
Fulfill Core Senior Data Analytics Developer Accountabilities
• Deliver on large data projects by leading planning, execution, and completion of projects through peer leadership, cross-functional team collaboration, and consensus building with functional and senior stakeholders and implementing logical solutions.
• Build, develop, and maintain data models, dashboards, reports, data automation systems, and performance metrics support that support key business decisions.
• Proactively evaluate data & data technology trends to guide business partners on emerging opportunities.
• Ensure data accuracy, quality, and consistent reporting by designing and creating optimal analytics code with data controls defined as defined within the policy, procedure, and standards.
• Tasks and deliverables are often time-sensitive and require a proactive approach to ensure deadlines are consistently met.
Develop And Implement Power BI Reports
• Create consistent dashboards, reporting, and analytics experiences for business users.
• Elicit and understand business requirements from stakeholders; transform into the BI context and design a data model to transform raw data into meaningful insights.
• Convert business requirements into technical specifications and implement them through reports that support decision-making.
• Perform DAX queries and functions in Power BI.
ETL, Data Extracts & Ad-Hoc Reporting
• Partner with business users to derive requirements, identify data sources, wrangle data and/or transform data via SQL and/or SAS to produce file extracts for use within PowerBI Dashboards or distribution to other systems.
• Partner closely with data engineering and data movement teams on ETL processes and to develop and enhance databases/schemas/tables and implement data solutions to move data from and to other internal and external systems and vendors.
• Drive efforts on ad-hoc, time-sensitive exploratory data analysis and/or qualitative analysis to provide insights on trends, client behaviors, system troubleshooting or non-recurring reporting needs.
• Creating customized diagrams and user-defined calculations as needed.
• Design, develop and deploy business intelligence solutions with SQL queries for best results, filters, and graphs to better understand your data at all levels for performance improvements and suggestions.
Qualifications And Education Requirements
• Bachelor’s degree in related field; advanced coursework/training related to computer science, management information systems, and mathematics/statistics, Master’s degree preferred.
• Exceptional analytic ability and problem-solving skills.
• 6-10 years’ experience in banking and finance with a thorough knowledge of the retail bank business line.
• Demonstrated ability in data retrieval from multiple databases and systems.
• 5+ years’ experience in developing analytics reports and dashboards, preferably PowerBI.
• 5+ years’ experience working with and creating data extracts.
• 5+ years’ experience programming skills with querying languages: SQL, SAS, R, Python, etc.
• 5+ years’ experience in Data Visualization.
• Experience integrating multiple components of the Microsoft Fabric / BI Stack, with specific emphasis on Power BI, Power Apps, Power Automate, and Azure services.
• Experience with both on-prem SQL server and Azure Databricks cloud data environments.
• Experience using analytics techniques to contribute to company growth efforts, increasing revenue and other key business outcomes.
• Exceptional written, verbal, and interpersonal communication skills.
• Strong project management skills and experience with agile methodologies preferred.
• Demonstrated ability to communicate and support data culture change initiatives.
• Client-centered approach to working with line of business stakeholders.
• Demonstrated ability to engage directly with C-level executives when sharing data, reports, and presentations.
• Working knowledge of common banking core systems and tools (Fiserv Signature, MeridianLink/LoansPQ, Encompass, Velocify, Marquis Executrax MCIF, Salesforce) preferred.
•
• We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, ethnic origin, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
•
•
