Custom ETL Developer

Custom ETL Developer

Leidos

Baltimore, MD 21244

Posted 10 months ago

  • Job Type(s)

    Full Time
  • Industry

    Technology
  • Job Description

    Custom ETL Developer

    Description

    Leidos is seeking a Custom ETL Developerto be part of the mission solutionand help lead SSAs Digital Modernization Strategy. Joinone 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 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!!

    • 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:

    • Bachelors degree 4 years of prior relevant experience or Masters 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.

    ITSSCII

    Original Posting Date:

    2024-02-02

    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:

    Pay Range $81,250.00 - $146,875.00

    The Leidos pay range for this job level is a general guideline onlyand 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.

    Original Posting Date:

    02/02/2024

    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.