Data Warehouse Solutions
Gemstar Staffing Group is looking for an Application Developer IV for a remote position. Long-term project (2027/28) with possibility of conversion. Central Time Zone is preferred.
Please send us your resume on our contact us page if you meet the skills below.
Duties:
Long-term project (2027/2028) with possibility of conversion!
NON-local candidates ok! Will accept US based remote workers.
Extensive data warehousing - must have experience.
ADF knowledge heavily desired.
5+ years of experience required!
API extraction knowledge preferred.
Enterprise Data Warehouse and Azure Data Factory knowledge required.
Under minimal supervision, provide cost-effective data warehouse solutions by creating new, modifying, and supporting existing data warehousing applications that are of a complex nature.
Expertise in creating complex extract, translation, and load routines, including detailed error handling and notification against any data source.
The ability to receive data from API calls
Expertise in creating and maintaining data marts and dimensional model, and the logic to keep these updated.
Understanding of the Kimball model and data warehousing best practices
Ability to use azure data factory to extract from any data source including big data structures.
Expertise in the azure platform, and its toolset
Expertise in loading into various big data structures.
Advanced design of curation routines, and best practices around data archival.
Expertise in ETL maintenance through multiple toolsets.
Ability to write complex big data migration routines ( Azure Data Factory, Python, Spark, .Net )
Ensure maximum availability of all Integrations and continuous flow of data
In the event of data load failures ensure rapid restoration of service and root cause analysis to resolve future issues.
Manage the resource pool in order to execute on required new data loads, and any enhancements of existing processes.
Provide technical leadership on best practices of data flow, and provide long term guidance for maintaining our data store ecosystem.
Perform other duties as assigned
Skills
Abillity to acquire technical skills quickly from standardized training and online information, in addition to hands on work with team members.
Ability to use critical thinking and problem solving to identify issues and restore services in a timely manner.
Knowledge of information technology topics (service bus architecture, database staging, master data integration, information accessing methods, etc.)
Apply knowledge of Microsoft SQL server, supporting operating systems, transaction managers, database tools, utilities, gateways, and middleware to sustain operations.
Apply knowledge of Azure Data Lake and SQL data warehouse, data flow, data factory, to enhance and maintain our data ecosystem.
Understanding of CICD (continuous integrations / continuous development) git/ devops knowledge.
Strong communication and collaboration skills, with the ability to work as part of a team and independently
Engaged in continuous improvement of internal processes and procedures
Ability to consult with clients and higher level technicians and analysts to resolve technical problems and ensure customer satisfaction
Ability to interact with customers to discuss alternative technical solutions
Ability to work with only minimal supervision
Ability to learn quickly and adapt to new circumstances
Ability to work extra hours and recognize the need to do so
Ability to adjust scheduled time
Ability to adjust to change and demands on time
Education:
Bachelor’s degree in a technical discipline such as Computer Science preferred, plus 7 years relevant technology experience or equivalent combination of education & experience