Remote Data Analyst

Custom Software Systems Inc. (CSS) is seeking a motivated Data Analyst with strong expertise in Microsoft Excel and Microsoft Access to join our team. This role involves creating and updating detailed reports and templates, developing macros for data cleansing and processing, and providing end-user training. The position is 100% remote, offering flexibility and the opportunity to collaborate with a dedicated team esupporting operational excellence.
Required experience with the following is needed: Microsoft Excel (Office 365) with Macros and advanced formulas, Microsoft Access for database development, QuickBooks with macro integration, SQL for queries and data manipulation, UNIX Shell Scripts, PowerShell, Oracle Forms and Reports, Section 508 Compliance Tools, AWS Infrastructure (optional), 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, and cloud infrastructure knowledge (optional).

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
Required Qualifications
? 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.
Education
? Bachelor's degree in Data Analytics, Information Systems, Business Administration, or a related field. Equivalent experience may be considered.
Clearance
N/A
Citizenship
U.S. Citizen or Green Card Holder
Desired Qualifications
? 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.

Compensation & Benefits
? Wage Range: [[$99,999.99 ? $99,999.99 per year] or [$99.99 - $99.99 per hour]]
? General Benefits: Custom Software Systems, Inc. offers our employees a competitive benefits package that may include:

? Health insurance plans
? Health Savings Account (HSA)
? Dental
? Vision
? Long-term disability
? Short-term disability
? Basic term life insurance
? Supplemental term life insurance for employees, spouses, and dependents
? Simple IRA
? Parking/Commuting expense reimbursement
? Training/Education

Company DescriptionCompany Background:
Headquartered in Leesburg, Virginia, Custom Software Systems, Inc. (CSS) is a Woman-Owned (WOSB) and HUBZone certified small business. Built on a foundation of trusted client partnerships, CSS has fostered a stakeholder-centric yet disciplined approach to IT solutions development. This ensures our ability to consistently meet or exceed our customers' expectations.

Benefits:
CSS is a very employee oriented company knowing that well trained, professional associates are what make our company great. We offer a competitive benefits package that includes: paid holidays and paid time off; medical insurance that includes vision; dental insurance; company paid long and short-term disability and life insurance; a Simple IRA plan (similar to 401k); parking and commuter reimbursement. We also work with our employees on training and professional certification plans that benefit the employee, the client and CSS - a win-win-win strategy.

Equal Opportunity Employer:
CSS provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. CSS complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

CSS expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of CSS employees to perform their expected job duties is absolutely not tolerated.

Apply Job!