Global Soft Systems, Inc. · 1 day ago
Cloud Data Engineer
United States
Contract
Remote
Mid, Senior Level
7+ years exp
Maximize your interview chancesAnalyticsBusiness Intelligence
Insider Connection @Global Soft Systems, Inc.
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Design, develop and optimize cloud-based solutions, ensuring seamless operations for Enterprise Data Warehouse team.
Take direction from Manager/Architect/Senior Programmer for ADF, Azure Synapse, and Snowflake on daily tasks and activities.
Develop and maintain data pipelines, data storage solutions, data processing and data integration using ADF and Snowflake.
Test new or modified programs to ensure that they conform to design. Develop test data for use in program testing.
Write documentation of system changes in conformance with department standards
Write any necessary user documentation (report descriptions, user procedures, operations procedures)
Provide timely and concise summaries of project status to manager.
Works closely with business data analyst and data architects to understand the requirement to create effective data workflows.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Design, develop and optimize cloud-based solutions, ensuring seamless operations for Enterprise Data Warehouse team.
Knowledge and experience with Azure Data Lake Storage Gen 2, Azure Data Factory (ADF), Azure Synapse and Snowflake Data Cloud.
Proficiency in designing, building, and testing on Azure.
Experience developing data pipelines using Azure Data Factory with ETL techniques to load from various sources into data warehouse or data lake.
Demonstrate experience in using different ADF components (Pipelines, Data Flows, Triggers, Linked Services etc.).
Proficient in using Snowflake Data Cloud including creating databases, schemas, tables and views.
Developing an optimizing ETL process for loading data into Snowflake.
Software development life cycle and software quality assurance best practices and methodologies.
Proficient in SQL query writing and editing.
Develop complex ETL routines to load a dimensional star schema with a strong focus on data quality, error handling, and logging processes.
Assess requirements for completeness and accuracy and determine actionable steps for the ETL team.
Identify necessary changes to current business and data integration processes.
Communicate risks and ensure understanding.
7 years of IT Development experience with advanced experience working on Azure Data Factory and Azure Synapse.
Advanced experience developing data pipelines using Azure Data Factory and Snowflake.
Experience in using ADF and Snowflake’s components to move data using different ETL techniques.
Experience with Azure, Azure DevOps, Azure Data Lake, Azure SQL Server.
Advanced experience with T-SQL, data warehousing design, BI concepts, and best practices.
Optimize data loading, querying, and performance within Synapse workspaces and Snowflake.
Experience with ETL processes using Snowflakes build in features.
Bachelor's Degree from an accredited college or university or equivalent practical and relevant experience.
Clear verbal and written communication skills.
Preferred
Experience developing Microsoft SQL Server Integration Services (SSIS) is a plus.
Familiarity with project deployment model, use of project and package parameters, and Integration Services Catalog (including Environments) preferred.
Previous experience in the health industry, SSRS, or Power BI is a plus.
Company
Global Soft Systems, Inc.
Global Soft Systems Inc. is one of the nation’s leading staffing and recruiting firm helping organizations accelerate business growth.
11-50 employees
H1B Sponsorship
Global Soft Systems, Inc. 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
2023 (31)
2022 (36)
2021 (35)
2020 (34)
Funding
Current Stage
Early StageCompany data provided by crunchbase
