Please note that our Terms of Use and Privacy Notice are applicable.
Back to search (Western Cape > Cape Town > Jobs > General Worker Jobs> ad 1126424736)
BI Engineer
1 Photo(s)
1 year ago1481 views
Ad Saved to My List
View and manage your saved ads in your account.
Share
WhatsApp
Facebook
Messenger
Twitter
Copy URL
Email
Report Ad
Report This Ad
Reason for Reporting
Email Address
(Required)
Message
(Optional)
Report Ad
By clicking "Report" you accept the Gumtree Terms and Conditions.
General Details
Description
We are offering you the opportunity to join our Business Intelligence Team as a BI Developer. Location Cape Town
As the ideal candidate you will take ownership for ensuring the integrity of all information within the data warehouse as well as the accuracy of the processes used to populate the warehouse on a daily basis. You will be responsible for developing and maintaining existing ETL as well as provide operational BI support to the business.
As a BI Developer, your responsibilities will include, but will not be limited to:
- Designing, developing, testing, maintaining and documenting ETL procedures
- Developing SQL scripts for ad-hoc requests and reports
- Assisting in data management and data integrity initiatives
- Understanding system workflows and documenting key data flows
- Aligning Key Performance Indicators, reporting and analytics
- Addressing reporting issues at root cause level
- Refine and automate regular processes / scheduled jobs, track issues, and document changes
- Continuously assess and document data quality
- Manage new permissions requested and report on database access for users and application logins
- Translating business needs into technical specifications
- Improving existing BI tools and procedures
Requirements
Our ideal BI Developer will possess:
- BA/Bcom/BsC in either Engineering, Info Systems, Computer Science or related field
- 2+ years’ experience with MSSQL & MYSQL
- 1-2 years of experience developing and maintaining ETLs and using Data Integration tools (e.g. Pentaho, Talend), or scripts
- Experience querying data from a data warehouse and loading data into it
- Experience obtaining data from diverse sources including APIs, RDBMSs, flat files, google sheets etc.
- Basic understanding of programming languages (Java or Python)
- Experience designing relational and non-relational data structures
- Working experience with more than one database technology
- Strong analytical and troubleshooting skills, including a proficiency for root cause analysis
- Experience creating technical documentation
- A collaborative and creative approach to solving business issues while working with partner teams
- A self-starter with phenomenal problem solving and diagnostic acumen, and a strong analytical mind-set
- Acute attention to detail and strong organisational skills in order to prioritise tasks and relay insights to members of the leadership team
- The ability and eagerness to further develop the required skills through self-learning
- Strong teamwork skills as well as the ability to work independently from team
Knowledge of the following will be advantageous:
- Multidimensional design & ...
https://protool.gumtree.co.za/external-link-browser.html?url=aHR0cHM6Ly93d3cuZGl0dG8uam9icy9qb2IvZ3VtdHJlZS8yODI5NDA2NDE/c291cmNlPWd1bXRyZWU=&jid=1301898&xid=282940641
Id Subtitle 1126424736
View More
ABC Worldwide
Selling for 2+ years
Total Ads378
Active Ads378
Professional Seller
This seller has registered a Gumtree business account which allows them to qualify as a professional seller.To grow your business with Gumtree read more
Seller stats
378Total Ads
878.26KTotal Views
Contact ABC Worldwide
Message
(4035)
Name
(Optional)
Email Address
(Optional)
Phone
(Required)
Upload CV(Optional)
DOC or PDF only max 2 MB file size
Send Message
By clicking "Send" you accept the Terms of Use and Privacy Notice and agree to receive newsletters and promo offers from us.
Related Ads
1
SavedSave
An innovative tech company is currently looking for a SQL Developer to join they are growing team, the successful candidate will contribute towards developing SQL database queries, writing applications, and creating and managing SSIS packages, SSRS reports, this role will enhance/improve your skills in demonstrating queries and creating data analysis conducting feature engineering.
Responsibilities
Provide efficient data environment, by automating and optimizing to a fully automated and managed environmentProduce solutions for the most effective performance and scriptingProvide functional database services to the organizationIdentifying solutions for database related incidents and requestsResolving incidents and requests within SLAs to client satisfactoryBackup reports and queries, ensure all database are backed upFile integration to database related alerts and escalations to appropriate teamsSQL scheduled jobs MaintenanceAdminister data into SQL databasesWriting reports in T-SQLCreating and managing SSIS packages and SSRS reportsUse T-SQL for Adhoc data extractionPerform test and evaluations regularly to ensure data security and integrity
Requirements and Skills
Relevant Qualifications/ IT Degree/Diploma)National Senior CertificateMS SQL Qualifications4 years + MS SQL Database Administration experienceKnowledge of all SQL versionsAdvanced SQL skills and TSQL query writingKnowledge in Troubleshooting SQL skills and PTOSSIS and Analysis Services (ETL)Experience in report creation with SSRSResolve database problemsKnowledge of backup methods, restores and recovery modelsExperience in automating and optimizing scriptsKnowledge of indexes, index management, statistics, and overall database maintenancePowerShell knowledge will be an advantage
If you meet the requirements for above position kindly email your profile to: link to the job
To see more career opportunities click link below:
https://www.dittojobs.com/company/view
or Visit our Website www.solicited.co.za
Should you have any questions regarding the above role or any other vacancies, kindly contact:
hr@solicited.co.za
If you don’t hear from us within 2 weeks from the closing date please consider your application unsuccessful. SHOULD WE HAVE ANY OTHER ROLES THAT MATCH YOUR PROFILE, WE WILL CONTACT YOU.
https://protool.gumtree.co.za/external-link-browser.html?url=aHR0cHM6Ly93d3cuZGl0dG8uam9icy9qb2IvZ3VtdHJlZS8zMDczNDk1MzA4P3NvdXJjZT1ndW10cmVl&jid=1213679&xid=3073495308
Invalid date
1
SavedSave
Location - Woodstock, Cape Town (Onsite)
Job Description
Our client is seeking to employ a Senior Data Analyst to join their team to work within their Internal Audit Department.
Report to: Audit Manager (IT)
Job Purpose
To support the department goals to increase efficient and effective use of data analytics by obtaining more timely access to and management of data assets. Key to the role is to turn data into meaningful information using leading data analytic techniques to present to Senior management in the organisation while assisting in reducing effort on the audit plan.
Job Objectives
Assist the audit team in the field by being responsive to data needs in a timely mannerBe the internal liaison between IT and the internal audit team to facilitate data needs for the audit teamAssist in investigations and other management requests as necessary by gathering, sorting, and otherwise making sense of necessary data.Proactively search for data anomalies that could be indicative of control issues.Work with internal auditors to understand data needs and brainstorm ways to perform audits more efficiently.Drive the implementation of a continuous monitoring framework using data analytics to support the relevant internal audit projectsPerform special reviews of operations when requestedLinking of different data streams and visualisations and graphic output; upskilling and SAS, ACL, Tableau, and visualisation tools.
Qualifications & Experience
Essential: Bachelors degree or above in quantitative fields such as Data Science/Analytics, Computer Science/Engineering, Statistics, Mathematics, or related fieldsDesirable: Postgraduate degree in quantitative fields such as Data Science/Analytics, Computer Science/Engineering, Statistics, Mathematics, or related fields5-8 years data analytics experienceexperience in data management, governance, data acquisition and modeling, data structures and architecture.3-5 years financial systems or system auditing experience from big 4 preferableExperience in using visualisation tools such as Tableau and Power BIUtilisation of Microsoft Office products
Skills
Data analytics tools such as ACL/SAS/IDEA or similarApplication of internal audit and risk assessment methodologiesMS Excel AdvancedBuilding and maintaining strong relationshipsStrong written and oral communication skillsStrong analytical and organisational skills
Essential Competencies
Delivering results & meeting customer expectationsWorking with peopleApplying expertise & technologyPresenting &a...
https://protool.gumtree.co.za/external-link-browser.html?url=aHR0cHM6Ly93d3cuZGl0dG8uam9icy9qb2IvZ3VtdHJlZS81NDE2OTg3NzA/c291cmNlPWd1bXRyZWU=&jid=1711433&xid=541698770
Invalid date
1
Requirements:
Understand business requirements in the BI context and design data models to transform raw data into meaningful insights.Create dashboards and interactive visual reports using Power BIIdentify key performance indicators (KPIs) with clear objectives and consistently monitor those.Analysing data and present data through reports that aid decision-making.Convert business requirements into technical specifications and decide timeline to accomplish.Create relationships between data and develop tabular and other multidimensional data models.Chart creation and data documentation explaining algorithms, parameters, models, and relations.Design, develop, test, and deploy Power BI scripts and perform detailed analytics.Perform DAX queries and functions in Power BIAnalyse current ETL process, define and design new systems.Redefine and make technical/strategic changes to enhance existing Business Intelligence systems.Create customize charts and custom calculations as per requirements.Design, develop and deploy business intelligence solutions as per needs.SQL querying for best results, use of filters and graphs for better understanding of dataWork with users and team members at all levels for performance improvement and suggestions
Kindly regard your application as unsuccessful if you have not heard from the agency within 2 weeks.
https://protool.gumtree.co.za/external-link-browser.html?url=aHR0cHM6Ly93d3cuZGl0dG8uam9icy9qb2IvZ3VtdHJlZS8zODg5NjM4OTMxP3NvdXJjZT1ndW10cmVl&jid=1743026&xid=3889638931
Invalid date
1
SavedSave
PBT Group has a requirement for an intermediate Data Engineers skilled in AWS, SQL, Oracle, legacy systems, infrastructure, Cobol.
Duties:
Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports.Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues.Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information.Perform root cause analysis, performance monitoring and application related issues.Review IT work products from the team members for completeness and quality.Accurately translate business requirement to technical documentation and test case or results.Analyse and map data from source systems to target operational data stores and data marts.Maintain and provide application support in production.Code or folder migration from one environment to another as part of release management.Participation in all aspects of quality assurance.Active participation in systems integration and user acceptance testing.
Required Skills:
Strong modular system design skills.Solid working experience in AWS, SQL, Oracle, legacy systems, infrastructure, CobolConventional and data warehouse modeling skills are required, in order to understand the various data models and to define the mappings between them.System analysis and design skills are necessary to design and document the data extractions and transformations.Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs.Good organisation, planning and basic management skills.Good interpersonal and communication skills.Decision making and problem solving skills.
Required Qualifications / Training:
Relevant data warehouse and BI solution training is essential.B.Sc. or related degree is advantageous.5+ years programming experience.
* In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent
https://protool.gumtree.co.za/external-link-browser.html?url=aHR0cHM6Ly93d3cuZGl0dG8uam9icy9qb2IvZ3VtdHJlZS8yNDIxMDMyMDUwP3NvdXJjZT1ndW10cmVl&jid=1719509&xid=2421032050
Invalid date
1
SavedSave
Job DescriptionThe Head of Environmental, Social and Governance (ESG) is responsible for developing and overseeing environmental, social and corporate governance policies and procedures across our existing and growing portfolio of 11 renewable energy projects. The projects are required to be socially and environmentally sustainable and comply with nationally and internationally recognized best practices.
The role reports to the Chief Executive Officer and will work closely with internal and external stakeholders to achieve the policy goals of the company in regards to ESG best practice and standards.
Responsibilities:The Head of ESG will manage, monitor and optimise the ESG performance of the company’s renewable energy assets. A key focus willbe the overall monitoring of ESG across the entire portfolio, ensuring best practice is applied and consolidated review is reported up to AIIM inrespect of its IDEAS Fund as shareholder and other stakeholder groups as needed.
Responsible for the development and implementation of EIMSenvironmental and social management system (ESMS) and ESG andHealth and Safety Policies and Procedures.Provide technical expertise on key issues related to environmental and social impact assessment and on sustainability risks in the design, preparation, implementation and supervision of projects in the portfolio taking into consideration best industry practices and standards.Manage and conduct environmental and social safeguarding due diligence across the portfolio and new projects as they arise.Identify all key potential social and environmental impacts and risks and ensure that their magnitude and significance are well understood and appropriately mitigated.Ensure that the whole management team understands the applicable ESG policies, guidelines and project-specific requirements, and has the necessary commitment and capacity to manage social and environmental impacts and/or risks ? Conduct consultations with stakeholders in accordance with relevant policies and guidelines and be responsible for reporting on such.Report on and disseminate good practices and generated knowledge.Assisting with ESG due diligence to assess compliance with UNPRI, Equator Principles, IFC Performance Standards, IFC EHS and Sector Guidelines, ILO and other relevant standards for potential new projects and acquisitions.Supporting the team unlocking positive ESG impacts.Reviewing the ESG aspects of projectsAssisting specialists with project implementation and contractual compliance in respect to the ESG obligations.Site visits to the various project locations.Preparation of investor reports and responses to ad-hoc investor/shareholder ESG queries.ESG data management and analysis .Training of the companys team members and oth...
https://protool.gumtree.co.za/external-link-browser.html?url=aHR0cHM6Ly93d3cuZGl0dG8uam9icy9qb2IvZ3VtdHJlZS8xMzI4NDAyMDY1P3NvdXJjZT1ndW10cmVl&jid=1448956&xid=1328402065
Invalid date
1
SavedSave
International Campaign
CallForce is an award-winning BPO service provider delivering innovative and customized contact centre solutions from South Africa to the global market. Join us as a Debt Collections Consultant and be part of a winning team. You will be servicing our global client, in the USA.
If you are a high performing, target driven individual, with great communication and negation skills, this opportunity is for you. You will be taking inbound calls and engaging with high profile clients in the USA to help them take control and get out of high debt.
Your daily activities will include
Meet the minimum productivity requirements for calls daily to ensure optimization of the collections function and achievement of the monthly collection target.Manage customer accounts and calls by logging onto and updating the relevant collections systems.Use the appropriate collections scripts and other tools available to verify clients identity and negotiate with customers to obtain a promise to pay (PTP) or to negotiate the repayment terms which will achieve the best outcome.For more complex accounts, analyze customers account history and provide the customer with a recommendation on the appropriate options available (e.g., account restructuring in the case of arrears amounts on multiple products to rehabilitate their account.Negotiate settlements to receive payment on a certain percentage of the debt,Although this is a scripted sale, your ability to carry a professional conversation and negotiate with the client is critical.
What you need
1-2 years debt review, debt consolidation or sales experienceMust have worked on international campaignsHighly proficient in English, written and verbal.Must have a neutral accent.Must have knowledge of debt collection techniquesHave sound negotiation skills
What’s in it for you
Basic salary of R7500, increased to R8500, after your first month with usHighly competitive commission structure over and above the R8500 basic salaryTransport is provided as you will be working USA hours, 3pm to 4amFantastic growth opportunitiesExpand your knowledge of the global markets
Shou...
https://www.ditto.jobs/job/gumtree/3771622411?source=gumtree
Invalid date
View More
Back To SearchGumtree Safety Tips
1.Meet in a public space to see the item and exchange money.
2.Never send your item before receiving the money.
3.Never send or wire money to sellers or buyers.
Looking to Sell?
Whether you are selling your car, old cell phone or laptop, learn how much your item could be worth with our Gumtree Pricing Guide.
