Job Openings at Momentum

About the job
Role purpose

• This person is responsible for creating data pipelines to support downstream data delivery. A data pipeline is a series of automated, programmatic steps. These data pipelines gather data from numerous, potentially disparate data sources and bring everything together into a central place (data lake & warehouse) where it is made readily available for downstream consumption.
• The incumbent works with a variety of technologies on a day to day basis. The nature of the job requires constant upskilling and personal development.

Responsibilities
There are two main duties:

• Develop & maintain data pipelines in support of downstream data delivery;
• Perform analysis on organisational data & create reports to communicate the results.

Other potential duties include, but are not limited to:

• Communicate and advocate for a data-driven mindset in the larger organisational community, especially the IT department;
• Investigate and evaluate emerging technologies like robotic process automation (RPA), new AWS services, new data management approaches, machine learning advancements, etc;
• Liaise with individuals in the organisation in support of all the above duties.

Qualifications and experience

• Good programming skills in both Python and SQL;
• Good database design skills and an understanding of data warehousing techniques and approaches;

An understanding of and ability to access data from sources such as:

• Microsoft SQL Server
• Oracle
• MongoDB
• Amazon S3
• Windows and Linux file systems (Excel, delimited files, etc.)
• HTTP APIs
• SFTP sites
• An ability to engineer cloud-first solutions in the Amazon Web Services cloud;
• An interest in machine learning and advanced analytics, and the development of data pipelines in support thereof;
• An understanding of the software development process, with proficiency in Git for version control and build & deployment pipelines in GitLab;
• An ability to create reports and BI dashboards to communicate data & analysis results, using a variety of technologies, which might include:
• Microsoft SQL Server Reporting Services
• Microsoft PowerBI
• Microsoft Excel

Location
Momentum Metropolitan, Head Office, Centurion.

go to method of application »

About the job
(CONTRACTING ROLE FOR 12 MONTHS VIA CONTRACTING HOUSE)
Role Purpose

• Develop, maintain and support a portfolio of software applications and services to ensure improved business efficiencies and that are aligned to the enterprise architecture and business strategy.

Responsibilities
1.     Develop software based on technical design (Internal Process)

• Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests.
• Translate business requirements into workable solutions and document solution into technical specifications.
• Design and code new software functionality using codes that is readable, maintainable and re-usable.
• Provide client with regular feedback on the technical design and timelines for solution.
• Collaborate with business analysts and testing team in developing, testing and deploying new software system components or software system enhancements.
• Collaborate with testing team to co-create test cases.
• Conduct System Integration Testing (SIT) and User Acceptance Testing (UAT) and resolve all issues/queries.
• Contribute to user acceptance testing (UAT) and training material.
• Once the solution has been successfully tested, transport the solution into production/live environment.
• Maintain existing programmes according to change requests.
• Monitor performance of solutions and make recommendations to improve the performance and functionality of the solution.
• Log issues found in existing systems as internal change controls and ensure successful resolution of issues.

2.     Engage with clients in a client centric manner (Client Services)

• Provide authoritative, expertise and advice to clients and stakeholders.
• Build and maintain relationships with clients and internal and external stakeholders.
• Deliver on service level agreements made with clients and internal and external stakeholders in order to ensure that client expectations are managed.
• Make recommendations to improve client service and fair treatment of clients within area of responsibility.
• Participate and contribute to a culture which builds rewarding relationships, facilitates feedback and provides exceptional client service.

3.     Self-management and teamwork

• Develop and maintain productive and collaborative working relationships with peers and stakeholders.
• Positively influence and participate in change initiatives.
• Continuously develop own expertise in terms of professional, industry and legislation knowledge.
• Contribute to continuous innovation through the development, sharing and implementation of new ideas.
• Take ownership for driving career development.

4.     Contribute to financial controls and planning (Finance)

• Identify solutions to enhance cost effectiveness and increase operational efficiency.
• Manage financial and other company resources under your control with due respect.
• Provide input into the risk identification processes and communicate recommendations in the appropriate forum.

Competencies

• Business Acumen
• Customer/ Stakeholder Commitment
• Drive for Results
• Leads Change and Innovation
• Collaboration
• Ability to Impact and Influence
• Self-Awareness and Insight
• Diversity and Inclusiveness

Skills
Methodologies:

• Have a clear understanding of Agile methodologies.
• Be familiar with Waterfall methodology.
• Be able to demonstrate hybrid integration of both Agile and Waterfall when required.
• Have the ability to elicit data requirements from stakeholders.
• Have clear documentation and communication skills.
• Have solid understanding of Metadata, Master Data Management (MDM) and Data Architecture.

Principles: 

• Be familiar with Software development principles such as SOLID, TDD, Separation of Concerns, Loose Coupling
• Be familiar with design patterns in data development industry.
• Have a clear understanding of Data warehouse principles.
• Be familiar with n-tier layered architecture (3-5 years).
• Have knowledge of Domain driven design would be an advantage.
• Have knowledge of repository pattern would be an advantage.
• Be familiar with the concept of Data Marts.
• The candidate must be familiar with abstraction techniques.

Modelling:

• Should have data modelling skills and should be able to interpret conceptual, logical and physical data models. (3 – 5 years).
• Should be able to translate business requirements into technical designs with appropriate data modelling.
• Should have proven data modelling techniques including normalization skills.
• Must be familiar with data warehousing principles, based on the Kimball and/or Inmon architectures.
• Should have knowledge of cloud warehousing components such as Snowflake would be to their advantage.
• Should have knowledge of Immon data warehouse modelling techniques would add an advantage.

Data Transportation:

• Have solid experience in data transportation techniques
• Has practical experience in using ETL software applications (advantageous).
• Has solid experience of sourcing, staging and loading (advantageous).
• Must be able to apply the appropriate data loading principles in order to performance tune ETL processes
• Must be familiar with source to target mapping.

Development Software:

• Have practical knowledge of T-SQL (2-5 years),
• Exposure and knowledge of Oracle, DB2, MySQL, MS Access, Mongo and PostgreSQL will be an advantage.
• Have practical experience of SQL Server Database Engine (2-5 years).
• Have practical experience of MS SSIS ETL software (2-5 years).
• Knowledge of MS SSAS OLAP software would add an advantage.
• Have practical experience of MS Visual Studio Data Tools (2-5 years).
• Should have a good understanding of source control systems and the concepts of building and releasing software versions.
• Microsoft TFS knowledge is preferred.
• MS SSRS and/or PowerBI report development experience.

Governance and Framework:

• Clear understanding and application of DAMA framework.
• Have the ability to draft new data governance policies in accordance with TOGAF, ZACHMAN or other frameworks.
• Have knowledge of financial acts and compliance frameworks requirements would add greater value.

Repository type:

• Must be able to source data from different repositories.
• Must be fully acquainted with Microsoft SQL Server repository.
• Must have knowledge of NoSQL would be an advantage.
• Must have knowledge of Data Lake would be an advantage.
• Must have the ability to source data from any repository in an appropriate manner with the appropriate application.

Qualifications & experience 

• IT Degree;
• 3-5 Years development experience within a SQL data lake and warehouse environment within the Financial Sector and
• Must have knowledge of the Software Development Lifecycle.

Location

Momentum Metropolitan, Head Office, Centurion.