Data Engineer / Data Solutions Consultant

Our client is seeking a hands-on Data Engineer / Data Solutions Consultant to support enterprise data, analytics, and reporting initiatives. This role will focus on designing, developing, and maintaining scalable data solutions across analytics and data warehousing environments.
The ideal candidate will bring strong expertise in Informatica Intelligent Cloud Services (IICS) and SQL, along with experience in AWS, Python, and data modeling. This position requires a detail-oriented data professional who can support end-to-end data lifecycle activities including integration, transformation, quality validation, and reporting delivery.
Key Responsibilities

• Design, develop, and maintain data solutions across analytics, reporting, and data warehouse environments
• Perform hands-on development using IICS, SQL, Python, Snowflake, and SAS
• Build and support data pipelines, data models, and integration processes
• Execute data migration, transformation, profiling, validation, and reconciliation activities
• Support source-to-target mapping, testing, and data quality initiatives
• Develop dashboards and reporting outputs using Tableau and related tools
• Partner with business and technical teams to translate requirements into scalable data solutions
• Document data logic, mappings, and testing results clearly

Required Qualifications

• Strong hands-on experience with Informatica Intelligent Cloud Services (IICS) (most critical)
• Advanced SQL skills for data transformation and optimization (most critical)
• Experience with AWS cloud environments
• Strong understanding of data modeling and data warehousing concepts
• Experience with Python for data processing
• Experience building and supporting ETL/ELT pipelines and data integrations
• Familiarity with Snowflake or similar cloud data platforms
• Strong communication and collaboration skills