ZipRecruiter

Log In

1

Excel Vba Developer Jobs in Massachusetts (NOW HIRING)

Ropes & Gray

Pricing Strategy Analyst

Boston, MA · On-site

Experience building tools using advanced Excel techniques and VBA programing. * Knowledge of financial and reporting systems; ideally of legal services products such as MicroStrategy and 3e. * The ...

Ropes & Gray

Pricing Strategy Analyst

Boston, MA · On-site

Experience building tools using advanced Excel techniques and VBA programing. * Knowledge of financial and reporting systems; ideally of legal services products such as MicroStrategy and 3e. * The ...

Ropes & Gray

Pricing Strategy Analyst

Boston, MA

Experience building tools using advanced Excel techniques and VBA programing. * Knowledge of financial and reporting systems; ideally of legal services products such as MicroStrategy and 3e. * The ...

previous page

Showing results 41-60

All JobsExcel Vba Developer JobsExcel Vba Developer Jobs in Massachusetts

Excel Vba Developer information

See Massachusetts salary details

$12K

$147.4K

$173.6K

How much do excel vba developer jobs pay per year?

As of Aug 22, 2026, the average yearly pay for excel vba developer in Massachusetts is $147,436.00, according to ZipRecruiter salary data. Most workers in this role earn between $125,600.00 and $169,300.00 per year, depending on experience, location, and employer.

What is an Excel VBA developer?

Excel VBA Developers are professionals who specialize in creating, modifying, and maintaining macros, scripts, and custom solutions using Visual Basic for Applications (VBA) within Microsoft Excel. They leverage VBA to automate repetitive tasks, enhance data analysis, and design user-friendly tools and dashboards tailored to business needs. Their expertise helps organizations improve efficiency, accuracy, and productivity in data processing and reporting.

What are the key skills and qualifications needed to thrive as an Excel VBA developer, and why are they important?

To thrive as an Excel VBA Developer, you need strong proficiency in Excel functions, advanced VBA programming, and a solid understanding of data analysis, usually supported by a degree in computer science, information systems, or a related field. Familiarity with Microsoft Office Suite, version control systems like Git, and relevant certifications such as Microsoft Office Specialist are often required. Attention to detail, problem-solving ability, and effective communication skills help developers understand user needs and deliver robust solutions. These competencies ensure the development of efficient, reliable automated processes that improve productivity and data accuracy within organizations.

What are some common challenges Excel VBA developers face when working with large or complex datasets?

Excel VBA Developers often encounter performance issues when automating tasks with large or complex datasets, as Excel has inherent limitations in processing speed and data capacity. Optimizing code for efficiency—such as minimizing loops, using arrays, and reducing interactions with worksheet cells—can help mitigate these issues. Additionally, ensuring data integrity and error handling becomes increasingly important as complexity grows, so writing robust, well-documented code is essential. Collaborating closely with data owners and end-users can also help clarify requirements and streamline workflows.

What is the difference between Excel Vba Developer vs Data Analyst?

AspectExcel Vba DeveloperData Analyst
Required skillsVBA programming, Excel automationData analysis, SQL, Excel, visualization
Work environmentFinance, IT, operationsBusiness, marketing, finance
CertificationsExcel VBA certifications, Microsoft Office certificationsData analysis certifications (e.g., CAP, Microsoft Certified Data Analyst)

Excel Vba Developers focus on automating Excel tasks using VBA, while Data Analysts interpret data and create reports. Both roles often work in similar industries and require strong Excel skills, but their core responsibilities differ: automation versus data interpretation.

More about Excel Vba Developer jobs

What are the most commonly searched types of Excel Vba Developer jobs in Massachusetts?

The most popular types of Excel Vba Developer jobs in Massachusetts are:

What are popular job titles related to Excel Vba Developer jobs in Massachusetts?

For Excel Vba Developer jobs in Massachusetts, the most frequently searched job titles are:

What job categories do people searching Excel Vba Developer jobs in Massachusetts look for?

The top searched job categories for Excel Vba Developer jobs in Massachusetts are:

What are popular job titles related to Excel Vba Developer jobs in MA?

For Excel Vba Developer jobs in MA, the most frequently searched job titles are:

Excel Vba Developer jobs near you
Infographic showing various Excel Vba Developer job openings in Massachusetts as of August 2026, with employment types broken down into 70% Full Time, 5% Part Time, and 25% Contract. Highlights an 100% In-person job distribution, with an average salary of $147,436 per year, or $70.9 per hour.

Director, Portfolio Analytics

Fidelity Investments

Boston, MA • On-site

Full-time

Re-posted 8 days ago

Fidelity Investments rating

8.7

Company rating: 8.7 out of 10

Based on 272 frontline employees who took The Breakroom Quiz

16th of 151 rated financial services

Job description


