Data Warehouse Developer (Closed)

SkillStorm is seeking a Data Warehouse Developer for our client in Charlotte, NC. Candidates must be able to work on SkillStorm's W2; not a C2C position. EOE, including disability/vets.

Job Description:

• Enterprise Architecture & Engineering (EAE) is a growing department within the Global Technology division at Client that is responsible for:
• Improving the experience for our developers, making it easier to deliver industry-leading solutions, while managing work efficiently and with the right controls
• Advancing our technology platforms through innovation
• Deliver the best digital experience for those managing the technology division
• For our teammates and customers Drive accessibility of applications
• Reducing risk and improving quality across our technology portfolio by aligning to a single enterprise architecture strategy and delivering governance that enables consistency, integration, and automation
• This role is responsible for developing and delivering complex requirements to accomplish business goals. Key responsibilities of the role include ensuring that software is developed to meet functional, non-functional, and compliance requirements. This role ensures solutions are well designed with maintainability/ease of integration and testing built-in from the outset. These individuals possess strong proficiency in development and testing practices common to the industry, and have extensive experience of using design and architectural patterns.

Responsibilities:

• Contribute to story refinement/defining requirements.
• Participate and guide team in estimating work necessary to realize a story/requirement through the delivery lifecycle.
• Perform spike/proof of concept as necessary to mitigate risk or implement new ideas.
• Code solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements.
• Utilize multiple architectural components (across data, application, business) in design and development of client requirements.
• Assist team with resolving technical complexities involved in realizing story work.
• Design/develop/modify architecture components, application interfaces, and solution enablers while ensuring principal architecture integrity is maintained.
• Design/develop/maintain automated test suites (integration, regression, performance).
• Set up and develop a continuous integration/continuous delivery pipeline.
• Automate manual release activities.
• Mentor other Software Engineers and coach team on CI-CD practices and automating tool stack.

Required Skills:

• Datawarehouse Developer - Specific Required Skills:
• Ability to extract, clean, transform and load data from source systems using direct database integrations (e.g. SSIS; Informatica) and API’s.
• Strong data warehouse knowledge, including how to conform data into a coherent schema while enforcing referential integrity.
• Preferred experience in master data management, data governance, performance tuning, query optimization and indexing strategies.
• 5+ years of hands on development experience with relational databases like Oracle & SQL.
• Strong experience with functions, procedures, triggers, packages.
• Good communication skills.
• Familiar with agile development methodology and Jira tool

#LI-DNI