Greenplum/PostgreSQL Architect

Leidos is seeking a Sr. Greenplum/PostgreSQL Architect to be part of the mission solution and help lead SSA’s Digital Modernization Strategy.  Join one of our high performing teams responsible for building the next-generation enterprise APIs and modern responsive user interfaces, supporting the Social Security Administration (SSA) and their mission to meet the changing needs of the public, positively impacting at least 65 million American lives per month.  We are a team of forward-looking professionals in need of a strong candidate with these key required skills:  Strong experience with database design, architect and development in Big data and RDBMS, Greenplum, PostgreSQL , SQL Server, Db2, Oracle, Python, R , SAS, PostgreSQL, SQL, PL/SQL, Ansible, T-SQL, UNIX, Linux Shell Script, SAS, Python, R, JavaScript, SSRS/SSIS , JSON and Tableau. 

If this sounds like a mission you want to be a part of, keep reading!

TEAM CULTURE

Your passion and values might be a good fit for our teams if you answer “yes” to the following questions:

• Are you looking for a company that puts employees first, with a focus on career, flexibility, and well-being?
• Do you enjoy collaborating with colleagues and teammates and believe that the best ideas are fostered in an inclusive environment?
• Are you searching for a team with a strong sense of ownership, urgency, and drive for daily mission success?
• Are you comfortable with proactive outward communication and technical leadership?
• Do you enjoy being a catalyst, solving complex problems, and providing innovative solutions?
• Do you have the flexibility, creativity, and resilience to pivot the mission for success?
• Do you have the courage to make tough ethical decisions with pride, transparency, and respect?

MENTORSHIP & CAREER GROWTH

Our teams are dedicated to supporting new team members in an environment that celebrates knowledge sharing and mentorship. Experienced team members will be assigned to new hires for one-on-one mentoring, collaborative reviews, and coaching on customer engagement to help each new hire successfully onboard and demonstrate their skills. Projects and tasks are assigned in a way that leverages your strengths and will help you further develop your skillset.

DAY TO DAY RESPONSIBILITIES

Every position we take is more rewarding when you know the why behind it. Know your work makes a difference to support those who need it most. If your passion is enabling life changing service to those around, you this is the place for you. Find you passion in a team environment where all members are valued regardless of contractor or employee status.   Find your “Why” with us and take your place in our Leidos Family!!

• 10+ years of experience in data architecture, database design, data analysis, and data engineering.
• Experience in designing and managing enterprise data warehouse environments, especially on Greenplum, PostgreSQL, and SQL Server.
•  Hands-on experience with cloud environments, particularly AWS.
• Advanced skills with Greenplum, PostgreSQL, and SQL Server.
• Proficient in designing data pipelines and ETL processes.
• Strong experience with performance tuning and optimizing databases for large datasets.
• Proficiency in Python and R for data manipulation, statistical analysis, and machine learning tasks.
• Expertise in Linux and shell scripting for automation and task scheduling.
•  Familiarity with SAS Viya for advanced analytics and reporting.
• Skilled in using Bitbucket and Git for code versioning and collaboration.
•  Experience with Visual Studio for development and Jupyter for interactive data analysis and visualization.
• Strong expertise in PostgreSQL and Greenplum database architecture, administration, and optimization.
• Proficiency in SQL and advanced query optimization techniques for PostgreSQL, Greenplum, SQL server , db2 and Oracle.
• Experience with data modeling (conceptual, logical, and physical models) to support high-performance data structures.
• Hands-on experience in designing data pipelines and ETL (Extract, Transform, Load) processes.
• Familiarity with ETL tools and frameworks to facilitate data integration from diverse sources.
• Proficiency in designing data warehouse schemas, including star, snowflake, and hybrid schemas.
• Strong programming skills in Python for data manipulation, scripting, and automation.
• Familiarity with data science libraries in Python (e.g., Pandas, Sqlalchemy) for data processing and transformation.
• Knowledge of API integration using Python for data ingestion.
• Familiarity with data partitioning and parallel processing concepts to enhance performance on large datasets.
• Strong experience with AWS services (EC2, S3, RDS, Redshift, etc.).
• Experience deploying and managing infrastructure on AWS and handling data security and governance on cloud platforms.
• Excellent communication skills for technical and non-technical audiences.
• Ability to translate business requirements into technical solutions.
•   Strong documentation and presentation skills to effectively communicate data architecture strategies.
• Use MS Project, Visio and IT Governance Frameworks to document the solution architecture & develop design documents and user guides.
• Attend all customer technical discussions/design/development meetings and provide technical inputs to further enhance the code quality/process.
• Impact functional strategy by developing new solutions, processes, standards, or operational plans that position Leidos competitively in the marketplace.
• Provide guidance/support to other junior/mid-level developers.
• All other duties as assigned or directed.

