- Partners with Cigna internal and Vendor external teams in functional design, technical design, and guides development of the Data Analytics platform. Gather and assess requirements and assist with translation into optimal analytical solutions.
- Facilitate client requirements and conversations through prototyping to gather requirements on KPIs and other reporting requirements.
- Translating and converting business requirements into Data Analytics functional design documents to support the business and technical teams.
- Deliver functional design documents that are comprehensible to end users and technical team.
- Create source to target data lineage mapping documents for mapping and validating data elements from multiple source systems to target system.
- Provide direction and guidance with mapping and validating data elements from multiple source systems to target system.
- Walkthrough the functional design documents and related deliverables with the technical team and business team to seek sign off.
- Responsible for providing functional guidance to technical resources.
- Review and provide feedback on the technical design documents from the technical team to ensure it aligns with the functional design document and leverages best practices from a DW perspective.
- Develop different ad-hoc and or user specific reports and queries to support the business team.
- Provide functional support in the form of research, documentation updates and enhancement requests during the testing phase to ensure the defects identified are valid defects that the technical team needs to work on.
- Support data reconciliation to ensure the KPIs, balances and field level data within dashboards/reports matches with whats expected to ensure data accuracy and completeness.
- Responsible for performing extensive data analysis & data mining leveraging various tools and summarizing the results / insights in a comprehensive way.
- Skill sets should include designing dimensional models, good knowledge of Relational databases, SQL, PL/SQL, and functional experience in Tableau reports/dashboards.
- Must possess a strong understanding of the BI architecture including physical data models, ETL, logical business models and subject areas.
- Good communication & presentation skills
- Detailed Oriented and strong experience in performing Data analysis.
- Strong data management principles, around data architecture, modeling/design, data quality, security, data organization and operations.
- Excellent analytical/troubleshooting skills.
- Ability to iterate quickly in an agile development process.
- Ability to deliver full life cycle engagements.
- Ability and desire to thrive in a proactive, high-pressure environment.
- Bachelors degree in computer science or a related discipline.
- Typically, six or more years of solid, diverse work experience in IT.
- A minimum of 4 years of experience in DWBI application design, development, and implementation.
- Experience in other BI/reporting tools such as ThoughtSpot, OBIEE etc. will be a plus.
- Experience in documenting key deliverables such as Requirement Gathering, FIT/GAP Analysis, ETL specs, Business model design, Functional Design for Reports and Data Mapping.
- Strong experience on customization & implementations of Data Warehouses using ETL and BI Reporting tools.
- Independent and self-motivated.
- Desire to work in a fast paced, agile, collaborative environment.
- Demonstrable ability to deliver projects on time, with high quality, and within budget.
Systems Analysis Lead Analyst - Hyderabad, India - Evernorth
Description
Systems Analysis Lead Analyst
Position Overview:
The Data Platform and Analytics engineering (DPaAS) team in Finance Technology group is looking for a Systems Analysis Lead Analyst to provide functional expertise and guidance for key data projects within DPaAS. The Systems Analysis Lead Analyst will be responsible for functional requirements for new feature development to support build out of new and or enhance existing data platform services in AWS and or Oracle cloud environments, using their extensive experience in data analysis, design and architecture supporting data engineering function.
Some of the engineering skills required for operating in data platforms would include strong expertise with SQL and data integration (i.e. transformation rules and extensive data warehousing experience). This role will collaborate with various levels of stakeholders to help articulate and influence the technical direction. Ideal candidate will possess a combination of systems and technology experience along with strong thought leadership to make the right and balanced functional design decisions that deliver key enabling features to support major initiatives across the domain.
Responsibilities:
Qualifications
Required Skills:
Required Experience & Education:
Desired Experience:
Equal Opportunity Statement:
Evernorth is an Equal Opportunity Employer actively encouraging and supporting organization-wide involvement of staff in diversity, equity, and inclusion efforts to educate, inform and advance both internal practices and external work with diverse client populations.