Sr. Data Analyst with STTM with Excel Exp

Position Name: Sr. Data Analyst with STTM with Excel exp Work Location: PARK6 City & State: Reston, Virginia Duration: 12+ Months developing Source to Target mapping (STTM) & Gap Analysis based on business requirement. Documentation Skill is a Must 7+ years of experience with multiple data warehousing and analytics development projects Ab Initio is nice to have Must Have: • 3+ years of Experience in Healthcare Industry • 7+ years of Hands-on experience with Big Data/NoSQL Platforms with experience delivering production projects at scale. • 7+ years of demonstrated experience as Data Analyst • 7+ years of 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. • 7+ years of experience in developing Source to Target mapping (STTM) & Gap Analysis based on business requirement. • 7+ years of experience with multiple data warehousing and analytics development projects PURPOSE: The purpose of a Sr. Data Analyst is to find meaning in data as a thought leader so that the derived knowledge can be used to make informed decisions and assist the organization in making better business decisions. ESSENTIAL FUNCTIONS: 25% Engages in data exploration using various programming languages (reading and writing code), requiring advanced knowledge of multiple database structures 15% Collect, analyze, and interpret data to glean insights, and develop business appropriate recommendations 15% Research and analyze data flow across complex data ecosystem including operational and analytical data platforms 15% Serve as an expert resource supporting data questions and issues from stakeholders and driving to resolution 10% Lead in the design, development, validation and delivery of data to provide insight into business decisions 10% Manage the collection of business and technical requirements from Stakeholders to deliver data driven solutions. Produces technical documentation that is consistent with professional standards 10% Be a resource and mentor to junior level staff Candidate will also support the implementation of a Data Integration/Data Warehouse for the Delivery Team • Data Cleaning – identify erroneous data and determine appropriate resolution • Analyze and assess the quality and integrity of the data including Reference 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 documentation of the STTM & Mapping doc • 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) Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Education Level: Bachelor's Degree Education Details: Data Science, Mathematics, Computer Science, Statistics, Business or related field Experience: 5 years’ experience in an analytical/quantitative role. In Lieu of Education In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience. Qualifications • 3+ years of Experience in Healthcare Industry • 7+ years of Hands on experience with Big Data/NoSQL Platforms with experience delivering production projects at scale. • 7+ years of demonstrated experience as Data Analyst • 7+ years of 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. • 7+ years of experience in developing Source to Target mapping (STTM) & Gap Analysis based on business requirement. • 7+ years of experience with multiple data warehousing and analytics development projects Knowledge, Skills and Abilities (KSAs) Quantitative ,analytical and problem solving skills. , Advanced Knowledge and understanding of analytical tools , languages ,applications, platforms., Advanced Excellent communication skills both written and verbal, Advanced Ability to learn quickly and take direction., Advanced The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes them ineligible to perform work directly or indirectly on Federal health care programs. Must be able to effectively work in a fast-paced environment with frequently changing priorities, deadlines, and workloads that can be variable for long periods of time. Must be able to meet established deadlines and handle multiple customer service demands from internal and external customers, within set expectations for service excellence. Must be able to effectively communicate and provide positive customer service to every internal and external customer, including customers who may be demanding or otherwise challenging. Thanks & Regards, Sekhar Pillala Team Lead - Talent Acquisition KMM Technologies, Inc. CMMI Level 2 | ISO 9001 | ISO 20000 | ISO 27000 Certified WOSB, SBA 8(A), MDOT MBE & NMSDC MBE Contract Vehicles: 8(a) STARS III & Schedule 70 Tel: 240-800-1958 | Fax: (866) 856 3684 E-MAIL: sekhar.pillala@kmmtechnologies.com Linked In: https://www.linkedin.com/in/sekhar-ji-1505ab22/ www.kmmtechnologies.com