Data Engineer - CyberPro Consulting - Johannesburg

CyberPro Consulting is a professional services company servicing the South African, European and Australian markets with a focus on Cloud Enablement, System Integration, Software Development, Web and Mobile Digital Solutions, Database, Business Intelligence and Data Analytics solutions. CyberPro's expertise spans the full range of modern software development, digital and data technologies and vendors, with a focus on Microsoft, AWS and Oracle. We offer the highest quality professional services at competitive rates combined with flexible engagement options ranging from consulting and turnkey options to onsite contractor services. CyberPro's services: 1. AWS and Microsoft Azure 2. Software and System development 3. System integration, Data integration and migration 4. Web and Mobile Digital solutions 5. Business Intelligence, Big Data and Data Analytics 6. Workflow and Robotics Process Automaton 7. System Analysis and Business Analysis 8. DevOps 9. Automation Testing 10. IT Project Management 11. Finance, Risk & Compliance 12. Engineering With over 500 consultants, CyberPro has a 24-year track record with a customer base ranging from enterprise to midsize businesses and particular expertise in: 1. Insurance 2. Banking 3. Wealth and Investments 4. Retail 5. Telecommunication · The Data Engineer will be responsible for transforming data into actionable insight using the Microsoft SQL tech stack of Business Intelligence products. · This will be a collaborative role that will be responsible for delivering the full stack in the BI solution from the business requirements gathering, solutions architecture, data models to the semantic models and the reports themselves. · Should be able to design and develop end to end BI Solutions. · Be able to do gap and impact analysis on the requirement. · Accept coaching and mentoring from fellow developers/architects. · Complete documentation of BI requirements and development according to Hollard standards. · Provide support to business on existing projects. · Assist business users in acquiring access to reports/databases. · Responsible for the design and implementation of effective cross-functional business intelligence systems and processes. · Translate business and technical requirements into efficient sustainable BI solutions. · This will be a dynamic role where you will be an integral member of a small team building an end-to-end business intelligence solution. · This person should be very analytical with an even mix of business acumen and technical capability. · The Data Engineer will be responsible for working with analysts, managers, and executives to understand business needs and working with source owners and BI teams to understand the data sources. · Participate in analysis and design sessions. · Communicate progress with business users and project teams. · Elicit requirements for ad-hoc data requests, extract data from the various sources using SQL, and deliver request via various reporting tools. · Update and maintain ETL scripts written in SQL, which extract data from source systems and load the data warehouse. · Redesign and improvement of existing solutions. · Analyse business requirements and translate them into technical and system requirements to best satisfy these requirements. · Write and maintain technical documentation · Develop end to end BI solutions. · Adhere BI SDLC and development methodologies. Unit test their own development. The successful candidate must have: · Tertiary qualifications with majors in at least one of the following: Computer Science, Information Systems · 5 years' experience working on Microsoft BI platform. · Familiar with Agile / Waterfall development methodology · Exposure to Visual Studio and C#/VB.Net coding · SQL Server 2016 highly recommended · Experience with relational databases · Exposure to database administration function · Exposure / Experience designing and implementing dimensional modelling and data warehouses. · Good database design skills (required) · Extensive skills on ETL packages · Experience in using and writing complex MDX and DAX statements. · MS PowerBI stack highly recommended (Power Pivot, Power View and Power Query experience) · MDS “Master Data Service” development, maintenance, and deployment · SQL Server Jobs, Stored Procs, Views, Functions, Indexes, Table Value Functions, etc. · SQL performance tuning and enhancements Knowledge to produce fully automated solutions with minimal human intervention required · Willingness to take ownership and accountability · Building and maintain relationships · Have a collaborative mindset · Have a strategic mindset when designing solutions that enable standardization and efficiency · Contribute to the success of the team; co-operate with other employees to improve personal and team performance · Team player & ability to work closely with others · Be able to function independently should that be required · Problem solver / solution provider · Passionate about BI and data integration · Committed, self-driven & highly motivated individual · Adaptable; be able to handle change effectively · Good communication skills · Able to work by themselves and in a team · Experience working in an agile manner Ability and willingness to work standby and / or weekends (if required) Apply Now

Share this job with someone you think should apply!

Facebook

Data Engineer - Johannesburg

Related Jobs

Data Engineer Johannesburg - Johannesburg

AWS DATA CLOUD ENGINEER - Johannesburg

DATA MODELLER - Johannesburg

Data Modeller Johannesburg - Johannesburg

Senior Data Development Engineer - Johannesburg

Want to do another search?