See more Collapse

Data Business Analyst

2 months ago

Mahwah, United States Ledgent Technology Full time

This role will align to business process areas to support the data conversion and readiness activities to prepare for the ERP systems deployment/go live. Support data cleansing (correction in legacy system) and data construction (the collection of "new" data). Support data validation activities. Monitors and responds to Data Readiness Reports. Participates in Cutovers and DLs responding to "Tap" emails. Partner with program on data load templates to ensure readiness. Work with the team to capture test data sets required for proper testing scenarios. Support testing efforts as needed. Proficiency in Microsoft programs including excel is required as well as the ability to create formulas to support data analysis. MUST KNOW EXCEL POWER QUERY.

When it comes to Excel and analytics skills, consider the following key competencies:

1. **Excel Power Query:** - **Data Transformation:** Ability to clean, transform, and reshape data from various sources. - **Query Development:** Proficiency in creating complex queries using the Power Query editor. - **Data Importing:** Experience in importing data from multiple sources (Excel files, CSVs, databases, web services).

2. **Advanced Excel Skills:** - **Formulas and Functions:** Strong understanding of advanced Excel formulas and functions (e.g., VLOOKUP, INDEX/MATCH, SUMIFS, etc.). - **PivotTables and PivotCharts:** Ability to create and manipulate PivotTables and PivotCharts for data analysis. - **Conditional Formatting:** Knowledge of applying conditional formatting to highlight key data points.

3. **Data Analysis:** - **Statistical Analysis:** Basic understanding of statistical methods and their application in Excel. - **Data Visualization:** Skills in creating charts and graphs to visualize data insights effectively.

4. **Power BI (optional but beneficial):** - **Integration with Power Query:** Familiarity with Power BI for more advanced data modeling and reporting. - **Report Development:** Ability to create interactive dashboards and reports.

5. **Scripting and Automation:** - **VBA (Visual Basic for Applications):** Proficiency in writing VBA macros to automate repetitive tasks. - **M Language:** Understanding of the M language for advanced data transformations in Power Query.

6. **Database Skills:** - **SQL Knowledge:** Basic SQL skills to query databases and extract necessary data. - **Data Connectivity:** Experience with connecting Excel to external databases and data sources.

