Language

Business Analytics Advisor (36158743)

DEV OPS
Data Quality
Microsoft SSRS
System Analysis
RDBMS
Pivot Tables
Data Warehouse
Data Warehousing
Git
Python
Data Pipelines
Semi-Structured Data
Data Profiling
Data Management
Data Architecture
Database Modeling
MS SQL Server
Data Retreival
Data Manipulation
SQL
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.
 

Location/Schedule Notes: 

Hybrid in Franklin, TN is preferred but open to remote USA for the right candidate. M-F 8-5 Central with some flex for remote candidates.


Responsibilities: 

  • Provides expert content/professional leadership on complex Data Management Strategy & Governance assignments/projects. 
  • Contributes to data oversight, data usage, system analysis and data retention to assure data quality standards.
  • Collaborates with other departments to ensure data consistency and quality throughout the organization.
  • Exercises considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives. 
  • Uses deep professional knowledge and acumen to advise functional leaders.

This is a contract position currently available through 12/31/2025; put in place specifically to complete the migration of usage across legacy systems (predominantly MS SQL Server but other RDBMS may be involved) to the Lakehouse (Azure Databricks). You will be working with other analysts as well as development teams comprised of onshore (Central US) and offshore developers, exploring data processes and usage of systems in order to determine next steps to migrate and to foster adoption from users to our modern platforms. This will require heavy analysts of usage against the legacy system as well as platforms within our Azure environment. This position will interact with business stakeholders and SMEs. Healthcare data knowledge is a major plus. This is a very fast-paced environment that will require a lot of self-guidance and motivation.

Qualifications: 

  • In depth knowledge in SQL, MS SQL Server stack (SSIS, SSRS, Information Schema), Azure Databricks, Azure Data Factory, Azure Storage Services, Python, SparkSQL, DevOps & GIT
  • Have a fluent understanding of data models, schemas, and databases to support analytical and reporting needs, and use SQL for data manipulation and querying
  • Demonstrate advanced proficiency in data processing
  • Advanced capabilities with data profiling, validation and analytics
  • Advanced analytics skillsets with MS Excel, making use of Excel's data retrieval capabilities, pivot tables, data comparison operations, etc.
  • Strong ability to explore, discover and map out large data pipelines that support the processing of structured and semi-structured data
  • Working knowledge of CICD pipelines for Azure resources
  • Highly organized and able to track multiple fast moving projects at a time
  • Knowledge and experience in an enterprise-level data warehouse environment with knowledge of data architecture patterns and best practices
  • In-depth knowledge of the US Healthcare industry to address healthcare-related challenges through data engineering solutions with particular emphasis in medical claims data
  • Possess excellent written and verbal communication skills, with the ability to effectively convey complex analytical findings and tell a compelling story with data
  • Work in a client-facing project environment independently
  • Bachelor’s degree preferred but not required
  • 3-5+ years of experience in an enterprise data warehousing environment with similar duties as described above, preferably using both MS SQL Server and Azure data platforms
  • HS Diploma or GED is minimum requirement

 

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

The pay range that Magnit reasonably expects to pay for this position is: $54.00/hour-$72.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 : 5+ Years
  • Travel Required : No travel required
  • Shift timings: Not specified
Job Location Franklin, Tennessee
Pay USD 54.00 - USD 72.00 Per Hour
Contract Duration 5 month(s)