Senior Professional ETL Application Designer

6 days ago

Apply Now

Receive Emails with Similar Jobs

Educology Solutions

WebsiteLinkedInAll Job Openings

Educology Solutions is a company specializing in the digital transformation and modernization of public sector technologies. They offer solutions in cloud integration, health IT, cybersecurity, and training, focusing on creating a digital-first experience for government and public sector clients. The company has been recognized for its excellence with awards such as the 8(a) STARS 3 GWAC by the General Services Administration and maintains high standards of quality management with ISO 9001:2015 certification. With a strong presence in Washington, DC, Educology Solutions aims to equip governmental organizations with advanced technological capabilities.

Systems Integration • Health CRM Solutions • Cyber Security • Program Management • Infrastructure Support

11 - 50 employees

🏛️ Government

🔒 Cybersecurity

📚 Education

📋 Description

• Responsible for designing and developing processes that translate data from various sources to destinations • Escalate concerns to management, determines best practices and provides suggestions on how to improve current practices • Serve as a mentor for less experienced developers • Solutions complex ETL-related technical tasks, identifies potential issues, resolves issues, and drives tasks to successful completion on or ahead of schedule • Understands processes and procedures and advocates for their use with all project members both inside and outside the ETL team • Mentors other team members in areas of expertise and ETL processes and standards and participates in code reviews • Informs Management of project issues; escalates issues in a timely manner, and asks for assistance when needed • Multi-tasks simultaneous assignments, prioritizing ETL tasks • Develops, tests, manages, and implements ETL packages and applications within the standards set by the team • Solves complex issues in innovative ways • Tunes and troubleshoots ETL applications • Performs standard ETL administration tasks such as deployment, package migration and relocation, and managing metadata • Prepares ETL packages for deployment to development, test, and production environments following all Release Management policies • Automates processes where appropriate • Participates in the on-call rotation

🎯 Requirements

• Bachelor’s Degree or equivalent experience • 5+ years ETL design and development experience • 5+ years Data analysis experience using SQL • 5+ years Database knowledge utilizing SSIS and T-SQL • Analytical skills in a SQL environment using T-SQL • ETL design and development knowledge using the Microsoft BI tool set, specifically SSIS and T-SQL • Database knowledge and ability to query complex data sets • Excellent verbal and written communication skills • Ability to maintain attendance to support required quality and quantity of work • Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA) • Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers