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.