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
Didn't find what you're looking for? Search again!
Loading more jobs...