Enterprise Business Intelligence Analyst

Corporate office located in Fort Smith, AR but can be remote. General PURPOSE 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. ESSENTIAL JOB DUTIES 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. PHYSICAL AND SENSORY REQUIREMENTS Mobility, reaching, bending, lifting (minimum of 10 pounds), fine hand coordination, ability to read and write, the ability to understand and follow written and oral instructions and directions, ability to travel, and ability to remain calm under pressure KNOWLEDGE, SKILLS, ABILITIES & BEHAVIORS Demonstrated ability to prioritize assignments and work independently on multiple complex projects in a fast-paced, deadline-driven team environment Strong interpersonal skills and ability to collaborate across departments Ability to integrate analytics into processes spanning business lines and departments Creativity and innovation in researching data and creating analytical approaches Must be able to maintain confidentiality regarding patient, employees, and company proprietary information Must have the ability to relate professionally and positively and work cooperatively with employees at all levels Code of Conduct Must adhere to the Company’s Code of Conduct and Business Ethics policy including documentation and reporting responsibilities. QUALIFICATIONS Bachelor’s degree required (in Computer Science, Data Science, MIS, information technology, or similar preferred). Master’s degree in related field 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 ETL solutions preferred. Experience with SQL, Stored Procedures & writing complex queries required. 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 Experience integrating data from multiple disparate sources for reporting. EEO Statement: Aegis Therapies and its Family of Companies is committed to a diverse workforce and is an Equal Opportunity Employer. For detailed information on your rights, Click Here OR https://aegistherapies.com/equal-opportunity-employer-provider-of-healthcare-services/ .