Ampcus Inc
Posted 65 days agoVerified live 10h ago
Data Analyst
Brief overview
Remote
SQLCommon Table Expressions (CTEs)Window functionsJoinsData visualization - TableauData visualization - Power BIStatistical analysisHypothesis testingSnowflakeRPythonMultivariate regression
About the company
Ampcus Incampcus.com
Ampcus is a global business, technology consulting and an staff augmentation firm specializing in AI/ML,digital solutions, Cybersecurity & Risk management, Testing, Forensics & Fraud services and human capital management.
Job description
Summary
Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. They are in search of a highly motivated Data Analyst who will assist in data extraction, analysis, and reporting, collaborating with the Enterprise Business Intelligence team to provide insights that solve business challenges. The role requires strong analytical skills and proficiency in SQL, along with the ability to communicate complex insights effectively.
Responsibilities
- 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
Skills
- 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
- 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
Qualifications
Must Haves
- 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
Nice to Haves
- 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
