Senior Data Consultant – Data Migration, Analytics

Job not on LinkedIn

🔥 0 minutes ago

🇺🇸 United States – Remote

💵 $110k - $130k / year

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 1%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

ON Partners

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2006

💼 Consulting

🏥 Healthcare

📦 Logistics

Consulting • Healthcare • Logistics

ON Partners is a pure-play retained executive search firm that specializes in building C-level and board leadership teams across various sectors. Since its inception in 2006, the company has focused on crafting tailored solutions for executive placements, ensuring a seamless experience for both clients and candidates. With expertise spanning technology, consumer products, professional services, life sciences, and industrial sectors, ON Partners is committed to innovative and diversity-focused recruiting practices.

📋 Description

• Analyze data across legacy applications, databases, and enterprise platforms to understand structure, relationships, quality, and business meaning • Develop source-to-target mapping specifications for transforming and migrating legacy data into target platforms • Write and optimize SQL queries to extract, transform, validate, and reconcile data • Produce migration-ready CSV extracts for Salesforce and other cloud platforms • Profile data to identify quality issues, inconsistencies, duplicates, missing values, and transformation requirements • Develop transformation and cleansing rules with functional and technical stakeholders • Conduct reconciliation and validation between source and target systems • Analyze data relationships across operational systems and data sources • Assist with logical and physical data modeling for migration, integration, and analytics initiatives • Translate business requirements into technical data requirements and transformation logic • Support ETL/ELT processes • Document data lineage, transformation rules, dependencies, and business logic • Resolve data-related issues with integration and application teams • Perform exploratory and analytical analysis to identify trends, anomalies, and improvement opportunities • Develop queries, reports, and datasets for operational reporting and analytics • Support data warehouse, reporting, and analytics initiatives • Establish data validation and quality controls throughout the migration lifecycle • Help clients improve enterprise data usability, consistency, and reliability • Facilitate requirements and data discovery sessions • Explain complex data issues to technical and non-technical audiences • Partner with client teams to investigate issues and recommend solutions • Communicate project status, risks, assumptions, dependencies, and data quality findings to project leadership • Collaborate with consultants, developers, architects, analysts, and project managers • Initially support the Data Migration team, with opportunities to expand into Analytics and broader Data Services & Analytics initiatives

🎯 Requirements

• 7+ years of experience in data analysis, data migration, data integration, business intelligence, data warehousing, or related disciplines • Advanced experience writing and troubleshooting SQL against enterprise relational databases • Demonstrated experience analyzing complex datasets and understanding relationships across multiple systems • Experience with data mapping, ETL/ELT, data transformation, or system migration initiatives • Strong understanding of relational databases, data models, joins, keys, and data relationships • Experience performing data profiling, validation, reconciliation, and data quality analysis • Ability to translate business requirements into technical data requirements • Experience gathering requirements directly from business and technical stakeholders • Strong analytical, problem-solving, documentation, and communication skills • Ability to manage multiple priorities and work effectively in a client-facing consulting environment • Demonstrated ability to build trusted advisor relationships with clients • Experience supporting sales and business development • Flexibility to travel periodically based on business and client needs • Preferred: experience in higher education and institutional data domains • Preferred: experience with Ellucian Banner, PeopleSoft, Workday, Slate, Advance, or similar enterprise applications • Preferred: experience with Salesforce, Salesforce data structures, Data Loader, bulk data loads, or Salesforce migration projects • Preferred: experience with Oracle, PostgreSQL, SQL Server, Snowflake, Redshift, or similar database platforms • Preferred: experience with AWS or Azure • Preferred: experience developing or supporting enterprise data warehouses • Preferred: familiarity with Power BI, Tableau, or Salesforce Analytics • Preferred: experience developing formal source-to-target mapping documents and migration specifications

🏖️ Benefits

• Competitive health, dental, and vision coverage • HSA and FSA accounts • Life and disability insurance • Fertility and family planning benefits • Employee assistance and discount programs • 11 paid federal holidays • Flexible unlimited time off (UTO) • Generous 401(k) matching with immediate vesting • Flexible career paths with advancement, mobility, and flexibility • Flexible work environment • Industry-leading benefits package beginning on the first day of employment • Annual discretionary bonus eligibility