Main Responsibilities and Required Skills for Business Intelligence Analyst
A business intelligence analyst is responsible for analyzing complex business problems to be solved with automated Business Intelligence solutions. They apply statistical analysis, simulations, and predictive modelling to analyze large amounts of information. In this blog post we describe the primary responsibilities and the most in-demand hard and soft skills for business intelligence analysts.
Get market insights and compare skills for other jobs here.
Main Responsibilities of Business Intelligence Analyst
The following list describes the typical responsibilities of a Business Intelligence Analyst:
Acquire
Acquire data from primary or secondary data sources and maintain databases / data systems.
Analyze
Analyze client data, run quantitative analyses, and develop savings analysis.
Analyze data incidences and processes to optimize BI solutions and complexity reductions.
Analyze, diagnose, follow up on and resolve critical and complex system problems.
Analyze information, conduct studies, develop and make recommendations, and draft reports.
Analyze, design, and develop well-defined methods and procedures for service related activities.
Analyze support tickets to identify trends and manage requests for data and reporting needs.
Analyze testing results to ensure the solution meets the needs of the business.
Analyze trends of monthly Key Performance Indicator results for performance improvement concepts.
Animate
Animate transversal actions to improve BI tools and processes.
Anticipate
Anticipate changes and future trends and potential impact and communicate accordingly.
Anticipate logical outcomes and impacts of proposed solutions mitigating need for change management.
Architect
Architect and build a web based execution mechanism for reports.
Assist in / Assist with
Assist in assessing departmental work flows and system implementation.
Assist in defining strategies and executing tasks and projects.
Assist in project planning and estimating.
Assist interfacing departments in implementation and execution of projects.
Assist in the client on-boarding process from pre-sale to transition.
Assist in the database upgrades, patching, and support.
Assist in the development of ad-hoc reports per need basis.
Assist Product Management and Sales with developing responses to complex bids.
Assist with actionable KPIs, tracking and creating more efficient and automated workflows.
Assist with ad-hoc analysis and presentation requests.
Assist with implementation of data quality improvement processes and initiatives.
Assist with logical and physical data modeling to support business initiatives.
Assist with training materials, and demonstrations.
Assure
Assure data quality, security, and compliance requirements are met.
Attend
Attend and present best practices and thought leadership at one of our world-class marketing events.
Automate
Automate and streamline manual data load processes.
Build
Build analytic systems and predictive models.
Build and develop dashboards, Power BI data models and self serve data pipelines.
Build and Maintain reports using SQL Server Reporting Services.
Build a social media presence and individual brand around this space.
Build, expand and maintain existing reports.
Build interactive program dashboards.
Build, maintain and improve financial forecasting models.
Build Power BI / Tableau Dashboards from scratch and maintain existing reporting.
Build, test and migrate reports.
Build work flow to construct data as needed and creatively visualize data to non-tech audience.
Capture
Capture and document business requirements for new organizational reports / tools.
Certify
Certify the availability, security, and performance of both legacy and cloud-based systems.
Choose
Choose appropriate underlying technology to model complex data.
Clarify
Clarify data inconsistencies and offer technical assistance / expertise as necessary.
Coach
Coach BI Executives to ensure they're learning and growing in their careers.
Collaborate with
Collaborate with BI leadership to triage, approve, and charter programs and projects.
Collaborate with business, third party and IT staff on complex data delivery solutions.
Collaborate with colleagues in designing solutions that meet the established business needs.
Collaborate with systems architects and analysts in conceptualizing and developing solutions.
Collaborate with team members to enhance expertise.
Collaborate with teams to integrate systems.
Collect
Collect, organize, and compile data into a series of reports that are distributed on a timely basis.
Combine
Combine internal and external data sources to understand the competitive landscape and behavior.
Communicate
Communicate effectively, Interpersonal Savvy, Plans and aligns, Strategic mindset.
Communicate issues, risks, and concerns proactively to management.
Communicate results and ideas to key decision makers.
Communicate results and impacts of data initiatives to internal and external stakeholders.
Communicate scope, changes and numbers clearly.
Communicate task status, roadblocks, and critical matters to management promptly.
Communicate the findings to senior management and others in the organization.
Communicate with Business and Marketing stakeholders to gather and assess requirements.
Complete
Complete ad hoc analyses for senior and executive management using SQL / SAS.
Conduct
Conduct analysis to provide enhanced BI to inform management leadership team.
Conduct program / Application gap analysis.
Conduct regular reviews to ensure business needs are met.
Connect
Connect different data sources, import data, and transform data for Business Intelligence.
Consult
Consult on a variety of reporting request from various team.
Consult with customers to understand their data needs and / or business questions.
Contribute to
Contribute to setting up our new data platform in Azure.
Contribute to the completion of organizational projects & goals.
Contribute to the development and evolution of our data warehouse and BI analytics platform.
Contribute to the development of the data warehouse.
Co-operate
Co-operate with colleagues and shares resources.
Coordinate
Coordinate and manages the business intelligence team's daily activities and operating budget.
Coordinate requests, gathers documents and business requirements for new reporting needs.
Craft
Craft and execute queries upon request for data.
Create
Create accurate reports that are audience appropriate.
Create actionable business intelligence tools and reports.
Create a Logical Data Model for the Medicaid Enterprise.
Create and maintain current- and target-state data architectures.
Create and maintain documentation including requirements, design and user manuals.
Create and maintain key program reports.
Create and maintains effective, detailed design documentation.
Create an Information Capability Matrix for the Medicaid Enterprise.
Create Bi Reports (Both automated and semi - automated).
Create data visualizations.
Create, describe, and maintain applicable system architecture and design artifacts.
Create documentation that allows teams to duplicate or replicate processes if necessary.
Create documentation to support knowledge sharing.
Create effective data visualizations, trends, and tables that intuitively convey insights in seconds.
Create gap action plans as needed to maintain compliance with division procedures to mitigate risk.
Create mock-up reports for proof of concept reviews.
Create regular communication plans (research, client engagement, events, etc.).
Create relational and dimensional models for BI related projects.
Create reports and dashboards in Oracle, Salesforce and Tableau.
Create visualizations and reports for requested projects.
Create visualizations and reports to communicate findings.
Create visualizations utilizing Tableau / Power BI tools.
Define
Define appropriate technical approaches and solutions to projects and business initiatives.
Define audit processes for data to ensure that it is current and relevant.
Define standards and procedures for best practices for business intelligence design & development.
Define the business intelligence strategic roadmap for Insurance Solutions and lead its execution.
Delete
Delete documents in existing directories; and Define dictionaries and use dictionaries.
Demonstrate
Demonstrate and document to end users on dashboard solutions, navigation and integrations.
Design
Design and build new dashboards to monitor performance metrics.
Design and deliver data solutions to support Incentive Design and Performance Management strategies.
Design and develop optimized data models, structures and coding techniques to improve efficiency.
Design and maintain Executive Tableau dashboards.
Design business intelligence dashboards to measure account performance.
Design data warehouse solutions.
Design intuitive and elegant visualizations that communicate actionable insights to business leaders.
Design / Maintain a Data Warehouse to centralise reporting data.
Design the layout for reports on the system.
Determine
Determine business intelligence and data warehousing solutions to meet business needs.
Determine critical project criteria to ensure project completion.
Determine the best course of action to ensure resolution meets established standards.
Develop
Develop advanced data visualizations using best practices to effectively solve business problems.
Develop analytics strategy and roadmaps in support of future business goals and objectives.
Develop and document best practices, scale processes with growth of the organization.
Develop and maintain dashboard design specification documents.
Develop and maintain ETL scripts that will synchronize data between internal systems.
Develop appropriate visuals / media for reviews, country visits, local meetings.
Develop automated tools and visualizations to provide real-time insights to business data.
Develop BI solutions using Tableau, Power BI, QLIK, or other platforms.
Develop code that is reusable, easily testable and highly efficient.
Develop custom data tools in Excel.
Develop custom SQL views, Tableau workbooks and publish BI applications.
Develop data and business intelligence visualizations relevant to the industry and customers demands.
Develop database solutions for both operational and analytical systems.
Develop ETL routines using SSIS to populate a data warehouse.
Develop, execute, and document test plans.
Develop, implement and maintain best practices and standard for delivery of quality BI solutions.
Develop implementation and operation support plans.
Develop, implement, enhance, maintain Business Intelligence reporting and dashboards.
Develop innovative team solutions to complex problems.
Develop interactive dashboards with drill-down capability.
Develop machine learning applications as per requirements.
Develop, maintain, and enhance database modules, system components, and data warehouse models.
Develop new reports, dashboards, and KPI scorecards using Power BI or similar tools.
Develop or support development of dashboards, visualizations and reports based on those requirements.
Develop policies and procedures for the collection of new data sources.
Develop Power BI reports using SSAS as a data source.
Develop Productivity Roll Forwards and reconciliations for Xylem Inc. with Segment analysis.
Develop protocol on how to best filter and variance.
Develop self serve data and reports for business users.
Develop SQL queries using Oracle to source data from enterprise and local systems.
Develop SSRS reports, Tableau reports and views.
Develop Tableau reports and support the administration of Tableau Server environment.
Develop trusted partnerships with business leaders based on collaboration and knowledge of business.
Develop, updates and coordinates the preparation of related educational and training materials.
Develop working knowledge of industry practices and standards.
Diagnose
Diagnose and resolve BI tool capacity issues.
Diagnose and support the resolution of Reporting / BI system defects identified by users.
Dig
Dig deep into the data to produce actionable insights based on your analysis.
Direct
Direct, organize, and lead projects in the implementation of business intelligence platforms.
Document
Document best practices for development and administration of the Tableau platform.
Document BI application dataflow, data schema and ETL processes.
Document business and technology roadmaps for the BI team.
Document requirements in a standardized manner (e.g. data dictionaries).
Document use cases and develop relevant wireframes.
Draft
Draft functional design documents with support from Solution Architect.
Drive
Drive data integration into a single source (Data Lake) which is based on SAP BW / HANA.
Educate
Educate and train users on our data and analytics tools.
Educate relevant stakeholders on general commission knowledge & principles.
Engage with
Engage with clients on highly complex or escalated requests.
Engage with people who make a difference.
Engage with upper management to support them in answering business questions.
Ensure
Ensure accurate and timely payment of incentive.
Ensure all database programs meet defined IT standards and performance requirements.
Ensure appropriate stimuli & respondent-friendly design.
Ensure effective end-to-end resolution of commission discrepancies within a reasonable time frame.
Ensure gathering and documenting learnings from issue management.
Ensure quality standards across both data and report functionality.
Ensure regulated compliance processes and procedures are established and followed.
Ensure report developers follows best practices.
Ensure software quality by efficiently identifying software defects and data quality issues.
Ensure strong linkage with and support of Client's Performance Management COE.
Ensure that applications inventory is kept updated with correct information.
Ensure that project submissions are original work and have not been plagiarized.
Ensure that systems and changes implemented do not expose Finning to unknown corporate risk.
Ensure that the core mission of availability, security, and performance drives team activities.
Ensure that the data presented to partners is relevant, clear and useful for decision making.
Ensure that the objectives are available at the beginning of each cycle.
Ensure the quality and accuracy of deliverables sent to users.
Ensure the stability and continuity of data ETL operation.
Ensure the validity and integrity of reports.
Ensure timely communication of issues / points of Interest.
Establish
Establish a robust reporting methodology to support business initiatives.
Establish best practices and standards for reporting and dashboard creation at HTC.
Establish, optimize and / or monitor key performance indicators (KPI).
Establish policies and make recommendations to the decision-making bodies and committees concerned.
Establish relationships with key business partners / Points of Contact to accelerate issues fix.
Evaluate
Evaluate and improve existing BI reports and dashboards.
Evaluate and improve existing BI systems.
Evaluate observations and prepares applicable reporting documents.
Examine
Examine the metrics that drive the business and you propose ways to improve them.
Execute
Execute database queries and conduct analyses.
Explore
Explore the data and understand how different tables relate.
Expose
Expose low-level roadblocks in system designs, and provide options to address the issues.
Extract
Extract business data and reports according to the KPIs.
Extract, transform, load, and maintain data from numerous and varied sources in the data warehouse.
Facilitate
Facilitate and contribute to product selection in BI architecture-related areas.
Facilitate workshops and discussions with clients to understand reporting needs.
Follow
Follow the data governance and integration rules.
Foster
Foster an environment that promotes teamwork.
Gather
Gather, analyze and document business requests, issues, and requirements.
Gather, document and define business requirements from diverse stakeholders.
Gather reporting requirements from business users.
Guide
Guide the development design activities with input and data dependencies.
Guide the team in creating initial R Programming Language models.
Help
Help clients best utilize the SwiftIQ platform to answer key business questions.
Help shape the account team's Six Sigma or process management approach.
Help us to keep moving the needle!.
Help with regression testing of reports during upgrades.
Identify
Identify and implement process improvements.
Identify and / or perform data cleansing to identify and understand anomalies.
Identify opportunities and establish a sales pipeline.
Identify opportunities to use data for new digital products / revenue.
Identify reports, dashboards, and analysis required in accordance with client's business needs.
Identify, research, and resolve technical problems.
Implement
Implement analytics design, data and information visualization across Teachers'.
Implement machine learning models, data mining methods, and statistical analysis using Python.
Implement new enhancements to BI, supporting additional insight into existing products and services.
Improve
Improve and automate processes using a variety of tools to drive operational efficiency.
Include
Include testing of tool and providing clear documentation to internal resources and customer.
Influence
Influence and drive Business Intelligence maturation across the Data & Analytic community.
Innovate
Innovate and solve problems independently, bring new vision.
Input
Input into the budget and forecasting process and reporting, understanding key drivers and variances.
Integrate
Integrate unique business understanding to support business strategy.
Interact with
Interact with client business users to understand business challenges and use cases.
Interpret
Interpret and communicate results to external customers.
Interpret data, analyzes results using statistical techniques and provide ongoing reports.
Introduce
Introduce creative research techniques which deliver rich and deep insights into relevant.
Investigate
Investigate data / process anomalies.
Know
Know SQL or any other data-related language and built ETL pipelines in the past.
Lead
Lead Business Intelligence Analyst with our Revenue Growth Management (RGM) team.
Lead campaign process evolution and innovation.
Lead data analytics on CORE processes and deliverables.
Lead data integration initiatives with partners, providers, and acquisitions.
Lead data mapping exercises to support system integration projects.
Lead engagement model with product partners and closely align with global SCMP & product leads.
Lead on BI matters supporting Site locations ranging from Africa, Middle East, Asia and Australia.
Lead projects impacting Master Data including New Product Launches and Master Data Integration.
Lead reporting for Integrated Services efforts across the business operations.
Lead and support the testing activities during life cycle of the BI systems.
Lead by example regarding the organization's vision and values.
Lead the strategic design and maintenance of enterprise business intelligence applications.
Lead the design, development, implementation and maintenance of complex data systems and solutions.
Lead the development of adopting new tools and data model.
Lead the team with passion and innovation.
Learn
Learn new tools that will elevate our BI offering and bring more value to our end users.
Leverage
Leverage available tools and resources to create visually effective analytics.
Liaise with
Liaise with stakeholders to understand and execute on their BI needs.
Liaise with users and other stakeholders to prioritize and deliver on BI requirements.
Listen
Listen carefully to each other and to our customers.
Look
Look for trends, risks, and performance or quality issues.
Maintain
Maintain and develop our Datamarts (AWS Redshift).
Maintain and enhance weekly, monthly, quarterly, and yearly reports to key stakeholders.
Maintain and improve our reporting to maximise effectiveness and accuracy.
Maintain and monitor month end processes to support the Analytics, Finance and Accounting teams.
Maintain and support data analytics platforms (e.g. Power BI, SQL Server Reporting).
Maintain and support Tableau to meet customer needs.
Maintain and transport SAP BW / BPC data models in all environments (Sandbox to production).
Maintain compliance with applicable laws, regulations and corporate governance objectives.
Maintain current knowledge base of databases, applications, and reporting tools.
Maintain, document, & configure data pipeline for customer success reports & dashboards.
Maintain library of model documents, templates, or other reusable knowledge assets.
Maintain source systems including OpenAir and Netsuite.
Maintain the integrity of technology solutions in the area in partnership with engineering manager.
Make
Make creative recommendations to expand product base and vision.
Make enhancements and troubleshoot.
Make your mark in the fight against cancer.
Manage
Manage ad hoc requests from business leaders / users with appropriate prioritization.
Manage any contractors for data analytics.
Manage Suppliers relationship for third party software / services.
Manage, update and maintain of internal data cubes for consumption of internal analytics peers.
Manage user permissions and security groups in accordance with data governance policies.
Measure
Measure ROI for various efforts.
Meet
Meet with Analysts to understand business and technical requirements.
Modify
Modify the reports as necessary.
Monitor
Monitor and fix any data loads (scheduled or on-demand) using SAP Data Services.
Monitor and troubleshoot operational or data issues in the data pipelines.
Monitor server activity / usage statistics to identify possible performance issues / enhancements.
Normalize
Normalize and aggregate large data sets.
Offer
Offer strategic guidance to both analysts and business teams on how to best leverage our tools.
Operate
Operate as a strategic business partner to the franchise.
Optimize
Optimize data storage / warehousing, working with the Is the external cloud infrastructure provider.
Optimize joint development efforts through appropriate database use and project design.
Oversee
Oversee and contribute to QA and testing processes.
Oversee a team that provides dedicated business intelligence support to GI.
Own
Own strategic initiatives that impact all of Field Services including.
Participate in
Participate in developing testing strategies.
Participate in scheduled production support plan.
Participate in the development of new data products and services to meet the business unit goals.
Perform
Perform adequate unit test for applications developed and validate expected results.
Perform and support in change management for software, hardware upgrades and patches.
Perform data cleansing, transformation, exploration, analysis and visualization.
Perform due diligence on know your client (KYC) activities.
Perform other duties as assigned.
Perform other duties as requested.
Perform other job-related duties as necessary.
Perform peer code reviews and provide feedback.
Perform quality assurance within the BI environment.
Perform requirements gathering, Tableau design specifications and Tableau development.
Perform research to advance the science and technology of intelligent machines.
Perform root cause analysis on reporting and data issues.
Perform system integration, data transformations and reporting on specific client projects.
Perform the tests needed to check the corrective maintenance.
Perform the unit testing, system integration testing and assist with user acceptance testing.
Perform unit testing to validate accuracy and validity of reports and data integrity.
Prepare
Prepare and give presentations to colleagues and users.
Prepare and present status of progress during the governance with the plant steering committee.
Prepare a variety of single-use Ad Hoc reports upon request.
Prepare presentations that clearly and concisely communicate key findings and objectives.
Prepare reports on sales, member dividends and income for international products and services.
Prepare release to production requests in compliance with current standards and processes.
Prepare, validate, and reconcile data from internal and external sources.
Present
Present information clearly through excel / google sheets and visualization software.
Prioritize
Prioritize and manage multiple, parallel technical projects using formal project planning techniques.
Prioritize enhancements and defects in the backlog for implementation within a release cycle.
Prioritize with upper management on campaigns requests and marketing initiatives.
Procedure
Procedure and work methods in a creative and flexible manner.
Produce
Produce ongoing strategic summaries that tie together business impact across business verticals.
Produce quality data, suited to the users' needs and delivered on time.
Propose
Propose and Introduce new BI technologies to the business.
Propose business solutions to resolve these issues.
Prototype
Prototype, deploy and support revenue and customer-related analytics and executive dashboards.
Provide
Provide accurate time estimates for work to be undertaken.
Provide ad hoc technical support.
Provide analytics expertise across the operational segments.
Provide business requirements across all business reports.
Provide estimates and agree on schedules within a framework for report delivery with business users.
Provide expertise on tools and software decisions and deployment.
Provide feedback, as needed to add clarification.
Provide feedback to manager to aid in development and troubleshooting needs.
Provide guidance and direction to Business Analyst.
Provide honest, constructive feedback in an empathetic manner.
Provide important / alarming observations and report the status for the current build.
Provide input to business requirements for the design of solutions.
Provide key leadership and direction in the governance model.
Provide mentoring and training services for both coworkers and business customers.
Provide ongoing support for these applications.
Provide plans and estimates for reporting initiatives.
Provide production support and on-call support including problem analysis and resolution.
Provide recommendations to improve data integrity and data management best practices.
Provide specialized analytical support to senior leaders.
Provide support for investigating and troubleshooting production and data integrity issues.
Provide support to students by responding to technical queries over our.
Provide technical assistance as necessary to end users as well as development staff.
Provide training to non-technical users on how to use dashboards or leverage data insights.
Pull
Pull the data needed with standard query syntax.
Recommend
Recommend improvements of analytics tool-set and operations / revenue management reporting process.
Recommend new procedures and processes to drive desired results on diverse projects.
Recommend the implementation strategy for patches and validate results.
Recruit
Recruit and mentor the next generation of Tableau rock-stars.
Release
Release management of reporting applications.
Report
Report Writing, Dashboard Development, ETL Development.
Represent
Represent the forecasting models business unit when reporting out to leaders in the organization.
Represent your unit in dealings with senior management committees and decision-making bodies.
Research
Research and prioritize best practices to increase completion rate and student engagement.
Research and report abnormal or inconsistent data.
Research business problems and creates models that help analyze these business problems.
Review
Review customer files to ensure integrity of data collection and utilization.
Review existing reports and metrics for automation and improvement as appropriate.
Review solution design and ensure that the defined EDW standards and framework are followed.
Review the current documentation of the current vendor to facilitate the completion of the above.
Revise
Revise and adjust as technology and the business changes.
Run
Run SQL and Snowflake queries and provide feedback on optimization.
Scale
Scale data processes and reports.
Seek
Seek alignment on definitions and terminology with business / process owners.
Spend
Spend a lot of time researching and planning solutions for existing problems within the company.
Stay
Stay on top of industry changes, algorithm updates and their impact on our sites.
Support
Support ad-hoc analytical projects based on Turo strategic priorities.
Support ad hoc reporting as necessary.
Support and troubleshoot technical problems within the Bl Environment.
Support business data discovery and profiling using Tableau.
Support business decisions with robust information analysis.
Support devOps teams in issue / problem troubleshooting regarding reporting solutions.
Support initiatives in a fast-growing, acquisitive environment.
Support internal decision making with focused analyses and recommendations.
Support internal stakeholders with reports and ad-hoc data requests.
Support internal teams on Tableau and with database server management.
Support pre-launch activities of new NorthStar products.
Support project management activities.
Support QA, UAT and performance testing phases of development cycle.
Support reporting and analytics needs from all areas of the business.
Support Reporting applications on 7 / 24 basis based on on-call roaster.
Support, test, and analyze applicable business applications.
Support the IT Service Desk and systems support operations.
Support the maintenance and development of these platforms.
Support the transformation program staff by responding to service requests from clients.
Synthesize
Synthesize current business intelligence or trend data to support recommendations for action.
Take
Take ownership of BI testing through the product.
Take the lead supporting GAM business.
Take time to listen deeply before acting.
Testing
Testing, reporting and governance support for MFC Strategic projects.
Track
Track and report on development progress.
Track record of building and developing high-performing teams.
Train
Train business partners on self-service data solutions and reports.
Train stakeholders on how to get the most out of the solutions that were built for them.
Translate
Translate business requirements to technical solutions leveraging strong business acumen.
Translate numbers, trends and data to consumable insights - both explanatory and exploratory.
Translate technical specifications into application modules.
Troubleshoot
Troubleshoot reported defects to determine the root cause.
Tune
Tune and optimized various complex SQL queries and views.
Turn
Turn data into actionable insights and improve business performance.
Turn data from informational to insightful.
Understand
Understand Business Objects Architecture and Security.
Understand business trends and communicate to internal and external stakeholders.
Understand clients' operations, processes and objectives.
Understand of current data protection and privacy laws.
Understand different disaster recovery solutions for reporting systems.
Understand statistic analysis (Regression analysis, predictive analysis, Cohorts).
Understand the functionality of our source systems.
Understand the systems and their data here at Traffic Tech.
Understand the unique features of MuleSoft's business model, data, and KPIs.
Use
Use internal and external data to develop analytical models to support business analytics needs.
Use of the masculine in this document refers equally to both men and women.
Use PL / SQL Developer, write SQL to fulfill ad hoc requests.
Use standard office equipment.
Use various sources to pull data into Power BI such as SQL Server, Dynamics 365, SQL Azure, etc.
Utilize
Utilize experience in BI Toolsets (SSRS, Tableau, etc..).
Utilize BI Development Software to process user requests and make modifications as necessary.
Validate
Validate data across datasets, reports, dashboards and support functional application testing.
Work with
Work as a team to develop publications toward a real-time control centre target.
Work closely with end users to design impactful analyses with a variety of methodologies.
Work closely with executive leadership to use increasingly complex data as a strategic tool.
Work closely with senior leadership on significant projects.
Work closely with the BI Analyst to implement data warehouse designs.
Work closely with the BI Manager to implement data warehouse changes.
Work directly with business owners to gather requirements and specifications.
Work in a collaborative way with our team members as well as customers.
Work in a professional manner with access to confidential and other data types.
Work interdependently with the Information Technology team with a great deal of autonomy.
Work on cutting edge technology.
Work on international analytics project with high priority and impact for the company.
Work on medium to complex and cross-functional SAP and business intelligence solutions.
Work well in groups and individually.
Work with and transform unstructured data utilizing data science techniques.
Work with a variety of data sources, including databases and APIs.
Work with finance / forecasting to update in-year forecasts as required during planning process.
Work with key stakeholders to gather requirements for report development.
Work with management to prioritize business and information needs.
Work with Product team to ensure analytics alignment to strategic vision and data roadmap.
Work with the product-line manager to identify, record, and manage technology debt.
Write
Write and maintain documentation for internal purposes as well as for the customer.
Write, modify, and debug software.
Write queries that stakeholders can update themselves or can be automated.
Write report specs to document "As Built' reports deployed to production.
Write technical and non-technical documentation.
Most In-demand Hard Skills
The following list describes the most required technical skills of a Business Intelligence Analyst:
Excel
Statistics
R
Business
SSRS
Analytics
SSIS
ETL
Data Analysis
Mathematics
Reporting
Finance
Oracle
Data Analytics
Project Management
Looker
SAS
Data Science
Powerpoint
SSAS
SQL Server
Data Visualization
Data Modeling
BI Tools
Business Analysis
Design
Data Warehousing
Qlikview
Microstrategy
Powerbi
Dashboards
Azure
Word
Economics
Math
Data Visualization Tools
Relational Databases
Snowflake
AWS
Data Mining
Big Data
Analysis
Java
Redshift
Data Management
Most In-demand Soft Skills
The following list describes the most required soft skills of a Business Intelligence Analyst:
Written and oral communication skills
Analytical ability
Problem-solving attitude
Interpersonal skills
Attention to detail
Organizational capacity
Presentation
Bilingualism
Leadership
Critical thinker
Team player
Collaborative
Curious
Flexible
Self-starter
Customer focused
Detail-oriented
Self-motivated
Work independently with little direction
Action-oriented
Multi-task
Creative
Time-management
Adaptable to changes
Initiative
Innovation
Results-oriented
Accurate
Organized
Innovative
Priority management
Take initiative
Influencing
Teamwork
Work ethic
