1

Weekend Excel Vba Jobs in Washington (NOW HIRING)

Senior Research and Data Analyst

Washington, DC ยท On-site +1

$97K - $122K/yr

  • Medical

  • Dental

  • Vision

  • PTO

... VBA, Python, HTML,HighCharts, JavaScript, and Verint. * Mentorlesssenior colleaguestoexpand intheir knowledge of this work. * Monitorthe soundness, timeliness, impact, efficiency, and security of ...

Customs and Border Protection's Power Platform team by developing, maintaining, and enhancing Power BI dashboards, improving the structure of Excel, SharePoint, and SQL databases that feed into the ...

Showing results 41-60

Weekend Excel Vba information

What is a weekend Excel VBA job?

Weekend Excel VBA jobs are positions that involve using Visual Basic for Applications (VBA) programming within Microsoft Excel, specifically scheduled on weekends. These roles typically require automating tasks, creating macros, or developing custom solutions in Excel to improve efficiency. Weekend Excel VBA jobs are ideal for individuals seeking flexible or part-time work, often supporting projects, data analysis, or reporting needs for businesses outside of regular weekday hours.

What are the key skills and qualifications needed to thrive as a weekend Excel VBA specialist?

To excel as a Weekend Excel VBA Specialist, you need advanced skills in Microsoft Excel, proficiency in Visual Basic for Applications (VBA), and a solid background in data analysis or related fields. Experience with Excel add-ins, macros, and possibly certifications like Microsoft Office Specialist are typically expected. Strong problem-solving abilities, attention to detail, and effective time management set standout performers apart in this role. These skills are crucial for efficiently automating tasks, handling complex data operations, and delivering reliable solutions within limited weekend timeframes.

What are some common challenges faced by weekend Excel VBA professionals, and how can they be addressed?

Weekend Excel VBA professionals often face the challenge of quickly understanding and automating existing spreadsheets within limited hours, which requires strong analytical skills and adaptability. Communication with weekday team members can also be a hurdle, so clear documentation and proactive updates are essential. To overcome these challenges, it's important to prioritize tasks, maintain organized code, and use collaborative tools to ensure a smooth handoff and continuity between weekend and weekday teams.

What is the difference between Weekend Excel Vba vs Weekend Data Analyst?

AspectWeekend Excel VbaWeekend Data Analyst
Required SkillsExcel VBA, macros, automationData analysis, Excel, SQL, visualization
Work EnvironmentOffice, remote, freelanceOffice, remote, consulting
Industry UsageFinance, accounting, automation projectsBusiness intelligence, marketing, finance

Weekend Excel Vba focuses on automating tasks within Excel using VBA, while Weekend Data Analyst involves analyzing data, creating reports, and interpreting results. Both roles often require Excel proficiency, but Data Analysts typically need additional skills like SQL and data visualization. The choice depends on whether you prefer automation and scripting or data interpretation and reporting.

Is Excel VBA still in demand?

Excel VBA remains in demand for automating tasks, data analysis, and reporting in many industries. Professionals skilled in VBA can find opportunities in finance, accounting, and data management, especially for roles requiring process automation and efficiency improvements.

What are the most commonly searched types of Excel Vba jobs in Washington?

The most popular types of Excel Vba jobs in Washington are:

Senior Research and Data Analyst

AAMC

Washington, DC โ€ข On-site, Remote

$97K - $122K/yr

Full-time

Medical, Dental, Vision, PTO

Posted 5 days ago


Job description

Who We Are:

The Association of American Medical Colleges is a not-for-profit association dedicated to transforming health care by supporting the entire spectrum of medical education, medical research, and patient care conducted by our member institutions. We are dedicated to the communities we serve and steadfast in our goal to improve the health of all.


