Solution Architect - Technology

Job Title: Solution Architect - Technology

Job Description:

We are seeking a skilled Solution Architect to join our dynamic team. The ideal candidate will be responsible for designing, and implementing, Data warehouse and Data Lake processes to support our digital platforms analytics needs. The Solution Architect will collaborate closely with analysts, database administrators, and business users to understand requirements and deliver efficient solutions.

Responsibilities:

• Design, develop, and maintain data management processes using industry best practices and tools like AWS and Microsoft Fabric Lakehouses, Amazon Redshift, Amazon Quicksight, AWS Glue, Kafka, Data Factory, Synapse, PowerBI.
• Stream and Extract data from various sources, including databases, files, APIs, RPA, and external systems.
• Transform data to meet business requirements, including data cleansing, validation, and enrichment.
• Load data into target systems, such as data lake, data warehouses, and operational databases.
• Perform data profiling, analysis, and quality assurance to ensure accuracy and completeness.
• Optimize ETL workflows and data warehouse Objects for performance, scalability, and reliability.
• Troubleshoot and resolve issues with ETL processes, data pipelines, and related systems.
• Document specifications, data mappings, and technical designs.
• Collaborate with cross-functional teams to support data-driven initiatives and projects.
• Stay current with emerging technologies, trends, and practices in data management space.

Requirements:

• Bachelors degree in computer science, Information Systems, or related field.
• Must have delivered Technology solutions in Healthcare RCM industry.
• Minimum relevant experience of 10 years.
• Proficiency in ETL tools such as AWS Glue, AWS MSK.
• Expertise in Databases and Data warehouses like Redshift and/or Synapse, SQL Server, postgres, mysql.
• Experience with GenAI and GenBI skills with Amazon Q and/or CoPilot
• Strong SQL skills for data manipulation, querying, and analysis.
• Ability to work independently and as part of a team in a fast-paced environment.
• Strong team player, quick learner, clear communication.

Nice to Have:

• AWS and Microsoft certifications in specified skill areas