Data Analyst I
Description
The Data Analyst I is responsible for designing, developing, implementing, and optimizing scalable data pipelines, integrations, and cloud-based data solutions that support analytics, reporting, operational processes, and enterprise applications. The position owns data workflows from source ingestion through transformation and delivery, ensuring that information is accurate, secure, reliable, traceable, and available to downstream consumers in a timely manner. The role works cross-functionally with data analysts, application teams, technology teams, and business stakeholders to translate requirements into maintainable technical solutions and continuously improve PriceSmart's data platforms, automation capabilities, and DataOps practices.
Responsibilities
• Design, develop, test, deploy, and maintain robust, scalable, and efficient ETL/ELT data pipelines.
• Build reusable ingestion and transformation frameworks for structured, semi-structured, batch, and API-based data sources.
• Design and maintain integrations among enterprise applications, databases, cloud services, SaaS platforms, and external systems.
• Develop secure and reliable REST and SOAP API integrations, including authentication, validation, exception handling, retry, and logging mechanisms.
• Develop and maintain data solutions using Snowflake, Informatica Intelligent Cloud Services (IICS), dbt, Microsoft Azure Data Services, and other approved platforms.
• Design and maintain relational, dimensional, and analytical data models that support reporting, analytics, operational processes, and downstream applications.
• Optimize SQL queries, transformations, storage patterns, and compute resources to improve performance, scalability, and cost efficiency.
• Implement automated data-quality controls, source-to-target reconciliations, validation rules, and exception-management processes.
• Establish monitoring and alerting for pipeline failures, processing latency, data anomalies, quality issues, and system dependencies.
• Monitor production pipelines, conduct root-cause analysis, and implement sustainable corrective and preventive actions.
• Apply enterprise standards for data security, privacy, governance, metadata, lineage, traceability, and access management.
• Use Git-based workflows, code reviews, automated testing, and CI/CD practices to support controlled deployment of data solutions.
• Create and maintain technical documentation covering architecture, mappings, data models, dependencies, business rules, and support procedures.
• Translate business and functional requirements into scalable technical designs and implementation plans.
• Collaborate with analysts, developers, automation engineers, infrastructure teams, application teams, and business stakeholders.
• Provide technical guidance through code reviews, troubleshooting, knowledge sharing, and reusable engineering standards.
• Identify opportunities to automate repetitive activities and improve the reliability, maintainability, observability, and efficiency of data-engineering workflows.
Qualifications
Bachelor’s degree in Computer Science, Software Engineering, Information Systems, Data Engineering, Computer Engineering, or a related technical discipline; equivalent relevant experience may be considered.
• Five or more years of experience in Data Engineering, Data Integration, Software Development, Data Warehousing, or a related technical field.
• Demonstrated experience designing, deploying, and supporting production-grade data pipelines and integrations.
• Advanced proficiency in SQL and proficiency in Python; working knowledge of Java, JavaScript, Scala, or another programming language is preferred.
• Strong experience with ETL/ELT development, data integration, data modeling, dimensional modeling, data warehousing, and data-lake architectures.
• Experience with Snowflake or a comparable cloud data platform.
• Experience with Informatica IICS, dbt, Airflow, Microsoft Azure Data Services, or comparable integration and orchestration technologies.
• Experience integrating systems through REST and SOAP APIs, including authentication, secure credential management, JSON, XML, validation, and error handling.
• Experience with Git, source control, code reviews, automated testing, CI/CD, and DataOps or DevOps practices.
• Experience implementing data-quality, monitoring, logging, reconciliation, lineage, and observability controls.
• Knowledge of data governance, information security, privacy, and access-control principles.
• Strong analytical and problem-solving skills, technical ownership, attention to quality, and ability to conduct root-cause analysis.
• Excellent written and verbal communication skills, with the ability to explain technical concepts to technical and non-technical stakeholders.
• Ability to manage multiple priorities, work cross-functionally, and learn new technologies quickly.
- • Professional proficiency in English; Spanish proficiency is preferred.
Skills
- Airflow
- Analytics
- API
- Authentication
- Automation
- Azure
- CI/CD
- Cloud
- Data Engineering
- Data Governance
- Data Lake
- Data Modeling
- Data Pipelines
- Data Quality
- Data Warehousing
- DataOps
- dbt
- DevOps
- Dimensional Modeling
- ELT
- ETL
- Git
- Java
- JavaScript
- JSON
- Observability
- Python
- Root Cause Analysis
- SaaS
- Scala
- Snowflake
- SOAP
- SQL
- Test Automation
- XML
Sign in to read and join the discussion.