Senior Data Analyst
Location
United States
Posted
46 days ago
Salary
0
Seniority
Senior
Job Description
Senior Data Analyst
SmartBank
Looking to join a Great Place to Work Employer and become a valued member of our growing team? At SmartBank, we're not just offering a job; we're inviting you to be a part of a culture built on excellence. Position Summary: As SmartBanks Data Analyst you will be held accountable for providing data analytics to the SmartBank ecosystem utilizing a no code/low code approach. The data reported will maintain a high level of integrity and accuracy. This will include preparing and distributing various reports as well as gathering requirements for new reporting needs from relevant interested parties. This will be done by developing the data architecture for the bank, identifying data locations, and ensuring appropriate controls are in place to ensure data integrity. The Data Analyst will report to the Enterprise Applications Manager and will be expected to provide seniority and leadership to the growing Data Analytics practice inside the Enterprise Applications functional group. Major Duties and Responsibilities: - Upholds SmartBank Core Values and Core Purpose. - Adheres to and embraces the SmartBank Way by Acting Smart, Looking Smart and Being Smart. - Build strong and effective relationships with internal and external business partners. - Analyze the current data architecture of SmartBank. - Must be able to recommend solutions and methods to modernize SmartBank’s data architecture. - Lead projects delivering reporting and analytical solutions to internal customers. - Complete data discovery projects – identify all data, obtain/build data dictionaries, identify key indicators to link data and assist with selection of data warehouse options. - Build necessary data pipelines to support a modern data architecture. - Build, maintain and improve new and existing ETL pipelines between Microsoft SQL Server databases, H360 (DB2), Cognos, Power BI, online data sources, and SaaS (DH1) applications - Create and maintain flow chart and internal control structure/process around data. - Work with business partners to drive the evolution of data analytics processes. - Plan, review, and/or support preparation of internal and external reports, reconciliations, tables, and schedules. - Identify opportunities to streamline, automate, and improve efficiencies to reduce costs. - Maintain general knowledge of bank products, processes, and procedures to ensure proper reporting and classification of system level data. - Maintain and develop database and other related tools to support data reporting and transform needs as assigned - Participate and adhere to change management and documentation required by IT policy - Design SQL database tables and structures along with creating views, functions and stored procedures; create database triggers for use in automation and maintain data quality for overseeing database security and performance (DH2) - Performs other duties as assigned. - Assist with development and implementation of data governance program. - Complies with all applicable federal, state, and local banking and industry related laws and regulations including but not limited to the Bank Secrecy Act. Position Requirements and Qualifications: - Advanced knowledge of Microsoft SQL (Views, Stored Procedures, Subqueries, Common Table Expressions, etc.) and Power BI - Hands-on experience using IBM Cognos Knowledge of Python and its related data transformation will be helpful - Advanced knowledge of Excel (Power Query and Power Pivot) - Experience with Data Visualization (experience making the data tell a story) Education and Experience: - 3-5 years’ experience in related role - Bachelor’s Degree (in lieu of a degree, more years of experience may be considered) - 3 years of banking experience is required Knowledge Requirements: - Excellent organizational skills. - Willing to accept new ideas and methods and be agreeable to change. - High level of integrity. - Detail oriented and ability to function in a team environment. - Strong written and oral communication skills. - Ability to apply knowledge and sound judgment in decision-making using established guidelines. Work Conditions: - Ability to routinely stand, sit, bend and stoop. - Ability to work in a fast paced and changing environment independently, with limited supervision. - Ability to travel - Ability to adapt to changing procedures and regulations. - Consistently at work and on time, follows instructions, responds to management direction and solicits feedback to improve performance. - Demonstrates accuracy and thoroughness, monitors own work to ensure quality and applies feedback to improve performance.
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
• Realizar análises exploratórias, diagnósticas e descritivas para identificar padrões, tendências e oportunidades de melhoria • Apoiar áreas de negócio com análises orientadas a dados, conectando informações a recomendações práticas • Desenvolver análises recorrentes e ad hoc para apoiar times como Financeiro, RevOps, Produto, CS e áreas corporativas • Apoiar a formulação de hipóteses, definição de métricas e acompanhamento de resultados • Organizar e estruturar demandas analíticas com clareza, garantindo boa interpretação do problema de negócio • Criar e manter dashboards, relatórios e painéis gerenciais com foco em clareza, confiabilidade e usabilidade • Apoiar a construção de materiais analíticos e apresentações para stakeholders e lideranças • Seguir boas práticas de uso e interpretação de dados, contribuindo para maior consistência analítica na empresa • Contribuir para a organização e padronização de entregas analíticas do time • Trabalhar de forma próxima a Analytics Engineers e Engenheiros de Dados, contribuindo com requisitos analíticos e feedbacks de negócio • Utilizar a camada analítica governada como base principal para análises e dashboards • Apoiar a evolução contínua das soluções analíticas da empresa, trazendo sugestões de melhoria em dados, métricas e reporting
• Realizar análises exploratórias, diagnósticas e explicativas, identificando padrões, tendências e oportunidades de melhoria • Apoiar a tomada de decisão por meio de insights orientados a negócio, conectando dados a ações práticas • Desenvolver análises recorrentes e ad hoc para áreas como Financeiro, RevOps, Produto e Diretoria • Formular hipóteses, definir métricas de acompanhamento e avaliar resultados • Criar e manter dashboards e relatórios executivos, garantindo clareza, consistência e alinhamento conceitual • Atuar na definição e acompanhamento de KPIs e métricas de negócio, em parceria com Analytics Engineers • Garantir que análises e visualizações reflitam corretamente os dados oficiais e modelos analíticos • Apoiar apresentações executivas, traduzindo dados em narrativas claras • Validar resultados analíticos, identificando inconsistências e alinhando conceitos com times técnicos • Documentar análises, métricas e premissas, contribuindo para padronização e reuso • Utilizar a camada analítica governada como base para análises e dashboards • Apoiar a evolução contínua das soluções analíticas da empresa.
• Analyze detailed claims data from internal claims processing system and external sources in various formats • Critical thinker that is comfortable supporting collaborative problem solving in a team environment • Benchmark, validate and test the solution for real-world environments • Develop analytic solutions to meet operational/strategic business needs, including contributing to new projects, while supporting and enhancing existing solutions • Assist in defining, developing, designing, prototyping, testing, and supporting the implementation of analytics • Partner with data engineering teams to ensure data accuracy, consistency, and validation across models and reports • Translate business requirement into actionable intelligence to business leaders • Work closely with solution architects to design scalable, efficient data solutions that support large datasets • Strong understanding of data warehousing, data pipelines, and data visualization tools • Adhering to RxBenefits’s Information Security Management System as well as all other company policies • Driven self-starter who is creative and results oriented; manages multiple priorities and deadlines • Work closely with engineering teams to ensure seamless development and implementation of analytics features and ability to report on progress to executive leaders as needed • Collaborate with data engineers, technology architects and product developers to design data pipelines, models, and visualizations • All other duties as assigned.
Data Analyst, Analytics & Insights
StrykerTogether with our customers, we are driven to make healthcare better. #WeAreStryker
• Build and maintain relationships with users and business leaders • Gather and document business requirements in partnership with stakeholders • Translate business questions into analytical approaches and reporting solutions • Participate in presentations and communications with business stakeholders • Query and analyze data using SQL or other analytical programming languages to support reporting and analytics needs • Develop and maintain dashboards and reports using approved business intelligence tools • Perform data and process analysis to support ad-hoc business questions and requests • Triage and resolve reporting issues, including data accuracy concerns • Maintain clear documentation of reports, datasets, and analytic processes • Support adherence to data governance practices including documentation of data definitions, sources, and calculations • Collaborate with the Data Engineering team to align on architecture and data sourcing • Assist with training and education of users on reporting solutions to promote effective report usage • Contribute to team development by suggesting improvements to tools, workflows, and analytics capabilities
