Application Developer IV (REMOTE) 3 openings

Application Developer IV (ETL)

long-term right-to-hire

Job Notes :

Extensive data warehousing - must have experience.

Cognos knowledge heavily desired.

5+ years of experience required!

Knowledge with Microsoft Azure highly preferred!

Formal Job Description :

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

Education :

Bachelor’s degree in a technical discipline such as Computer Science, plus 7 years relevant technology experience or equivalent combination of education & experience