Senior Data Engineer

Senior Data EngineerAmpcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented team.In this role, you will:Incorporate Cloud technologies on new application development to include microservices, SQL and AWS services such as Lambda, S3, SQS, SNS, DynamoDB, Quicksight, AWS Redshift and OpensearchCreate and maintain automated functional and system tests to replicate complex real-world scenariosDevelop code and our test automation suite to support security features and technical scoping, ensuring that features deliver the expected functionality with high qualityEnsure that continuous integration is performed on the application source code and constantly seek to enhance the continuous integration methods of the development team to ensure extremely high quality of codeSupport and coordinate with other Engineers, Architects and teams such as User Experience and/or infrastructure teamsStrategy & Communication (20%)Implement cloud-first architectural solutions and best practicesParticipate in agile scrum ceremonies (Sprint Planning, Grooming, Daily SCRUM, Demo) and contribute to team deliverablesParticipate in peer reviews of software engineering artifactsTeam Coordination (10%)Mentor team members by designing and developing training materials to communicate the current and future product architectureMentor technical staff by providing feedback of code and other design artifactsAbout You You have:Ideally 6+ years of software development experience in a production environmentExpertise writing and optimizing complex SQL queries for data extraction, transformation, and reporting (e.g., SELECT, JOIN, GROUP BY, HAVING, WINDOW functions)Expertise integrating Redshift Serverless with AWS services such as S3, Glue, Lambda, Athena, DynamoDB and Kinesis BI tools like Tableau, Quicksight, or Looker for real-time analytics and dashboardsExpertise building serverless ETL pipelines with Lambda to automate data ingestion and transformation into RedshiftExperience with Python required; React and Node.js nice to haveExperience building event-driven cloud-based serverless applications and deploying to AWSTechnical knowledge of Cloud Computing, DevOps, and MicroservicesExcellent communication skills with the ability to present ideas in business-friendly and user-friendly languageDemonstrated ability to develop and maintain good customer working relationshipsExceptional analytical, conceptual, and problem-solving abilitiesAble to prioritize and execute tasks in a high-pressure environmentAmpcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.