At the AAMC, we are committed to supporting our employees with a comprehensive and competitive benefits package designed to promote well-being, professionaldevelopment,and work-life balance.


  • HybridWork- Primarily remote roles with theabilityto work across the U.S.
  • Comprehensive Health & Wellness- Medical, dental, and vision coverage;wellness programs;and fitness reimbursement
  • Generous Time Away- Paid time off, holidays, personaldays,sickleave,paidparental leaveand shortand longterm disabilitybenefits.
  • Retirement & Financial Well-Being- 403(b)retirementplan with generous employer contributions and financial planning resources
  • Family & Care Support- Backup care for children, elders, and pets, plus resources for families with specialized needs
  • Learning & Purpose:Tuition reimbursement, professionallearning and developmentopportunitiesand the chance to advance a meaningful mission.

Additional information can be found on our website.

Why us, why now?

Senior Research & Data Analyst is responsible for the development, collection, maintenance, and operations fora portfolio of assigned standard data collections and reports includingquality metrics,utilizationmetrics, work effort, and financial metrics asappropriate.Supportsandcoachesjunior stafffor complex tasksand collaborates with technical leaders for guidancerelated to enhancing data operations and services.Develops, implements, and evolves programming and documentation for assigned data and reports, including programming and documentation about what members or constituentsareeligibletoparticipateand have access to assigneddata collections and reports.Collaborates and consults withinternal and external partners on enhancements to data collectionsand reporting systems.

How you will make an impact?

Execute Data Collection and Reporting SystemsRelated toApplicant, Student, and Trainee Data and Reports:

Specific responsibilities and deliverables related tothis duty include:

  • Be responsible for data assets and systems related totheNational GME Census in GME Track, the FACTS tables, the ERAS National Statistics tables,the Primary Care Loan Report, the Report on Residents, and additional dataand reporting assets as assignedfromother DOS teams and data teams fromother clusters.Asappropriate, mentorlesssenior colleagueson these data assets and systems.

  • Develop, collect,verify,maintain,and report data aboutand frommembers and constituents.

  • Develop, implement, andupdateprogramming and documentation for assigned data and reports, including programming and documentation about what institutions and individuals are eligible to receive the corresponding data collections and data reports.

  • Produce and maintain programming and databases for collecting data, importing data, managing data, checking data,engaging with members and constituents as required for data quality questions,linking data, analyzing data, reporting data, and distributing data, usingAAMC IT approvedtools such as SQL, PL/SQL, PostgreSQL, VBA, Python, HTML,HighCharts, JavaScript, and Verint.

  • Mentorlesssenior colleaguestoexpand intheir knowledge of this work.

  • Monitorthe soundness, timeliness, impact, efficiency, and security of data collection and data reporting services. Monitoring occurs through, for example, performing data quality checks and investigatingdiscrepancies, verifying, and resolving dataissues.

  • Develop and/ormaintainrecurring datacollections andadminister data collections to members and constituents.

  • Writeandmaintainoffice manuals, runbooks, and similar materials that describe the procedures for running data collection and data reporting services;review materialsfromless senior staff in a collegial manner.

  • Collaborate with IT colleaguesto supportIT-maintained applications, data collections, and integration with otherdata and analytical offerings.Coach andassistjunior staffforIT-relatedactivities such asdeveloping requirements and user acceptance testing.

  • Support and coach junior staff on more complex tasks and for addressing technical and process issues and improvement opportunities.

  • Engage withdata collection participants, report recipients, and other users with content questions, reminders, extensions, quality control checks, or similar operational concerns.

Contribute toUnitand AAMCProcessImprovement andTrainingRelated toDataCollectionandReportingSystems:

Specific responsibilities and deliverables related to this duty include:

  • Consult with colleagues and constituents (including, but not limited to, data respondents, report users, subject matter experts,researchers, and IT staff) on ways to enhance datacollections, standard reports, research reports, external/internal ad hoc reports, and other analytical offerings.Supportjunior staffandunitsupervisorsto synthesizeand prioritizetheinput from colleagues and constituents.

  • Contribute to IT initiatives related to infrastructure changes, data access and security, and system modernizationsand updates,providingsupport for junior staff as well asalertingunitsupervisorsabout risk and benefits.

  • Represent the unit, the cluster, and the AAMC data community in internal and external discussions around data collection, analytics,and reporting.

  • Maintainaccuratefinancial and timekeeping records to support ongoing prioritization, enterprise portfolio management,and impact analyses asrequiredfor assigned data assets.

  • Apply knowledgeand experienceto solve problems and toidentifyroot causes of onetime or recurring issues and recommend solutions.

  • Be a good steward of AAMC time and resources; escalate potential issues early enough to ensure that collaboration with other colleagues will result in on-time, high-quality, impactful, efficient, and securedata services.

  • Help with other data assets and their associated analytical offerings, asrequired.

  • Manage the tracking of internal and external data requests across the AAMC. This duty includes reviewing data requests, fulfilling data requests, and triaging data requests to other staff asappropriate.

