Jr. Data Analyst

Artech Information System LLC; Walnut Creek (CA); On-site; USD 75,000 - 95,000; Full time

Job summary

A leading IT staffing company is seeking a skilled Data Analyst to gather and analyze data from various sources, providing actionable insights. The role requires a Bachelor's degree and 4 years of experience, including proficiency in SQL Server and Tableau. Responsibilities include managing stakeholder expectations, developing new reporting capabilities, and creating dashboards. Strong Excel skills and the ability to work collaboratively are essential for success.

Qualifications

• 4 years of experience in data analysis.
• Experience in creating and scheduling jobs in SQL Server.
• High level of proficiency in MS Excel.

Responsibilities

• Gather report requirements from stakeholders and manage expectations.
• Develop and deliver new reporting capabilities, including ad-hoc requests.
• Provide coherent data analysis through dashboards.
• Design and develop ETLs based on business needs.

Skills

Tableau Desktop

Microsoft SQL Server 2008 R2

BI XI

Microsoft Excel

Education

Bachelor's Degree

Tools

Microsoft Windows Server 2008 R2

Microsoft SharePoint 2013

Job description

Artech is the 10th Largest IT Staffing Company in the US, according to Staffing Industry Analysts' 2012 annual report. Artech provides technical expertise to fill gaps in clients' immediate skill-sets availability, deliver emerging technology skill-sets, refresh existing skill base, allow for flexibility in project planning and execution phases, and provide budgeting/financial flexibility by offering contingent labor as a variable cost.

Job Description

Duration: 12+ Months

Interview Type: In-person

The Data Analyst will gather and analyze data from various databases and sources, develop reports and visual representations, develop and/or maintain databases, provide analytics and technical assistance to Network Services departments. The Data Analyst will add structure and context to data and information, transforming it into actionable insights via efficient presentation.

Education: Bachelor’s Required

Minimum years of experience required: 4 years

Daily Responsibilities

• Gather report requirements from key stakeholders and manage their expectations accordingly
• Develop and delivery new reporting capabilities, including ad-hoc requests
• Provide coherent data analysis thru clear and concise dashboards
• Design and develop end-to-end ETLs based on business needs

Required Skills

• Six months to a year experience with Tableau Desktop
• 4 years of experience on Microsoft SQL Server 2008 R2 (stored procedures, views, reporting services, creating and scheduling jobs, etc)
• 4 years of experience in BI XI environment (creating queries, scheduling, custom SQL coding)
• MS Excel high level of proficiency

Desired Skills

• Basic knowledge of Microsoft Windows Server 2008 R2
• Some basic experience on Microsoft SharePoint 2013
• Previous hands-on experience building reports out of BMC Remedy data base / data mart

Soft Skills

• Ability to work on a team and work towards team goals
• Comfortable working on a virtual team
• Good listening skills: Ability to work with others to solicit and understand business requirements
• A track record of innovation / accomplishments