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
Qualifications:
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
معرفی شرکت
اسنپفود بزرگترین سرویس آنلاین سفارش غذا در ایرانه که در کنار غذا، سرویسهایی از جمله سفارش نان، پروتئین، شیرینی و میوه رو هم در خودش داره.
همراهی صمیمانه و اعتماد بیش از ۵ میلیون کاربر ما رو بر این داشته که همواره به دنبال خلق پدیدههای تازه و راهی برای خدمترسانی بهتر و باکیفیتتر باشیم.
ما در این مسیر علاقهمند به همکاری با افرادی هستیم که با هوشمندی و سرعت عملشون در عبور از چالشها و مسائل کسبوکار یاریگرمون باشن.