Junior Data Analyst - SQL/Tableau/Visualizations/Hive (Hybrid in Fremont, CA)

Job Description

iTalent Digital is seeking a Junior Data Analyst to join our BI, Data & Analytics practice. 90% of your work will be client focused. 10% of your work will be internal. This role offers an exciting opportunity within one of our esteemed technology and social media clients, focusing on supporting dynamic engagements in the realm of Facilities and Culinary operations.

The role primarily involves creating and maintaining analytics products, reporting, and analytical tasks within the context of Facilities and Culinary operations. The ideal candidate will demonstrate proficiency in Business Intelligence (BI) and data analysis, particularly in SQL, Hive, and Tableau, navigating complex data environments and driving BI-centric priorities within these domains.

This position is based in Fremont, CA. We provide comprehensive medical benefits, a 401k plan, paid holidays, and more. Please note that we are only considering direct W2 candidates at this time, as we are unable to offer sponsorship.

Responsibilities:

• Create and maintain analytics products to support Facilities and Culinary operations. Support enhancements of existing products and drive efforts to improve efficiencies.
• Develop a thorough understanding of spatial, financial, and behavioral data in areas such as Facilities and On-campus services.
• Write queries to analyze data and combine disparate sources.
• Build dashboards and visualizations for a wide range of operational and executive audiences. Translate requirements into dashboard designs that are informative, polished, and concise.
• Utilize your knowledge of the data to answer stakeholder questions with the right sources. Work with urgency on time-sensitive matters without compromising accuracy.
• Respond to data quality issues by identifying root causes and proposing solutions with minimal guidance.
• Clearly articulate issues, enhancements, and related impacts to both technical teams (data engineering) and non-technical business partners.
• Support various cross-functional teams within the Facilities & Culinary division, including:

1. Culinary Team: Manage day-to-day operations, purchasing, planning spend, and overseeing the number of people fed.
2. Design Team: Assist in the design and programming of meeting rooms and amenities spaces.
3. Space Planning Team: Manage occupancy, desk assignments, moving teams, and work on business strategy.
4. Technical Space Team: Support labs, lab standards, and lab usage.
5. Transportation Team: Aid in shuttle services, other transportation needs, capacity planning, and commute analysis.

Internal Responsibilities:

• Attend regular internal practice community meetings.
• Collaborate with your iTD practice team on industry thought leadership.
• Complete client case studies and learning material (blogs, media material).
• Build out material to contribute to Digital Transformation practice.
• Attend internal iTD networking events (in-person and virtual).
• Work with leadership on career fast-track opportunities.

Required qualifications and skills

• Education: Bachelor’s Degree in Business, Computer Science, Mathematics, Engineering, or related field, or equivalent work experience.
• 3 years of experience managing, analyzing, and reporting on large data sets.
• Strong proficiency in SQL.
• Experience building and maintaining Tableau dashboards with advanced capabilities such as LOD calculations, data blending/joins, window functions, and parameters.
• Fluency in Excel to perform analysis and summarize data into a presentable format.
• Experience managing and analyzing data using Hive tables for efficient processing and insightful analysis.
• Excellent interpersonal skills and ability to work as a team player.
• Excellent communication skills with the ability to communicate complex issues in a clear, concise manner.
• Ability to learn, operate, and troubleshoot independently.
• Keen attention to detail in the context of numbers (data fidelity) as well as design (dashboard presentation).

Preferred qualifications and skills

• Proficiency in developing ETL processes.
• Experience with scripting languages like Python or R.
• Experience in Business Operations, Finance, People Analytics, or Product Analytics.
• Experience in addressing data quality issues and translating vague technical issues to non-technical terms.
• Ability to work effectively in a hybrid model with in-person attendance required 3 days a week in Fremont, CA.

Education

• Bachelor’s Degree in Business, Computer Science, Mathematics, Engineering, or related field, or equivalent work experience.

Company description

About iTalent Digital:

We are part of a new generation of consulting and software development company that blends diversity, innovation, and integrity with real business results. Our structure rejects any strong hierarchy, empowering us to deliver excellent results. We are a woman- and minority-led firm. Every day, we challenge ourselves to be considerate, fair and to re-think what great outcomes mean for our customers. This permeates down to how we approach every interaction, on every project, for every client. You’ll thrive here if you are a dynamic self-starter, a difference-maker or someone who wants to deliver great results, without constraints.

The iTalent Digital Experience:​

Joining us means you’ll be part of our global community, you have a say about your own career journey, and you’ll get a chance to give back to causes that matter. You will experience working with Fortune 500 companies and high-performance teams across numerous industries.

iTalent Digital offers our employees excellent benefits such as medical, dental, vision, life insurance, paid holidays, PTO, 401K matching, networking & career learning and development programs. We are growing and we want to see you grow!​

​

Visit https://www.italentdigital.com/careers to learn more about what working at iTalent can mean for you.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.

iTalent is committed to working with and providing reasonable accommodation to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application process, or to perform the essential functions of a position, please contact us at [email protected] and let us know the nature of your request and your contact information.

Additional info

Dynamic environment in a culture of respect, empowerment and recognition for a job well done, apply today!