Description Leidos is seeking a
Custom ETL Developerto be part of the mission solutionand 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,
supportingthe 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 who can support Production, Development and Cloud Environments Database Infrastructure, SSAS Infrastructure and Reporting Services Infrastructure.
If this sounds like a mission you want to be a part of, keep reading!TEAM CULTUREYour 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 GROWTHOur 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 RESPONSIBILITIESEvery 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!!
- Experience working with complex data warehouse projects
- Design custom ETL processes to populate the data warehouse
- Analyze source data for potential data quality issues and address these issues
- Work with various industry leading data warehouse components (databases, ETL tools, BI/reporting tools)
- Use scripting (Shell scripting, python, Java) and automation and DevOps
- Prepare technical documents and presentations
- Utilize Atlassian product suites, git, bitbucket, confluence, Jira.
FOUNDATION FOR SUCCESS (Basic Qualifications) This experience is the foundation a candidate needs to be successful in this position:
- Bachelor's degree 4 years of prior relevant experience or Master's degree +2 years of prior relevant experience.
- Must be able to obtain and maintain a Public Trust Clearance.
- 2-4+ years of combined experience with SQL and/or PL/pgSQL
- 2+ years of combined experience with Jira and Confluence
- The ideal candidate will have a strong desire to learn new skills, embed with a team, solicit ideas, and feedback.
- Excellent communication skills
- Expert in Shell scripting including but not limited to regular expressions, and automating tasks
- Experience creating custom ETL using Python
FACTORS TO HELP YOU SHINE (Required Skills)These skills will help you succeed in this position:
- Experience working with complex data warehouse projects
- Experience designing custom ETL processes to populate the data warehouse (not Tool based ETL)
- Ability to analyze source data for potential data quality issues and address these issues
- Ability to effectively communicate information, both verbally and written to end users, team members and management
- High-level knowledge of various industry leading data warehouse components (databases, ETL tools, BI/reporting tools)
- Experience in scripting (Shell scripting, python, Java) and automation
- Experience with DevOps
- Prepare technical documents and presentation
- Familiarity with Atlassian product suites, git, bitbucket, Confluence, Jira.
- High availability to support On-Call rotations for 24/7 Production database environment
- Be comfortable working independently as well as in a team with a collaborative attitude
HOW TO STAND OUT FROM THE CROWD (Desired Skills)Showcase your knowledge of modern development through the following experience or skills:
- Ansible scripting
- Experience with cloud environment, AWS
- Database Administration (DBA) skills
- Ability to work individually and as part of a team
- Basic knowledge of relational databases (PostgreSQL, DB2, and Oracle)
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.Pay Range:Pay Range $78,000.00 - $141,000.00
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.
About LeidosLeidos is a Fortune 500® technology, engineering, and science solutions and services leader working to solve the world's toughest challenges in the defense, intelligence, civil, and health markets. The company's 47,000 employees support vital missions for government and commercial customers. Headquartered in Reston, Virginia, Leidos reported annual revenues of approximately $14.4 billion for the fiscal year ended December 30, 2022. For more information, visit www.Leidos.com.
Pay and BenefitsPay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available here.
Securing Your DataBeware of fake employment opportunities using Leidos' name. Leidos will never ask you to provide payment-related information during any part of the employment application process (i.e., ask you for money), nor will Leidos ever advance money as part of the hiring process (i.e., send you a check or money order before doing any work). Further, Leidos will only communicate with you through emails that are generated by the Leidos.com automated system - never from free commercial services (e.g., Gmail, Yahoo, Hotmail) or via WhatsApp, Telegram, etc. If you received an email purporting to be from Leidos that asks for payment-related information or any other personal information (e.g., about you or your previous employer), and you are concerned about its legitimacy, please make us aware immediately by emailing us at [email protected].
If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission.
Commitment to DiversityAll qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.