Data Analyst

Ampcus, Inc; Reston (VA); On-site; Full time

Job summary

A prominent technology and business consulting firm located in Reston, VA seeks a motivated Data Analyst. The ideal candidate will extract, analyze, and report data using SQL and collaborate with the Enterprise Business Intelligence team to provide actionable insights. Requirements include a Bachelor's degree in Data Analytics or a related field and strong analytical skills. Proficiency in SQL and familiarity with data visualization tools like Tableau or Power BI are essential for success in this role.

Qualifications

• Bachelor's degree in Data Analytics, Data Science, Mathematics, Statistics, or Computer Science.
• Proficiency in constructing complex SQL queries.
• Strong analytical and detail-oriented thinking.

Responsibilities

• Assist in data extraction, analysis, and reporting using various tools.
• Write complex SQL queries to join disparate data.
• Collaborate with the Enterprise Business Intelligence team.

Skills

SQL

Data Analysis

Analytical Thinking

Problem-Solving

Attention to Detail

Education

Bachelor's degree in Data Analytics or related field

Tools

Tableau

Power BI

Snowflake

R

Python

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Data Analyst

Location(s): Reston, VA

Description

The Data Analyst uses a variety of tools to assist in data extraction, analysis, and reporting. With strong foundational skills in SQL, they will work with datasets from a variety of sources, write complex queries to join disparate data, and collaborate with the larger Enterprise Business Intelligence team to provide meaningful and actionable insights that solve business challenges across the organization. Strong analytical and detail-oriented thinking is required along with a solid understanding of relational databases.

Qualifications

• A Bachelor's degree in Data Analytics, Data Science, Mathematics, Statistics, Computer Science, or other technically-intensive field;
• Proficiency in constructing and interpreting complex SQL queries including joins, pivots, aggregation, basic case/if logic, common table expressions (CTEs), and window functions;
• Understanding of and exposure to data visualization tools like Tableau and Power BI;
• Familiarity with data exploration and basic statistical analysis including hypothesis testing;
• Strong analytical and problem-solving skills, creativity in solving problems, strong attention to detail and accuracy, and the ability to perform with limited guidance;
• Ability to communicate complex insights to teammates and non-technical stakeholders.

Preferred Qualifications

• Experience in working with Snowflake databases;
• Basic proficiency with manipulating data in R and/or Python;
• Familiarity with basic machine learning concepts (i.e. multivariate regression) including how to perform and interpret them.

Skills

• SQL and any other Database Systems such as Snowflake, Writing Queries, Pivot, CTE, Analytical.
• Proficiency in constructing and interpreting complex SQL queries including joins, pivots.

Education

• Bachelors in IT, Data Science or any relevant Technical fiel.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.