What are the responsibilities and job description for the Sr. SQL Data Analyst position at Momento USA?
Momento USA is a global technology consulting, talent acquisition and creative development firm that addresses clients most pressing needs and challenges. We currently looking for Sr. SQL Data Analyst Please see the job description below for your reference.
Role : Sr. SQL Data Analyst
Location : PST(Remote)
Duration Long term
Job Summary :
Looking for 2 Sr. Data Analyst with expert level Microsoft SQL Server expertise, with preference to the latest version (2022 or 2019). Also, he / she needs to have enough expertise with other RDBS like MySQL, Postgre SQL or Oracle Dat base server.
JOB DESCRIPTION
We are seeking a Senior Data Analyst to support the IPMS project through data conversion, cleanup, mapping, and validation. This role is critical to ensuring data accuracy and integrity during the transition and integration of systems. The ideal candidate will have experience working with large datasets, developing data mapping strategies, and performing rigorous validation checks. Familiarity with SQL Server, expert SQL skills, and advanced Excel skills for data analysis are essential.
ESSENTIAL DUTIES AND RESPONSIBILITIES (and other duties as assigned)
- Data Conversion : Execute data conversion strategies to ensure seamless migration of data from legacy systems to the new platform.
- Data Cleanup : Address data inconsistencies, duplicates, and other quality issues to maintain data integrity.
- Data Mapping : Collaborate to develop and implement data mapping logic to align source and target data structures, ensuring accuracy and completeness.
- Data Validation : Perform manual validation using excel and use automated validation tools identified as needed.
- Advanced Excel Analysis : Leverage advanced Excel skills, including pivot tables, VLOOKUP, macros, and complex formulas, to analyze and validate data effectively.
- SQL Server : Utilize SQL Server for querying, data analysis, and troubleshooting data issues. Expert level skill set in SQL scripting.
- Reporting : Create reports and dashboards to track data conversion progress and highlight key metrics.
- Collaboration : Work closely with cross-functional teams, including developers, business analysts, and project managers, to align data efforts with project goals.
- Documentation : Maintain comprehensive documentation of data conversion processes, mapping logic, and validation outcomes to support project transparency.
REQUIRED QUALIFICATION
Best Regards,
Sunitha Thapa
Desk 856 372 4625, 856-456-1805 Ext 1025
Email : sunitha@momentousa.com
linkedin.com / in / sunitha-thapa-sanu-649b46229
Web : www.MomentoUSA.com
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.
