The Business Intelligence Analyst is responsible for coordinating efforts in data analytics, data collection, reporting, and data visualizations. The Business Intelligence Analyst will partner with senior team members to ensure that the use of business intelligence applications enhances business decision-making capabilities.
Essential Duties and Responsibilities
Responsible for data analytics, data collection, reporting and data visualizations of key business objectives
Transforms data into insights that drive business value
Operationalizes data workflows and modeling
Deploys data to a data warehouse
Participates in the strategic design and maintenance of business intelligence application
Identifies, researches, and resolves technical problems as well as ensures that the use of business intelligence applications enhances business decision-making capabilities
Reports, analyzes, and distributes key reports on weekly, bi-weekly, monthly, and quarterly basis
Ability to liaison between business and the development team, while working with a wide range of stakeholders
Ensures integrity of Data Collection and Utilization
Assists in the automation of reporting creation through power query, windows tasks, Macros, SQL agent jobs, data refresh schedules
Works with stakeholders to develop specific, repeatable definitions of metrics
Understands business process and how BI technologies enable the process
Supports, maintains, and improves existing application
Provides data requests through ad-hoc queries
Provides support and guidance to end users
Informs key stakeholders of potential issues related to errors and trends
Provides great customer service to our business partners
Performs other duties as assigned / necessary
Minimum Requirements
Bachelor's Degree in computer science, business, mathematics, economics, statistics, management, accounting or in a related field or equivalent experience required
2+ year experience in the IT
Relational database skills using SQL Server
Proficient working knowledge of Power BI
TSQL Programming experience required
Advanced knowledge of Excel (Power Query, Macros, Automation of reporting)
Capable of learning new technology in a fast paced environment
Ability to analyze system and process related issues and offer solutions
Strong customer service and communication skills required
Must be able to work effectively as part of a team while maintaining a strong attention to detail
Advanced computer proficiency required and proficiency in Windows XP Professional, Microsoft Office suite software programs, internet usage, and learning program design systems and software
Ability to effectively elicit / provide information to and from appropriate individuals (including, but not limited to, supervisors, co-workers, clients) via strong communication skills; proficiency in the English language is required
Intelligence Analyst • Columbia, MD, United States