Implementation Consultant (SQL / Excel)

Join the company in creating a thriving ecosystem that provides accessible, high-quality, and sustainable healthcare for all. As an Implementation Analyst, you will be responsible for supporting data migration and import workflows to ensure seamless transitions of patient and clinical data across Electronic Health Record (EHR) systems. Your role within athenahealth's Data Imports team is crucial in accurately mapping, validating, transforming, and loading data from source EHR systems into athenaOne. You will manage a portfolio of import projects, collaborate with cross-functional teams and clients, and utilize tools such as Microsoft Excel, Salesforce, and SQL to achieve high-quality data migration outcomes.

Key Responsibilities:

• Manage end-to-end data import and migration projects, including data extraction, transformation, validation, and loading from source EHR systems into athenaOne.
• Analyze and map source data fields to target EHR data structures, ensuring accuracy and compliance with clinical and regulatory requirements.
• Use Microsoft Excel for data transformation, transformation templates, and pre-import quality checks.
• Leverage SQL to query, validate, and reconcile data sets across source and destination systems.
• Track and manage project status, client communications, and issue resolution using Salesforce CRM.
• Communicate with clients, healthcare practices, and internal stakeholders to convey import project status, timelines, and data requirements.
• Manage a high volume of concurrent import projects and tasks with competing priorities.
• Identify data quality issues, discrepancies, and gaps in source data proposing and executing remediation strategies.
• Develop a thorough understanding of athenahealth's data models, import tools, and EHR workflows to effectively support complex migrations.
• Collaborate with cross-functional teams including Product, Engineering, and Client Services to resolve technical and functional challenges.
• Extract, synthesize, and analyze data to support project decisions and reporting.
• Troubleshoot and resolve issues related to data imports, including data mapping errors, format mismatches, and load failures, escalating when necessary.
• Support the training and mentoring of new team members on import processes and tools.
• Serve as a subject matter expert for data import best practices and process-related questions.
• Perform other duties as assigned by the Implementation Manager to optimize and scale data import operations.

Qualifications Required:

• Graduate in engineering, science, or any related field.
• Fluency and comfort with both spoken and written English.
• Willingness to work in any shift, including IST Night shifts.
• Excellent customer service skills and professionalism in managing communication with external healthcare clients and partners.
• Proficiency in Microsoft Excel, including advanced functions, pivot tables, VLOOKUP/XLOOKUP, and data transformation techniques.
• Hands-on experience with SQL for querying, filtering, and validating large datasets is an added advantage.
• Experience using Salesforce or equivalent CRM tools for project tracking and client communication is an added advantage.
• Excellent analytical and problem-solving skills with strong attention to data accuracy and detail.
• Demonstrated experience identifying and resolving data quality issues and workflow inefficiencies.
• Ability to manage complex projects throughout their entire lifecycle, from discovery and data analysis through go-live and post-import validation.
• 0-3 years of work experience in US healthcare, health IT, data migration, or a related field.
• Familiarity with Implementation/onboarding EHR systems, healthcare data standards.

Please note: The candidates are required to be flexible in all shifts. Join the company in creating a thriving ecosystem that provides accessible, high-quality, and sustainable healthcare for all. As an Implementation Analyst, you will be responsible for supporting data migration and import workflows to ensure seamless transitions of patient and clinical data across Electronic Health Record (EHR) systems. Your role within athenahealth's Data Imports team is crucial in accurately mapping, validating, transforming, and loading data from source EHR systems into athenaOne. You will manage a portfolio of import projects, collaborate with cross-functional teams and clients, and utilize tools such as Microsoft Excel, Salesforce, and SQL to achieve high-quality data migration outcomes.

Key Responsibilities:

• Manage end-to-end data import and migration projects, including data extraction, transformation, validation, and loading from source EHR systems into athenaOne.
• Analyze and map source data fields to target EHR data structures, ensuring accuracy and compliance with clinical and regulatory requirements.
• Use Microsoft Excel for data transformation, transformation templates, and pre-import quality checks.
• Leverage SQL to query