Data Analyst Intern

This is a fully remote position, open to applicants in California.

📋 Description

• Develop and optimize SQL queries to extract, clean, and transform data from extensive databases, data marts, or cloud storage solutions.

• Create, build, and sustain interactive business intelligence dashboards and reports utilizing Power BI, Tableau, or Mode.

• Conduct regular data validations to ensure accuracy, consistency, and integrity across metrics and reporting frameworks.

• Explore open-ended operational queries and analyze trends such as customer demand, process efficiency, and financial metrics.

• Provide clear visual summaries for team leaders.

• Aid in the automation of manual reporting processes and spreadsheets using Python, Excel Power Query/Pivot Tables, or basic scripting.

• Contribute to the comprehensive development and management of client data systems, covering data ingestion/warehousing, automation, modeling, machine learning, and business intelligence tools.

• Collaborate with clients to design, develop, and implement scalable data analytics solutions.

• Offer actionable insights from raw data to facilitate informed business decisions.

⛳️ Requirements

• Currently pursuing a Bachelor's degree in Data Science, Data Analytics, Statistics, Computer Science, Economics, Business Information Systems, or a related quantitative discipline, having already obtained an Associate's degree.

• Proficient in SQL for querying relational databases.

• Familiarity with Python or R for data manipulation and analysis.

• Experience with BI and visualization tools such as Power BI, Tableau, Sigma, or Looker.

• Advanced skills in Microsoft Excel, including Pivot Tables, VLOOKUP/XLOOKUP, and data modeling.

• Strong analytical and problem-solving skills with a keen attention to detail.

• Capability to communicate technical findings clearly to non-technical stakeholders both verbally and in writing.

• Ability to sit or stand for up to 8 hours daily.

• Capability to move freely for up to 8 hours daily.

• Applicants may be subject to background checks, drug testing, and/or a fit-for-duty physical examination after accepting an offer.

🏝️ Benefits

• 401(k) plan with employer matching contributions.

• Paid time off.