Senior Data Analyst

Hadoop, Big Data, COBOL, DB2, Java, UNIX, Columnar databases, Strong SQL, Data Cleaning, Data profiling, Abinitio
Contract W2, Contract Independent, Contract Corp-To-Corp, 12 Months
Depends on Experience

Job Description

Company Description

Lumen Solutions Inc. is a technology consulting services company based in Virginia. We provide a wide array of experienced business and IT professionals supporting clients from solution design to implementation and support. We specialize in strategy development, portfolio management and enterprise architecture.


Only Local candidates based at VA/DC/MD may apply.


Job Industry: Healthcare Domain


We have an urgent job opening of Senior Data Analyst experience with our direct client based in Reston VA. please check below job description and share your resume ASAP.


Job Role: Senior Data Analyst
Location: Reston VA
Job Type: Long Term Contract


7+ years of experience in SQL Data Analysis

Strong SQL, Reporting needs

Healthcare Claims adjudication projects

Develop to produce stm (source to target mapping).  Lot of transformation logic is build into STM

Customer provides business requirement and business analyst will develop technical requirements

Data analyst - Analysis on technical requirements

Will develop STM from technical requirements in Excel and will had over to ETL developers

ETL developers will code based on technical requirements derived from excel

Data quality (any tool would work), data cleansing

Analyzing the defects and capable of modifying 


Data Analysis is the art of collecting and analyzing data so that FEP can use said data to address gaps in operational capabilities and support analytics and reporting projects. The Senior Data Analyst is a highly trained professional who will become an expert in our source data and lead the data mapping effort to migrate the data into our new enterprise data platform. The Senior Data Analyst will use his/her technical expertise and work closely with source system experts to perform data research, run advanced queries, assess data quality and integrity issues, determine data definitions, and define data mappings.



Candidate will support the implementation of a Data Integration/Data Warehouse for the Informatics Teams


  • Data Cleaning – identify erroneous data and determine appropriate resolution • Analyze and assess the quality and integrity of the data • Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality • Understand the meaning/business context of data • Acquire data from internal or external data sources and maintain mapping documents of the files, databases/data systems.
  • Perform data analysis and data modeling to create source to target mappings.
  • Evaluate risk from statistical information to determine risk to operations or non-compliance.
  • Perform gap analysis of data requirements versus current data sources.
  • Work closely with business analysts and source data experts to develop data requirements.
  • Assess current data and assist in the resolution of data anomalies.
  • Interpret data, analyze results using statistical techniques and provide ongoing reports and feedback • Data profiling experience (Preferably using Abinitio DQE)


Required Qualifications:

  • 7+ years demonstrated experience as Data Analyst • Strong SQL and data modelling skills like 3rd normal form and dimensional modelling • Demonstrated ability to perform complex queries, assess data quality and develop data mappings.
  • Experience with multiple data warehousing and analytics development projects • Bachelor of Science in Mathematics, Engineering, or Computer Science or 4 additional years of experience in the related area


Preferred Qualifications:

  • Working knowledge of U.S. Healthcare Industry • Working knowledge of HEDIS, Fraud, Waste & Abuse • Working knowledge of ETL • Experience with Hadoop and Big Data technologies • Working knowledge of ALM • Working knowledge of COBOL • Strong DB2, Java, and UNIX skills • Understanding and working (hands-on) knowledge of newer or emerging trends such as Big Data, Columnar databases, NoSQL, Hadoop, MapReduce, social media, data visualization, XML, and unstructured text is a plus.



Additional information

Interview format: 1st – Phone, 2nd - Skype 

Location: Reston, VA


Compensation and benefits – Lumen Solutions offers competitive compensation package as well as an array of benefits matching with current industry standard based on experience and qualifications.

Overview of benefits:

  • Medical, Dental, Vision, Rx Insurance
  • Vacation, Sick Leave, Holidays
  • 401K, Employee Referral Bonus
  • Lumen Solutions is an EEO and presents an incredible opportunity for growth and advancement with initiatives in transportation, healthcare, and financial sectors.


Contact Information:

Phone Number of assigned recruiter - 703-596-4950

Posted By: Jaiprakash Singh Lumen Solutions, Inc.


Please send resume to:


Dice Id : 10483685
Position Id : 25339
Originally Posted : 2 months ago
Have a Job? Post it