Array ( [edu] => 0 [exp] => 0 [skill] => 0 ) Data Warehouse Developer at AfyA Care July, 2023 | MyJobMag
 
Jobs Career Advice Signup
X

Send this job to a friend

X

Did you notice an error or suspect this job is scam? Tell us.

  • Posted: Jul 17, 2023
    Deadline: Not specified
    • @gmail.com
    • @yahoo.com
    • @outlook.com

  • Never pay for any CBT, test or assessment as part of any recruitment process. When in doubt, contact us

    Afya Care Nigeria (AfyA Care) invests in healthcare assets with a vision to make healthcare accessible and affordable. We are building vertically integrated healthcare institutions that serve every urban market segment through the creation and aggregation of hospital capacity and demand.
    Read more about this company

     

    Data Warehouse Developer

    Responsibilities

    • Architect data in the cloud (open to cloud platform)
    • Own and drive the technical design, development, and day-to-day support of the Data Warehouse and associated ETL processes
    • Support ongoing data quality and data integrity initiatives through audit, balance, and control procedures, alerts and reports, and automated recovery
    • Designs, develops, extends, and maintains Data Warehouses and Data Marts
    • Provides expert level application and data analysis for data warehouse and systems integration projects
    • Manages and monitors of daily database backups of databases from operational systems
    • Designs and codes ETL processes and constructs OLAP data sources
    • Develops the scripts used to load data into the data warehouse
    • Develops scripts and programs to extract data from source systems
    • Develops the scripts necessary to incrementally evolve the data warehouse data model
    • Creates and maintains project requirements documents
    • Creates technical project documentation
    • Works closely with Applications Architect and Project Managers to ensure proper architecture design and compliance with database and development standards
    • Implements and deploys phases of business intelligence and systems integration projects
    • Performs production support of data warehouse and BI related systems
    • Advises/recommends project and activities as related to system/architectural direction and strategy
    • Assist with identifying required data in various source environments identifying data quality gaps
    • Experience: Strong understanding of database structures/Data Modeling, theories, principles and practices
    • Solid understanding of dimensional modeling, STAR schema design, Snow fake schema design, slowly changing dimensions, confirmed dimensions.
    • ETL design, development and monitoring
    • Proficiency in the use of DBMS tools for various DBMS including Microsoft SQL Server, Postgres, MySQL and ETL tools
    • Proficiency in SQL Language Scripting
    • Eight or more years in database/data warehouse development experience
    • Previous experience supporting a data warehouse optimized for a Business Intelligence environment preferred
    • Ability to execute assigned tasks with a high degree of independence based on verbal or written requirements
    • Ability to adhere to coding standards and participate in peer code reviews
    • Some shell scripting skills is an added advantage

    Deliverables

    • Daily Database Backup Management
    • Successful executions of all ETL jobs and processes
    • Data Warehouses and Data Marts that is online and available with up-to-date information

    Work Environment

    • Fast paced environment with occasional high pressure or emergent situations
    • Work hours subject to office needs to ensure coverage during all hours of operation
    • Interaction with diverse population of team members across the group, insurance, IT, and healthcare divisions.

    Physical Demands

    • Frequent sitting and regular meetings
    • Frequent use of computer and keyboard.

    Method of Application

    Interested and qualified? Go to AfyA Care on afya.care to apply

    Build your CV for free. Download in different templates.

  • Send your application

    View All Vacancies at AfyA Care Back To Home
    View Current vacancies at AfyA Care
Jobs You Might Be Interested in

Related Companies Hiring Now

View Hot Nigerian Jobs Today »
tech jobs

Career Advice

View All Career Advice
 

Subscribe to Job Alert

 

Join our happy subscribers

 
 
Send your application through

GmailGmail YahoomailYahoomail