Applications Analyst

Agreeya Solutions Sunnyvale , CA 94085

Posted 4 days ago

Job Description:

  • Seeking analysts to be a technical resource in supporting our HCM data migration from legacy application and integrations definition for ERP/HCM implementation.

  • In addition, this role will provide primary IT technical support with various database (Oracle and SQL Server) and interface tools (scripting and reporting).

  • This position is required to participate in a hardcharging project environment, quickly analyzing and understanding legacy systems and help identify the best solutions in a timely manner utilizing database, programming and application analysis skills.

Required Skills/Experience:

  • Working knowledge of Oracle, Microsoft SQL Server, and Microsoft Access

  • Ability to learn and understand application data table structure to create database schemas and ability to conditionally extract data directly from data base to create complex database views with Strong SQL programming

  • Experience with Microsoft SQL Server and Oracle database backup/restore processes and Microsoft SQL Server SSIS

  • Define, manage and/or perform the design, testing, implementation and documentation of IT systems per agreed timelines, business requirements and organization standards in collaboration with internal business units

  • Experience developing interfaces and integration between different system

  • Extract & transform for data integration

  • Work as a crossfunctional team member, critically evaluate and manage user requests to ensure accurate prioritization and optimal resolutions

  • Lead communication with internal staff, business users, and technology service providers to bridge the requirement gaps and technical needs

  • 2+ years' experience in IT Applications

  • 2+ years' report development in Oracle BI Publisher, Crystal reports or SSRS

  • 4year degree or Master's degree related to Computer Science and Business Analyst

General Skills & Abilities:

  • Communications skills to define and document requirements

  • Excellent documentation skills

  • Willingness to document processes and procedures, enabler of turnover to production

Desired Skills/Experience:

  • Working experience of creating Oracle Packages/functions and Microsoft SQL Server stored procedures

  • Experience supporting application functions like Payroll, Time Reporting, Absences, Benefits, Position Budgeting and Core HR

  • Working experience of developing reports in Oracle Fusion including Oracle BI Publisher and OTBI

  • Working experience of Oracle Fast Formula, HCM extract

  • Experience with programming

  • Experience working on interface development between finance/HR system (eP/NextGen) and Questica budget system

  • Experience with a publicsector agency

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
SAP Supply Chain Analyst

Amick Brown, LLC

Posted Yesterday

VIEW JOBS 1/28/2023 12:00:00 AM 2023-04-28T00:00 <span><span><span sans-serif""="">Amick Brown is seeking an experienced <b>SAP Supply Chain Analyst</b> for our direct client.</span></span></span><br><span><span><span sans-serif""=""><b>Location:</b> S<span>unnyvale</span>, CA / remote</span></span></span><br><span><span><span sans-serif""=""><b>Duration:</b> 4 Months</span></span></span><span><span><span sans-serif""="">Estimated pay range: $74.07 - $92.59 an hour per client contract and candidate skills, experience and work location</span></span></span><br><span><span><span sans-serif""=""><b>Description</b></span></span></span><ul><li style="margin-left:8px"><span><span><span sans-serif""="">Business Intelligence Analyst: Analyzes complex business problems and issues using data from internal and external sources to provide insight to decision-makers. </span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Identifies and interprets trends and patterns in datasets to locate influences. </span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Constructs forecasts, recommendations and strategic/tactical plans based on business data and market knowledge. </span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Creates specifications for reports and analysis based on business needs and required or available data elements. </span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">May provide consultation to users and lead cross-functional teams to address business issues. </span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">May directly produce datasets and reports for analysis using system reporting tools.</span></span></span></li></ul><div><strong>Top skills</strong><ul><li style="padding: 0; margin: 0;">SAP MRP, SAP PP, Advance planning tool skills like APO, IBP, O9 or Blue Yonder</li></ul><strong>Experience</strong><ul><li style="padding: 0; margin: 0;">at least 8 years' experience</li><li style="padding: 0; margin: 0;">Service part planning experience is a plus</li></ul><strong>Location:</strong><ul><li style="padding: 0; margin: 0;">prefer in the bay area, otherwise remote is fine</li></ul></div><br><span><span><span sans-serif""="">Amick Brown is an Information Technology consulting company specializing in ERP, Data Analytics, Information Security, Application Development, Networking, and Cloud Computing. The company was founded in 2010 and is headquartered in San Ramon, California.</span></span></span><br><span><span><span sans-serif""="">Regular full-time employees are eligible for the following Amick Brown provided benefits:</span></span></span><ul><li style="margin-left:8px"><span><span><span sans-serif""="">Vision</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Dental</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">401k Health</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">with company match</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Paid time off</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Sick Leave</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">long-Term Disability</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Life Insurance</span></span></span></li><li style="margin-left:8px"><span><span><span sans-serif""="">Wellness & Discount Programs</span></span></span></li></ul> Amick Brown, LLC Sunnyvale CA

Applications Analyst

Agreeya Solutions