Data Analyst (3-5 years) Role Summary We are seeking a Data Analyst to turn data into insights by building dashboards, defining metrics, and conducting analyses on AWS-based datasets. You will work primarily with SQL on Redshift/Athena, Python for analysis and automation, and BI tools to deliver accurate, actionable reporting.
Key Responsibilities Translate business questions into analyses, KPIs, and dashboards.
Query and transform data using SQL against RDS, Oracle, Amazon Redshift and Athena.
Perform data profiling and validation on S3/Redshift datasets; elevate data quality issues and partner on resolution.
Write Python (pandas) for exploratory analysis, feature preparation, and light automation.
Optimize queries via appropriate partitioning, filters, and Redshift/Athena best practices.
Document logic, assumptions, and lineage in Confluence; manage work in Jira.
Create STTM Mapping document by coordinating with upstream/downstream stakeholders
Collaborate with data engineers on data requirements, schema changes,



and data freshness SLAs.
Follow version control practices (Git) for SQL, notebooks, and dashboard assets.
Must-Have Skills Strong SQL (CTEs, window functions, joins, query optimization basics).
Python for analysis (pandas, basic visualization) and working with JSON.
Hands-on experience with Amazon Redshift, Athena, and S3-based datasets.
Understanding of dimensional modeling, star schemas, and partitioned data.
Requirements gathering, stakeholder communication, and documentation (Confluence/Jira).
Nice-to-Have Basic statistics (A/B testing, confidence intervals), Excel/Sheets power-user skills.
Familiarity with Glue Data Catalog concepts, data contracts, and data quality checks.
Build and maintain dashboards in QuickSight (or Tableau/Power BI) with consistent, well-documented metrics.

#J-18808-Ljbffr

📌 Big Data Lead (Colón)
🏢 Psc Industries
📍 Colón