Educology Solutions
Senior ETL Professional Application Designer
Educology Solutions, Washington, District of Columbia, us, 20022
ESI is seeking am ETL Senior Professional Application Designer that will be responsible for designing and developing processes that translate data from various sources to destinations and presents findings to appropriate team members, clients and vendors. Escalate concerns to management, determines best practices and provides suggestions on how to improve current practices. Serves as a mentor for less experienced developers.
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)
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)