Position Description:
Note: Fidelity will not provide immigration sponsorship for this position.
Oversees production data management, model integrity, and end-to-end technical support for portfolio management, risk models, and quantitative research platforms, by building quantitative research platforms and tools. Ensures complete data quality coverage, Service Level Agreement (SLA) documentation, and proper team communication. Drives the buildout of new data quality frameworks and tools to streamline teamwork in support of Data Quality (DQ) coverage at scale. Draws on in-depth knowledge of advanced principles, theories, and concepts to create high quality quantitative research solutions for complex projects, applications, and products. Consults with development architects and business on internal service quality control standards, policies, and procedures.
Primary Responsibilities:
  • Develops new processes, performs calculations, identifies anomalies, and produces new reporting capabilities by analyzing large data sets.
  • Evaluates the value of new content and methods through proofs-of-concept.
  • Extends data platforms using existing data models and quantitative research processes.
  • Translates analytics into model construction, factor definition, and calculation.
  • Develops and incorporates non-traditional and unstructured data and data science applications to enhance research and investment process.
  • Performs validations and testing of models to ensure adequacy and reformulate models as necessary.
  • Presents mathematical modeling and data analysis results to management and other end users.
  • Formulates and applies mathematical modeling and other optimizing methods to develop and interpret information that assists with decision making.
  • Collects and analyzes data and develops decision support software, service, or products.
  • Develops and supplies optimal time, cost, or logistics networks for program evaluation, review, or implementation.
  • Advises senior management on technical strategy.
  • Participates in high-level, cross-functional design teams.
  • Sets vision, goals, and direction of team/organization.
  • Plans and leads organization-wide initiatives.
  • Provides leadership, technical supervision, and expertise to multiple teams in broad technical areas on complex organization-wide projects.
  • Researches and recommends new technologies.
  • Regularly provides guidance, training, and coaching to other team members for performance and career development.
  • Identifies and plans for future resource needs.

Education and Experience:
Bachelor's degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and six (6) years of experience as a Director, Portfolio Analytics (or closely related occupation) performing multi-asset class analytics in a financial services environment.
Or, alternatively, Master's degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and four (4) years of experience as a Director, Portfolio Analytics (or closely related occupation) performing multi-asset class analytics in a financial services environment.
Skills and Knowledge:
Candidate must also possess:
  • Demonstrated Expertise ("DE") performing product management and impact analysis on trading and risk analytics in a complex multi-asset class environment (open and closed architecture fund-of-funds structures); debugging differences between economic and accounting views of holdings and assessing their influence on portfolio construction; monitoring and measuring risk for mutual funds; and writing specification documents, interpreting business requirements, and creating analytical visualization solutions, using Microsoft Office suite, Visual Basic (VBA), Tableau and Oracle SQL.
  • DE defining and maintaining operational workflows; creating data quality assurance tools for validating holdings from various vendors (Morningstar, Bloomberg, Index providers and accounting views) and instrument data across multi-asset classes (Equity, Corporate Bonds, Municipal Bonds, Commodities, Derivatives, and Alternative strategies), using Oracle SQL, Snowflake, Python, Microsoft Excel, and Visual Basic (VBA); and cleaning, validating, cross-checking, tracking, and documenting changes, anomalies, and inconsistencies in raw data for investment risk analysis.
  • DE analyzing BarraOne Multi-Asset Class (MAC) risk factor model construction, factor definitions, and calculations; translating equity, fixed income, alternatives risk and stress analytics into meaningful insights used for portfolio maintenance; integrating BarraOne risk models into existing infrastructure, and expanding and enhancing analytic platforms and tools, using Microsoft Excel, Snowflake, Tableau, Oracle SQL, Python, and R; and performing investment risk analysis (portfolio performance and risk reporting), using BarraOne Multi-Factor Model (MAC) risk and performance attribution.
  • DE measuring incremental effects of portfolio construction methodologies; performing fund holdings and returns analysis, using statistical methods and analytical tools - Analysis of Variance (ANOVA) and Analysis of Covariance (ANCOVA); writing risk model methodologies and specification documents, interpreting business requirements, and creating model performance monitoring reports in Confluence and Microsoft Office Suite; integrating portfolio management workflows into vendor tools (Factset and MSCI BarraOne), using Microsoft Office Suite, Tableau, Oracle SQL, Snowflake, Python, and R; and researching and testing methods to improve existing models, using regression techniques, time series analysis, and interest rate models and Monte Carlo simulations.

Salary: $165,000.00 to $194,000.00/Year.
#PE1M2
#LI-DNI
Fidelity's Onsite Working Model
Fidelity is transitioning to a full-time onsite working model through a phased rollout across regions and roles. Currently, some roles and locations require 100% onsite presence, while others require less. Onsite expectations are likely to evolve as the rollout continues. This transition does not apply to fully remote roles.
Certifications:
Category:
Data Analytics and Insights
Please be advised that Fidelity's business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.

What Fidelity Investments employees say

Pay

Benefits

Hours and flexibility

Workplace

Get the full story on Breakroom

Apply