Language

Software Engineering Lead Analyst (36522918)

SAS
B2B Software
Technical Support
Data Warehouse
Vantage
Rally
Agile
JIRA
Product Management
SQL Queries
Database Modeling
DBMS
Data Analysis
SQL
Reference Data
Database Management System
Data Warehouses
Data Sources
Datasets
Data Migration
Data Mart
Teradata
Description:

This position is a temporary assignment. As a contractor, you’ll be employed by Magnit, not The Cigna Group or any subsidiaries of The Cigna Group.

Alternate Title: 

Senior Data Analyst (within a Software Engineering group)

Location/Schedule: 

Remote, USA (EST hours) with a strong preference for a candidate near one of Cigna's major locations: Bloomfield, CT | Morris Plains, NJ | Dallas, TX

Responsibilities: 

The Client Reporting organization within Data & Analytics is entrusted with key Business & Analytics’ team relationships, iterative delivery and measurement of business value, and application of agile and product management best practices. 

The Analyst works as part of the Business & Technical Product teams to understand and document the needs of the business.  In partnership with the Business and/or Technical Product Owner, the Analyst helps to enable the business value of data solutions delivered by the teams and must engage with the teams accordingly.  The Analyst also partners with the Analytics org as well Business Subject Matter Experts (SMEs) for methodology, calculations, and content. 

Analyzes large amounts of data stored in a data warehouse or data mart to find relationships and patterns across Customer, Provider, Claims, Client and Benefits data. Works autonomously, only requiring “expert” level technical support from others. Exercises judgment in the evaluation, selection, and adaptation of both standard and complex techniques and procedures. Utilizes in-depth professional knowledge, any healthcare experience and acumen to develop models and procedures, and monitor trends, within Data and Analytics Engineering.

  • Facilitates individual conversations with the business to understand their needs for new solutions and data required; drives thorough discussions and recommends requirements based on reporting and analytics best practices, data needs, and data availability.
  • Technical expertise to ensure the quality and accuracy of data, design and present it in ways to demonstrate insights required by the business.
  • Technical expertise to read from SAS, SQL to infer the transformations/calculations to then map to the new data sources and methodology, for large scale migration projects.
  • Asks key questions to ensure understanding of the business expectations. For Reporting Products, this includes detailed questions about data sources, reference data, calculations, logic, etc.
  • Reviews Test Plans with the TPO each sprint, ensuring that they include detailed scenarios to test prior to approval of delivery. Documents analysis outcomes in a digestible yet comprehensive manner.
  • Requirements Gathering, e.g. Conduct interviews, workshops, or focus group discussions with stakeholders to understand their data needs and requirements. Document these requirements clearly, ensuring they're specific, measurable, and unambiguous.
  • Data Analysis, e.g. Use SQL to extract data from databases, transform, model and visualize the data to provide the data insights required by business as captured in business requirements.
  • Data Insights e.g. Write SQL queries to group and aggregate data to produce summary statistics on large datasets and communicate insights to stakeholders. Capture queries and metric definitions for use in reporting applications.

Qualifications:

  • Must have excellent analytics and reporting acumen including experience building reports or completing data analysis related to trend management; strong Analytical mindset is required.
  • Competent in cloud DBMS such as Teradata Vantage, Snowflake, Deltalake; and concepts such as database modeling, data migration, and BI. Expectation is that there will be a need to adaptable to quickly learn new technologies as they emerge.
  • 8+ years of experience in Analytics and/or Reporting 
  • Working experience with SAS.
  • Strong hands-on experience with SQL.
  • Experience working with large enterprise data warehouses / solutions
  • Experience in healthcare environment is strongly preferred; client reporting experience is a huge plus.
  • 2+ years Agile experience, preferably in a Business Analyst for an analytic or reporting product, is required; Experience with Jira or Rally for documenting project requirements is preferred.
  • Excellent verbal and written communication skills is required; individual must be polished and professional and have experience interacting with senior leadership. Must demonstrate a high “EQ” (emotional intelligence) in all situations.
  • Experience managing and reporting on performance of a “product” is required, including operational and outcomes metric tracking and goal setting.
  • Experience measuring results and outcomes post-implementation is required.
  • Strong business acumen is preferred.
  • Must be able to track to goals and deadlines in the context of the big picture
  • Excellent organization skills are required.
  • Proven ability to manage multiple projects simultaneously is required.
  • Flexibility to change course based on business needs as required; must operate well with ambiguity.
  • Bachelor’s degree in Math, Finance, Business, Engineering, or mathematical discipline and/or 5 years’ experience in analytics and/or reporting is required.

 

Hourly Pay Rate Range (dependent on location, experience, expectation)  

The pay range that Magnit reasonably expects to pay for this position is: $50.00/hour-$62.00/hour  

Benefits: Medical, Dental, Vision, 401K (provided minimum eligibility hours are met) 

QUALIFICATION/ LICENSURE :
  • Work Authorization : Green Card, US Citizen, Other valid work visa
  • Preferred years of experience : 8+ Years
  • Travel Required : No travel required
  • Shift timings: 8-5 or 9-6 EST
Job Location bloomfield, Connecticut
Pay USD 50.00 - USD 62.00 Per Hour
Contract Duration 6 month(s)