Description
Business Intelligence Engineer Job Description
For internal use of MIT only.
Business Intelligence Engineer J ob Description
December 1, 2015
Version 5
BI Engineer J ob Description December 1, 2015 – Page i
For internal use of MIT only.
Table of Contents
General Characteristics ................................................................................................ 1
Job Path ......................................................................................................................... 2
Explanation of Proficiency Level Definitions .............................................................. 7
Summary Proficiency Matrix ........................................................................................ 8
Proficiency Matrix ......................................................................................................... 9
Version 5
BI Engineer J ob Description December 1, 2015 – Page 1
For internal use of MIT only.
General Characteristics
Individuals within the Business Intelligence (BI) Engineer role work closely with customers and BI Analysts to turn data into critical
information and knowledge that can be used to make sound business decisions. They provide data that is accurate, congruent and
reliable and is easily accessible. BI professionals educate and train customers to use the data as an analytical tool, displaying the
information in new form and content for the purpose of analysis and exploring options.
The BI Engineer is responsible for the full life cycle development, implementation, production support, and performance tuning of the
Enterprise Data Warehouse, Data Mart, and Business Intelligence Reporting environments, and support the integration of those
systems with other applications. They design and implement reporting and analytical solutions, including both the design of table
structures and the processes used to populate those structures with data from internal and external sources. The data they provide
helps business teams drive improvement in key business metrics, customer experience and business results. BI Engineers also
interact with various development teams, project managers, internal and external customers, senior management, and external
vendors.
Members of this role understand how data is turned into information and knowledge and how the knowledge supports and enables
key business processes. They must have an in-depth understanding of the business environment, and strong analytical and
communication skills. Individuals must work well within a team environment.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 2
For internal use of MIT only.
Job Path
The following section is intended to serve as a general guideline for each relative dimension of project complexity, responsibility and
education/experience within this role. This table is not intended for use as a checklist to facilitate promotions or to define specific
responsibilities as outlined in a position description. Actual responsibilities and experiences may vary.
Title BI Engineer I BI Engineer II BI Engineer III
Dimension
Work Complexity
? Works on low to medium complex
and cross-functional BI solutions.
? Works multiple projects as a team
member.
? Works on medium to complex
and cross-functional BI solutions.
? Works multiple projects as a team
member, sometimes as a
technical lead.
? Works on highly complex and
cross-functional BI solutions.
? Directs, organizes, and leads
projects in the implementation
and use of new BI software
tools and systems.
Typical Responsibilities
Project/Work Planning
? Participates in or supports
workstream planning process.
? Participates in workstream
planning process including
inception, technical design,
development, testing, and
delivery of BI solutions.
? May participate in project
management estimation
process.
? Develops demand forecasts.
? Participates in workstream
planning process including
inception, technical design,
development, testing and delivery
of BI solutions.
? Develops work plans or reviews
other work plan timelines and
manages workflows to meet
timeframes.
? Participates in project
management estimation process.
? Manages and plans for service
demand forecasts.
? May participates in the
development of business cases
to support IT projects.
Business Requirements
? Works with BI Analysts to
understand customer needs.
? Works with BI Analysts to
understand customer needs.
? Analyzes business and
functional requirements and
translates these requirements
? Works with BI Analysts to
understand customer needs.
? Analyzes business and functional
requirements and translates these
Version 5
BI Engineer J ob Description December 1, 2015 – Page 3
For internal use of MIT only.
Title BI Engineer I BI Engineer II BI Engineer III
into robust, scalable, operable
solutions.
requirements into robust, scalable,
operable solutions.
Develop and Implement
? Collects, analyzes, and shares
data to help business teams drive
improvement in key business
metrics, customer experience, and
business results.
? Utilizes database and web
application technologies to
develop and evaluate innovative
business intelligence tools and
automated reports.
? Develops and tests BI solutions
such as databases, queries,
views, reports, and dashboards.
? Assists in data conversions,
imports, and exports of data within
and between internal and external
software systems.
? Documents new and existing
models, solutions, and
implementations.
? Design and build reporting and
analysis tools that help streamline
the business and make reporting,
analyzing, planning, and
forecasting more efficient.
? Supports and assists with the
integration of BI platforms with
enterprise systems and
applications.
? Collects, analyzes, and shares
data to help business teams drive
improvement in key business
metrics, customer experience, and
business results.
? Utilizes database and web
application technologies to
design, develop, and evaluate
innovative business intelligence
tools and automated reports.
? Designs, develops and tests BI
solutions such as databases, data
warehouses, queries and views,
reports, and dashboards.
? Performs data conversions,
imports, and exports of data within
and between internal and external
software systems.
? Merges BI platforms with
enterprise systems and
applications.
? Enhances the performance of
business intelligence tools by
defining data to filter and
indexes.
? Documents new and existing
models, solutions, and
implementations.
? Collects, analyzes, and shares
data to help business teams drive
improvement in key business
metrics, customer experience, and
business results.
? Works with the BI Analyst
during implementation,
gathering additional information
when needed and keeping the
business informed.
? Implements data structures
using best practices in data
modeling, processes, and
technologies.
? Performs data conversions,
imports and exports of data within
and between internal and external
software systems.
? Implements tools and
frameworks for automating
report generation, identification
of data-quality issues, and data-
governance.
? Leads the integration efforts for
merging BI platforms with
enterprise systems and
applications.
? Performs data conversions,
imports, and exports of data within
and between internal and external
software systems.
? Explores the data and discovers
patterns, meaningful
Version 5
BI Engineer J ob Description December 1, 2015 – Page 4
For internal use of MIT only.
Title BI Engineer I BI Engineer II BI Engineer III
relationships, anomalies, and
trends.
? Performs programming
analyses for a wide range of
requests using data in different
formats and from various
platforms.
? Ensures documentation is
created and maintained.
Production Support
? Troubleshoots BI tools, systems,
and software.
? Tracks performance and
production issues.
? May assist in performance tuning
of BI applications.
? Escalates production issues as
appropriate.
? Troubleshoots BI tools, systems,
and software.
? Troubleshoots reported data
loads or reconciliation
inconsistencies in conjunction
with the sites for data models
and/or reports.
? Tracks, monitors and analyzes
performance and production
issues, and implements
improvements.
? Supports and helps manage
external resources, such as
service providers and vendor
support.
? Troubleshoots BI tools, systems,
and software.
? Troubleshoots reported data loads
or reconciliation inconsistencies in
conjunction with the sites for data
models and/or reports.
? Tracks, monitors and analyzes
performance and production
issues, and implements
improvements.
? Supports and helps manage
external resources, such as
service providers and vendor
support.
Quality Assurance
? Ensures the collected data is
within required quality standards.
? May maintain the quality of
Metadata Repository by adding,
modifying, and deleting data.
? Ensures the collected data is
within required quality standards.
? Maintains the quality of Metadata
Repository by adding, modifying,
and deleting data.
? Provides input to the
development of
data/information quality
metrics.
? Ensures the collected data is
within required quality standards.
? Maintains the quality of Metadata
Repository by adding, modifying,
and deleting data.
? Recommends quality metrics and
ensures quality metrics are
documented and tracked.
Process, Policies &
Standards
? Adheres to process, policies, and
standards.
? Provides input and adheres to
process, policies, and standards.
? Creates scalable, efficient,
automated processes for large
scale data analyses, model
Version 5
BI Engineer J ob Description December 1, 2015 – Page 5
For internal use of MIT only.
Title BI Engineer I BI Engineer II BI Engineer III
development, model validation,
and model implementation.
? Documents standards and
policies for the form, structure,
and attributes of the BI tools and
systems.
? Ensures adherence to process,
policies, and standards.
Customer Service
? Keeps customer informed about
business intelligence tool
problems and resolutions.
? Tracks and reports out on issues
and enhancement request for the
business in a timely manner.
? Keeps customer informed about
business intelligence tool
problems and resolutions.
? Tracks and reports out on issues
and enhancement request for the
business in a timely manner.
? Works closely with customers
and BI Analysts to create ad
hoc reports to support timely
business decisions and project
work.
? Keeps customer informed about
business intelligence tool
problems and resolutions.
? Tracks and reports out on issues
and enhancement request for the
business in a timely manner.
? Works closely with customers and
BI Analysts to create ad hoc
reports to support timely business
decisions and project work.
Research/Evaluation
? Analyzes and tests new
releases/versions of software.
? May participate in vendor
evaluations.
? Conducts research and makes
recommendations on BI
products and services.
? Interfaces with vendors to keep
abreast of new technologies,
pricing, and customer
applicability.
? Analyzes and tests new
releases/versions of software.
? Participates in vendor evaluations.
? Analyzes and tests new
releases/versions of software.
? Conducts research and makes
recommendations on BI products
and services.
? Interfaces with vendors to keep
abreast of new technologies,
pricing, and customer applicability.
? Participates in vendor evaluations.
? Interfaces with Architects to
recommend new technology
opportunities that will have an
impact on BI systems.
Training
? May train customers in the use of
the business intelligence tools to
? Designs and delivers end-user
training and training materials.
? Designs and delivers end-user
training and training materials.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 6
For internal use of MIT only.
Title BI Engineer I BI Engineer II BI Engineer III
enhance business decision-
making capability.
? Trains users to transform data
into action-oriented information
and to use that information
correctly.
? Trains users to transform data into
action-oriented information and to
use that information correctly.
Coaching/Mentoring
? Provides guidance, training, and
problem solving assistance to
other team members.
? Provides coaching to less-
experienced individuals.
? Provides guidance, training, and
problem solving assistance to
other team members.
? Provides coaching to less-
experienced individuals.
TYPICAL EDUCATION/
EXPERIENCE
? Bachelor's degree in Computer
Science, Information Systems,
Business Management or
specialized training/certification.
Or equivalent work experience.
? Typically requires 3-5 years’ of
related technical experience.
? Knowledge of one business
functional areas.
? Experience with database
administration.
? Knowledge of business
intelligence tools and systems
required.
? Bachelor's degree in Computer
Science, Information Systems,
Business Management,
Mathematics or specialized
training/certification. Or equivalent
work experience.
? Typically requires 5-7 years’ of
related technical experience.
? Knowledge of one or more
business functional areas.
? Advanced skills in data analysis
and data mining.
? Hands-on experience supporting
or working with Business
Intelligence/Data Warehousing
environments.
? Bachelor's degree in Computer
Science, Information Systems,
Business Management,
Mathematics or specialized
training/certification. Or equivalent
work experience.
? Typically requires 7 or more year
of related technical experience.
? At least 3 years of experience
supporting a major system.
? In-depth knowledge of the
industry and multiple business
functional areas.
? Expert skills in data analysis and
data mining.
? Hands-on experience supporting
or working with Business
Intelligence/Data Warehousing
environments.
? Experience leading teams.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 7
For internal use of MIT only.
Explanation of Proficiency Level Definitions
Proficiency scale definitions are provided to help determine an individual’s proficiency level in a specific competency. The rating
scale below was created as a foundation for the development of proficiency level definitions used for assessments.
Being Developed: (BD)
Demonstrates minimal use of this competency; limited knowledge of subject matter area; needs frequent
assistance and close supervision for direction. Currently developing competency.
Basic: (B)
Demonstrates limited use of this competency; basic familiarity of subject matter area; needs additional
training to apply without assistance or with frequent supervision.
Intermediate: (I)
Demonstrates working or functional proficiency level sufficient to apply this competency effectively without
assistance and with minimal supervision; working/functional knowledge of subject matter area.
Advanced: (A)
Demonstrates in-depth proficiency level sufficient to assist, consult to, or lead others in the application of
this competency; in-depth knowledge in subject matter area.
Expert: (E)
Demonstrates broad, in-depth proficiency sufficient to be recognized as an authority or master performer in
the applications of this competency; recognized authority/expert in subject matter area.
As you complete the competency assessment, read all of the proficiency level definitions for a competency (provided in the next
section) and select the one that is most characteristic of the demonstrated performance. If more than one definition is descriptive,
select the highest level that is typically exhibited.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 8
For internal use of MIT only.
Summary Proficiency Matrix
The chart provides a summary of proficiency ratings.
Title
BI
Engineer
I
BI
Engineer
II
BI
Engineer
III
Competency
Analytical Thinking: Able to breakdown raw information and undefined problems into specific, workable
components that in-turn clearly identifies the issues at hand. Makes logical conclusions, anticipates
obstacles and considers different approaches that are relevant to the decision making process.
I A E
Business Function Knowledge: Uses an understanding of business functions to analyze and propose
technical strategies for the business. Assesses benefits, risks, and costs.
B I A
Consulting: Uses professional knowledge, experience and technical expertise to respond to questions,
facilitate problem-solving, and generally advise, influence and provide guidance to customers and
business partners over whom there is no direct authority.
B I A
Customer Service Orientation: Identifies the ongoing needs of internal and/or external clients. Ensures
these needs are met or exceeded.
B I A
Information Seeking: Gathers and analyzes information or data on current and future trends of best
practice. Seeks information on issues impacting the progress of organizational and process issues.
Translates up to date information into continuous improvement activities that enhance performance.
I A E
Innovation: Improves organizational performance though the application of original thinking to existing
and emerging methods, processes, products and services. Employs sound judgment in determining how
innovations will be deployed to produce return on investment.
B I A
Problem Solving: Anticipates, identifies and defines problems. Seeks root causes. Develops and
implements practical and timely solutions.
B I A
Quality Assurance: Applies quality assurance, testing concepts, and methodologies. Constructs
comprehensive test plans based on a thorough understanding of business requirements. Imparts
confidence that a product optimally fulfills customers' expectations.
B I A
Version 5
BI Engineer J ob Description December 1, 2015 – Page 9
For internal use of MIT only.
Proficiency Matrix
The following charts illustrate proficiency levels for each competency.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Competency
Analytical Thinking: Able to breakdown raw information and undefined problems into specific, workable
components that in-turn clearly identifies the issues at hand. Makes logical conclusions, anticipates
obstacles and considers different approaches that are relevant to the decision making process.
Being Developed (BD): Gathers and links data. Reviews for non-conformity and gathers further
information in response to routine problems. Identifies direct cause and effect relationships. Breaks down
tasks and problems into manageable components. Solicits guidance as needed to assess importance
and urgency. Escalates issues of a non-routine nature as needed.
Basic (B): Collates and reports information. Solicits guidance to define criteria and assign values of
importance and urgency. Sorts information in order of importance. Investigates to define problems more
accurately. Identifies trends and exceptions. Identifies relationships and linkages between components.
Identifies variable potential causes and effects. Escalates issues of an exceptional nature.
Intermediate (I): Coordinates the information gathering and reporting process. Reviews trends and
compares to expectations. Conducts research to define problems and prepares responses to anticipated
questions. Prioritizes multiple issues and opportunities. Identifies relationships and linkages within
several information sources. Anticipates issues that are not readily apparent on the surface. Identifies
root causes and effects. Defines priorities within performance objectives. Reports and identifies areas
that need guidance in order to resolve complex issues. Anticipates the possible outcome of potential
solutions.
?
Advanced (A): Determines criteria for assessing issues and opportunities. Establishes clear goals and
priorities needed to assess performance. Identifies relationships and linkages between different
information sources. Anticipates issues that are not readily apparent on the surface. Identifies root
causes and effects. Establishes clear goals and priorities. Anticipates potential problems and develops
solutions needed to resolve them. Systemically analyzes relationships between apparently independent
problems and issues. Reviews and cross-reviews reports. Identifies trends as well as isolated events.
Translates analytical reports into management presentations, and provides guidance to resolve issues.
Anticipates the possible outcome of potential solutions. Identifies areas of significant concern or
opportunity. Probes and initiates research to identify critical problems.
?
Version 5
BI Engineer J ob Description December 1, 2015 – Page 10
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Expert (E): Establishes strategic goals and enterprisewide priorities. Uses techniques of advanced
business and organizational analysis to identify and assess problem definitions and potential solutions,
and compares and contrasts them against predetermined criteria. Creates framework for reviewing large
volumes of unorganized data. Probes for and points to subtle and unclear relationships in highly complex
matters and evaluates the merit of problem definitions and potential solutions. Anticipates the possible
outcome of potential solutions. Systemically identifies and resolves complex enterprisewide issues, while
educating senior leaders as to their solution.
?
Version 5
BI Engineer J ob Description December 1, 2015 – Page 11
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Business Function Knowledge: Uses an understanding of business functions to analyze and propose
technical strategies for the business. Assesses benefits, risks, and costs.
Being Developed (BD): Asks questions to determine the needs of a specific business function.
Assessed the impact on business functional requirements prior to taking action.
Basic (B): Assesses the needs of primary business functions. Suggests technical solutions for business
functions, and implements action plans to improve ongoing business performance in ways that minimize
day-to-day disruption of operations.
?
Intermediate (I): Involves the key players in identifying operating needs, issues and solutions. Proposes
technical plans that are aligned with business objectives and technical requirements. Takes and leads
actions to enhance business function standards and performance with the participation of business and
technical partners.
?
Advanced (A): Engages business and technical leaders in the identification of medium-term business
solutions consistent with best practices for cross-functional implementation. Sets the direction for and
steers medium-term enhancements of integrated standards and significant business performance drivers
across multiple areas of responsibility.
?
Expert (E): Participates in setting the strategic direction of and drivers for multiple lines of business.
Applies superior industry benchmarks to proposals for organization-wide initiatives. Sponsors capital
intensive, strategic business change. Reviews long-term business and technical solutions proactively.
Evaluates high-risk proposals and defines parameters for contingency plans that ensure seamless
change to the enterprise.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 12
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Consulting: Uses professional knowledge, experience and technical expertise to respond to questions,
facilitate problem solving, and generally advice, influence and provide guidance to customers and
business partners over whom there is no direct authority.
Being Developed (BD): Shares information in relation to procedures and routine activities. Provides
guidance and advice. Suggests caution as appropriate. Asks questions that raise awareness and
demonstrate insight.
Basic (B): Shares information and reports on the immediate situation. Provides feedback and advice as
appropriate in relation to procedures and routine activities. Asks questions that raise awareness and
demonstrate insight.
?
Intermediate (I): Conducts investigations and interprets issues within operational and professional
contexts. Provides guidance and counsel. Suggests caution to impacted areas as appropriate in relation
to matters of policy interpretation and implementation of operational improvement. Conducts discussions
that share information and trigger solutions and improvements.
?
Advanced (A): Leads research and summarizes requirements for the engagement. Interprets issues
within the framework of core business processes. Provides substantiated, risk-assessed options and
counsel in relation to process enhancement and professional expertise. Facilitates dialogues that
produce new perspectives and trigger recommendations for substantial innovative enhancements and
analysis of consequences.
?
Expert (E): Collaborates with clients to determine the scope of engagement. Advises senior leaders on
environmental analysis, planning opportunities, and implementation considerations for strategic
interventions. Researches long-range world-class business and technology trends. Uses formal
techniques of facilitation and analysis to assist leadership in criterion-based decision-making and
strategic planning.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 13
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Customer Service Orientation: Identifies the ongoing needs of internal and/or external clients. Ensures
these needs are met or exceeded.
Being Developed (BD): Asks questions in response to clients' requests for assistance on day-to-day
needs. Responds promptly and courteously. Updates clients on progress. Solicits support and guidance
as needed and refers client requests appropriately.
Basic (B): Asks questions and conducts investigations in response to clients' requests for assistance on
day-to-day needs. Responds promptly and courteously. Updates clients on progress. Instructs clients on
products and services and how to apply them to their business processes. Escalates to appropriate
parties as needed. Makes customers and their needs a primary focus of one's actions.
?
Intermediate (I): Asks questions and conducts investigations in order to understand clients' specific
needs and provides prompt, attentive service. Understands client’s expectations and takes initiatives to
meet and exceed them. Monitors progress and updates client and management as to status. Educates
clients in ways of using products and services. Quickly and effectively solves customer problems.
Develops trust and credibility with the customer.
?
Advanced (A): Researches the underlying needs of business partners and recommends options with
cost benefits. Leads initiatives and programs to meet and exceed customer’s expectations of
deliverables. Monitors performance trends and updates business partners and senior management on
progress. Educates clients in performance improvement opportunities offered by existing and new
technologies. Responds to escalated service issues and involves other subject matter experts as
needed. Develops and maintains strong relationships with customers. Ensures customer satisfaction.
?
Expert (E): Compares internal practices and performance trends with industry best practices. Assesses
the long-term needs of the enterprise, Approves and seeks consensus for options with cost benefits.
Lobbies for and sponsors enterprise programs to meet and exceed agreed standards. Reviews
performance trends and provides feedback to business leaders on progress and corrective strategies.
Educates business leaders in performance improvement opportunities offered by existing and new
technologies and services. Reviews escalated service response capability and procure subject matter
authorities as needed. Develops and sustains productive customer relationships.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 14
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Information Seeking: Gathers and analyzes information or data on current and future trends of best
practice. Seeks information on issues impacting the progress of organizational and process issues.
Translates up to date information into continuous improvement activities that enhance performance.
Being Developed (BD): Asks questions and solicits procedural information that explains how day-to-day
tasks are conducted. Collates facts and data. Checks and monitors progress of activities in area of
responsibility. Seeks out the appropriate people for guidance when needed to get things done.
Basic (B): Seeks information on both formal and informal processes. Uses appropriate tools, techniques
and sources to gather, update and monitor information. Checks for accuracy of interpretation. Seeks out
the appropriate people for guidance when needed depending on the type of issue.
Intermediate (I): Utilizes a variety of information and data sources pertaining to organizational and
professional trends. Checks the source for omission and accuracy. Identifies the sources that are
appropriate for specific types of information. Checks for bias and omission. Seeks out the appropriate
people to approach for guidance either formally or informally depending on the type of issue. Links
information in a lateral as well as linear manner. Finds hidden data. Relates and manipulates data from
various sources to create a fuller picture. Investigates and uncovers root causes of a problem or issue.
?
Advanced (A): Researches organizational and professional trends. Networks internally and externally
on areas of interest and concern. Evaluates sources, and collates and compares findings for bias,
omission and accuracy. Conducts objective analysis. Prioritizes information by source. Monitors
systematically. Deploys resources (time, people, and systems) to ensure timely management reporting.
Reviews and determines need for corrective action and/or business opportunities.
?
Expert (E): Studies environmental, business and technological trends and forecasts. Networks among
thought leaders and strategic influencers. Differentiates data sources for validity, reliability and credibility.
Tracks and synthesizes systemic benchmarking trends. Evaluates composite information in relation to its
impact on decision-making and strategic implications. Sets expectations for and reviews management
and key stakeholder reports. Assesses validity of business strategy recommendations against trend data.
Steers senior leadership toward making informed, sound strategic decisions.
?
Version 5
BI Engineer J ob Description December 1, 2015 – Page 15
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Innovation: Improves organizational performance though the application of original thinking to existing
and emerging methods, processes, products and services. Employs sound judgment in determining how
innovations will be deployed to produce return on investment.
Being Developed (BD): Participates in problem-solving discussions and suggests ideas as opportunities
arise. Accepts that new ways of doing things can improve individual and team results.
Basic (B): Reacts open-mindedly to new perspectives or ideas. Considers different or unusual solutions
when appropriate. Identifies opportunities for innovation and offers new ideas. Takes the initiative to
experiment.
?
Intermediate (I): Shares new ideas and consistently demonstrates openness to the opinions and views
of others. Identifies new and different patterns, trends, and opportunities. Generates solutions that build
upon, adapt, and go beyond tradition and status quo. Targets important areas for innovation and
develops solutions that address meaningful work issues. Seeks to involve other stakeholders in
developing solutions to problems. Takes calculated risks.
?
Advanced (A): Challenges conventional thinking and traditional ways of operating and invites
stakeholders to identify issues and opportunities. Helps others overcome resistance to change. Seeks
out opportunities to improve, streamline, reinvent work processes. Explores numerous potential solutions
and evaluates each before accepting any, as time permits. Maintains balance between innovation and
pragmatism when determining the practical application of new ideas. Makes lots of proposals, builds on
others’ ideas. Sees opportunities, open-minded. Develops new products or services, methods or
approaches. Develops better, faster, or less expensive ways to do things. Fosters a non-judgmental
environment that stimulates creativity.
?
Expert (E): Thinks expansively by combining ideas in unique ways or making connections between
disparate ideas. Devises unusual or radically different approaches to deliver value added solutions.
Analyzes previously used concepts, processes or trends and devises new efficiencies not obvious by
others. Directs creativity toward effective implementation of solutions. Creates a work environment that
encourages creative thinking and innovation. Sponsors the development of new products, services,
methods, or procedures. Exhibits creativity and innovation when contributing to organizational and
individual objectives. Employs sound judgment when selecting among various creative ideas for
implementation.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 16
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Problem Solving: Anticipates, identifies and defines problems. Seeks root causes. Develops and
implements practical and timely solutions.
Being Developed (BD): Asks questions and looks for data that helps to identify and differentiate the
symptoms and root causes of every day, defined problems. Suggests remedies that meet the needs of
the situation and those directly affected. Escalates issues appropriately.
Basic (B): Investigates defined issues with uncertain but limited cause. Solicits input in gathering data
that help identify and differentiate the symptoms and root causes of defined problems. Suggests
alternative approaches that meet the needs of the organization, the situation, and those involved.
Escalates issues with suggestions for further investigation and options for consideration.
?
Intermediate (I): Applies simple problem-solving methodologies to diagnose and solve operational and
interpersonal problems. Determines the potential causes of the problem and devises testing
methodologies for validation. Shows empathy and objectivity toward individuals involved in the issue.
Analyzes multiple alternatives, risks and benefits for a range of potential solutions. Recommends
resource requirements and collaborates with impacted stakeholders.
?
Advanced (A): Diagnoses problems using formal problem-solving tools and techniques from multiple
angles and probes underlying issues to generate multiple potential solutions. Proactively anticipates and
prevents problems. Devises, facilitates buy-in, makes recommendations and guides implementation of
corrective and/or preventive actions for complex issues that cross organizational boundaries and are
unclear in nature. Identifies potential consequences and risk levels. Gains support and buy-in for problem
definition, methods of resolution, and accountability.
?
Expert (E): Anticipates long-term problem areas and associated risk levels with objective rationale. Uses
formal methodologies to forecast trends and define innovative strategic choices in response to the
potential implications of multiple integrated options. Generates and solicits the approval of senior
leadership prior to defining critical issues and solutions to unclear, multi-faceted problems of high risk
which span across and beyond the enterprise.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 17
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Quality Assurance: Applies quality assurance, testing concepts, and methodologies. Constructs
comprehensive test plans based on a thorough understanding of business requirements. Imparts
confidence that a product optimally fulfills customers' expectations.
Being Developed (BD): Applies the basic concepts and methodologies of the quality assurance and
testing process. Seeks knowledge of quality assurance and testing functions methodologies and
standards within the organization. Conducts quality assurance and testing on software units based on
predefined test cases.
Basic (B): Applies concepts and methodologies surrounding quality assurance and testing. Creates test
plans and test cases for software units. Conducts assigned test cases, recording results. Discusses test
results with users, conveying the understanding of the importance that quality assurance plays in
providing confidence in the developing product.
?
Intermediate (I): Utilizes multiple approaches to quality assurance and testing. Demonstrates working
knowledge of tools used in the development of test plans. Documents outcomes and reviews with
stakeholders, demonstrating an understanding of the relationship between test plan construction and
fulfilling customer expectations.
?
Advanced (A): Proficient in the use of multiple test plan construction tools. Makes recommendations on
the test plan construction tools to utilize for a specific project. Performs quality assurance for multiple
areas ensuring proper integration of units. Provides guidance to team members on quality assurance
techniques and approaches testing complex applications.
?
Expert (E): Subject matter expert in the concepts and methodologies of quality assurance and testing.
Determines approach to test plan construction for complex projects that must be integrated. Monitors
industry trends and directions for developments in quality assurance and testing.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 18
For internal use of MIT only.
Any questions regarding this Report
should be addressed to:
Diana Hughes
Director of HR and Administration
Information Systems and Technology
Massachusetts Institute of Technology
(617) 253-6205
[email protected]
doc_436974581.pdf
Business Intelligence Engineer Job Description
For internal use of MIT only.
Business Intelligence Engineer J ob Description
December 1, 2015
Version 5
BI Engineer J ob Description December 1, 2015 – Page i
For internal use of MIT only.
Table of Contents
General Characteristics ................................................................................................ 1
Job Path ......................................................................................................................... 2
Explanation of Proficiency Level Definitions .............................................................. 7
Summary Proficiency Matrix ........................................................................................ 8
Proficiency Matrix ......................................................................................................... 9
Version 5
BI Engineer J ob Description December 1, 2015 – Page 1
For internal use of MIT only.
General Characteristics
Individuals within the Business Intelligence (BI) Engineer role work closely with customers and BI Analysts to turn data into critical
information and knowledge that can be used to make sound business decisions. They provide data that is accurate, congruent and
reliable and is easily accessible. BI professionals educate and train customers to use the data as an analytical tool, displaying the
information in new form and content for the purpose of analysis and exploring options.
The BI Engineer is responsible for the full life cycle development, implementation, production support, and performance tuning of the
Enterprise Data Warehouse, Data Mart, and Business Intelligence Reporting environments, and support the integration of those
systems with other applications. They design and implement reporting and analytical solutions, including both the design of table
structures and the processes used to populate those structures with data from internal and external sources. The data they provide
helps business teams drive improvement in key business metrics, customer experience and business results. BI Engineers also
interact with various development teams, project managers, internal and external customers, senior management, and external
vendors.
Members of this role understand how data is turned into information and knowledge and how the knowledge supports and enables
key business processes. They must have an in-depth understanding of the business environment, and strong analytical and
communication skills. Individuals must work well within a team environment.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 2
For internal use of MIT only.
Job Path
The following section is intended to serve as a general guideline for each relative dimension of project complexity, responsibility and
education/experience within this role. This table is not intended for use as a checklist to facilitate promotions or to define specific
responsibilities as outlined in a position description. Actual responsibilities and experiences may vary.
Title BI Engineer I BI Engineer II BI Engineer III
Dimension
Work Complexity
? Works on low to medium complex
and cross-functional BI solutions.
? Works multiple projects as a team
member.
? Works on medium to complex
and cross-functional BI solutions.
? Works multiple projects as a team
member, sometimes as a
technical lead.
? Works on highly complex and
cross-functional BI solutions.
? Directs, organizes, and leads
projects in the implementation
and use of new BI software
tools and systems.
Typical Responsibilities
Project/Work Planning
? Participates in or supports
workstream planning process.
? Participates in workstream
planning process including
inception, technical design,
development, testing, and
delivery of BI solutions.
? May participate in project
management estimation
process.
? Develops demand forecasts.
? Participates in workstream
planning process including
inception, technical design,
development, testing and delivery
of BI solutions.
? Develops work plans or reviews
other work plan timelines and
manages workflows to meet
timeframes.
? Participates in project
management estimation process.
? Manages and plans for service
demand forecasts.
? May participates in the
development of business cases
to support IT projects.
Business Requirements
? Works with BI Analysts to
understand customer needs.
? Works with BI Analysts to
understand customer needs.
? Analyzes business and
functional requirements and
translates these requirements
? Works with BI Analysts to
understand customer needs.
? Analyzes business and functional
requirements and translates these
Version 5
BI Engineer J ob Description December 1, 2015 – Page 3
For internal use of MIT only.
Title BI Engineer I BI Engineer II BI Engineer III
into robust, scalable, operable
solutions.
requirements into robust, scalable,
operable solutions.
Develop and Implement
? Collects, analyzes, and shares
data to help business teams drive
improvement in key business
metrics, customer experience, and
business results.
? Utilizes database and web
application technologies to
develop and evaluate innovative
business intelligence tools and
automated reports.
? Develops and tests BI solutions
such as databases, queries,
views, reports, and dashboards.
? Assists in data conversions,
imports, and exports of data within
and between internal and external
software systems.
? Documents new and existing
models, solutions, and
implementations.
? Design and build reporting and
analysis tools that help streamline
the business and make reporting,
analyzing, planning, and
forecasting more efficient.
? Supports and assists with the
integration of BI platforms with
enterprise systems and
applications.
? Collects, analyzes, and shares
data to help business teams drive
improvement in key business
metrics, customer experience, and
business results.
? Utilizes database and web
application technologies to
design, develop, and evaluate
innovative business intelligence
tools and automated reports.
? Designs, develops and tests BI
solutions such as databases, data
warehouses, queries and views,
reports, and dashboards.
? Performs data conversions,
imports, and exports of data within
and between internal and external
software systems.
? Merges BI platforms with
enterprise systems and
applications.
? Enhances the performance of
business intelligence tools by
defining data to filter and
indexes.
? Documents new and existing
models, solutions, and
implementations.
? Collects, analyzes, and shares
data to help business teams drive
improvement in key business
metrics, customer experience, and
business results.
? Works with the BI Analyst
during implementation,
gathering additional information
when needed and keeping the
business informed.
? Implements data structures
using best practices in data
modeling, processes, and
technologies.
? Performs data conversions,
imports and exports of data within
and between internal and external
software systems.
? Implements tools and
frameworks for automating
report generation, identification
of data-quality issues, and data-
governance.
? Leads the integration efforts for
merging BI platforms with
enterprise systems and
applications.
? Performs data conversions,
imports, and exports of data within
and between internal and external
software systems.
? Explores the data and discovers
patterns, meaningful
Version 5
BI Engineer J ob Description December 1, 2015 – Page 4
For internal use of MIT only.
Title BI Engineer I BI Engineer II BI Engineer III
relationships, anomalies, and
trends.
? Performs programming
analyses for a wide range of
requests using data in different
formats and from various
platforms.
? Ensures documentation is
created and maintained.
Production Support
? Troubleshoots BI tools, systems,
and software.
? Tracks performance and
production issues.
? May assist in performance tuning
of BI applications.
? Escalates production issues as
appropriate.
? Troubleshoots BI tools, systems,
and software.
? Troubleshoots reported data
loads or reconciliation
inconsistencies in conjunction
with the sites for data models
and/or reports.
? Tracks, monitors and analyzes
performance and production
issues, and implements
improvements.
? Supports and helps manage
external resources, such as
service providers and vendor
support.
? Troubleshoots BI tools, systems,
and software.
? Troubleshoots reported data loads
or reconciliation inconsistencies in
conjunction with the sites for data
models and/or reports.
? Tracks, monitors and analyzes
performance and production
issues, and implements
improvements.
? Supports and helps manage
external resources, such as
service providers and vendor
support.
Quality Assurance
? Ensures the collected data is
within required quality standards.
? May maintain the quality of
Metadata Repository by adding,
modifying, and deleting data.
? Ensures the collected data is
within required quality standards.
? Maintains the quality of Metadata
Repository by adding, modifying,
and deleting data.
? Provides input to the
development of
data/information quality
metrics.
? Ensures the collected data is
within required quality standards.
? Maintains the quality of Metadata
Repository by adding, modifying,
and deleting data.
? Recommends quality metrics and
ensures quality metrics are
documented and tracked.
Process, Policies &
Standards
? Adheres to process, policies, and
standards.
? Provides input and adheres to
process, policies, and standards.
? Creates scalable, efficient,
automated processes for large
scale data analyses, model
Version 5
BI Engineer J ob Description December 1, 2015 – Page 5
For internal use of MIT only.
Title BI Engineer I BI Engineer II BI Engineer III
development, model validation,
and model implementation.
? Documents standards and
policies for the form, structure,
and attributes of the BI tools and
systems.
? Ensures adherence to process,
policies, and standards.
Customer Service
? Keeps customer informed about
business intelligence tool
problems and resolutions.
? Tracks and reports out on issues
and enhancement request for the
business in a timely manner.
? Keeps customer informed about
business intelligence tool
problems and resolutions.
? Tracks and reports out on issues
and enhancement request for the
business in a timely manner.
? Works closely with customers
and BI Analysts to create ad
hoc reports to support timely
business decisions and project
work.
? Keeps customer informed about
business intelligence tool
problems and resolutions.
? Tracks and reports out on issues
and enhancement request for the
business in a timely manner.
? Works closely with customers and
BI Analysts to create ad hoc
reports to support timely business
decisions and project work.
Research/Evaluation
? Analyzes and tests new
releases/versions of software.
? May participate in vendor
evaluations.
? Conducts research and makes
recommendations on BI
products and services.
? Interfaces with vendors to keep
abreast of new technologies,
pricing, and customer
applicability.
? Analyzes and tests new
releases/versions of software.
? Participates in vendor evaluations.
? Analyzes and tests new
releases/versions of software.
? Conducts research and makes
recommendations on BI products
and services.
? Interfaces with vendors to keep
abreast of new technologies,
pricing, and customer applicability.
? Participates in vendor evaluations.
? Interfaces with Architects to
recommend new technology
opportunities that will have an
impact on BI systems.
Training
? May train customers in the use of
the business intelligence tools to
? Designs and delivers end-user
training and training materials.
? Designs and delivers end-user
training and training materials.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 6
For internal use of MIT only.
Title BI Engineer I BI Engineer II BI Engineer III
enhance business decision-
making capability.
? Trains users to transform data
into action-oriented information
and to use that information
correctly.
? Trains users to transform data into
action-oriented information and to
use that information correctly.
Coaching/Mentoring
? Provides guidance, training, and
problem solving assistance to
other team members.
? Provides coaching to less-
experienced individuals.
? Provides guidance, training, and
problem solving assistance to
other team members.
? Provides coaching to less-
experienced individuals.
TYPICAL EDUCATION/
EXPERIENCE
? Bachelor's degree in Computer
Science, Information Systems,
Business Management or
specialized training/certification.
Or equivalent work experience.
? Typically requires 3-5 years’ of
related technical experience.
? Knowledge of one business
functional areas.
? Experience with database
administration.
? Knowledge of business
intelligence tools and systems
required.
? Bachelor's degree in Computer
Science, Information Systems,
Business Management,
Mathematics or specialized
training/certification. Or equivalent
work experience.
? Typically requires 5-7 years’ of
related technical experience.
? Knowledge of one or more
business functional areas.
? Advanced skills in data analysis
and data mining.
? Hands-on experience supporting
or working with Business
Intelligence/Data Warehousing
environments.
? Bachelor's degree in Computer
Science, Information Systems,
Business Management,
Mathematics or specialized
training/certification. Or equivalent
work experience.
? Typically requires 7 or more year
of related technical experience.
? At least 3 years of experience
supporting a major system.
? In-depth knowledge of the
industry and multiple business
functional areas.
? Expert skills in data analysis and
data mining.
? Hands-on experience supporting
or working with Business
Intelligence/Data Warehousing
environments.
? Experience leading teams.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 7
For internal use of MIT only.
Explanation of Proficiency Level Definitions
Proficiency scale definitions are provided to help determine an individual’s proficiency level in a specific competency. The rating
scale below was created as a foundation for the development of proficiency level definitions used for assessments.
Being Developed: (BD)
Demonstrates minimal use of this competency; limited knowledge of subject matter area; needs frequent
assistance and close supervision for direction. Currently developing competency.
Basic: (B)
Demonstrates limited use of this competency; basic familiarity of subject matter area; needs additional
training to apply without assistance or with frequent supervision.
Intermediate: (I)
Demonstrates working or functional proficiency level sufficient to apply this competency effectively without
assistance and with minimal supervision; working/functional knowledge of subject matter area.
Advanced: (A)
Demonstrates in-depth proficiency level sufficient to assist, consult to, or lead others in the application of
this competency; in-depth knowledge in subject matter area.
Expert: (E)
Demonstrates broad, in-depth proficiency sufficient to be recognized as an authority or master performer in
the applications of this competency; recognized authority/expert in subject matter area.
As you complete the competency assessment, read all of the proficiency level definitions for a competency (provided in the next
section) and select the one that is most characteristic of the demonstrated performance. If more than one definition is descriptive,
select the highest level that is typically exhibited.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 8
For internal use of MIT only.
Summary Proficiency Matrix
The chart provides a summary of proficiency ratings.
Title
BI
Engineer
I
BI
Engineer
II
BI
Engineer
III
Competency
Analytical Thinking: Able to breakdown raw information and undefined problems into specific, workable
components that in-turn clearly identifies the issues at hand. Makes logical conclusions, anticipates
obstacles and considers different approaches that are relevant to the decision making process.
I A E
Business Function Knowledge: Uses an understanding of business functions to analyze and propose
technical strategies for the business. Assesses benefits, risks, and costs.
B I A
Consulting: Uses professional knowledge, experience and technical expertise to respond to questions,
facilitate problem-solving, and generally advise, influence and provide guidance to customers and
business partners over whom there is no direct authority.
B I A
Customer Service Orientation: Identifies the ongoing needs of internal and/or external clients. Ensures
these needs are met or exceeded.
B I A
Information Seeking: Gathers and analyzes information or data on current and future trends of best
practice. Seeks information on issues impacting the progress of organizational and process issues.
Translates up to date information into continuous improvement activities that enhance performance.
I A E
Innovation: Improves organizational performance though the application of original thinking to existing
and emerging methods, processes, products and services. Employs sound judgment in determining how
innovations will be deployed to produce return on investment.
B I A
Problem Solving: Anticipates, identifies and defines problems. Seeks root causes. Develops and
implements practical and timely solutions.
B I A
Quality Assurance: Applies quality assurance, testing concepts, and methodologies. Constructs
comprehensive test plans based on a thorough understanding of business requirements. Imparts
confidence that a product optimally fulfills customers' expectations.
B I A
Version 5
BI Engineer J ob Description December 1, 2015 – Page 9
For internal use of MIT only.
Proficiency Matrix
The following charts illustrate proficiency levels for each competency.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Competency
Analytical Thinking: Able to breakdown raw information and undefined problems into specific, workable
components that in-turn clearly identifies the issues at hand. Makes logical conclusions, anticipates
obstacles and considers different approaches that are relevant to the decision making process.
Being Developed (BD): Gathers and links data. Reviews for non-conformity and gathers further
information in response to routine problems. Identifies direct cause and effect relationships. Breaks down
tasks and problems into manageable components. Solicits guidance as needed to assess importance
and urgency. Escalates issues of a non-routine nature as needed.
Basic (B): Collates and reports information. Solicits guidance to define criteria and assign values of
importance and urgency. Sorts information in order of importance. Investigates to define problems more
accurately. Identifies trends and exceptions. Identifies relationships and linkages between components.
Identifies variable potential causes and effects. Escalates issues of an exceptional nature.
Intermediate (I): Coordinates the information gathering and reporting process. Reviews trends and
compares to expectations. Conducts research to define problems and prepares responses to anticipated
questions. Prioritizes multiple issues and opportunities. Identifies relationships and linkages within
several information sources. Anticipates issues that are not readily apparent on the surface. Identifies
root causes and effects. Defines priorities within performance objectives. Reports and identifies areas
that need guidance in order to resolve complex issues. Anticipates the possible outcome of potential
solutions.
?
Advanced (A): Determines criteria for assessing issues and opportunities. Establishes clear goals and
priorities needed to assess performance. Identifies relationships and linkages between different
information sources. Anticipates issues that are not readily apparent on the surface. Identifies root
causes and effects. Establishes clear goals and priorities. Anticipates potential problems and develops
solutions needed to resolve them. Systemically analyzes relationships between apparently independent
problems and issues. Reviews and cross-reviews reports. Identifies trends as well as isolated events.
Translates analytical reports into management presentations, and provides guidance to resolve issues.
Anticipates the possible outcome of potential solutions. Identifies areas of significant concern or
opportunity. Probes and initiates research to identify critical problems.
?
Version 5
BI Engineer J ob Description December 1, 2015 – Page 10
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Expert (E): Establishes strategic goals and enterprisewide priorities. Uses techniques of advanced
business and organizational analysis to identify and assess problem definitions and potential solutions,
and compares and contrasts them against predetermined criteria. Creates framework for reviewing large
volumes of unorganized data. Probes for and points to subtle and unclear relationships in highly complex
matters and evaluates the merit of problem definitions and potential solutions. Anticipates the possible
outcome of potential solutions. Systemically identifies and resolves complex enterprisewide issues, while
educating senior leaders as to their solution.
?
Version 5
BI Engineer J ob Description December 1, 2015 – Page 11
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Business Function Knowledge: Uses an understanding of business functions to analyze and propose
technical strategies for the business. Assesses benefits, risks, and costs.
Being Developed (BD): Asks questions to determine the needs of a specific business function.
Assessed the impact on business functional requirements prior to taking action.
Basic (B): Assesses the needs of primary business functions. Suggests technical solutions for business
functions, and implements action plans to improve ongoing business performance in ways that minimize
day-to-day disruption of operations.
?
Intermediate (I): Involves the key players in identifying operating needs, issues and solutions. Proposes
technical plans that are aligned with business objectives and technical requirements. Takes and leads
actions to enhance business function standards and performance with the participation of business and
technical partners.
?
Advanced (A): Engages business and technical leaders in the identification of medium-term business
solutions consistent with best practices for cross-functional implementation. Sets the direction for and
steers medium-term enhancements of integrated standards and significant business performance drivers
across multiple areas of responsibility.
?
Expert (E): Participates in setting the strategic direction of and drivers for multiple lines of business.
Applies superior industry benchmarks to proposals for organization-wide initiatives. Sponsors capital
intensive, strategic business change. Reviews long-term business and technical solutions proactively.
Evaluates high-risk proposals and defines parameters for contingency plans that ensure seamless
change to the enterprise.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 12
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Consulting: Uses professional knowledge, experience and technical expertise to respond to questions,
facilitate problem solving, and generally advice, influence and provide guidance to customers and
business partners over whom there is no direct authority.
Being Developed (BD): Shares information in relation to procedures and routine activities. Provides
guidance and advice. Suggests caution as appropriate. Asks questions that raise awareness and
demonstrate insight.
Basic (B): Shares information and reports on the immediate situation. Provides feedback and advice as
appropriate in relation to procedures and routine activities. Asks questions that raise awareness and
demonstrate insight.
?
Intermediate (I): Conducts investigations and interprets issues within operational and professional
contexts. Provides guidance and counsel. Suggests caution to impacted areas as appropriate in relation
to matters of policy interpretation and implementation of operational improvement. Conducts discussions
that share information and trigger solutions and improvements.
?
Advanced (A): Leads research and summarizes requirements for the engagement. Interprets issues
within the framework of core business processes. Provides substantiated, risk-assessed options and
counsel in relation to process enhancement and professional expertise. Facilitates dialogues that
produce new perspectives and trigger recommendations for substantial innovative enhancements and
analysis of consequences.
?
Expert (E): Collaborates with clients to determine the scope of engagement. Advises senior leaders on
environmental analysis, planning opportunities, and implementation considerations for strategic
interventions. Researches long-range world-class business and technology trends. Uses formal
techniques of facilitation and analysis to assist leadership in criterion-based decision-making and
strategic planning.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 13
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Customer Service Orientation: Identifies the ongoing needs of internal and/or external clients. Ensures
these needs are met or exceeded.
Being Developed (BD): Asks questions in response to clients' requests for assistance on day-to-day
needs. Responds promptly and courteously. Updates clients on progress. Solicits support and guidance
as needed and refers client requests appropriately.
Basic (B): Asks questions and conducts investigations in response to clients' requests for assistance on
day-to-day needs. Responds promptly and courteously. Updates clients on progress. Instructs clients on
products and services and how to apply them to their business processes. Escalates to appropriate
parties as needed. Makes customers and their needs a primary focus of one's actions.
?
Intermediate (I): Asks questions and conducts investigations in order to understand clients' specific
needs and provides prompt, attentive service. Understands client’s expectations and takes initiatives to
meet and exceed them. Monitors progress and updates client and management as to status. Educates
clients in ways of using products and services. Quickly and effectively solves customer problems.
Develops trust and credibility with the customer.
?
Advanced (A): Researches the underlying needs of business partners and recommends options with
cost benefits. Leads initiatives and programs to meet and exceed customer’s expectations of
deliverables. Monitors performance trends and updates business partners and senior management on
progress. Educates clients in performance improvement opportunities offered by existing and new
technologies. Responds to escalated service issues and involves other subject matter experts as
needed. Develops and maintains strong relationships with customers. Ensures customer satisfaction.
?
Expert (E): Compares internal practices and performance trends with industry best practices. Assesses
the long-term needs of the enterprise, Approves and seeks consensus for options with cost benefits.
Lobbies for and sponsors enterprise programs to meet and exceed agreed standards. Reviews
performance trends and provides feedback to business leaders on progress and corrective strategies.
Educates business leaders in performance improvement opportunities offered by existing and new
technologies and services. Reviews escalated service response capability and procure subject matter
authorities as needed. Develops and sustains productive customer relationships.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 14
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Information Seeking: Gathers and analyzes information or data on current and future trends of best
practice. Seeks information on issues impacting the progress of organizational and process issues.
Translates up to date information into continuous improvement activities that enhance performance.
Being Developed (BD): Asks questions and solicits procedural information that explains how day-to-day
tasks are conducted. Collates facts and data. Checks and monitors progress of activities in area of
responsibility. Seeks out the appropriate people for guidance when needed to get things done.
Basic (B): Seeks information on both formal and informal processes. Uses appropriate tools, techniques
and sources to gather, update and monitor information. Checks for accuracy of interpretation. Seeks out
the appropriate people for guidance when needed depending on the type of issue.
Intermediate (I): Utilizes a variety of information and data sources pertaining to organizational and
professional trends. Checks the source for omission and accuracy. Identifies the sources that are
appropriate for specific types of information. Checks for bias and omission. Seeks out the appropriate
people to approach for guidance either formally or informally depending on the type of issue. Links
information in a lateral as well as linear manner. Finds hidden data. Relates and manipulates data from
various sources to create a fuller picture. Investigates and uncovers root causes of a problem or issue.
?
Advanced (A): Researches organizational and professional trends. Networks internally and externally
on areas of interest and concern. Evaluates sources, and collates and compares findings for bias,
omission and accuracy. Conducts objective analysis. Prioritizes information by source. Monitors
systematically. Deploys resources (time, people, and systems) to ensure timely management reporting.
Reviews and determines need for corrective action and/or business opportunities.
?
Expert (E): Studies environmental, business and technological trends and forecasts. Networks among
thought leaders and strategic influencers. Differentiates data sources for validity, reliability and credibility.
Tracks and synthesizes systemic benchmarking trends. Evaluates composite information in relation to its
impact on decision-making and strategic implications. Sets expectations for and reviews management
and key stakeholder reports. Assesses validity of business strategy recommendations against trend data.
Steers senior leadership toward making informed, sound strategic decisions.
?
Version 5
BI Engineer J ob Description December 1, 2015 – Page 15
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Innovation: Improves organizational performance though the application of original thinking to existing
and emerging methods, processes, products and services. Employs sound judgment in determining how
innovations will be deployed to produce return on investment.
Being Developed (BD): Participates in problem-solving discussions and suggests ideas as opportunities
arise. Accepts that new ways of doing things can improve individual and team results.
Basic (B): Reacts open-mindedly to new perspectives or ideas. Considers different or unusual solutions
when appropriate. Identifies opportunities for innovation and offers new ideas. Takes the initiative to
experiment.
?
Intermediate (I): Shares new ideas and consistently demonstrates openness to the opinions and views
of others. Identifies new and different patterns, trends, and opportunities. Generates solutions that build
upon, adapt, and go beyond tradition and status quo. Targets important areas for innovation and
develops solutions that address meaningful work issues. Seeks to involve other stakeholders in
developing solutions to problems. Takes calculated risks.
?
Advanced (A): Challenges conventional thinking and traditional ways of operating and invites
stakeholders to identify issues and opportunities. Helps others overcome resistance to change. Seeks
out opportunities to improve, streamline, reinvent work processes. Explores numerous potential solutions
and evaluates each before accepting any, as time permits. Maintains balance between innovation and
pragmatism when determining the practical application of new ideas. Makes lots of proposals, builds on
others’ ideas. Sees opportunities, open-minded. Develops new products or services, methods or
approaches. Develops better, faster, or less expensive ways to do things. Fosters a non-judgmental
environment that stimulates creativity.
?
Expert (E): Thinks expansively by combining ideas in unique ways or making connections between
disparate ideas. Devises unusual or radically different approaches to deliver value added solutions.
Analyzes previously used concepts, processes or trends and devises new efficiencies not obvious by
others. Directs creativity toward effective implementation of solutions. Creates a work environment that
encourages creative thinking and innovation. Sponsors the development of new products, services,
methods, or procedures. Exhibits creativity and innovation when contributing to organizational and
individual objectives. Employs sound judgment when selecting among various creative ideas for
implementation.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 16
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Problem Solving: Anticipates, identifies and defines problems. Seeks root causes. Develops and
implements practical and timely solutions.
Being Developed (BD): Asks questions and looks for data that helps to identify and differentiate the
symptoms and root causes of every day, defined problems. Suggests remedies that meet the needs of
the situation and those directly affected. Escalates issues appropriately.
Basic (B): Investigates defined issues with uncertain but limited cause. Solicits input in gathering data
that help identify and differentiate the symptoms and root causes of defined problems. Suggests
alternative approaches that meet the needs of the organization, the situation, and those involved.
Escalates issues with suggestions for further investigation and options for consideration.
?
Intermediate (I): Applies simple problem-solving methodologies to diagnose and solve operational and
interpersonal problems. Determines the potential causes of the problem and devises testing
methodologies for validation. Shows empathy and objectivity toward individuals involved in the issue.
Analyzes multiple alternatives, risks and benefits for a range of potential solutions. Recommends
resource requirements and collaborates with impacted stakeholders.
?
Advanced (A): Diagnoses problems using formal problem-solving tools and techniques from multiple
angles and probes underlying issues to generate multiple potential solutions. Proactively anticipates and
prevents problems. Devises, facilitates buy-in, makes recommendations and guides implementation of
corrective and/or preventive actions for complex issues that cross organizational boundaries and are
unclear in nature. Identifies potential consequences and risk levels. Gains support and buy-in for problem
definition, methods of resolution, and accountability.
?
Expert (E): Anticipates long-term problem areas and associated risk levels with objective rationale. Uses
formal methodologies to forecast trends and define innovative strategic choices in response to the
potential implications of multiple integrated options. Generates and solicits the approval of senior
leadership prior to defining critical issues and solutions to unclear, multi-faceted problems of high risk
which span across and beyond the enterprise.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 17
For internal use of MIT only.
Title
BI
Engineer I
BI
Engineer
II
BI
Engineer
III
Quality Assurance: Applies quality assurance, testing concepts, and methodologies. Constructs
comprehensive test plans based on a thorough understanding of business requirements. Imparts
confidence that a product optimally fulfills customers' expectations.
Being Developed (BD): Applies the basic concepts and methodologies of the quality assurance and
testing process. Seeks knowledge of quality assurance and testing functions methodologies and
standards within the organization. Conducts quality assurance and testing on software units based on
predefined test cases.
Basic (B): Applies concepts and methodologies surrounding quality assurance and testing. Creates test
plans and test cases for software units. Conducts assigned test cases, recording results. Discusses test
results with users, conveying the understanding of the importance that quality assurance plays in
providing confidence in the developing product.
?
Intermediate (I): Utilizes multiple approaches to quality assurance and testing. Demonstrates working
knowledge of tools used in the development of test plans. Documents outcomes and reviews with
stakeholders, demonstrating an understanding of the relationship between test plan construction and
fulfilling customer expectations.
?
Advanced (A): Proficient in the use of multiple test plan construction tools. Makes recommendations on
the test plan construction tools to utilize for a specific project. Performs quality assurance for multiple
areas ensuring proper integration of units. Provides guidance to team members on quality assurance
techniques and approaches testing complex applications.
?
Expert (E): Subject matter expert in the concepts and methodologies of quality assurance and testing.
Determines approach to test plan construction for complex projects that must be integrated. Monitors
industry trends and directions for developments in quality assurance and testing.
Version 5
BI Engineer J ob Description December 1, 2015 – Page 18
For internal use of MIT only.
Any questions regarding this Report
should be addressed to:
Diana Hughes
Director of HR and Administration
Information Systems and Technology
Massachusetts Institute of Technology
(617) 253-6205
[email protected]
doc_436974581.pdf