Senior Data Engineer

Software Guidance & Assistance, Inc., (SGA), is searching for a Senior Data Engineer for a contract assignment with one of our premier Financial Services clients in New York, NY
.

• Work on migrating applications from an on-premises location to the cloud service providers.
• Develop products and services on the latest technologies through contributions in development, enhancements, testing and implementation.
• Develop, modify, extend code for building cloud infrastructure, and automate using CI/CD pipeline.
• Partners with business and peers in the pursuit of solutions that achieve business goals through an agile software development methodology.
• Perform problem analysis, data analysis, reporting, and communication.
• Work with peers across the system to define and implement best practices and standards.
• Assess applications and help determine the appropriate application infrastructure patterns.
• Use the best practices and knowledge of internal or external drivers to improve products or services.
• Design, develop, and optimize scalable ETL/ELT pipelines using Databricks and Apache Spark (PySpark and Scala).
• Build data ingestion workflows from various sources (structured, semi-structured, and unstructured).
• Develop reusable components and frameworks for efficient data processing.
• Implement best practices for data quality, validation, and governance.
• Collaborate with data architects, analysts, and business stakeholders to understand data requirements.
• Tune Spark jobs for performance and scalability in a cloud-based environment.
• Maintain robust data lake or Lakehouse architecture.
• Ensure high availability, security, and integrity of data pipelines and platforms.
• Support troubleshooting, debugging, and performance optimization in production workloads.

• Develop, and optimize scalable ETL/ELT pipelines using Databricks and Apache Spark (PySpark and Scala)
• Experience in developing data pipeline solutions to ingest and exploit new and existing data sources.
• Expertise in leveraging SQL, programming language like Python and ETL tools like Databricks
• Perform code reviews to ensure requirements, optimal execution patterns and adherence to established standards.
• Expertise in AWS Compute (EC2, EMR), AWS Storage (S3, EBS), AWS Databases (RDS, Dynamo
  
  DB), AWS Data Integration (Glue).
• Advanced understanding of Container Orchestration services including Docker and Kubernetes, and a variety of AWS tools and services.
• Good understanding of AWS Identity and Access Management, AWS Networking and AWS Monitoring tools.
• Proficiency in CI/CD and deployment automation using GITLAB pipeline.
• Proficiency in Cloud infrastructure provisioning tools e.g., Terraform.
• Proficiency in one or more programming languages e.g., Python, Scala.
• Experience in Starburst, Trino and building SQL queries in federated architecture.
• Good knowledge of Lake house architecture

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do.

Be yourself, love what you do and find your passion ase find us at  .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities.

Please visit our company EEO page to request an accommodation or assistance regarding our policy.