To our valued Leidos candidates:

Coronavirus is on everyone's mind with the effects being felt around the world. The markets are volatile, and we're all concerned for the health and safety of our families, friends, and colleagues. Please know that we're taking all necessary measures to safeguard our employees, customers and the communities in which we live, including following all recommended best practices around social distancing.

With that in mind, in an abundance of caution, we are canceling all face to face career events, such as job fairs and open house events. In the coming days and weeks, we will be hosting career events virtually, using our online chat tools so that we may continue our hiring practice safely and securely. You can find available virtual career events at https://career-events.leidos.com.

We are using telephone meetings and online chats via Brazen to conduct interviews and hiring discussions, and we are offering options for video interviews so that you can have a virtual face to face meeting with your potential new leader. We do not conduct interviews or extend offers via text or chat based social media, such as WhatsApp or MySpace.

Leidos will never ask you to provide payment-related information at any part of the employment application process, nor will Leidos ever advance money as part of the hiring process. And Leidos will communicate with you only through emails that are generated by Leidos.com automated system. If you receive an email purporting to be from Leidos that asks for payment-related information or any other personal information, please report the email to Chris Scalia, Leidos’ Senior Vice President of Talent Acquisition, at [email protected].

As a company, as a country, as a world, we have confronted challenging moments before. We are confident that, guided by our values and the strength of our community as well as the commitment we have to the important work we do each day, we will find our way through this time together. We will do this with the care and concern for one another and the common good that defines. Please keep those impacted by the virus in your thoughts.

Close Window
Join our talent network

Job #: R-00048238
Location: Bethesda, MD
Category: Database Management
Schedule (FT/PT): Full Time
Travel Required: No
Shift: Day
Potential for Telework: Yes, 50%
Clearance: Public Trust
Referral Eligibility: Eligible
Group: Health

Share: mail twitter linkedin

Description

Job Description:

The Government Health and Safety Solutions Operation is seeking candidates for the position of Data Modeler/ETL Developer, contingent upon contract award, supporting the Health Resources and Services Administration (HRSA) Data Warehouse (HDW) in Bethesda, MD. 

HRSA is the nation’s Public Health Agency, and its mission is to provide direct and indirect resources to see to the health care needs of the un-served and under-served in the United States.  In order to do so, HRSA requires extensive data on population, income, existing health care resources, the health workforce, as well as various other types of contextual data.  HRSA’s business processes result in considerable amounts of administrative and process data as well as some measures of outcome and performance.  All of these types of data are stored in a central repository, and must be kept up to date.  In addition, older data must be archived, and consolidated aggregate data must be managed so as to permit trend analyses.

This position is responsible for designing and developing automated processes to extract, transform, and load data and metadata so they can be loaded into the data warehouse using a mixture of MS SQL Server Integration Services, Python, ArcGIS, SAS, and SQL scripts.

RESPONSIBILITIES:

  • Design conceptual and logical models for data warehouses.

  • Update data models to meet new and changing business requirements.

  • Map source system data to data warehouse models.

  • Develop, test, and maintain ETL processes for all sources and destinations in SQL Server SSIS.

  • Adapt ETL processes to accommodate changes in source systems and to respond to changes in business requirements.

  • Develop processes for capturing and maintaining metadata from all data warehousing components

  • Define and capture metadata and rules associated with ETL processes.

  • Maintain recommended specifications for client access, application servers, database servers and networks

  • Work collaboratively with Product Owners and Subject Matter Experts to identify and understand source data systems.

  • Provide a feedback loop to advise on data standards in transaction systems that will lend better to long term analytic use of institutional data.

  • Produce technical documentation such as designs, process flow diagrams, data flow diagrams, decision trees, and data dictionaries

REQUIRED SKILLS/EXPERIENCE:

Bachelor’s Degree in a Technical Discipline

  • Seven or more years of SQL Server development experience with at least five years Integration service experience.

  • Demonstrated experience with SQL Server Integration Service to accomplish regular, non-disruptive data refreshes implementing data validation, business rules, and aggregations; design error handling and deployment plans.

  • Experience building data refreshes in SQL Server Integration Service from ground up without using any existing packages.

  • Intermediate to advanced relational and dimensional data modeling, database design, and technical design skills.

  • Intermediate to advanced SQL data integration skills.

  • Understanding of source and target data structures.

  • Understanding of data analysis and presentation concepts that facilitate collaborative work with BI Analysts and end users.

  • Ability to read technical documentation and architecture artifacts.

  • Familiar with Agile processes.

  • Understanding of system analysis, business analysis, and requirements development and able to utilize such information in analyzing and solving complex problems.

  • Ability to work quickly and efficiently in designing and implementing technical solutions.

  • Ability to analyze technical and functional aspects of a program and troubleshoot complex issues, take corrective actions and implement improvements.

  • Ability to work successfully in a team environment and possess the flexibility and adaptability to changing requirements is required.

  • Ability to translate needs analysis results into functional designs and to develop and learn new technical skills quickly.

  • Familiarity with process recovery capabilities, outcome monitoring and audit recording is preferred.

  • Exposure to GIS data, data management with ArcGIS, and Python geoprocessing scripting a plus

The above description reflects the details considered necessary to describe the principal functions of the job and should not be construed as a detailed description of all the work requirements that may be performed in the job.

U.S. citizenship or permanent resident status and the ability to pass a background investigation is required. Candidates will be required to sign and adhere to data use agreements on an annual basis.  

External Referral Bonus:

Eligible

Potential for Telework:

Yes, 50%

Clearance Level Required:

Public Trust

Travel:

No

Scheduled Weekly Hours:

40

Shift:

Day

Requisition Category:

Professional

Job Family:

Database Management

Pay Range:

  

About Leidos

Leidos is a Fortune 500® information technology, engineering, and science solutions and services leader working to solve the world’s toughest challenges in the defense, intelligence, homeland security, civil, and health markets. The company’s 38,000 employees support vital missions for government and commercial customers. Headquartered in Reston, Va., Leidos reported annual revenues of approximately $11.09 billion for the fiscal year ended January 3, 2020. For more information, visit www.Leidos.com.

Pay and Benefits

Pay 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 Data

Leidos will never ask you to provide payment-related information at any part of the employment application process. And Leidos will communicate with you only through emails that are sent from a Leidos.com email address. If you receive an email purporting to be from Leidos that asks for payment-related information or any other personal information, please report the email to [email protected].

Commitment to Diversity

All 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.

   Save Job Saved

Talent Community

Join our Talent Community to create a profile, enabling a streamlined application process and to help our recruiters better understand your areas of expertise and interest.

Join our Talent Community