Serve as Data Steward,Data Lead,or Technical Contact for assigned data assets:

Serve as a Data Asset Owner for assigned data assets, executing job responsibilities consistent with AAMC policies and procedures, including:

  • Completing allrequiredinternal and external Data Asset Owner training.

  • Determiningtheappropriate levelof internal and external access to data assets.

  • Enforcingappropriate dataaccess, publication, and security policies and procedures, including but not limited to those of:

  • Survey and Research Central (e.g., for guidance about Human Subjects Research Protection Program issues, IRB, and Data Collection/Research Registrationand standards);

  • OCOMM (e.g., for guidance about publishing standards and AAMC messaging on policy and advocacy);

  • Legal (e.g., for guidance about data privacy and anti-trustconsiderations);

  • IT (e.g., for guidance about information securityand aboutapproved technologies for data collection, management, analytics, and reporting).

  • Respond to internal and external ad hoc requests about data and reports, as well as reviewing and processing external data requests.

What you will bring to the role:

Required Qualifications:

MinimumEducation:Bachelor'sdegree

Preferred Education:A master's degreeor doctoraldegreewould be preferred, with course work in quantitative reasoning and qualitative reasoning. Courses of study might include topics such as computer programming, data analysis, data visualizations,economics,information systems, mathematics, psychometrics, research and evaluation, sociology, statistics, survey construction, survey sampling, and related topics.

Minimum Experience of Related Work:5-7 years of related work experience

Minimum Supervisory or Subject Matter Expertise:3-5 years of experience managing a specialized program

Additional Minimum Experience:

  • Experience withquantitative, qualitative, and logical reasoning; self-directed knowledge acquisition and application;

  • Programming, database design, data security, data standards, data processing, relational databases, data instrument construction, data visualization, and report writing;

  • Collaborative working environments;

  • Time management, resource management, quality control, and continuous quality improvement.

PreferredExperience:

  • Experience in data collection, analysis, and reporting in small to large organizations where dataare critical todelivering onstrategy, mission, and services to members and constituents.

Remote Work Eligibility

This position is eligible for remote work in the contiguous US

Compensation Grade Range

$105,315.00-$123,900.00

Multiple factors are taken into consideration to arrive at the final hourly rate/annual salary to be offered to the selected candidate. Factors may include, but are not limited to, the scope and responsibilities of the role, the selected candidate's work experience, education and training, as well as internal equity, market, and business considerations.

If a bachelor's degree is required, related work experience may be substituted in some positions. One year of college course work at an accredited institution is equivalent to one year of related work experience.

The AAMC is an Equal Opportunity Employer. The AAMC is committed to an Equal Employment Opportunity policy in recruitment, hiring, career advancement, and all other personnel practices. The AAMC will not discriminate on the basis of race, color, sex, national origin, religion, age, marital status, personal appearance, sexual orientation, gender identity or expression, family responsibilities, matriculation, political affiliation, genetic information, disability, past or current military service, or any other legally protected characteristic. The AAMC is committed to the full inclusion of all qualified individuals. As part of this commitment, the AAMC will ensure that people with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, perform essential job functions, and/or receive other benefits and privileges of employment, pleasecontact the talent acquisition team.

Please attach a resume as part of the application process. It is important that files DO NOT include periods ( . ) within the file name.

BROWSER REQUIREMENTS: Applications must be submitted using Chrome, Mozilla Firefox, Safari, orMicrosoft Edge.