What are the responsibilities and job description for the Senior Data Engineer/ Architect position at Alltech Consulting Services?
Job Description
Primary Responsibility
Client is searching for a hands-on business-focused technology lead. The ideal candidate will have functional knowledge in Sales and Marketing processes and core data engineering technologies such as databases, BI, ETL and AI tools. The individual will work closely and partner with global sales enablement, analytics client management, operations, and finance teams to deliver on projects that provide the capabilities defined in the target operating model.
- Setting up Semarchy MDM tools and maintenance. (Mandatory)
- Strong database management skills – Snowflake / SQL / DBT. (Mandatory)
- Strong cloud infra e.g. ADLS & ADF.
- Expertise in relational and dimensional data modeling.
- Designing and developing efficient data ingestion processes, data models, and data pipelines leveraging the power of Snowflake / Redshift / Bigquery
- Collaborating extensively with clients to gain a deep understanding of their data requirements and translating them into robust technical solutions.
- Implementing end-to-end ETL / ELT workflows to seamlessly extract, transform, and load data into Snowflake / Redshift / Bigquery
- Optimizing data pipelines to achieve exceptional performance, scalability, and reliability.
- Conducting thorough data quality assessments and implementing effective data governance best practices.
- Monitoring and troubleshooting data integration processes to ensure the utmost accuracy and integrity of data.
QUALIFICATIONS AND EXPERIENCE : (Academic, Professional, Experience)
