Remote Advanced Excel Jobs (NOW HIRING)

IT Applications Analyst- 100% remote (Dallas, TX)
Overview Requirements
Plan to convert to full time after 90 days
100% remote (Dallas, TX)
Prefer candidates in the Dallas area, but not mandatory
Core Business Hours: Must be available to work 8:00 AM - 5:00 PM Central Time
U.S. citizenship required. No sponsorship provided.
Job Tech Requirements
Intermediate SQL experience, including writing queries, not just executing prewritten queries
Financial software background
Advanced Excel experience
API experience preferred
Software application support experience
Strong verbal and written communication skills, sufficient to produce reports, communicate with customers, and collaborate with team members.
Job Summary
The IT Applications Analyst will become an application and business process expert, partnering with business users to define development requests, including enhancements and application or procedural issues. This role analyzes requirements, develops and executes test plans, supports root cause analysis for production issues, and works collaboratively across departments in a team-focused environment.
Essential Duties and Responsibilities
Provide application and business process support under general supervision, helping improve processes, services, and software to increase business efficiency.
Act as a liaison between business users and the IT group.
Develop scope and define backlog items, including epics, features, and user stories, to support Agile software development teams and/or third-party vendors.
Interpret and document technical publications, diagrams, and project specifications.
Partner with business stakeholders to recommend solutions that help the organization achieve its goals.
Collaborate with business stakeholders throughout the Scrum development process to gather requirements and provide status demonstrations.
Develop and execute robust test scripts and support regression testing activities.
Analyze complex data sets to identify trends, issues, and opportunities.
Conduct root cause analysis in support of process improvements and issue resolution.
Identify defects, document expected results, and escalate issues as needed.
Provide demonstrations during Scrum development releases for IT and business stakeholders.
Perform basic fixes and data maintenance.
Assist with demos and training materials for new development releases.
Provide 24/7 production support as required.
Perform other related duties as assigned.
Minimum Requirements
Bachelors degree or equivalent specialized work experience may be considered in lieu of degree.
5+ years of related work experience.
Experience developing and executing test plans under a Scrum development methodology.
Knowledge, Skills, and Abilities
Strong technical, analytical, and problem-solving skills.
Ability to understand data structure and data flow.
Knowledge of Agile Scrum development methodology.
Familiarity with Microsoft SQL.
Proficiency in Microsoft Office Suite, including Word, Excel, and PowerPoint.
Advanced Microsoft Excel skills preferred, including delimited files, VLOOKUP, and pivot tables.
Strong verbal and written communication skills.
Adaptability and the ability to multitask in a fast-paced environment.
Customer service orientation.
Ability to work collaboratively in a team and independently.
Accountability and results-driven mindset.
Familiarity with finance business processes such as General Ledger, Fixed Assets, Indirect Sourcing and Procurement, Payables, Receivables, Revenue Accounting, Tax, and Treasury.
Scope
Supervision: Not applicable for this job
Complexity of Work: Semi-Complex
Independent Judgement and Decision Making: General Supervision
Working Conditions and Physical Demands
Remote/office-based work environment
Travel to offsite locations: Occasionally, up to 20%
Physical demands are consistent with a standard office environment
Start Time: 8 am
End Time: 5 pm