The Business Analyst role is the primary architect of reporting and dashboard solutions for assigned business units. Utilizing ESI development tools, this position is responsible for the design, development, implementation, analysis, interpretation and communication of business information based on the needs of individual clients. The ability to balance overall aesthetics with robust and intuitive functionality is a critical requirement for success in this position.
Work with business and technology subject matter experts to acquire data from technology production systems and make that data available for operational research, reporting, analysis.
Help to automate and streamline complex manual or semi-automated reporting processes.
Work consistently to improve data completeness, accuracy, and actionability.
Develop efficient ETL (Extract-Transform-Load) routines for loading small-to-large amounts of operational data.
Ensure appropriate indexing is in place to optimize performance of web-based reporting applications fed from team data repositories.
Enhance/create automated systems to monitor database server health (including storage space, CPU usage, fragmentation, etc.).
Identify and remediate performance pain points as needed.
Help make analysis-ready data available to downstream consumers, analysts, applications, etc. within our Hadoop Data Lake.
Help improve data documentation and accessibility.
Learn from senior developers/analysts in the areas of data modeling, ETL design, and query efficiency.
Bachelor’s degree or 8-11 years relevant work experience
2-5 years relevant analyst experience.
Analytical and strategic thinking skills.
Able to quickly learn how to use new software applications.
Strong organization and communication skills (oral and written)
Analytical and detail-oriented in all work activities.
Able to handle and prioritize multiple projects or tasks at a time.
Able to work cross-functionally and solve complex problems.
Demonstrated ability to design, develop, and maintain relational databases preferred.
Demonstrated knowledge writing SQL queries.
Knowledge of one or more query design tools (i.e., Microsoft SQL Server Management Studio, Teradata SQL Assistant, Oracle SQL Developer, etc.).
Knowledge of one or more ETL (Extract-Transform-Load) tools a plus (i.e., Microsoft SQL Server Integration Services, Informatica, Ab Initio, Talend, etc.).
Skills in query tuning and overall efficient use of database resources preferred.
Experience with Hadoop and other Big Data tools (such as Hive, Spark, SQOOP, etc.) a plus.
Experience with "semantic-layer" tools (such as Business Objects, Cognos, or SQL Server Analysis Services) a plus.
Experience with metadata catalog tools (such as Alation) a plus.
Knowledge of Pharmacy Benefit Management (PBM) concepts and business processes a plus.
ABOUT THE DEPARTMENT
The Operations Strategic Analytics department helps to achieve the goals of Express Scripts' Operations through design and delivery of analytic tools and reporting. Operations Strategic Analytics proactively partners with operations leadership to measure business activities and define metrics and processes that will increase productivity, drive out waste, and improve quality. Operations Strategic Analytics supports a wide array of internal organizations including Home Delivery Pharmacy, Contact Center, Service Delivery, Account Management, and Finance among others. The Data Engineering team focuses specifically on the challenge of acquiring, storing, organizing, and optimizing operational data for investigation, reporting, and analysis. The data curated by this team powers rich data visualizations and other tailored analytic products throughout operations to enable Express Scripts to provide cost-effective, high-quality service to our clients and patients.
ABOUT EXPRESS SCRIPTS
Advance your career with the company that makes it easier for people to choose better health.
Express Scripts is a leading healthcare company serving tens of millions of consumers. We are looking for individuals who are passionate, creative and committed to creating systems and service solutions that promote better health outcomes. Join the company that Fortune magazine ranked as one of the "Most Admired Companies" in the pharmacy category. Then, use your intelligence, creativity, integrity and hard work to help us enhance our products and services. We offer a highly competitive base salary and a comprehensive benefits program, including medical, prescription drug, dental, vision, 401(k) with company match, life insurance, paid time off, tuition assistance and an employee stock purchase plan.
Express Scripts is an equal opportunity employer/disability/veteran