Req ID: RQ201044
Type of Requisition: Regular
Clearance Level Must Be Able to Obtain: None
Public Trust/Other Required: Other
Job Family: Software Development
Skills:
Data Warehouse Design,Data Warehouse Development,Data Warehouse ETL,Extract Transform Load (ETL),SQL Server Integration Services (SSIS)
Experience:
10 + years of related experience
Job Description:
We are GDIT. The people supporting and securing some of the most complex government, defense, and intelligence projects across the country. We ensure today is safe and tomorrow is smarter. Our work has meaning and impact on the world around us, but also on us, and that's important.
GDIT is your place. You make it your own by embracing autonomy, seizing opportunity, and being trusted to deliver your best every day.
We think. We act. We deliver. There is no challenge we can't turn into opportunity. And our work depends on a Sr. SQL Server/ SSIS Developer joining our team to support World Trade Center Health Program (WTCHP) activities at Falls Church, VA.
At GDIT, people are our differentiator. As a Sr. SQL Server/ SSIS Developer supporting WTCHP, you will be trusted to design and develop ETL. In this role, a typical day will include:
Research, design, develop, and/or modify enterprise-wide systems and/or applications software.
Design, develop, and unit test SQL Server ETL processes and thoroughly evaluate the system to analyze upstream and downstream effects.
Gather and analyze functional requirement documents from the business and understand the key business questions.
Translate the functional requirements into technical specifications.
Build and maintain the naming standards and data dictionaries with respect to the data model and database and document the data model.
Develop, operate, and maintain a transactional processing system.
Design, build, and maintain data warehouse to house data extracted from multiple sources to support analytical analysis/financial reporting.
Enhance the existing data model to facilitate the financial and clinical reporting needs of the end users.
Reverse engineer existing source databases to understand the data architecture and perform detailed source data analysis.
Develop and maintain SQL queries, stored procedures, triggers, and functions to support the ETL (Extract, Transform & Load) process.
Design and maintain source to target mapping and implementation documents to support the ETL processes to refresh the target database or data mart with data from multiple sources.
Create and maintain SSIS/SSDT packages to load data from various sources to data warehouse as well as generate output extracts to external entities.
Support ad hoc report requests from the business.
Create and maintain database objects, enforce constraints, and create validation rules around data maintained in MS Access databases for custom functionality.
Develop and maintain production notification process to efficiently track and report the automated job status to the business.
Tune SQL generated by MicroStrategy for improved performance.
Effectively utilize the tool to its maximum efficiency to read, cleanse, validate, transform, and move data from a variety of source data structures into target databases and vice versa.
Interact and coordinate with business teams as part of requirements gathering and analysis and conduct design review meetings.
Use of SQL Server, SQL Server Integration Services (SSIS), SQL Server Data Tools (SSDT), T-SQL, CA Erwin, Visual Studio, Tortoise SVN, MS Visio, MS Office, and Windows.
REQUIRED QUALIFICATIONS:
Bachelor's degree or foreign academic equivalent in Computer Science, Electrical / Electronics Engineering, Information Technology, or a related field.
10+ years of experience in the job offered or 10 years in a related occupation including Data Modeler, Programmer Analyst, or related experience.
Position requires 10 years of experience with ETL, SQL Server, SSIS, T-SQL, CA Erwin,. Strong SSIS (SQL Server Integration Services) skills required.
75% ETL work is done in SSIS.
LOCATION : Remote
HOURS : 20 hrs/week
CLEARANCE : Ability to pass CDC background check / clearance process.
FedHealth Jobs
The likely hourly rate for this position is between $51.85 - $70.15. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.
Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year. Paid leave and paid holidays are prorated based on the employee's date of hire. The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.
We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 50 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology.
Join our Talent Community to stay up to date on our career opportunities and events at https://gdit.com/tc.
Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans
