Senior Data Engineer

As an employee, you Turn Change Int Value® - for our clients, for our company, for your professional growth, and for the consumers. We hire the best and brightest, who are driven to create lasting value. At xScion, you aren't just another team member, you're impactful. You're empowered. You're driven. You're an xScioneer.

Overview: xScion is seeking a highly experienced Senior Data Engineer to join our growing data team. You will play a key role in building and maintaining customer data pipelines, focusing on migrating and optimizing data processes from Informatica to Redshift, utilizing AWS Glue for orchestration, and leveraging the power of Python and PySpark for data transformation. This role requires strong coding skills, a deep understanding of data warehousing concepts, and experience with AWS cloud services.

Location: Remote (United States)

As a Senior Data Engineer, You Will

• Design, develop, and maintain robust and scalable data pipelines using AWS Glue, Redshift, Python, and PySpark.
• Migrate existing data processes from Informatica PowerCenter to AWS Glue, optimizing for performance and efficiency.
• Develop and optimize Redshift stored procedures for data transformation and loading.
• Write Python and PySpark scripts for data pre-processing, transformation, and analysis within Glue jobs.
• Orchestrate and schedule data pipelines using AWS Glue workflows, ensuring reliable and timely execution.
• Monitor and troubleshoot data pipelines, identifying and resolving performance bottlenecks and data quality issues.
• Collaborate with data scientists and analysts to understand data requirements and translate them into efficient data solutions.
• Implement data quality checks and monitoring to ensure data accuracy and integrity.
• Stay up-to-date with the latest data engineering technologies and best practices.
• Contribute to the continuous improvement of our data infrastructure and processes
  
  

To Be Successful, You Need

• Bachelor's degree in Computer Science, Engineering, or a related field.
• Proven experience (8 years) as a Data Engineer, with a focus on data warehousing and ETL processes.
• Strong proficiency in SQL, including experience with Redshift and its specific features (e.g., distribution keys, window functions).
• Hands-on experience developing and optimizing Redshift stored procedures.
• Solid understanding of AWS Glue and its components (crawlers, ETL jobs, data catalog).
• Expertise in Python and PySpark, with the ability to write efficient and scalable data processing scripts.
• Experience with data orchestration and scheduling tools, preferably AWS Glue workflows.
• Familiarity with data modeling concepts and best practices.
• Experience with Informatica PowerCenter is a plus.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.
• Experience with other AWS services (e.g., S3, Lambda, EC2) is a plus.
• US Citizenship or Permanent Residency is required for this position.
  
  

Why xScion?

• We have an amazing culture– We were namedBest Places to Work in Virginia 7 times, including 2023.
• We are poised for rapid growth– We are on the cutting edge of digital transformation in Financial Services, Healthcare, Nonprofit and Public Sector and continuously welcome new clients to the xScion family.
• We believe in your continuous development– We invest in our teams’ development, including our Communities of Practice, technology partnerships, sandbox and paying for certifications and trainings to improve their skills because we are committed to collectively being the best at what we do.
• We want you to make an impact in whatever you do– Our people are given the opportunity to provide impactful change to our clients and team.
• We believe in equality- As a woman-owned organization, we believe in an inclusive and diverse culture where everyone’s uniqueness makes us stronger.
• Great Benefits: Medical, dental, 401(k) match, flexible spending and more, but we also have unique perks such as up to 27 days off a year (including your birthday!), remote work opportunities, parental leave, wellness benefits and many other things that inspire balance and flexibility.
  
  

We’re Transforming RegTech Organizations

At xScion, we Turn Change Into Value. We help clients in highly regulated industries start or accelerate their digital transformation initiatives by shifting their mindset and goals into smaller, actionable steps that create lasting value. With more than 20 years of experience supporting Regulatory Technology (RegTech), xScion provides both domain experts and tailored solutions to help organizations navigate complex compliance and technology requirements. We specialize in Business Agility, Cloud Transformation, and Organizational Change Management solutions for clients in Financial Services, Public Sector, Nonprofits, and Healthcare. Our experts help prepare and create change to clients’ processes, technology and culture in order to improve operational efficiencies and the customer experience. As a certified Woman-Owned Small Business, we are proud to be the most trusted solutions partner that business and technology leaders count on to deliver lasting, impactful value.

All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or protected veteran status. xScion takes affirmative action in support of its policy to employ and advance in employment individuals who are minorities, women, protected veterans and individuals with disabilities.

You will be added to our talent community when you apply for this job. You may opt-out at any time.

Want to Learn More about xScion?

Check us out on www.xscion.com or socially at LinkedIn, Twitter, and Glassdoor.