SQL/ETL/Integration Developer
Dynamic Frontiers Consulting
Johannesburg, Gauteng, ZA
3d ago

What will you do?

This role will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights.

The person fulfilling this role will not only analyze data models, but also test the outputs, investigate & troubleshoot data issues and devise solutions in line with best practice.

The role will also support the application development team with data-related design, development, and maintenance of the transactional systems.

Responsibilities include, but are not limited to :

  • Design and development, support, and monitoring of all ETL / Integration solutions as may be required from GB Systems and GB Data warehouse initiatives.
  • Assessment of all SQL scripts that will be deployed into production in terms of quality, efficiency, and speed. Will be responsible for the final deployment of scripts (Stored Procs, Views, SSIS jobs, etc.) into production.
  • Develop and implement ETL processes, reports, and queries in support of business analytics
  • Perform data quality profiling according to functional area specifications
  • Support the reporting requirements by way of data extracts, queries, and automating processes / tasks, creating reports, scorecards, and dashboards
  • Translate data in a way that meets functional area specifications
  • Create and update documentation for the entire environment in the context of your job
  • Acquire data from various data sources and combine & transform data into interpretable datasets, reports, or dashboards
  • Assess the effectiveness and accuracy of new data sources and data gathering techniques
  • Provide the data mapping and associated transformation rules for each data item
  • What will make you successful in this role?

    High competency in problem-solving capabilities, and the ability to communicate business information to technical teams as well as challenges and solutions to the team, are essential.

    The position is multi-disciplined and taking ownership of assigned tasks and delivering on commitment is key to success in this position.

    The applicant will require an ability to consider all relevant architectural needs such as synchronized indexes, key constraints, triggers, table partitions, table bucketing, multiple SQL formats, database compression, memory utilization, and different data types.

    Qualification & experience

    We are looking for top applicants that have graduated with a relevant IT qualification. Applicants with relevant education and experience will also be considered.

    The applicant should have :

  • At least 3 years’ relevant experience, preferably within the financial services industry
  • 3+ years’ ETL / SQL / BI Development experience in Microsoft BI Stack environment
  • Strong experience in business, data, and application analysis for data migration
  • Extensive experience with MS SQL Server 2014+, TFS, MS T-SQL
  • Experience developing SSIS packages (data flow tasks, transformations, precedence constraints, expressions, etc.)
  • Experience with SAP HANA and Cloudera may be advantageous.
  • Deep understanding of relational databases
  • Risk Management

    Data warehouse programming

    Personal Attributes

    Interpersonal savvy - Contributing independently

    Decision quality - Contributing independently

    Plans and aligns - Contributing independently

    Optimizes work processes - Contributing independently

    Core Competencies

    Cultivates innovation - Contributing independently

    Customer focus - Contributing independently

    Drives results - Contributing independently

    Collaborates - Contributing independently

    Being resilient - Contributing independently

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form