Description
(Primary Responsibilities)
- As a BI Analyst, you will play a key role in transforming raw data into actionable insights that drive business decisions.
- Collaborating with business units (e.g., Risk, Finance, Product) to gather reporting requirements and provide analytical support.
- Writing and optimizing SQL queries to extract and manipulate data from complex systems and data warehouses.
- Designing and enhancing Tableau dashboards to communicate KPIs, trends, and financial metrics effectively.
- Working on data ETL processes in collaboration with data engineering teams to ensure smooth data flow and availability for reporting.
- Translating business logic into data-driven solutions by implementing calculations, data transformations, and rules that align with business definitions.
- Developing new metrics and performance indicators to support evolving business strategies and regulatory needs.
- Continuously identifying and driving process improvements across reporting workflows, automation, and dashboard performance.
- Conducting deep-dive analyses to uncover insights related to customer behavior, product performance, risk exposure, and compliance trends.
- Documenting data definitions, business rules, and reporting logic for transparency and consistency.
Desired Skills / Qualifications :
Minimum 4 years of hands-on experience in a BI Analyst or similar role.Expertise in SQL (T-SQL, PL / SQL, or similar) for data extraction and manipulation.Strong experience with Tableau, including dashboard design, storytelling, and performance tuning.Prior experience working in the Banking or Financial Services industry is mandatory.Familiarity with data warehousing concepts, ETL processes, and BI tools.Strong analytical thinking and problem-solving skills.Excellent communication and stakeholder management abilities.Bachelor’s degree in computer science, Statistics, Finance, or a related field.S oft Skills :
Strong problem-solving and critical-thinking abilities.Excellent communication and presentation skills.Ability to work independently and as part of a team.Attention to detail and the ability to work with complex data sets.Preferred Qualifications :
Proficiency in SQL, Python, VBA, and JavaScript for data analysis, automation, and enhancing reporting functionalities.Strong experience with Tableau; experience with other BI tools like Power BI or Looker is a plus.Exposure to Databricks for building and managing data pipelines, performing large-scale data processing, and advanced analytics.Working Shift / arrangement : US Shift (1 : 30 PM – 10 : 30 PM – IST), Flexible - Hybrid working model
Our full-time employee benefits include :
A competitive compensation package, annual bonus, 401k match
Flexible PTO including 7 paid holidays, 1 floating holiday, and 1 volunteer day
Employer-paid benefits (medical, dental, vision, health savings account)
Professional career development and reimbursement
Up to 16 weeks paid maternity leave; up to 4 weeks of paid parental leave
Backup childcare offered through Bright Horizons
Amherst is proud to be an Equal Opportunity Employer and committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, genetic information or veteran status, and encourage all applicants to apply.