NJVC
Company Job Title: | SSIS / Python Developer |
| |
Clearance: | Top Secret with ability to obtain SCI |
Location: | St. Louis, MO |
Reports To: | Program Manager |
FLSA Status: | Exempt, Full Time, Regular |
|
|
|
|
Summary:
The SSIS/ Python Developer will be assignedto an Agile Scrum team that focus on the development of internal data migrationsoftware using SQL Server and SSIS. The SSIS/ Python Developer will providepeers with technical expertise that will offer solutions for difficultprogramming problems.
Duties andResponsibilities:
- Collaboratewith Product Owners and Scrum team members to deliver high quality technicalsolutions to business requirements
- DataDiscovery techniques and Data Modelling
- Datawrangling to pull data together from disparate sources.
- SQLServer administration, tuning, and workbench.
- SQLServer Integration Services (SSIS) including UI and custom code features.
- AWSinfrastructure functionality and configuration, installation as applied todatabases and specifically.
- WritingSQL.
Examine existing ETL scripts and track data back to source
Work with business experts to understand data and complete data mappings. - Otherduties as assigned
MinimumQualifications: (Toperform this job successfully, an individual must be able to perform eachessential duty satisfactorily.)
- Bachelor’s Degree in Statistics,Mathematics, Computer Science or another quantitative field
- Equivalentyears of experience may be used in lieu of degree
- 4+ years of relevant experience withthe following software / tools:
- Ability to writeor create stored procedures, SQL scripts, SSIS packages, etc. that can be usedto:
- Move data fromsource databases to target databases
- Clean / Conditiondata
- Convert ortransform data
- Reconcile andconfirm converted data
- Find data errors
- Validate data tobusiness rules
- Priorexperience supporting IC/DoD
- Experience in the design,deployment and support of a large data warehouse used agency wide for analytics
- Active Top-Secret Clearance withability to obtain SCI
Knowledge, Skillsand Abilities:
- Experiencein at least one scripting language desirable (PowerShell, Shell, PERL, Python).
- Ability to work independently and yet be effective within a team setting
- Must be capable of managing multiple efforts with time related constraints in a fast-paced contracting environment
- Demonstrated ability to effectively communicate and collaborate with diverse internal and external stakeholder groups and individuals
- Friendly presence, helpful attitude, good interpersonal skills, and ability to work well with others.
- Excellent skills in Microsoft Word, Excel, and other Office applications
- Experience working in a home office setting as well as the ability to train end users on frequently asked technical issues.
- Ability to provide technical assistance and support over the phone; good phone skills, professional demeanor, previous customer service experience strongly desired.
- Good problem-solving skills; ability to visualize a problem/situation and think abstractly to solve it
Physical Demands:(The physical demands describedhere are representative of those that must be met by an employee tosuccessfully perform the essential functions of this job. Reasonableaccommodations may be made to enable individuals with disabilities to performthe essential functions.)
- While performing the duties of thisJob, the employee is regularly required to sit and talk or hear. The employeeis frequently required to walk; use hands to finger, handle, or feel and reachwith hands and arms. The employee is occasionally required to stand; climb orbalance and stoop, kneel, crouch, or crawl. The employee must occasionally liftand/or move up to 25 pounds. Specific vision abilities required by this jobinclude close vision.
Work Environment: (The work environment characteristicsdescribed here are representative of those an employee encounters whileperforming the essential functions of this job.)
- The employee will normally work ina temperature-controlled office environment, with frequent exposure toelectronic office equipment.
- During visits to areas ofoperations, may be exposed to extreme cold or hot weather conditions. Is occasionally exposed to fumes or airborneparticles, toxic or caustic chemicals, and loud noise.
ChenegaCorporation and family of companies is an EOE.
Equal OpportunityEmployer/Veterans/Disabled
Nativepreference under PL 93-638.
Weparticipate in the E-Verify Employment Verification Program.