Intermediate Data Analyst
Job#: 2019382
Job Description:
Intermediate Data AnalystApex Systems is a global IT services provider, and our staffing practice has an opening in the Online Retail space for Data Analysts with strong experience in investigative data analysis that results in growth combined with experience in SQL, databases of a terabyte or more and optimum queries to place at our client.
Start date: ASAP.
Office Location: 100% remote (within Canada)
Application Process: It is best to apply via the medium on which you are seeing this posting. If you encounter technical difficulties submitting your resume, please send a Word version of your resume to Johanna at [email protected]
Job description:
Assess/query large datasets to determine impactful trends within our business.
? Interpret data trends and patterns. Correlate to actionable insights.
? Work closely with cross-functional partners to communicate discovered trends, resolve data issues,
troubleshooting and analysis, and bug fixes
? Develop reports and presentations for various business stakeholders
? Work with teams across the Company on data quality and availability
? Develop new frameworks to collect data including automated data collection
? Collaborate with Data Warehouse and Engineering teams to manage relevant datasets within the Company.
Data Analysis and Interpretation: Collect, analyze, and interpret data to identify trends and patterns affecting our Ads Taxonomy table. Translate data findings into actionable insights and recommendations for the core team.
Data Collection and Strategy: Develop and implement effective data collection systems and strategies to support automation and integration projects. Ensure data accuracy, availability, integrity and reliability for various initiatives.
Cross-Functional Collaboration: Collaborate with teams across different functions to support entity and taxonomy realignments. Identify process improvement opportunities and provide regular recommendations to enhance data-related processes.
SQL Expertise: Utilize efficient SQL writing and querying techniques to troubleshoot issues directly within the Snowflake data warehouse. Optimize queries for performance and maintainability.
Data Workflows and Insights: Work with data tools including SQL and Tableau to automate data workflows. Build meaningful insights through data visualizations, standardized reports, and dashboards for ad-hoc analyses.
ABOUT YOU
? Experience in a quantitative role at a product company
? A high level of organization and attention to detail
? Familiarity with Database interface tools, SQL, and Programming concepts
? Relevant experience within the Retail space along
? Eagerness to learn, flexibility to pivot when needed, savviness to navigate and thrive in a dynamic
environment, and a growth mindset needed to build a successful team and company.
? Experience with Data mapping, Data architecture, Data integration, ETL, and working on large datasets
Requirements:
- Bachelor’s degree or equivalent work experience in a relevant business/domain.
- Hands-on experience with SQL, Data Manipulation, and Data Analysis.
- experience working with bad data turning it into a story
- Ability to work independently as an individual contributor, taking ownership of assigned tasks/projects. Capable of collaborating effectively in team environments, especially on large/complex projects.
- Flexibility to adapt to changing project requirements and reprioritizations.
- Proficiency in documentation, creating and accepting handovers, and effectively managing change/release communications.
- Strong verbal and written communication skills
- Exposure to working with large data platforms and handling sizable datasets is a plus.
- Snowflake, Cassandra or Vertica
- Mode/Tableau
- comfortability working with raw/ad data and the ability to create a story out of it.
- 2+ years of experience applying Python (NumPy, Pandas, Other common libraries) programming to solve business challenges.
- Scripting/development experience with Python, including working with Google APIs, building data pipelines, authentication, file handling, and raw data manipulation is a plus.
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.