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