Corporate Development Analyst
Baker Tilly US
Senior Business Analyst
The Cigna Group
full-time
Posted on:
Location Type: Hybrid
Location: Morris Plains • New Jersey • 🇺🇸 United States
Visit company websiteSalary
💰 $66,500 - $110,900 per year
Job Level
Senior
Tech Stack
PythonSQLTableauVBA
About the role
- responsible for the analysis, creation and distribution of information and insights within self-service applications utilized by internal account teams and key stakeholders
- Building processes and reporting in SQL and VBA, supporting delivery of self – service reports, ad hoc and analytic requests
- Creating documentation and working collaboratively with cross-functional teams to resolve issues and create innovative reporting solutions with new technologies
- Strong ability to collaborate with a number of cross functional key stakeholders to obtain consensus on multiple client and Evernorth deliverables
- Being able to strategize, design and present new visualizations and client data insights to turn complex problems using large amounts of data into easily understandable and impactful analysis
- Effectively communicate with user via a number of channels, including the ability to develop and deploy training plans to ensure users understand content
- Understand user needs and ability to create interactive User Interfaces for users, leveraging Microsoft VBA and other appropriate solutions
- Ability to mentor coworkers to share knowledge on technical and business use cases
- Design and implement technical, business, and functional requirements for use by the team
- Create and display quantitative information through charts, graphs, tables, and bespoke visualizations
- Review and analyze results, assisting other business areas with issue resolution
- Collaborate with Business users and internal teams to drive decision making to ensure that business needs are being met
- Provide support as required to ensure the data availability and performance of enterprise data and BI environments for users
- Develop and improve processes and documentation to support best practices in Data Visualization
- Communicate project status and escalate issues as needed
- Work on special projects as assigned
Requirements
- 1-2 years' experience in writing & understanding SQL queries, stored procedures & macros, table & view creation and other technical designs
- Strong experience with Microsoft Visual Basic for Applications; including UI design and creation, macro creation and maintenance, advanced Excel analysis techniques
- Experience with Python development, design, methodologies, tools and processes
- Experience in Data Visualization tools like Tableau, Power BI
- Familiarity with health care or PBM industry
- Ability to provide innovative, practical, and consistent solutions
- Demonstrated ability to prioritize work load and meet project deadlines via team collaboration
- Adaptability and willingness to learn new tools and applications
- Highly organized with strong documentation skills
Benefits
- medical, vision, dental, and well-being and behavioral health programs
- 401(k) with company match
- company paid life insurance
- tuition reimbursement
- a minimum of 18 days of paid time off per year
- paid holidays
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLVBAPythonData VisualizationExcel analysisUI designmacro creationreportingdata analysistechnical design
Soft skills
collaborationcommunicationmentoringproblem-solvingadaptabilityorganizationprioritizationinnovationtraining developmentdocumentation