FOUNDATION FOR SUCCESS (Basic Qualifications)

• Bachelor's Degree in Computer Science, Mathematics, Engineering or a related field. Additional years of experience may be substituted in lieu of degree.
• Masters or Doctorate degree may substitute for required experience

• 12+ years of experience with databases, python and Linux.
• Must be able to obtain and maintain a Public Trust. Contract requirement.

*** Selected candidate must reside within two (2) hours of SSA Headquarters in Woodlawn, MD

*** Selected candidate must be willing to work on-site at least 2 days a week.

FACTORS TO HELP YOU SHINE (Required Skills)

These skills will help you succeed in this position:

• Effective communication skills for working with cross-functional teams, including data scientists, analysts, and business stakeholders.
• Ability to translate technical concepts into non-technical terms for business stakeholders.
• Ability to manage multiple projects, prioritize tasks, and deliver within deadlines.
• Ability to analyze complex data requirements and create scalable solutions.
• Proficiency in debugging and optimizing SQL queries and Python scripts and R scripts.
• Strong understanding of data warehousing best practices and data governance principles.
• Proven experience with PostgreSQL and Greenplum in a production environment.
• Experience with data modeling (conceptual, logical, and physical models) to support high-performance data structures.
• Knowledge of API integration using Python for data ingestion.
• Understanding of Greenplum as a Massively Parallel Processing (MPP) database and experience optimizing queries for distributed processing.
• Familiarity with data partitioning and parallel processing concepts to enhance performance on large datasets.
• Knowledge of BI tools (Tableau, Power BI) and their integration with databases.
• Familiarity with version control systems like Git and CI/CD pipelines for data projects.
• Experience working on Agile projects and strong knowledge of Agile terminology and tools including VersionOne.
• Experience designing and deploying cloud-native applications onto AWS with PostgreSQL.
• Experience with modern software development tools for Continuous Integration including Jenkins, Git/BitBucket, Jira, Nexus and confluence.
• Experience with performance tuning software applications for effective CPU, Memory utilization, Quick turnaround response time, building highly scalable software applications in Cloud Environment handling higher volume of data and traffic.
• Strong communication and documentation skills.

HOW TO STAND OUT FROM THE CROWD (Desired Skills)

Showcase your knowledge of modern development through the following experience or skills:

• Experience with python and R for ETL and writing the predictive models.
• Experience with the SAS ,  SAS Viya tool , Tableau and multiple databases.

• Prior experience with federal or state governments IT projects.

At Leidos, we deliver innovative solutions through the efforts of our diverse and talented people who are dedicated to our customers’ success. We empower our teams and contribute to our communities. Everything we do is built on a commitment to do the right thing for our customers, our people, and our community. Our Mission, Vision, and Values guide the way we do business. Every position we take is more rewarding when you know the why behind it. Know your work makes a difference to support those who need it most. If your passion is enabling life changing service to those around, you this is the place for you. Find your passion in a team environment where all members are valued regardless of contractor or employee status.  We are excited for you to take your place in our Leidos Family.

Are you an US citizen, US resident, or Visa candidate and think you might fit? We recommend you apply and start the conversation today! Join us in supporting our SSA contracts in Woodlawn, Maryland.

ITSSCII

Original Posting Date:

While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.

Pay Range:

The Leidos pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.