Junior Full Stack Data Analyst
Getzville, NY, United States
Full Time Entry-level / Junior USD 69K+
M&T Bank
With a community bank approach, M&T Bank helps people reach their personal and business goals with banking, mortgage, loan and investment services.This entry-level data position will be responsible for providing support to their direct team working across several projects/programs to produce standard reports and dashboards, leveraging data captured via departmental databases (SQL) or other existing available data sources.
This is a great opportunity for recent graduates looking to start their career in Data, or for established professionals looking to pivot careers into the exciting, growing world of Data Analytics!
Primary Responsibilities:
- Leverage SQL to produce complex queries, that are fed into visualization tools such as Tableau or Power BI
- Develop automation workflows leveraging ETL tools such as Microsoft Visual Studios (SSIS), Power Automate, Broadcom Automic, etc.
- Perform statistical analysis and qualitative analysis over a variety of related disciplines to support business decisions.
- Prepare and produce routine departmental reports and spreadsheets to include but not limited to project or product strategy analysis, historical reporting, work flow analysis, and financial analysis.
- Responsible for data collection and consolidation for reporting in a format that is easy to use. Maintain and update various departmental reports including but not limited to workbooks, slide deck presentations and dashboards.
- Perform routine analysis and judgment based work over a single or a few closely related disciplines to support business decisions.
- Perform routine data review, research, and/or reconciliation.
- Support continuous improvement of existing processes, develop new or enhance existing processes where required including maintenance plans, procedural documentation and custom tools for automation. Identify resources that can be utilized to support business operations or improve existing business processes.
- Support the planning and implementation of new projects, programs, and plans to achieve short and long term business objectives.
- Support user certifications; obtain documentation necessary for departmental audits.
- Participate in the planning, testing, and implementation of new projects, systems, products, and regulatory changes.
- Assist with technical troubleshooting and escalations, coordinating with business partners, vendors and technology to address issues for the team.
- Adhere to applicable compliance/operational risk controls in accordance with Company or regulatory standards and policies.
- Promote an environment that supports belonging and reflects the M&T Bank brand.
- Maintain M&T internal control standards, including timely implementation of internal and external audit points together with any issues raised by external regulators as applicable.
- Complete other related duties as assigned.
Experience and Education Required:
Associates degree and a minimum of 2 years related business line experience,
OR in lieu of a degree,
A combined minimum of 4 years higher education and/or work experience.
M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $20.94 - $34.91 Hourly (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.LocationGetzville, New York, United States of AmericaTags: Data Analytics ETL Power BI Research SQL SSIS Statistics Tableau Testing
Perks/benefits: Competitive pay
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.