iQuasar LLC ยท 6 hours ago
Data Analyst
United States
Full-time
Remote
Entry Level
Maximize your interview chancesCRMInformation Technology
Insider Connection @iQuasar LLC
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Design and create reports and databases using Microsoft Excel (Office 365) to ensure functionality on individual computer hard drives.
Develop and implement macros for data cleansing and processing to automate report and summary worksheet population.
Consolidate and update multiple reports for streamlined operations, ensuring preapproval for any modifications.
Prepare final reports that are printable in PDF or hard copy format.
Recreate and enhance various templates and reports, such as daily spot cotton quotations, monthly/annual cotton price statistics, user-fee billing and analysis, and budget operating plan formulations.
Ensure seamless migration of data into Excel worksheets and apply cleaning macros as needed.
Provide virtual training sessions, recorded for future reference, on creating and troubleshooting macros and formulas.
Develop detailed instruction sheets that comply with Section 508 requirements for accessibility.
Offer support in transferring data to QuickBooks templates using custom macros.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Extensive experience with Microsoft Excel, including advanced proficiency in formulas, macros, and data visualization tools.
Proven expertise in creating and maintaining Microsoft Access databases.
Strong ability to build data cleansing macros and automate processes for efficiency.
Skilled in training end-users on creating and utilizing Excel reports and tools.
Ability to work effectively in a remote environment, demonstrating strong communication and collaboration skills.
Commitment to delivering high-quality work within specified timelines.
Preferred
QuickBooks with macro integration
SQL for queries and data manipulation
UNIX Shell Scripts
PowerShell
Oracle Forms and Reports
Section 508 Compliance Tools
AWS Infrastructure
GitLab or Azure DevOps for CI/CD
NIST 800-53 Standards for FISMA compliance
Agile methodologies
data migration and cleaning processes
report automation
virtual training platforms
documentation standards
database design
cloud infrastructure knowledge
Experience in data migration and integration into Excel worksheets.
Familiarity with developing reports for agricultural and administrative divisions, including cotton price statistics and user-fee billing analysis.
Knowledge of Section 508 compliance standards.
Background in creating training materials and conducting virtual training sessions.
Company
iQuasar LLC
iQuasar is an information technology company that provides custom software implementation services.
Founded in 2004
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Tahir Qazi
Chief Executive Officer
Amin Bhat
Co-Founder
Recent News
Company data provided by crunchbase
