Title: Data Analyst
Location: Hybrid in Des Moines, IA
We are seeking a highly analytical and detail-oriented Data Analyst to join our CRM team. In this role, you will focus on deep data work-including gap analysis, data profiling, and Source-to-Target (S2T) mapping for both structured and unstructured data-as part of complex data migration and integration projects. You will also play a key role in supporting Monthly Recurring Revenue (MRR), non-MTM (non-monthly, non-recurring), sales data analysis, and contribute to the development and optimization of new data pipelines. The ideal candidate is passionate about understanding data at its core, possesses advanced SQL skills, and has experience working with CRM and sales data. This is a hands-on, technical position focused on the foundational work that enables high-quality analytics and business operations.
Key Responsibilities
Conduct comprehensive gap analysis to identify data discrepancies and requirements between legacy and target systems, especially within CRM and sales data domains.
Perform data profiling to assess data quality, completeness, consistency, and structure for both structured and unstructured data sources.
Develop detailed Source-to-Target (S2T) mapping documentation to guide the migration and transformation of data from old systems to new environments.
Write and optimize complex SQL queries for data extraction, manipulation, validation, and analysis across CRM, MRR, non-MTM, and sales data sets.
Collaborate with CRM, sales, and business stakeholders to understand data requirements and ensure accurate data movement and transformation.
Support the analysis and reporting needs for MRR, non-MTM, and sales data, ensuring data integrity and actionable insights for the business.
Participate in the design, development, and optimization of new data pipelines to support evolving business and analytics needs.
Troubleshoot data issues, investigate anomalies, and provide recommendations for data cleansing and remediation.
Document data definitions, mapping logic, transformation rules, and data lineage as part of the migration and integration process.
Participate in data migration testing and validation to ensure data integrity and completeness post-migration.
Communicate findings, risks, and recommendations clearly and effectively to both technical and non-technical audiences.
Qualifications
Bachelor's degree in computer science, Information Systems, Data Science, or a related field.
6-10+ years of hands-on experience in data analysis, data profiling, and data mapping, especially in migration, integration, or CRM projects.
Demonstrated advanced SQL skills (writing, optimizing, and troubleshooting complex queries).
Experience with CRM data, MRR, non-MTM, and sales data analysis.
Experience with both structured (relational databases) and unstructured (text, documents, etc.) data.
Strong analytical and problem-solving skills with a passion for deep data exploration and understanding.
Excellent written and verbal communication skills, with the ability to document and explain complex data concepts and findings.
Detail-oriented, organized, and able to manage multiple priorities in a dynamic environment.
Preferred Skills
Experience with large-scale data migration, CRM system integration, or data pipeline projects.
Familiarity with data quality tools, ETL processes, or scripting languages (Python, etc.).
Knowledge of data governance, data lineage, and best practices for data management.
Experience with legacy systems and modern data platforms.
Thanks,
Subia Khan
DESK: 856 268 0027, 856-456-1805 EXT: 1032
w: e: subia@momentousa.com
440 Benigno Blvd, Unit#A 2nd Floor. Bellmawr, NJ 08031
Interstate Business Park
Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
We are Looking for a full-time Education Service Consultant for a training center located in Shenzhen. About the programThe students are... ...applications7 days hotel stay on arrivalExpat + HR support - apartment search, bank opening etc.Worldwide Health Insurance (including dental)
Located in NW Houston, Be Strong Fitness is hiring a driven and reliable coach to lead strength-based group classes and support our members beyond the workouts. This is more than just a coaching job - youll be helping people stay consistent, stay connected, and ultimately...
(Physician/MD qualifications required) Anesthesiology (Cardiac) - Large interventional pain management group located in Baltimore Metropolitan area with multiple offices and multiple doctors and PA's looking to add additional physician who is trained in interventional...
...Japanese Bilingual Purchasing Assistant Who we are: Established in 1926, Mutual Trading Co., Inc. was originally a small co-op organization for centralized purchasing of basic import foods to service the needs of the early Japanese immigrant society in Southern...
...The Entry Level Marketing & Communications team sets the marketing strategy and master calendar... ...This position does not require prior experience as full training is provided, but as we... ..., counselor, travel, teaching, help desk, law enforcement, trainer, media, professional...