Entry Level Excel Data Analyst Jobs in Washington, DC

 ASHLIN is an Equal Opportunity Employer. ASHLIN is also an Equal Opportunity of Protected Veterans and Individuals with Disabilities. 

 ASHLIN Management is a VEVRAA Federal Contractor and desires for Priority Referrals of Protected Veterans

DATA ANALYST 

JOB DESCRIPTION 

ASHLIN Management Group is seeking a Data Analyst to join our team working with our data analytics team. This professional will start off working with ASHLIN’s cloud-based visualization platform, CompassBI, powered by Sisense, on visualizing descriptive statistics and other key performance indicators and building ASHLIN’s library of dashboard templates. Additional projects will include supporting our team of project specialist in developing deliverables to our clients, based research and analysis methods, using statistical models on business data collected in field. Candidates should also be comfortable preparing routine as well as ad-hoc business reports and PowerPoint decks to present the information to senior management and clients. 

Essential duties and responsibilities: 

• Develop visualizations using tools such as Tableau, PowerBI and/or Sisense 
• Use sophisticated data analysis methods to support project team in creating deliverable for client 
• Work with clients to devise methods to optimize data capturing schemes and overall program evaluation plan Perform statistical modeling (e.g. ANOVA) using statistical software applications such as R and SPSS 
• Work with Senior Database Architect(s) to develop analytical SQL queries and reports for tracking, trending, and interpreting business data 
• Perform ongoing data quality assessments, identify discrepancies/inconsistencies, and resolve them 
• Continually improve the end-to-end process of data collection, transformation, analysis, and reporting 
• Develop data management programs and forms for data entry and maintenance by end-users 
• Document data analysis and reporting architecture, designs, and write user guides 
• Other duties as defined by senior research team 

Qualifications

To be successful in this position, the Data Analyst must have a minimum of 3 years’ experience in: 

• Data analysis, involved in both primary and secondary research using data to arrive at decision pertaining to marketing strategies 
  • Ability to interpret complex data sets (quantitative and qualitative) into insights that lead to effective marketing strategies and frameworks  

• Strong data analysis modelling, specifically the successful candidate must be able to:
  • Conduct cross-tabular and ANOVA and other statistical analysis using R and/or SPSS
  • Interpret results of statistical analysis output and draw insights in order to make recommendations to senior management what steps to take
  • Present data, interpretation and resulting strategy in language that indicates a command of the material while at the same time making sense to lay persons who may not have a marketing and/or data analysis background  

• MS-Excel (Pivot Tables, VBA, Power Pivot, H-Lookup, V-Lookup, Import/Export from/to external data sources)
• Online Dashboards (e.g. Tableau, PowerBI, Sisense)
• Expert level skills in the development of highly impactful PowerPoint slide decks
• Development of scheduled and ad-hoc reports and analysis.

• Working in a team environment with responsibility for delivery of timely and accurate business-critical reports and analysis:
  • Self-motivated and proactive, willing to drive a program of work to successful completion,
  • Strong oral/written communication, and presentation skills,
  • Ability to work with highly sensitive information and preserve the confidentiality of the information,
  • Detail oriented and capable of identifying and resolving data quality issues.

In addition, the following are highly desirable:

• A minimum of 3 years’ experience with statistical analysis tools (e.g. R, SPSS)
• A background in market research, or related disciplines
• Working knowledge of relational databases (e.g. SQL)

Position requirements include:

• At least a Bachelor’s Degree in Math, Probability & Statistics, or related data science field
• Master’s degree in any of the above disciplines is highly desirable, or MBA
• High proficiency with statistical analysis tools
• Only open to candidates US Citizens and Permanent Residents currently authorized to work in the US