7. **Soft Skills:** - **Problem-Solving:** Strong analytical and problem-solving skills. - **Attention to Detail:** Meticulous attention to detail for data accuracy and integrity. - **Communication:** Ability to communicate findings and insights clearly to stakeholders. These skills will ensure the contractor can effectively handle data-related tasks, transform and analyze data, and provide actionable insights. (SQL might be optional

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

We have other current jobs related to this field that you can find below

  • Sr Business Analyst

    1 month ago

    Mahwah, United States The Computer Merchant, LTD. Full time

    Job Description: Senior Business Systems Analyst Location: Mahwah, NJ or Sandy Springs, GA - Onsite Wage Range: 40-41/hr W2 OR $48/hr C2C Job Number:UPS-REQ-0022029 5 Year Contract Senior Business Systems Analysis About this role: The Schedule, Time and Pay program is looking for a Senior Business Systems Analyst to support various activities of this...

  • Analyst, IS Business Support

    3 days ago

    Mahwah, United States The Judge Group Full time

    Job Title: Data Analyst Location: On Site in Mahwah, NJ Type: Contract 12+ MonthsRole Overview:As a Data Analyst, your role will align with business process areas to support data conversion and readiness activities in preparation for ERP system deployment and go-live. You will be responsible for data cleansing (correction in legacy systems), data...

  • Sr Business Analyst

    1 month ago

    Mahwah, United States The Computer Merchant Full time

    Job Description: Senior Business Systems Analyst Read all the information about this opportunity carefully, then use the application button below to send your CV and application. Location: Mahwah, NJ or Sandy Springs, GA - Onsite Wage Range: 40-41/hr W2 OR $48/hr C2C Job Number:UPS-REQ-0022029 5 Year Contract Senior Business Systems Analysis About this role:...

  • Pricing / Rebate Analyst - VIrtual

    1 month ago

    Mahwah, United States iMPact Business Group Full time

    Job Description Our client, a Global Leader in the Medical Device Industry has an immediate opening for a Pricing / Rebate Analyst for a 12 month + Contract. Our client offers results-driven people a place where they can make a difference - every day! You will also have the opportunity to work with other like-minded, self-directed and detail oriented Top...

  • Business Analysis

    4 weeks ago

    Mahwah, New Jersey, United States Eclaro Full time

    Lead Business Systems Analyst Join a renowned company in the logistics industry. We are currently seeking a Lead Business Systems Analyst for a challenging opportunity in a prime location. About Us: Work closely with key stakeholders and senior leadership to streamline processes and enhance productivity for the organization. Act as a vital link between...

  • Lead Financial Analyst

    4 weeks ago

    Mahwah, United States Stryker Full time

    Cultivate robust relationships with key stakeholders across the organization. Collaborate closely with the upstream marketing team to develop and review New Product Development models. Conduct comprehensive financial reviews with business leaders, of Financial Analyst, Financial, Analyst, Lead, Product Development, Business Partner, Manufacturing, Banking

  • Lead Financial Analyst

    3 weeks ago

    Mahwah, United States Stryker Full time

    We are excited to be named one of the World’s Best Workplaces by Fortune Magazine! We are proud to offer you 12 paid holidays annually. For an overview of our benefits and time off, please follow this link to learn more:US Stryker employee benefits....

  • Lead Financial Analyst

    4 weeks ago

    Mahwah, United States Stryker Full time

    Work Flexibility: Hybrid *This position will operate on a hybrid schedule where the candidate will be on-site at our Mahwah, NJ 2-3 days/week As a Lead Analyst, Finance you will serve as a key member supporting the Knee business unit, actively contributing to crafting and executing strategies aimed at fostering growth, enhancing profitability, and expanding...

  • Sales Operations Analyst

    4 weeks ago

    Mahwah, United States Stryker Corporation Full time

    **Why join Stryker?** The Sales Compensation Analyst will engage in key business partnerships with field sales leadership to develop incentive compensation plans and territory structures that drive growth and support Stryker’s strategic sales objectives. **Who We Want**: - ** Strategic thinkers. **People who enjoy analyzing data or trends for the...

  • Data Analyst

    2 months ago

    Mahwah, United States Comrise Full time

    OverviewSummary: Encompasses the application of scientific, technological, and mathematical principles to determine the most effective way for a manufacturing organization to use people, materials, equipment, information, and energy to make a product. Plans plant, office, and production facilities and equipment layouts; determines the most efficient sequence...

  • Sr Financial Analyst

    1 week ago

    Mahwah, United States The LOFT Full time

    About us KnitWell Group, a specialty retail operating company, comprises some of the most iconic brands in America – Ann Taylor, LOFT, Lane Bryant, and Talbots. Individually, our brands are unique and strong. Together, we are powerful.Our common thread is our commitment to create exceptional products, provide memorable experiences, and achieve superior...

  • Sr Financial Analyst

    2 months ago

    Mahwah, United States Ascena Retail Group Full time

    About us KnitWell Group, a specialty retail operating company, comprises some of the most iconic brands in America - Ann Taylor, LOFT, Lane Bryant, and Talbots. Individually, our brands are unique and strong. Together, we are powerful. Our common thread is our commitment to create exceptional products, provide memorable experiences, and achieve superior...

  • Business Analyst- with direct Client on UPS

    1 month ago

    Mahwah, United States Avacend Full time

    Job DescriptionJob DescriptionJob Title:Business Systems AnalystLocation:Mahwah, NJ 07430Start Date: 5/1/2024Est. End Date: 3/31/2026Conduct data analysis and requirements elicitation/analysisComplete functional and non functional requirements, plan system integrations, and other applicable artifacts necessary for test, design, and automationCreate analysis...

  • School Services

    4 weeks ago

    Mahwah, United States Therapy Staff EDU Full time

    Job DescriptionTherapy Staff EDU is seeking a School Services Board Certified Behavioral Analyst (BCBA) for a local contract job in Mahwah, New Jersey.Job Description & RequirementsSpecialty: Board Certified Behavioral Analyst (BCBA)Discipline: School ServicesStart Date: 07/31/2024Duration: 36 weeks40 hours per weekShift: 8 hours, daysEmployment Type: Local...

  • School Services

    4 weeks ago

    Mahwah, United States Therapy Staff EDU Full time

    Therapy Staff EDU is seeking a School Services Board Certified Behavioral Analyst (BCBA) for a local contract job in Mahwah, New Jersey.Job Description & RequirementsSpecialty: Board Certified Behavioral Analyst (BCBA)Discipline: School ServicesStart Date: 07/31/2024Duration: 36 weeks40 hours per weekShift: 8 hours, daysEmployment Type: Local ContractAequor...

  • Data Entry Clerk

    7 days ago

    Mahwah, United States iLabs Full time

    Who We Are Amare Global is committed to fostering a clear distinction between Mental Wellness and Mental Health Disorders. We emphasize that Mental Wellness is a holistic state of mental well-being that should not be equated to or confused with Mental Health Disorders. The Way We Work At Amare, we help people believe in themselves and experience their own...

  • Contracts Analyst

    2 months ago

    Mahwah, New Jersey, United States Aston Carter Full time

    Description: These two positions will be focused on the contract activation side of the contract life cycle. They are not going to be having a back and forth with the custoemrs but once the deals are signed they are going to set up and activate the deals in the system. They will upload the pricing and handle the pricing files. There is a lot of work inside...

  • Sr. Financial Analyst

    1 month ago

    Mahwah, United States The Ladders Full time

    Sr. Financial Analyst - Sales Financial Operations - Mahwah NJMahwah NJJob Summary: Key finance professional responsible for developing critical business intelligence reports relied upon by executive management in making timely business decisions, including daily/weekly sales and order reports. Responsibilities of the sales finance operations team also...

  • Sr. Financial Analyst

    1 month ago

    Mahwah, United States Mindray North America Full time

    Job DescriptionJob DescriptionSr. Financial Analyst - Sales Financial Operations - Mahwah NJMahwah NJJob Summary:Key finance professional responsible for developing critical business intelligence reports relied upon by executive management in making timely business decisions, including daily/weekly sales and order reports. Responsibilities of the sales...

  • Sr. Financial Analyst

    1 month ago

    Mahwah, United States Mindray North America Full time

    Job DescriptionJob DescriptionSr. Financial Analyst - Sales Financial Operations - Mahwah NJMahwah NJJob Summary:Key finance professional responsible for developing critical business intelligence reports relied upon by executive management in making timely business decisions, including daily/weekly sales and order reports. Responsibilities of the sales...