Data Architect (AWS, SSIS, SQL, Python)

Job Summary:

We are seeking a highly skilled and experienced Data Architect to design, implement, and manage scalable data solutions. The ideal candidate will have deep expertise in SSIS, SQL, Python, and data pipeline development, with strong experience in AWS cloud services. You will play a key role in shaping our data infrastructure, ensuring high performance, reliability, and security across all data systems.

Key Responsibilities:

• Design and implement robust data architectures to support business intelligence, analytics, and operational needs.
• Develop and maintain ETL processes using SSIS and custom scripts in Python.
• Optimize and manage SQL databases, ensuring data integrity, performance, and scalability.
• Build and orchestrate data pipelines for batch and real-time data processing.
• Leverage AWS services (e.g., S3, Redshift, Glue, Lambda, RDS) to deploy and manage cloud-based data solutions.
• Collaborate with data engineers, analysts, and business stakeholders to understand data requirements and translate them into technical solutions.
• Ensure compliance with data governance and security policies.
• Monitor and troubleshoot data workflows and system performance.

Required Qualifications:

• Proficiency in SSIS, SQL, and Python.
• Hands-on experience with AWS data services and cloud architecture.
• Strong understanding of data modeling, normalization, and schema design.
• Experience with data pipeline orchestration tools (e.g., Apache Airflow, AWS Step Functions).
• Excellent problem-solving and communication skills