Sr. ETL Developer Advisor - United Global Technologies

The Enterprise Data Services Role Developer Advisor (US) is responsible for the development, documentation, testing and ongoing support of ETL, data pipelines and data processes in order to support the delivery of data. They will help support data platform administration and collaborate with architects, QA, product owners, and other developers/admins to ensure solutions that are developed, align with IT standards and best practices, while also adhering to security and service level requirements.

Location: This position will work a hybrid model (remote and office). The ideal candidate will live within 50 miles of our Indianapolis, IN.

Highly skilled and motivated Data Developer/Administrator with a proven background in automation, orchestration, and the processing of data, which includes the full data lifecycle of data transformation, management, retention, security, performance tuning, and SLA management. This role will be responsible for administration and support of data platform tools and the design, development, implementation, and ongoing monitoring of data processes to support organizational data needs. The Developer Advisor (US) will collaborate and partner with data architects, product owners, data governance, technical teams, and other developers/admins to align with organizational standards and requirements surrounding platform administration, security, patching and data processing. They will be responsible for requirements gathering, process mapping, data processing requirements and managing/assessing data platform performance, while focusing on data security/compliance, collaboration, communication and continuous improvement of the data processing framework.

Key Responsibilities:
• Data Orchestration, Automation and Pipeline technology solutions
• Data Platform Tools Support (administration, maintenance, patching, etc)
• Utilizing data fabrics and data virtualization platforms to optimize data delivery.
• Managing and monitoring processes and tools that support data delivery and automation.
• Develop, troubleshoot and optimize queries, views, and stored procedures to support data pipelines and automations.
• Troubleshoot and help performance tune query processing supporting data reporting and delivery.
• Collaborate within the data operations and governance teams to assess and troubleshoot potential data quality and discrepancy issues at key intake points within the data transformation layer.
• Documents data platform processes, programs, and solutions as per established standards for data governance.
• Integrates best practices within data pipeline processes to maximize object reuse.
• Experience sourcing and moving data between database systems (Oracle/MS SQL/Postgres/etc)
• Experience with data research, analysis, security, and data quality
• Ability to create / read / modify / enhance SQL code and packages across database technologies.
• Experience working within agile development teams and processes.
• Familiarity with data protection regulations and compliance requirements for sensitive data.
• Excellent analytical, problem-solving, and solutioning skills.
• Good communication and interpersonal skills, with the ability to engage and collaborate with product owners/managers, application teams, architects, database administrators, and other technical areas or development teams as needed.

Minimum Requirements:
• Requires an BA/BS degree in Information Technology, Computer Science or related field of study and a minimum of 5 years of experience as a Report administrator, Developer, ETL tool administrator, or similar role in a data-centric environment.
Preferred Skills, Capabilities and Experiences:
• 5+ years of experience in administering, testing, and implementing enterprise data process automation and orchestration.
• Experience with Data processing platforms and technologies such as Microsoft SSIS, Informatica, ActiveBa

Primary duties may include but are not limited to: Maintains active relationships with customers to determine business requirements and leads requirements gathering meetings. Owns the change request process and may coordinate with other teams as necessary. Develops and owns list of final enhancements. Develops and defines application scope and objectives and prepares technical and/or functional specifications from with programs will be written. Performs technical design reviews and code reviews. Ensures unit test is completed and meets the test plan requirements, system testing is completed, and system is implemented according to plan. Assesses current status and supports data information planning. Coordinates on-call support and ensures effective monitoring of system. Maintains technical development environment. Mentors others and may lead multiple or small to medium sized projects. Facilitates group sessions to elicit complex information on requirements clarification, design sessions, code reviews and troubleshooting issues. Supports vendor evaluation. Requires BA/BS degree in related field or technical institute training; 5 or more years related experience; multi platform experience; , expert level experience with business and technical applications, or any combination of education and experience, which would provide an equivalent background. Incumbent should also have the ability to mentor others, lead multiple small projects and provide troubleshooting support. Multi dimensional required. Multi database and/or multi language preferred.

Monday-Friday standard work hours, with ability to support on-call activities for critical processes for evenings and weekends on a rotating basis with other team members. Schedule can be anything between roughly 8am-6pm EST.

This position requires worker to be within 50 miles of one of the locations. city/states listed below and PulsePoint locations are listed on the rate card.
Indianapolis, IN
Denison, TX
Baltimore, MD
Harrisburg, PA
Syracuse, NY
Portland, ME
Hingham, MA