Entry Level Excel Data Analyst Jobs in Phoenix, AZ

Job Summary:
The Client is seeking a high-caliber Business Intelligence Analyst motivated by the opportunity to apply strong analytical thinking, data mining, and visualization techniques to achieve the department's strategic goals. We prioritize professional potential and a proactive approach to problem-solving over years of specific tool expertise. This role focuses on the core capabilities of breaking down complex business data, interpreting findings, and communicating insights through clear reports and dashboards.

Job Duties & Responsibilities:

• Create and maintain reports & dashboards for internal stakeholders, providing clear visualizations and explanations of findings.
• Use BI tools and data analytics software to analyze data, identify trends, and provide actionable insights.
• Conduct data analysis to generate meaningful insights from data sets
• Writing, executing and analyzing SQL queries
• Create ad-hoc and standard SSRS reports to document results of data analysis
• Utilize data analysis tools such as SQL, MS Excel, Google Sheets, Power BI to work with huge volumes of Data.
• Collaborate with cross-functional teams to understand business data analysis needs and goals.
• Develop, analyze, and evaluate business needs to improve workflow processes, troubleshoot Business Intelligence tool problems and tune for performance optimization and usability.
• Ensure accuracy and validity of data sets and reports.
• Organize, classify and synthesize the data into fundamental issues from the information provided
• Identify the logical outcomes from the analysis of the data collected and identify the options & solutions for addressing the problems analyzed
• Develop and maintain applications and automation scripts using Visual Basic (VB) to streamline reporting and data analysis tasks.
• Perform additional tasks as assigned by the supervisor.

Education:

• Bachelor's degree in Computer Science, a related field, or equivalent experience is required.
• Any training, coursework, and work experience relevant to the assignment.

Knowledge:

• Knowledge and understanding of software development processes, including requirements and technical design analysis, development, system and user testing, problem resolution, and planning
• Knowledge of Relational Database Management Systems (RDBMS)
• Knowledge of using PC in a Windows environment; using MS Office Applications such as Outlook, Word and Excel, VB, PowerPoint; and using Google Suite applications such as Gmail, Sheets, Docs, and Drive

Skills:

• Effective organization and time management skills with the ability to manage multiple projects simultaneously and work in high-pressure situations
• Proficient in the use of tools & technologies such as MS Excel, MS Access, SQL
• Strong interpersonal and relationship-building skills, fostering a collaborative and constructive team environment.
• Effective verbal, written, and listening communication skills
• Effective in the skill of synthesizing feedback and adjusting accordingly
• Visual Basic (VB) skills preferred
• Interest in AI tools and an aptitude for working in environments that leverage AI technologies

Abilities:

• Ability to work both independently or collaboratively with minimal supervision
• Ability to work in a confidential manner, ensuring information is shared with internal and external individuals in an appropriate manner
• Ability to understand and solve problems by applying analytical skills to include collecting all the relevant information and data needed to address the problem
• Ability to prioritize tasks and duties based on importance and urgency level
• Willingness and ability to embody client’s core values of Do the Right Thing,

Required Skills

• Experience with SQL and excel
• Data Analytics experience

vTech Solution Inc. is a Managed IT Services firm headquartered in Washington, DC. They specialize in a range of services including cloud computing, managed network security, and cybersecurity. Their primary focus is on providing human-centered IT solutions for government and business sectors, including federal, state, local, and education (SLED) groups, as well as commercial organizations.