Company:
HonorVet Technologies
Location: St. Louis
Closing Date: 27/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Title: Application Developer IV
Location: Remote
Duration: Long term Project
Overview:
Extensive data warehousing - must have experience.
Cognos knowledge heavily desired.
5+ years of experience required!
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: • Ability 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
Keywords:
Education: Bachelor's degree in a technical discipline such as Computer Science, plus 7 years relevant technology experience or equivalent combination of education & experience preferred.
Location: Remote
Duration: Long term Project
Overview:
Extensive data warehousing - must have experience.
Cognos knowledge heavily desired.
5+ years of experience required!
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: • Ability 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
Keywords:
Education: Bachelor's degree in a technical discipline such as Computer Science, plus 7 years relevant technology experience or equivalent combination of education & experience preferred.
Share this job