Senior 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 complex ETL-related technical tasks, identifies potential issues, resolve issues, and drives tasks to successful completion on or ahead of schedule.
o Understands processes and procedures and advocates for their use with all project members both inside and outside the ETL team.
o Mentors other team members in areas of expertise and ETL processes and standards and participates in code reviews
o Informs Management of project issues; escalates issues in a timely manner, and asks for assistance when needed.
o Multi-tasks simultaneous assignments, prioritizing ETL tasks, ensuring all 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 Solves complex issues in innovative ways.
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 Automates processes where appropriate.
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:
5+ years ETL design and development experience,
5+ years Data analysis experience using SQL
5+ years Database knowledge utilizing SSIS and T-SQL
Preferred Licensure/Certification:
Microsoft Business Intelligence certification(s)