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.
...Job Description Job Description House Inspection Services is seeking a Professional Home Inspector to join our team in North Dallas, Texas. If you are passionate about making a positive impact in the realm of property ownership, this opportunity is for you. Our...
...Environmental Services, Healthcare Technology Solutions, Patient Transportation, Laundry & Linen, Facilities Management, and Ambulatory EVS. Learn more at .Job Summary... ...customer service? Working as the Patient Experience Manager, you will be recognized for those efforts...
Premier Transportation is looking for CDL Class A tractor trailer drivers to make Dedicated deliveries in the Southeast Region. We do not slip seat trucks! Our drivers are assigned a Freightliner tractor and are Home Daily . Schedule: Tues - Sat OR Sun - Thurs...
...locations worldwide, our team of over 3,500 employees excels in offering a multitude of mission-critical services. The Tank Wash Buffer will perform the operation of buffing stains and residue inside tanks by climbing and working in and out of tanks by buffing and...
...mission to offer hope, is seeking an Occupational Therapist to join our award-winning Special Education team and perform meaningful work in a culture that welcomes innovation, encourages creative expression and offers limitless potential for personal and professional...