Data Analyst

Pinnacle IT Solutions LLC seeking a dynamic and detail-oriented Data Analyst to join our innovative team! In this role, you will harness your analytical expertise to transform complex data into actionable insights that drive strategic decision-making. Your enthusiasm for data visualization, business intelligence, and technical proficiency will empower stakeholders across the organization. This position offers an exciting opportunity to work with cutting-edge tools and methodologies, contributing to impactful projects that shape our company’s future. If you thrive in a fast-paced environment and are passionate about uncovering stories within data, we want to hear from you!, * Collect, clean, and analyze large datasets using SQL databases, R, Python, and ETL (Extract, Transform, Load) processes to ensure data accuracy and integrity.

• Develop interactive dashboards and reports utilizing Tableau, Power BI, Looker, and other reporting tools to visualize key performance indicators and business metrics.
• Collaborate with cross-functional teams in an Agile environment to understand business requirements and translate them into effective data solutions.
• Design and optimize data models and database structures within Microsoft SQL Server, Oracle, or other SQL databases to support efficient query management.
• Conduct comprehensive analysis using Excel data analysis techniques and VBA scripting to automate repetitive tasks and improve reporting efficiency.
• Participate in the software development lifecycle (SDLC), including analysis, design, testing, and deployment of analytics solutions.
• Support business intelligence initiatives by integrating linked data sources and developing dashboards that facilitate strategic insights for decision-makers.

• Proficiency in SQL for querying databases effectively; experience with query management is essential.
• Strong knowledge of Tableau, Power BI, Looker for dashboard development and data visualization.
• Hands-on experience with Python and R for statistical analysis and automation tasks.
• Familiarity with ETL tools such as Talend or similar platforms for data integration processes.
• Understanding of database design principles for creating scalable data models; experience with Microsoft SQL Server or Oracle is preferred.
• Ability to analyze complex datasets using Excel, VBA, Bash (Unix shell scripting), and other analysis skills.
• Knowledge of the software development lifecycle (SDLC), Agile methodologies, project management principles, and business analysis techniques.
• Experience working with linked data sources and implementing business intelligence solutions in a collaborative environment.

Join us to leverage your technical expertise in a vibrant setting where innovation meets impact!

Pay: $53,482.80 - $80,409.39 per year