استخدام Data Warehouse Engineer

شرح موقعیت شغلی

• Ability to build, test, and maintain SSIS/ETL architecture and processes using strong modular system design skills
• Create, modify, document, and enhance data specifications including identifying and mapping data elements from source systems into the dimensional data warehouse and operational system; Validate that the operational system and data warehouse meets specified requirements
• Implement and maintain complex queries, stored procedures and databases.
• Builds, deploys, schedules and monitors SQL Server Integration Services (SSIS) packages.
• Perform the design and extension of data marts, meta data, and data models
• Lead and participate in design review sessions, testing and poste-deployment activities including data accuracy validations.
• Carry out monitoring, tuning, and database performance analysis
• Investigate data quality issues and implement appropriate solutions
• Ensure all data warehouse architecture codes are maintained in a version control system.
• Responsible for performance tuning of database functions, SQL queries, stored procedures and SSIS packages to ensure scalability demands are satisfied and will be responsible for monitoring the production jobs, and other database activities (Backups, recovery, etc).,
• Ability to manage individual priorities and tasks and coordinates with other team members and supervisor to meet such timelines and actively contributes to project status reporting processes to identify and mitigate risks.
• Requirement gathering business requirements, analyzing business needs, defining the BI/DW architecture to meet & support and participate in the delivery of technical solutions to complex business and technical requirements all belonging to different departments and divisions to ensure smooth implementation and running of the applications
• Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients
• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization 

• Three years or more experience performing data warehouse architecture development and management
• Remarkable experience with technologies such SSIS and SSRS
• High proficiency in dimensional modeling techniques and their applications
• Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel
• Working knowledge of SAS and R code used in data processing and modeling tasks

مهارت‌های مورد نیاز

• Data Warehouse
• SSIS
• Databases
• Sql Server

حداقل سابقه کار

• سه تا شش سال

جنسیت

• مهم نیست

وضعیت نظام وظیفه

• مهم‌ نیست

مشاهده آگهی‌های استخدام مشابه