Full-timeAverage Employment Length: 2.5 years
Full Job Description
US Citizen is REQUIRED. Please do not apply if you do not have US Citizenship
Assist in data model design, including relational database, data warehouse, and de-normalized data marts for reporting. Develop SSIS packages and SQL scripts for ETL process. Perform initial testing/verification of the SSIS packages and support deployment testing. Create documentation for SSIS packages created, data lineage, etc. Assist in the troubleshooting of production issues.
- Strong knowledge of relational database design, data warehouse design, data mart design, and business intelligence reporting. Hands-on design experience is a big plus.
- Strong knowledge of data model and entity relationship.
- Design database or create data model from existing database: at least 2+ years of working with data model.
- In-depth knowledge of ETL process; at least 4+ years of experience of conducting data extraction and data transformation.
- At least 4+ years of hands-on experience of developing complicated SQL scripts.
- At least 2+ years of hands-on experience of developing Microsoft SQL Server Integration Services (SSIS) packages.
- Familiar with Agile development methodologies.
- Knowledge of GIT and Microsoft DevOps is a plus.
- Demonstrated capability to understand and analyze business requirements.
- Strong troubleshooting skills.
- Strong written and oral communications skills.
- Strong performer with the ability to get job done, expected to be team-focused, self-motivated, self-managed, and willing-to-learn.
Job Type: Full-time
Pay: $85,000.00 - $95,000.00 per year
- 401(k) matching
- Dental insurance
- Health insurance
- Paid time off
- Referral program
- Vision insurance
Remote work until return to job location is implemented (exact date is unknown).
Ability to commute/relocate:
- Falls Church, VA: Reliably commute or planning to relocate before starting work (Required)
- US Citizen is required for this position. Are you a US Citizen?
- Have you designed relational database or data warehouse on your own before?
- Are you able to create data model for an existing database without using a data modeling tool?
- Are you able to write and understand complex SQL statements?
- Overall: 8 years (Required)
- ETL: 4 years (Required)
- SSIS: 2 years (Required)
- Temporarily due to COVID-19
Work Location: One location