Experienced Full Stack Data Analyst – Microsoft Excel, Microsoft Access, and Cloud Infrastructure Development
About Custom Software Systems Inc.
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.
Job Summary
We are seeking an experienced Full Stack Data Analyst to join our team. As a key member of our data analytics team, you will be responsible for creating and updating detailed reports and templates, developing macros for data cleansing and processing, and providing end-user training. This is a 100% remote position, offering flexibility and the opportunity to collaborate with a dedicated team supporting operational excellence.
Responsibilities
- Design and Create Reports and Databases: Utilize Microsoft Excel (Office 365) to design and create reports and databases that ensure functionality on individual computer hard drives.
- Develop and Implement Macros: Develop and implement macros for data cleansing and processing to automate report and summary worksheet population.
- Consolidate and Update Reports: Consolidate and update multiple reports for streamlined operations, ensuring preapproval for any modifications.
- Prepare Final Reports: Prepare final reports that are printable in PDF or hard copy format.
- Recreate and Enhance Templates: 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 Data Migration: Ensure seamless migration of data into Excel worksheets and apply cleaning macros as needed.
- Provide Virtual Training Sessions: Provide virtual training sessions, recorded for future reference, on creating and troubleshooting macros and formulas.
- Develop Instruction Sheets: Develop detailed instruction sheets that comply with Section 508 requirements for accessibility.
- Support Data Transfer: Offer support in transferring data to QuickBooks templates using custom macros.
Required Qualifications
We are seeking a highly skilled and experienced Data Analyst with the following qualifications:
- Extensive Experience with Microsoft Excel: Advanced proficiency in formulas, macros, and data visualization tools.
- Proven Expertise in Microsoft Access: Creating and maintaining databases.
- Strong Ability to Build Data Cleansing Macros: Automating processes for efficiency.
- Skilled in Training End-Users: Creating and utilizing Excel reports and tools.
- Ability to Work Remotely: Demonstrating strong communication and collaboration skills.
- Commitment to Delivering High-Quality Work: Meeting specified timelines.
Education
A Bachelor's degree in Data Analytics, Information Systems, Business Administration, or a related field is required. Equivalent experience may be considered.
Clearance and Citizenship
N/A
Desired Qualifications
We are looking for a candidate with the following desired qualifications:
- Experience in Data Migration and Integration: Integrating data into Excel worksheets.
- Familiarity with Developing Reports: Agricultural and administrative divisions, including cotton price statistics and user-fee billing analysis.
- Knowledge of Section 508 Compliance Standards: Creating training materials and conducting virtual training sessions.
Compensation and Benefits
We offer a competitive salary and benefits package, including:
- Wage Range: $99,999.99 - $99,999.99 per year or $99.99 - $99.99 per hour.
- Health Insurance Plans: Medical, dental, and vision insurance.
- Health Savings Account (HSA): A tax-advantaged savings account for medical expenses.
- Long-term Disability: Protection against long-term disability.
- Short-term Disability: Protection against short-term disability.
- Basic Term Life Insurance: Basic life insurance coverage.
- Supplemental Term Life Insurance: Additional life insurance coverage for employees, spouses, and dependents.
- Simple IRA: A retirement savings plan.
- Parking and Commuting Expense Reimbursement: Reimbursement for parking and commuting expenses.
- Training and Education: Opportunities for training and education.
Company Culture and Work Environment
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, paid holidays and paid time off, medical insurance, dental insurance, company-paid long and short-term disability and life insurance, a Simple IRA plan, parking and commuter reimbursement, and 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 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.
How to Apply
If you're a motivated and experienced Data Analyst looking for a new challenge, please submit your application today! Don't worry if you don't meet every single requirement - we value a great attitude and a willingness to learn above all.
Apply for this job