We are looking for a skilled Data Engineer with a strong experience in designing, developing, and maintaining complex data warehouse and business intelligence solutions, with a focus on AWS cloud technologies and data architecture. Ideal candidates must have expertise in SQL, data modeling and ETL development using Informatica along with hands on experience in cloud-based data warehousing solutions such as AWS Redshift and Aurora. Proficiency in Python scripting and working knowledge of visualization tools like Tableau and SAP BusinessObjects are essential. Responsibilities: • Design, develop, test, and automate enterprise data warehouse and BI solutions. • Build and maintain ETL pipelines, data models, and analytics dashboards. • Translate complex technical details into clear, non-technical language for stakeholders. • Analyze and troubleshoot data issues, ensure accuracy, consistency, and integrity. • Develop implementation and transition plans and participate in on-call support as needed. • Occasionally travel domestically for business with rare overnight stays possible. • Participate in the full lifecycle of complex data warehouse and business intelligence solutions, including design, development, testing, implementation, and review. • Develop components of advanced data warehouse applications based on defined requirements, builds reports and dashboards, creates prototypes, and evaluates the feasibility of proposed system designs. • Review and implement updates, patches, and new versions of data warehouse software • Responsible for code deployment and application integration. Qualifications: • Bachelor’s degree in Computer Science, Information Systems, or a related technical field. • At least 5 to years of experience in data engineering, data science, and software engineering. • Proven expertise in writing and optimizing complex SQL queries across multiple RDBMS platforms, including Microsoft SQL Server and Oracle. • U.S. Citizenship or Green Card status is required for this position. • Hands-on experience with ETL tools, particularly Informatica, for data integration and transformation. • Proficient in data visualization using Tableau and SAP BusinessObjects (BO). • Experienced in scripting and automation using Python. • Extensive experience using core AWS services to design and support cloud-based data warehouse solutions in alignment with AWS architecture using S3, DMS, Glue, Lambda. • Development and modeling experience with Amazon Redshift and Amazon Aurora PostgreSQL. • Proficient in using AWS service APIs, AWS CLI, and SDKs to build, deploy, and debug applications. • Experience developing cloud native and serverless applications using AWS, with emphasis on applying security leveraging IAM roles over embedded credentials. • Experience with CI/CD pipelines and deployment tools, including GitLab, Terraform, and DBMaestro. • Capable of maintaining and debugging modular AWS-based code. • Understanding of application lifecycle management (ALM) and containerization technologies.