About
Requirement/Must Have: Strong experience working within AWS cloud environments. Strong development experience working within the Snowflake platform. 3+ years of direct experience in warehouse design, development, modeling, support, and operations utilizing Snowflake. 5+ years of experience with SQL Server 2012 or later. Strong expertise in SQL, including complex query development utilizing multiple large data sources. Strong understanding of data modeling and ETL processes. Experience developing ingestion processes, data mapping, validation, and transformation workflows. Experience ensuring data quality and automating data pipelines. Experience troubleshooting ingestion errors and supporting seamless system adoption. Experience developing and maintaining scripting languages such as Python and PowerShell. Solid understanding of computer science fundamentals. Experience utilizing and developing RESTful APIs, both custom and existing. Experience with SQL Server Integration Services (SSIS) and RDBMS concepts and methods. Strong problem-solving and analytical skills. Effective communication and teamwork skills. Experience:
3+ years of direct experience in warehouse design, development, modeling, support, and operations utilizing Snowflake. 5+ years of experience in SQL Server 2012 or later. Significant experience in public health or in the analysis of health data is preferred. Experience with business intelligence design and implementation. Experience supporting data onboarding and platform administration activities. Responsibilities:
Design, implement, and optimize data solutions using the Snowflake data platform. Support development and administration of the client's Snowflake platform. Support development and administration of onboarding activities within the Snowflake platform. Develop system requirements and assist with onboarding newly identified data sources into the platform. Work closely with data stewards and internal partners to understand current and future data needs, expected outcomes, and platform use cases. Develop ingestion processes, data mapping, validation, and transformation workflows for partner data onboarding. Ensure data quality, automate data pipelines, and accurately map data fields from disparate sources. Troubleshoot ingestion errors to support seamless system adoption. Assist with development and execution of quality assurance protocols, including data integrity and security. Support business intelligence design and implementation. Collaborate with cross-functional teams to ensure data integrity, security, and performance. Should Have:
Preferred Bachelor's degree in Public Health, Computer Science, or a related field. Consideration for relevant technical certifications and related work experience. Experience with SQL Management Studio (SSMS). Experience with SQL Server Analysis Services (SSAS). Experience with database design and implementation. Experience with healthcare informatics. Development experience within cloud platforms. Skills:
Snowflake. AWS. SQL. SQL Server 2012 or later. ETL. Data Warehousing. Data Modeling. SSIS. SSMS. SSAS. Python. PowerShell. RESTful APIs. API Development. Business Intelligence Development. Database Design. Data Integration. RDBMS. Data Quality. Data Validation. Data Transformation. Healthcare Informatics.
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.