Business Intelligence Systems Analyst

Company: Northeastern University
Location: Boston
Posted on: January 26, 2023

Job Description:

About the OpportunityJOB SUMMARYThe Division of Information Services is currently seeking a talented individual to fill the role of Business Intelligence Systems Analyst. The Business Intelligence Systems Analyst will be a dedicated member of the Business Intelligence & Analytics team responsible for ongoing growth and development of the University's bi-modal Snowflake cloud data platform and enterprise data warehouse capabilities.Under the direction of the Director of Business Intelligence & Analytics, the incumbent will work closely with business partners and the Data Administration team to gather functional requirements and translate them into technical specifications used in the design, development, and deployment of Business Intelligence applications, reports, and data assets.The candidate will be expected to develop a solid foundational understanding of the key business concepts and drivers followed by functional organizations within the University. The Business Intelligence Systems Analyst will work closely with Data Architects and Engineers to utilize conceptual and physical data modeling techniques that define the data platform and enterprise data warehouse environments.Additionally, the Business Intelligence Systems Analyst will be closely involved in other aspects of the University's business intelligence function, including source system profiling and data transformation design; design and development of BI content (e.g., static & dynamic reports, dashboards, data files, etc.); metadata documentation; and user support and training.To ensure that essential services are provided to the university community, the employee will be required to work outside his/her regular working hours and on some university holidays. This is a remote position that does not require the candidate to work on site.At Team ITS, your success matters as much as the mission. Learn more about our flexible, highly dynamic, and values-first culture at -.MINIMUM QUALIFICATIONS

• The ideal candidate will hold a Bachelor's degree in Computer Science, Data Analytics or related and 5+ years working in a business intelligence function
• Experience working with modern SaaS cloud data platforms such as Snowflake, AWS, or Google
• Advanced understanding of SQL query language required
• Working experience with data integration & transformation procedures to load data from transactional systems into data platforms, lakes, warehouses
• Experience with design and creation of operational and analytical reports and dashboards for end users. Understanding of data warehouse best practices and methodologies, including Kimball, Inmon, etc.
• Experience with one or more industry leading BI applications such as Cognos, Tableau, or PowerBI required
• Prior experience with ETL/ELT tools such as IICS, PowerCenter, Matillion, Databricks, etc. a plus
• Understanding of data visualization techniques (e.g., Few, Tufte, etc.) a plus
• Experience effectively interacting with end-users, partners or customers required along with excellent written and verbal communication skills.
• A sense of urgency to address client requests effectively and quickly
• Ability to work independently and be on-call when neededKEY RESPONSIBILITIES & ACCOUNTABILITIESAnalyze Client Requests for Project / Work Initiation 35%Clarifies understanding of business/technical requests. Identifies and evaluates alternative business intelligence and reporting solutions. Works with the Director of Business Intelligence & Analytics to prepare high level documentation that identifies viable options to address reporting/analytic needs. Works with appropriate parties to gain approval of proposal and initiate work. Collaborates with appropriate functional/technical staff (e.g., Data Architects, BI Developers, Business Analysts, etc.) to prepare and document project-planning information (e.g., time, resources, major tasks required to complete work) for input into the scoping documentation.Document Business Requirements and Prepare Detail Design Specifications 30%Facilitates and/or partners with Data Administration and other business/technical staff to facilitate a systematic process for capturing detailed business functional and technical requirements (e.g., via JAD session, etc.). Works with business/technical partner to capture requirements in a standard format that will serve as the foundation for the creation of technical documentation (e.g., business intelligence application technical requirements, input and output requirements, ETL/interfaces, design specification, test strategies and plans, etc.). Works with Business Intelligence & Analytics team and other business/technical staff to determine system components and functional flow of components and data between components. Assist in source definition for the cloud data platform and data warehouse attributes. Map attributes to source including identification and documentation of transformation algorithms as necessary. Document findings in the metadata repository. Creates detailed business intelligence program specifications from which a developer can code. Validates the design documentation with the appropriate parties and receives approval on these documents. Reviews final design documents with Business Intelligence & Analytics team to ensure that they thoroughly understand the work requested of them.Manage Informatics Project Implementation 10%May serve as, project manager or coordinate with assigned IS project manager for business intelligence and reporting projects/programs whose scope and duration range from small to large. Works with internal customers to identify the issue or request, and then identifies and collaborates with Data Administration and technical team to design business intelligence or reporting solutions that meets the business need(s). Involves appropriate parties as needed to complete the work. Ensures delivered business intelligence solutions meet customer requirements, expectations and needs.Assist in Testing New or Upgraded Informatics System Solutions 15%Verifies acceptance testing at the business intelligence system level. Works with appropriate parties to complete accurate and thorough test plans on new / upgraded functionality. Reviews test results for any business intelligence system modifications. Resolves issues uncovered during testing.Provide Leadership / Direction / Consultation to Business Intelligence & Analytics Team 10%Works with business and technical teams to maintain or build business intelligence and reporting systems and clarifies design expectations as necessary. Respond to business and technical questions. Researches and involves appropriate parties to resolve more complex business intelligence and technical issues. Monitors progress of work to ensure that design requirements are met. Collaborate with other IT BI team members in the development and implementation of standards, policies, and best practices in the development and maintenance of the business intelligence systems. Provides management with timely and appropriate status updates on the work performed by the team and any barriers that have been encountered.Position TypeInformation TechnologyAdditional InformationNortheastern University is an equal opportunity employer, seeking to recruit and support a broadly diverse community of faculty and staff. - Northeastern values and celebrates diversity in all its forms and strives to foster an inclusive culture built on respect that affirms inter-group relations and builds cohesion. -All qualified applicants are encouraged to apply and will receive consideration for employment without regard to race, religion, color, national origin, age, sex, sexual orientation, disability status, or any other -characteristic protected by applicable law.To learn more about Northeastern University's commitment and support of diversity and inclusion, please see .

Keywords: Northeastern University, Boston , Business Intelligence Systems Analyst, Professions , Boston, Massachusetts