Back to search (Western Cape > Cape Town > Jobs > General Worker Jobs> ad 1244375374)

Finance Power BI Developer - (CONTRACT)

1 Photo(s)

6 months ago620 views

Report Ad

General Details

Location:

Higgovale, Cape Town

Advertised By:Agency

Company Name:Project Management Connection

Job Type:Contract

Description

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 BI
Identify 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 BI
Analyse 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 data
Work 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

Id Subtitle 1244375374

Project Management Connection

Selling for 2+ years

Total Ads2

Active Ads2

Professional Seller

Seller stats

2Total Ads

66.03KTotal Views

View seller profile

Contact Project Management Connection

Message

(4007)

Name

(Optional)

Email Address

(Optional)

Phone

(Required)

Upload CV(Optional)

Choose file

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.

Save

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

Save

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 proceduresDeveloping SQL scripts for ad-hoc requests and reportsAssisting in data management and data integrity initiativesUnderstanding system workflows and documenting key data flowsAligning Key Performance Indicators, reporting and analyticsAddressing reporting issues at root cause levelRefine and automate regular processes / scheduled jobs, track issues, and document changesContinuously assess and document data qualityManage new permissions requested and report on database access for users and application loginsTranslating business needs into technical specificationsImproving existing BI tools and procedures Requirements Our ideal BI Developer will possess: BA/Bcom/BsC in either Engineering, Info Systems, Computer Science or related field2+ years’ experience with MSSQL & MYSQL1-2 years of experience developing and maintaining ETLs and using Data Integration tools (e.g. Pentaho, Talend), or scriptsExperience querying data from a data warehouse and loading data into itExperience 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 structuresWorking experience with more than one database technologyStrong analytical and troubleshooting skills, including a proficiency for root cause analysisExperience creating technical documentationA collaborative and creative approach to solving business issues while working with partner teamsA self-starter with phenomenal problem solving and diagnostic acumen, and a strong analytical mind-setAcute attention to detail and strong organisational skills in order to prioritise tasks and relay insights to members of the leadership teamThe ability and eagerness to further develop the required skills through self-learningStrong 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

Invalid date

Save

Who we are: An award-winning PR, Talent and Influencer Marketing company in the entertainment sector with offices in Cape Town and Los Angeles. Work with high-profile artists and celebrities including supermodels, stars of the big and small screens, musicians and sports people from around the world. Who we are looking for: An Account Manager with strong experience in the PR/Advertising industry with at least five years’ experience in the Communications/Advertising industry and a good network of contacts. Project management, Reporting and Analytics will be a critical part of this role, alongside managing inter-agency relationships. The candidate must be based in Cape Town. What you will do: Client relations: ongoing working relationship with brand manager/marketing manager and inter-agency partners to ensure execution of requirements on brand strategy and communicationsHave the ability to manage multiple stakeholders, both internal and externalMedia planning: overseeing and managing the implementation of a PR calendar according to brand strategyInfluencer marketing: Create, manage, and implement influencer content calendar/s according to brand strategyIdentify, recruit, and establish relationships with influencers relevant to our clients brands and campaignsScouting and casting new influencer talent across various African marketsMaintain ongoing communication with influencers, fostering trust and collaborationNegotiate terms, fees and deliverables with influencers to secure partnershipsDraft and execute influencer contracts and agreementsCoordinate campaign logistics, including content creation, posting schedules and product shipmentsEnsure that influencers adhere to campaign guidelines and deliver content as per the agreementReview influencer-generated content for brand alignment, quality, and compliance with guidelinesResearch and Reports: compiling reports applicable to industry trends, analyse campaign performance metrics, including engagement, reach and ROI What you must have: Previous experience in a similar account management and brand communications roleAt least five years solid experience with traditional external PRA proven track record designing and implementing PR/content distribution (Influencer) campaignsA keen interest in entertainment and culture, especially from an African perspectiveKnowledge of the South African media landscapeExperience generating contentA proven track record of driving resultsOrganised and methodicalAn eye for detail and an ability to see the big pictureAbility to juggle multiple projects, prioritise, meet deadlines and communicate effectively https://protool.gumtree.co.za/external-link-browser.html?url=aHR0cHM6Ly93d3cuZGl0dG8uam9icy9qb2IvZ3VtdHJlZS8xMTcxOTkzOTExP3NvdXJjZT1ndW10cmVl&jid=1596437&xid=1171993911

Invalid date

Save

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

Gumtree 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.