ETL Developer/Data Modeler

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:

Potential for Telework:

Clearance Level Required:

Travel:

Scheduled Weekly Hours:

Shift:

Requisition Category:

Job Family:

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.