Principal Business Intelligence Analyst (Microsoft)

Job Locations US-MA-Bedford
Req #
# of Openings
Job Posting Category
Information Technology


Aspen Technology, Inc. has an immediate need for a Microsoft-focused Business Intelligence Professional to work in Bedford, MA.  This role will be part of the Data Analytics team and responsible for building, implementing and supporting Microsoft BI solutions. The right individual will possess experience in all stages of BI project work (requirements and logical design, physical design, implementation, testing and deployment). The Principal BI Analyst should have a firm grasp of BI implementation methodologies and will have had in-depth experience with the Microsoft BI Stack (SSIS, SSRS and SSAS). The candidate will perform analyses and help deliver business insights for major product lines, customer usage, pricing, segmentation and costs. You will work with product management, marketing, finance and sales operations to better understand our installed base and support initiatives that drive adoption of AspenTech’s software.


  • Design, develop, and test highly complex BI solutions on the Microsoft Business Intelligence stack (SSIS, SSAS, SSRS, SQL Server Database and Power BI)
  • Perform data validation, error checking, troubleshooting, performance tuning and keeping schema/data in existing application database environments in sync
  • Responsible for the day to day database development tasks which include the development of queries, stored procedures, functions, views, and other database schema objects
  • Work in conjunction with BI analysts and business users, acting as a liaison between technical and business teams in developing dashboards, data visualizations, analytics and other BI related solutions using SSRS and Power BI
  • Troubleshoot data integration and data quality issues and bugs, analyze reasons for failure, implement optimal solutions, and revise procedures and documentation as necessary


  • Bachelor's Degree in Computer Science or Information Technology
  • 8+ years of experience, with at least 3 years in a data analyst position
  • Experience in the design, development and testing of high quality automated SSIS ETL mappings and scripts to migrate data from source systems and files into a data mart and SSRS cubes
  • Experience in Microsoft SQL Server development (T-SQL, advanced SQL, query performance, and database design)
  • Experience in building SSAS cubes and tabular model solutions as well as developing MDX and DAX queries
  • Experience in developing paginated reports, dashboards and data visualizations using SSRS
  • Experience in Star-schema style data warehouse experience
  • Knowledge of PowerBI is preferred
  • Knowledge of Excel and VBA to develop reports in Excel by querying SSAS cubes and existing SQL Server databases
  • Ability to gather requirements, research alternatives and analyze data so as to develop insightful conclusions and generate solutions to address user needs
  • Ability to create written communication materials that effectively summarize findings and support recommendations for presentation to senior management
  • Ability to drive data quality assurance and coordinate user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT)
  • Ability to effectively collaborate and operate in a team environment

AspenTech is an equal opportunity/affirmative action employer


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.