Application Developer IV

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.