Role:- Data Architect

Experience: 7+ Years

Mandatory Skills:

As a Tech Lead, the candidate will participate in the design/development / customization and maintenance of software applications. The candidate will also be maintaining a close working relationship with the other application stakeholders. The candidate must also demonstrate the ability to independently work in a fast-paced environment requiring multitasking, efficient time management and excellent communication skills

• Should be hands-on & Maintain health of current customer implementation & their data pipelines (most cases, get data from Blob/S3/File stored on Media through SFTP and build/modify pipeline)
• Experience as Python Developer
• Experience in the development of incremental data load or sub pipeline
• Experience in Python API dev., Flask, Django, 3rd party API
• Good Knowledge of Web Services, REST, SOAP
• Good Understanding of Tools like SOAP UI , Postman, etc
• Fix bugs of current pipeline•
• Knowledge of software development life-cycle methodology e.g. Waterfall, Agile etc.
• Python, Apache Airflow scheduler
• Expert in writing SQL queries
• Expert in ETL Tools using Python Libraries
• Must have experience in Pipelines, Data Flows, Transformations, ETL optimization, error handling, troubleshooting.
• Knowledge of Data Warehouse with AWS/GCP/Hadoop.
• Should be able to set business requirements for ETL process.
• Should be able to lead ETL development, deployment, and maintenance.
• Should be able to actively participate in data warehouse design.
• Should have worked on Real-Time Analytics & Batch analytics
• Should be capable of creating technical documentation for ETL solutions.
• Should have the ability to handle structured /unstructured data and have prior experience in loading, validating, and cleaning various types of data
• Advanced knowledge of SQL/redshift with proficiency with Python/R
• Sound knowledge of advanced analytics and machine learning techniques such as segmentation/clustering, recommendation engines, propensity models, and forecasting to drive growth throughout the customer lifecycle
•  

Job description & KRA

• Develop database solutions to store and retrieve company information
• Install and configure information systems to ensure functionality
• Analyze structural requirements for new software and applications
• Migrate data from legacy systems to new solutions
• Design conceptual and logical data models and flowcharts
• Improve system performance by conducting tests, troubleshooting and integrating new elements
• Optimize new and current database systems
• Define security and backup procedures
• Coordinate with the Data Science department to identify future needs and requirements
• Provide operational support for Management Information Systems (MIS)

Requirements

• Proven work experience as a Data Architect, Data Scientist, Data Analyst or similar role