ETL Professional Application Designer
Educology Solutions - Washington, District of Columbia, us, 20022Work at Educology Solutions
Overview
- Apply
Overview
ESSENTIAL FUNCTIONS• Duties and Responsibilities (List all essential duties and responsibilities in order of importance)
o Solutions ETL-related technical tasks, identifies potential issues, resolve issues, and drives tasks to successful completion on or ahead of schedule.
o Understands and follows processes and procedures
o Informs Management of project issues; escalates issues in a timely manner, and asks for assistance when needed.
o Prioritizes ETL tasks, ensuring that tasks are completed on or ahead of schedule
o Develops, tests, manages, and implements ETL packages and applications within the standards set by the team.
o Tunes and troubleshoots ETL applications.
o Performs standard ETL administration tasks such as deployment, package migration and relocation, and managing metadata.
o Prepares ETL packages for deployment to development, test, and production environments following all Release Management policies.
o Participates in the on-call rotation.• Knowledge, Skills and Abilities ( List all knowledge, skills and abilities that are necessary to perform the job satisfactorily)
o Analytical skills in a SQL environment using T-SQL
o ETL design and development knowledge using the Microsoft BI tool set, specifically SSIS and T-SQL
o Database knowledge and ability to query complex data sets
o Excellent verbal and written communication skills
o Ability to abide by policies and values
o Ability to maintain attendance to support required quality and quantity of work
o Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA)
o Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers
Required Education: Bachelor's Degree or equivalent experience
Required Experience:
1+ years ETL design and development experience,
1+ years Analysis experience using SQL
1+ years database knowledge utilizing SSIS and T-SQL
Preferred Licensure/Certification:
Microsoft Business Intelligence certification(s)