Senior Data Analyst

Prophecy Technologies Corp; Northern (KY); On-site; USD 90,000 - 120,000; Full time

Job summary

Prophecy Technologies Corp. seeks a Senior Data Analyst to collect, clean, and organize data from multiple sources, and to design actionable dashboards.

You will write SQL, analyze trends, present insights to stakeholders, and collaborate with business teams to define data requirements. Key qualifications include 10+ years of data analysis and proficiency in SQL, Excel, Python, and dashboard tools like Tableau/Power BI or Looker.

Qualifications

• 10+ years of experience in data analysis.
• Proficiency in SQL, Excel, Python and data cleaning.
• Experience building dashboards in Tableau/Power BI or Looker.
• Ability to translate data into insights for non-technical audiences.

Responsibilities

• Collect, clean, and organize structured data from multiple sources.
• Write and optimize SQL queries to extract and validate data.
• Build dashboards and reports using Tableau, Power BI, or Looker.
• Analyze datasets to identify trends, patterns, and anomalies.
• Visualize data using graphs, infographics, and other methods.
• Present findings to technical and non-technical stakeholders.
• Collaborate with business teams to define data requirements.
• Monitor KPIs and evaluate business initiatives.
• Validate data quality and resolve discrepancies.

Skills

SQL

Excel

Python

Tableau/Power BI

Data cleaning

Statistical analysis

Looker

Tools

Looker

Job description

The Senior Data Analyst will be responsible for collecting, cleaning, and organizing structured data from various sources. This role involves writing and optimizing SQL queries, building interactive dashboards and reports using tools like Tableau, Power BI, or Looker, and performing in-depth analysis to identify trends, patterns, and anomalies within datasets. The analyst will also be crucial in visualizing data and presenting findings to both technical and non-technical stakeholders, collaborating with business teams to define data requirements, monitoring Key Performance Indicators (KPIs), and ensuring data quality.

Key Responsibilities:

• Collect, clean, and organize structured data from multiple sources.
• Write and optimize SQL queries to extract and validate data.
• Build dashboards and reports using Tableau, Power BI, or Looker.
• Analyze datasets to identify trends, patterns, and anomalies.
• Visualize data using graphs, infographics, and other methods.
• Present findings to technical and non-technical stakeholders.
• Collaborate with business teams to define data requirements.
• Monitor KPIs and evaluate business initiatives.
• Validate data quality and resolve discrepancies.

Required Skills:

• Technical Skills: SQL, Excel, Python, Tableau/Power BI, data cleaning, statistical analysis.
• Analytical Skills: Trend identification, problem-solving, diagnostic and predictive analytics.
• Communication: Ability to translate complex data into clear insights for non-technical audiences.
• Business Acumen: Understanding KPIs, business processes, and decision-making needs.

Qualifications:

• 10+ years of experience in data analysis.
• Candidate should be able to attend face to face interview and preferably local to Malvern, PA.