Senior Data Consultant – Data Migration, Analytics

This is a fully remote position, open to applicants in United States.

📋 Description

• Examine data across legacy systems, databases, and enterprise platforms to comprehend their structure, interrelations, quality, and business implications.

• Create source-to-target mapping specifications for the transformation and migration of legacy data into new platforms.

• Construct and optimize SQL queries for data extraction, transformation, validation, and reconciliation.

• Generate migration-ready CSV extracts for Salesforce and other cloud platforms.

• Profile data to detect quality issues, inconsistencies, duplicates, missing values, and transformation needs.

• Establish transformation and cleansing rules in collaboration with functional and technical stakeholders.

• Perform reconciliation and validation between source and target systems.

• Analyze data relationships across operational systems and various data sources.

• Assist in logical and physical data modeling for migration, integration, and analytics projects.

• Convert business requirements into technical data specifications and transformation logic.

• Provide support for ETL/ELT processes.

• Document data lineage, transformation rules, dependencies, and business logic.

• Address data-related issues in partnership with integration and application teams.

• Conduct exploratory and analytical analyses to uncover trends, anomalies, and areas for improvement.

• Create queries, reports, and datasets for operational reporting and analytics.

• Support data warehouse, reporting, and analytics projects.

• Implement data validation and quality controls throughout the migration process.

• Assist clients in enhancing the usability, consistency, and reliability of enterprise data.

• Facilitate sessions for requirements gathering and data discovery.

• Clarify complex data issues for both technical and non-technical stakeholders.

• Collaborate with client teams to troubleshoot issues and propose solutions.

• Relay project status, risks, assumptions, dependencies, and data quality insights to project leadership.

• Work alongside consultants, developers, architects, analysts, and project managers.

• Initially support the Data Migration team, with potential to expand into Analytics and broader Data Services & Analytics initiatives.

⛳️ Requirements

• Over 7 years of experience in data analysis, data migration, data integration, business intelligence, data warehousing, or related fields.

• Advanced proficiency in writing and troubleshooting SQL for enterprise relational databases.

• Proven experience in analyzing complex datasets and understanding interrelations across multiple systems.

• Familiarity with data mapping, ETL/ELT processes, data transformation, or system migration initiatives.

• Strong knowledge of relational databases, data models, joins, keys, and data relationships.

• Experience in data profiling, validation, reconciliation, and quality analysis.

• Ability to translate business needs into technical data requirements.

• Experience in gathering requirements directly from both business and technical stakeholders.

• Strong analytical, problem-solving, documentation, and communication skills.

• Capability to manage multiple priorities and function effectively in a client-facing consulting environment.

• Proven ability to establish trusted advisor relationships with clients.

• Experience in supporting sales and business development efforts.

• Willingness to travel occasionally based on business and client requirements.

• Preferred: experience in higher education and institutional data environments.

• Preferred: familiarity with Ellucian Banner, PeopleSoft, Workday, Slate, Advance, or comparable enterprise applications.

• Preferred: knowledge of Salesforce, its 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: familiarity with AWS or Azure.

• Preferred: experience in developing or supporting enterprise data warehouses.

• Preferred: knowledge of Power BI, Tableau, or Salesforce Analytics.

• Preferred: experience in creating formal source-to-target mapping documents and migration specifications.

🏝️ Benefits

• Competitive health, dental, and vision insurance coverage.

• HSA and FSA accounts available.

• Life and disability insurance provided.

• Benefits for fertility and family planning.

• Employee assistance and discount programs.

• 11 paid federal holidays observed.

• Flexible unlimited time off (UTO) policy.

• Generous 401(k) matching with immediate vesting.

• Flexible career paths that allow for advancement, mobility, and adaptability.

• Flexible working environment.

• An industry-leading benefits package starting on the first day of employment.

• Eligibility for an annual discretionary bonus.