Data Analyst
Role details
Job location
Tech stack
Job description
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.
Requirements
- 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!
Benefits & conditions
Pay: $53,482.80 - $80,409.39 per year