Join AB Consultants Inc. as a Junior Data Analyst in Lanham, MD onsite, supporting clean data, dashboards, and reporting that helps teams act on trends.
Responsibilities
- Gather, clean, and validate data using SQL, Excel analysis, and ETL processes (extract, transform, load).
- Assist with database design and data model design to support reporting needs.
- Support query management and requirements analysis for analytics and reporting.
- Build and maintain dashboards and visualizations using Tableau, Power BI, or Looker.
- Use SDLC analysis and Agile practices to help document and deliver analytics work.
- Contribute to clear, reliable reporting so business teams can understand trends and make informed decisions.
Requirements
- Foundational skills in data analysis, including business analysis, business intelligence, analytics, and data visualization, plus project management fundamentals.
- SQL skills and familiarity with SQL databases.
- Knowledge of Microsoft SQL Server or Oracle is useful.
- Exposure to Python, R, VBA, or Bash (Unix shell), and familiarity with Talend or other data analytics tools.
- Experience with reporting and dashboarding, including dashboard development and linked data; technical proficiency with Visio.
- Familiarity with SDLC analysis, Agile, and data model design is an advantage.
- No prior professional experience is required.
Tech Stack
- SQL, Excel, ETL, Tableau, Power BI, Looker
- SDLC, Agile, Microsoft SQL Server, Oracle
- Python, R, VBA, Bash (Unix shell), Talend, Visio
Benefits
- 401(k)
- 401(k) matching
- Green card sponsorship
- Visa sponsorship
Pay
USD 60,700 - 73,200 per year
Work Location
- Onsite (in person) in Lanham, MD