Chelsoft Solutions Co. ยท 5 months ago
Sr Data Analyst Snowflake ADF_C2H_W2_Remote
Chelsoft Solutions Co. is seeking a Senior Data Analyst with expertise in Snowflake and Azure Data Factory for a 6-month contract role that is 100% remote. The primary responsibilities include leading the development of ETL processes, managing data pipelines, and ensuring data security and compliance within the Program Integrity data mart.
Information Technology & Services
Responsibilities
Lead the development and management of ETL processes for Program Integrity data marts in Snowflake and SQL Server
Design, build, and maintain data pipelines using Azure Data Factory (ADF) to support ETL operations and Peer Group Profiling procedures and outputs
Implement and manage DevOps practices to ensure efficient data loading and workload balancing within the Program Integrity data mart
Collaborate with cross-functional teams to ensure seamless data integration and consistent data flow across platforms
Monitor, optimize, and troubleshoot data pipelines and workflows to maintain performance and reliability
Independently identify and resolve complex technical issues to maintain operational efficiency
Communicate effectively and foster collaboration across teams to support project execution and alignment
Apply advanced analytical skills and attention to detail to uphold data accuracy and quality in all deliverables
Lead cloud-based project delivery, ensuring adherence to timelines, scope, and performance benchmarks
Ensure data security and compliance with relevant industry standards and regulatory requirements
Qualification
Required
Over 5 years of hands-on expertise in cloud-based data engineering and data warehousing, with a strong emphasis on building scalable and efficient data solutions
More than 2 years of focused experience in Snowflake, including the design, development, and maintenance of automated data ingestion workflows using Snowflake SQL procedures and Python scripting
Practical experience with Azure data tools such as Azure Data Factory (ADF), SQL Server, and Blob Storage, alongside Snowflake
Skilled in managing various data formats (CSV, JSON, VARIANT) and executing data loading/exporting tasks using SnowSQL, with orchestration via ADF
Proficient in using data science and analytics tools like Snowpark, Apache Spark, pandas, NumPy, and Scikit-learn for complex data processing and modeling
Strong experience with Python and other scripting languages for data manipulation and automation
Proven ability to develop cloud-native ETL processes and data pipelines using modern technologies on Azure and Snowflake
Demonstrated excellence in analytical thinking and independent problem-solving
Preferred
Certification in Azure or Snowflake
Experience with data modeling and database design
Knowledge of data governance and data quality best practices
Familiarity with other cloud platforms (e.g., AWS, Google Cloud)
Company
Chelsoft Solutions Co.
Inc. 5000 Fastest Growing Pvt. Companies in USA 5 yr Honoree; Ingrams 4yr Honoree; 2014 MBE Award Winner in State of KS
H1B Sponsorship
Chelsoft Solutions Co. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (15)
2024 (12)
2023 (21)
2022 (26)
2021 (18)
2020 (70)
Funding
Current Stage
Growth StageCompany data provided by crunchbase