Enterprise Business Intelligence Analyst

Aegis Therapies•Fort Smith, AR

1d•Remote

About The Position

Responsible for creating and implementing descriptive diagnostic analytical reports and dashboards to drive business decisions and strategy. This position is also involved with assigned projects that impact all areas of the business, including operations, clinical, finance, pricing, sales, human resources, and others. Decision makers at all levels rely on this position to provide timely, accurate, actionable data and analysis for strategic and tactical planning.

Requirements

Bachelor’s degree required (in Computer Science, Data Science, MIS, information technology, or similar preferred).
Strong background in latest versions of Tableau Server (2020.x) or Power BI.
6+ years of experience within a Tableau Desktop environment; developing worksheets, dashboards, data extracts, scheduling, performance tuning and stories in Tableau.
Experience with SQL, Stored Procedures & writing complex queries required.
Experience integrating data from multiple disparate sources for reporting.

Nice To Haves

Master’s degree in related field preferred.
Experience with ETL solutions preferred.
Experience working on Enterprise Data Warehouse environment preferred.
Healthcare and Power BI experience a plus
Experience with scripting or software development languages is a plus

Responsibilities

Works with developers to define, score and data architecture.
Ensures proper back-end/front-end integrations, data flow & ETL processes.
Collaborates with IT, Operations, Sales and Marketing, Finance and other relevant organizational areas to determine potential systems which will utilize BIDW infrastructure.
Lead the reporting team to establish the ongoing development and operations of a business intelligence architecture that enables fact-based decision making and ad hoc analysis and insight.
Creates complex SQL stored procedures, views and functions using best practices and efficient code.
Loads and refreshes Data Warehouse by extracting complex data from multiple sources into business centric Data Marts.
Design, build, and deploy BI solutions.
Ensures the analytics and reporting team is meeting correct expectation as set by management.
Defines ways to maximize system use, including identifying opportunities to better use the system to create more efficiency and stronger operations, creating new reports and queries, working with internal team or vendor.
Provide back-end analysis and reporting.
Lead the development of data controls for various data feeds and work with the Integration team to ensure the integrity of data.
Design reports, visualizations and dashboards that highlight key trends in the business; Understand critical business performance drivers.
Work collaboratively with internal customers to understand, gather and document business requirements for reporting and data projects.
Ability to take a lead role on data improvement and implementation projects.
Proactively seeks opportunities that will support business goals and provide business users with alternatives that enhance business performance and efficiency.
Answers business questions by determining root question and creating visually relevant, interactive Business Analyses, using Power BI.
Performs training and knowledge transfer of technology.