Posted on Indeed on Feb 26, 2021
Project Description:
  • Area Data Architect (Modeler) is responsible for design, development and expansion of data assets that support business intelligence, advanced analytics, and reporting. They will also develop, maintain, and support the enterprise data warehouse system, corresponding data marts, and data interfaces between operational systems. This Area Data Architect- modeler will analyze and review complex object and data models and the metadata repository to structure the processes and data for better management and efficient access. Create and maintain the data documentation and be the liaison between multiple team
Responsibilities:
Analyzing the business requirements, design, develop and implement highly efficient, highly scalable ETL processes
Required to perform daily project functions with a focus on meeting the business objectives on time in rapidly changing work environment
Thorough understanding of DWH concepts and Data Models
Design and Develop detailed ETL specifications based on business requirements
Analyze functional specifications and assist in designing potential technical solutions
Works with source system team and data analyst to define data extraction methodologies
Advanced Oracle & SQL Server database skills including PL/SQL, packages, procedures, indexing and query tuning (5+ years)
Enhance/Re-architect existing components to satisfy new performance and scalability requirements
Regular meeting with team and stakeholders to avoid impediments
Innovative ideas on automation and Proof Of concepts to get it implemented
Proficient in ETL Informatica
Well versed in Unix shell scripting
Interact with multiple teams and translate reported problems/issues into JIRA items to implement to meet enterprise standards.
Good knowledge in writing complex queries. Experience in MS SQL is value added
Maintain highest levels of software quality and stability through continuous improvement of the SDLC
Build and maintain design standards and best practices and ensure the team adhere these standards
Evaluates and recommends unique hardware /software configurations; defines special hardware/software requirements, capacities, capabilities, etc. to meet user needs while adhering to technical standards
Unit Integration testing activities and assist in User Acceptance Testing
Effective time management skills in order to manage multiple priorities with flexibility on time zones and timelines
Must have strong interpersonal skills and outstanding communication skill

Skills Required:

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Jack Henry and Associates
Featured
7 d ago
Kronos Incorporated
3 d ago
TechnologyAdvice
3 d ago