Data Warehouse Developer

Phithos is an IT Services and Solutions company building on data-centric technologies for Healthcare, Education, Financial Services and Social-Media industries. At Phithos, we believe in Research & Development, Innovation, large-scale meaningful solutions and Quality Service. We are headquartered in Johannesburg, South Africa and have offshore delivery center in New Delhi, India from where we are servicing the customers in USA, UK, Africa & India.

We currently offer Permanent/Contract roles where candidates can:

• Work remotely or on-site in Johannesburg or Cape Town.
• Work remotely from Mumbai or Delhi

We are looking for a DATA WAREHOUSE DEVELOPER who enjoys analyzing source data architecture and delivering scalable data marts which enable internal/external clients to perform advanced analytics and derive insights. Who is always seeking to build optimized and standardized code while preserving a documented single source of truth for our clients.

Areas of responsibility may include but not limited to

• Develop, deploy, and support MS SQL Server BI solutions utilizing T-SQL and Integration Services (SSIS)
• Establish and develop relationships with key stakeholders and end-users
• Coordinate with business unit leaders to understand requirements, define solutions and communicate delivery timelines
• Help define and maintain data mart standards across multiple international markets
• Develop solutions to help drive operational improvements and/ or cost savings
• Design, code, test, maintain and document programs to support and automate information and decision support.
• Develop scalable and configurable solutions to deliver external client data extracts
• Adhere to departmental standard development, testing, deployment, source control processes, and ticket tracking
• Contribute to the creation and maintenance of end-user documentation

Education/Experience/Skills:

• Bachelor’s Degree or equivalent education/experience in Management Information Systems, Computer Science, or Information Systems.
• 5+ years of Business Intelligence Development working with technical teams
• Business Intelligence Development: Microsoft Integration Services
• Database: Microsoft T SQL, Postgres
• Excellent analytical, communication, and writing skills.
• Planning and organizational skills
• Agile Development experience on Scrum teams
• Skilled at developing dashboards and reporting solutions
• Extensive experience writing and optimizing stored procedures, packages and queries
• Ability to work well as a member of a team