Posted Apr 16, 2021 18 views
Responsibilities:
- Work independently with business and other team users to define ETL/BI concepts, information needs and defining functional requirements, specifications and recommendations related to a proposed solution.
- Participates in analysis, design, and ETL development as part of Agile / Scrum development Team.
- Build and maintain highly visible, enterprise-wide BI dashboards / Reports
- Have used APIs or source XML Type columns to dynamically extract integrate and load data in target schema using ETL Tools; Experience working with multiple source systems / file formats.
- Should be responsible for building extraction and mapping rules for loading data from multiple sources for data warehouse implementation
- Should contribute to logical data model for data warehousing and making data available for downstream consumption.
- Strong verbal and written communication skills with technical and non-technical audiences.
- Makes a positive contribution as demonstrated by - Making suggestions for improvement - Learning new skills, procedures and processes.
- Detailed-oriented team player with an ownership mindset.
- Good understanding of requirements for Data Quality, Metadata and Operational Data Stores.
- Must have hands-on expertise in PL/SQL, Stored Procedures using MS-SQL Server.
- Design and implement storage schemas in accordance to end user’s information needs and views.
Qualifications:
- 5+ years of relevant experience in data management, ETL, data warehousing and BI Reporting.
- Experience of Designing Transactional and Reporting Databases
- Strong experience in Data Integration tools.
- Proficiency in writing complex SQL queries, Stored Procedures.
- Strong experience in Data Warehouse and ETL concepts.
- Solid foundation in DW and BI design, tools, processes and implementation approaches
- Knowledge of data modeling, data ingestion and ETL design.
- Knowledge of integration with systems like Salesforce, Relational Databases, REST API, FTP/SFTP...etc.
- Experience in BI tools, preferably AWS Quick Sight/Tableau/Power BI.
- Knowledge of AWS technologies are a plus (EC2, S3, RDS, Redshift...etc.).
- Ability to learn and use new technologies quickly & effectively. Problem solving skills and ability to think algorithmically
- MySQL Hands-on Experience with AWS RDS is a plus
- Bachelor's degree in Computer Science or equivalent
Skills
Job Details
Shispare Pvt. Limited
Shispare Pvt. Limited is a Software development & web development company. Mainly Shispare Pvt. Limited specialty is in ware house management system. We are working under Constellation Software International(CSI Software) umbrella, with its supply chain branch (fogsoftware group) and are working with some of the largest fortune 100 companies like Target Super stores, CEVA Logistics, NIKE, Under Armour in North America Region.
What is your Competitive Advantage?
Similar Job Titles
BI Developer / SQL Developer
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Ali Aziz
CEO
Shopistan
Aqib Irshad
Head of HR, Training & OD
FINCA
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Muzammil Baig
Digital Marketing Manager
IT Services Group
Zohaib Ali
Marketing Manager
Digital Online Devices
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
