Job Description
Job Description
The Data Analyst will focus on loading data from various sources into the Data Lake and / or Data Warehouse, as well as building and maintaining data pipelines. As the company transitions from SQL to Snowflake, this role will play a key part in modernizing data infrastructure and optimizing ETL / ELT processes.
Responsibilities :
- Profile and analyze data from multiple sources and data types.
- Build ETL / ELT pipelines to ingest and load data, supporting the migration to Snowflake.
- Maintain and monitor data pipelines and schedules.
- Triage and troubleshoot data quality issues and implement corrective actions.
- Build and maintain data transformations.
- Build and standardize reporting objects, data, and logic at the database layer.
- Follow best practices for development, QA, deployment, and source code management.
- Ensure proper documentation is maintained and provide walkthroughs of definitions and metrics.
- Coordinate closely with other developers to streamline processes and optimize workflows.
- Gain strong knowledge of underlying data and business rules, assisting other teams during the transition.
- Adopt an agile methodology and assist in tracking and communicating progress of deliverables.
- Identify improvement opportunities (proactive and reactive).
- Build and maintain strong relationships with business and IT users, both onshore and offshore.
Qualifications :
4+ years working as a data engineer or data analyst.4+ years working with SQL Server or other relational databases, building data pipelines using ETL tools like ADF, Airbyte, Informatica, etc.4+ years building objects in a SQL database, including tables, stored procedures, and views.Expertise in SQL and data analysis.Experience with Healthcare or Financial data preferred.Strong ability to quickly understand data relationships and analyze data.Demonstrated ability to meet deadlines and communicate progress across projects.Ability to coordinate and collaborate with other team members and business owners.Excellent communication, organization, and time management skills.Bachelor’s degree or higher.Preferred Experience :
Exposure to cloud data systems (Snowflake) and modern ELT tools (DBT) preferred, with a willingness to learn and contribute to the company's transition from SQL to Snowflake.