Sr Data Analyst

7 days ago


Los Angeles, California, United States TechnoGen Full time

Title: Sr Data Analyst

Location: Los Angeles, Remote

Sr Data Analyst

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

• Data Conversion Experience: Proven expertise in enterprise-wide data conversion projects, including data mapping and validation. Hands-on experience with at least three implementations of enterprise-wide applications, such as ERP systems.

• SQL Proficiency: Expert level skills in SQL, with the ability to query and manipulate large datasets.

• Advanced Excel Expertise: Demonstrated expertise with Excel for data analysis, including advanced formulas, pivot tables, and macros.

• Data Quality Management: Hands-on experience with data cleanup, reconciliation, and validation techniques.

• Analytical Skills: Strong ability to analyze complex data structures and provide actionable insights.

• Technical Documentation: Ability to document processes, workflows, and data mapping logic clearly and concisely.

• Team Collaboration: Experience working with diverse teams and stakeholders to achieve project objectives.

• Communication: Clear and concise communication skills, both written and verbal, with the ability to explain technical concepts to non-technical stakeholders.



  • Los Angeles, California, United States GUESS Full time

    Job DescriptionPOSITION TITLE: Sr. Financial Data AnalystPOSITION PURPOSE: The Sr. Financial Data Analyst will combine the analytical skills of a traditional financial analyst with the advanced data manipulation and modeling capabilities of a data scientist, allowing the individual to leverage complex data sets to generate key financial insights.ESSENTIAL...


  • Los Angeles, California, United States GUESS?, Inc. Full time

    The Guess?, Inc. Finance department is seeking a curious individual to join their essential team. The department's responsibilities include traditional financial duties such as accounting, planning and analysis, and shareholder outreach alongside partnering with the executive team to define our organization's capital allocation strategy. The department also...


  • Los Angeles, California, United States GUESS?, Inc. Full time

    The Guess?, Inc. Finance department is seeking a curious individual to join their essential team. The department's responsibilities include traditional financial duties such as accounting, planning and analysis, and shareholder outreach alongside partnering with the executive team to define our organization's capital allocation strategy. The department also...


  • Los Angeles, California, United States GUESS?, Inc. Full time

    The Guess?, Inc. Finance department is seeking a curious individual to join their essential team. The department's responsibilities include traditional financial duties such as accounting, planning and analysis, and shareholder outreach alongside partnering with the executive team to define our organization's capital allocation strategy. The department also...


  • Los Angeles, California, United States Jobot Full time

    Sr. Kronos Business Analyst-100% Remote-Must work PST-Contract to Hire OpportunityThis Jobot Job is hosted by: Robert ReyesAre you a fit? Easy Apply now by clicking the "Apply Now" button and sending us your resume.Salary: $112,000 - $124,700 per yearA bit about us:Sr. Kronos Business Analyst-100% Remote-Must work PST-Contract to Hire OpportunityPrestige...


  • Los Angeles, California, United States Jobot Full time

    Sr. Kronos Business Analyst-100% Remote-Must work PST-Contract to Hire Opportunity This Jobot Job is hosted by: Robert ReyesAre you a fit? Easy Apply now by clicking the "Apply Now" button and sending us your resume.Salary: $112,000 - $124,700 per yearA bit about us:Sr. Kronos Business Analyst-100% Remote-Must work PST-Contract to Hire Opportunity Prestige...


  • Los Angeles, California, United States Jobot Full time

    Sr. Kronos Business Analyst-100% Remote-Must work PST-Contract to Hire OpportunityIf you think you are the right match for the following opportunity, apply after reading the complete description.This Jobot Job is hosted by: Robert ReyesAre you a fit? Easy Apply now by clicking the "Apply Now" button and sending us your resume.Salary: $112,000 - $124,700 per...

  • Sr. Technical Analyst

    4 weeks ago


    Los Angeles, California, United States ShiftCode Analytics Full time

    We need a Sr. Technical Analyst - Health insurance Data for a 3-4 month contract-to-hire role in Los Angeles, CA. This role will be Remote full time, but the client is looking for someone who will convert to Permanent employee status after 3-4 months . Thus, they are focusing on candidates who are LOCAL to CA, with extra preference given to those who...

  • Sr. Data Scientist

    4 weeks ago


    Los Angeles, California, United States Pyramid Technology Solutions, Inc Full time

    Job Role: Sr. Data ScientistIs your CV ready If so, and you are confident this is the role for you, make sure to apply asap.Location: Los Angeles, CA - RemoteDuration: 12 Months ContractIs this role located on-site, hybrid, or remote?: RemoteIs a Livescan Required for Position?: YesPosition Description:An Informatics Data Analyst works independently to...


  • Los Angeles, California, United States AEG Full time

    Company Information For more than 20 years, AEG has played a pivotal role in transforming sports and live entertainment. Annually, we host more than 160 million guests, promote more than 10,000 shows and present more than 22,000 events around the world. We are committed to innovation, artistry, and community, and leverage the power of our 300+ venues,...

  • Sr. Data Scientist

    4 weeks ago


    Los Angeles, California, United States Tech Providers Full time

    Position : Sr. Data Scientist Duration: 12+ month contract (Potential for extension) Location: Los Angeles, CA (Remote) (Live Scan Required)Skills Required: The Informatics Data Analyst will possess knowledge and experience in basic statistical concepts; identifying the trends, business opportunities, and relevant issues; commonly-used demographics and...


  • Los Angeles, California, United States West Advanced Technologies (WATI) Full time

    SR. BUSINESS ANALYSTS Commerce, CA 6 monthsBachelor's degree or higher from an accredited college or university in Computer Science, Management Information Systems, Software Development, Business Administration/Management or related field Three (3) years of experience within the last five (5) years working as a business analyst conducting business analyst...


  • Los Angeles, California, United States MedPOINT Management Full time

    Job Description Job Description SummaryUnder the guidance of the Auditing & Recoveries Manager & Supervisor, the Financial Recovery Data Analyst is responsible for overlooking the OB Maternity Kick agreements for MPM's Hospital & IPA clients. This includes submitting, tracking & reconciling deliveries.Duties and ResponsibilitiesPrepare monthly reporting for...


  • Los Angeles, California, United States Adecco USA Full time

    One of Asia's largest beauty ecommerce and retail leaders is expanding to the US and is seeking a Sr. Accounting Analyst. In this role, you will generate and consolidate financial statements, perform reconciliations, assist in budgeting and the establishment of accounting and finance processes. This is a highly impactful role with a stable and profitable...

  • Data Analyst

    2 weeks ago


    Los Angeles, California, United States iSpace Full time

    Data Analyst / Data Modeler Location: Los Angeles CA Duration: 3+ months contract Client is looking for a Data Analyst/Data Modeler that can help them to fully document their current schema and data models in MongoDB (and potentially in MS SQL). Experience with MongoDB is crucial as this person would need to work independently in that environment Strong...

  • Data Analyst

    2 weeks ago


    Los Angeles, California, United States iSpace Full time

    Data Analyst / Data Modeler Location: Los Angeles CA Duration: 3+ months contract Client is looking for a Data Analyst/Data Modeler that can help them to fully document their current schema and data models in MongoDB (and potentially in MS SQL). Experience with MongoDB is crucial as this person would need to work independently in that environment Strong...

  • QA Sr Analyst

    2 weeks ago


    Los Angeles, California, United States PlayStation Global Full time

    Why PlayStation? PlayStation isn't just the Best Place to Play - it's also the Best Place to Work. Today, we're recognized as a global leader in entertainment producing The PlayStation family of products and services including PlayStation5, PlayStation4, PlayStationVR, PlayStationPlus, acclaimed PlayStation software titles from PlayStation Studios, and more....

  • QA Sr Analyst

    3 weeks ago


    Los Angeles, California, United States Sony Interactive Entertainment Full time

    Why PlayStation? PlayStation isn't just the Best Place to Play - it's also the Best Place to Work. Today, we're recognized as a global leader in entertainment producing The PlayStation family of products and services including PlayStation5, PlayStation4, PlayStationVR, PlayStationPlus, acclaimed PlayStation software titles from PlayStation Studios, and more....

  • Data Analyst

    2 weeks ago


    Los Angeles, California, United States Alexis Fiscal Advisory Full time

    Job Title: Data Analyst Representative - Alexis Fiscal Advisory (Remote) Location: Remote Job Type: Full-time / Part-time About Us: Alexis Fiscal Advisory is seeking a Data Analyst Representative to analyze financial data and provide insights to support business decisions in a remote setting. Key Responsibilities: Analyze financial data and trends. Prepare...


  • Los Angeles, California, United States FASTENER DISTRIBUTION HOLDINGS LLC. Full time

    Job Description Job Description FDH Aero is a trusted global supply chain partner for aerospace and defense companies. With more than 55 years of experience, it specializes in c-class components that include hardware, electrical, chemical, and consumable products and services for global OEM and aftermarket customers. At FDH Aero, we understand that the...