Find Jobs
Find Jobs Near You – Available Work in Your Location
BI DATA ANALYST
Career Insights for Data Analyst
See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.
Scorecard
Based on Pennsylvania data
Review key factors to help you decide if this role fits your goals. How is this calculated?
What they do
A Data Analyst develops computer programs to analyze large customer information databases for companies and organizations. Analyzes data to identify patterns and provide information relevant to a particular business, industry or field; analysis may be used for marketing, or to detect fraud in financial transactions, or for research. Develops computer programs to protect confidential customer information.
$83,002 / year median in Pennsylvania
+11% projected growth
Job Description
DAY TO DAY RESPONSIBILITIES
- Design, develop, and maintain dashboards, reports, and visualizations that highlight key operational and performance insights.
- Analyze complex datasets to identify trends, patterns, anomalies, and opportunities for improvement.
- Apply statistical analysis and modeling techniques to answer business questions and support data-driven decisions.
- Partner with stakeholders to understand business needs, define reporting requirements, and translate them into effective analytics solutions.
- Use data storytelling and visualization best practices to communicate insights clearly to both technical and non-technical audiences.
- Write, optimize, and validate SQL queries to extract, combine, and analyze data from multiple sources.
- Perform data profiling, validation, and quality checks to ensure accurate, consistent, and reliable reporting.
- Collaborate with IT teams, data owners, and business users to resolve data issues and improve reporting processes.
- Evaluate existing dashboards and reports, recommending improvements to usability, performance, design, and analytical value.
- Identify opportunities to improve data collection, reporting standards, business processes, and analytics practices.
- Support business intelligence best practices by developing reusable solutions, consistent metrics, and visualization standards.
- Help stakeholders interpret dashboards, metrics, and analytical findings so they can take informed action.
REQUIREMENTS
- 5+ years of professional experience in data analytics, business intelligence, data visualization, or a related field.
- Demonstrated experience using Tableau to develop interactive dashboards and compelling visualizations.
- Strong proficiency in SQL and experience working with relational databases and complex datasets.
- Experience performing data analysis to identify trends, patterns, anomalies, and actionable insights.
- Experience gathering requirements and translating business questions into analytical and reporting solutions.
- Understanding of data visualization principles, dashboard design, and reporting best practices.
- Working knowledge of data modeling and the relationships between source data, analytical datasets, and reporting solutions.
- Ability to communicate analytical and technical concepts clearly to non-technical audiences.
NICE TO HAVE
- Experience with Tableau Server or Tableau Cloud, including publishing, permissions, data sources, extracts, and dashboard performance optimization.
- Familiarity with data warehouses, data lakes, and modern analytics architecture.
- Familiarity with Microsoft SQL Server and/or
SAP ASE/IQ.
- Experience working with large or complex data sets from multiple systems.
- Experience supporting data governance, metric definitions, data quality, or reporting standards.
- Tableau Certified Data Analyst or similar certification.
- Experience with Python or R for data analysis, data preparation, or automation.
- Experience with exploratory data analysis, statistical analysis, or advanced analytics.
- Experience developing dashboards or analytics solutions for operational, performance, or executive reporting.