ETL Developer III (Data Modeling)

$105,000 - $141,000/Yr

Universal Service Administrative Company - Washington, DC

Full-time - Mid Level

Washington, DC

About the position

The ETL Developer III (Data Modeling) position at USAC involves implementing business intelligence solutions across the organization, guiding the team in design and implementation, and managing the reporting environment. The role requires a strong focus on data access control, integrity, and the development of data models for data marts and warehouses. The successful candidate will also be responsible for developing complex ETL SQL scripts, troubleshooting reporting issues, and identifying areas for improvement within the organization.

Responsibilities

• Execute on implementing business intelligence solutions across all divisions of the organization.
• Serve as a technical lead in the development of business intelligence solutions.
• Coordinate with scrum masters/project managers on optimizing scheduling, work allocations, and story assignments.
• Manage reporting environment including data sources, connections, security, subscriptions, and metadata.
• Assist in initiative towards data access control and integrity across the enterprise.
• Create data models and schema for reliable and highly performant data marts and data warehouse.
• Develop complex ETL (extract, transform, and load) SQL scripts to gather data from various databases and systems for enterprise analytics and reporting.
• Evaluate, test, and implement new or upgraded software.
• Troubleshoot reported problems pertaining to reports and the reporting database environment.
• Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports.
• Identify areas for improvement within the EDS organization related to architecture, design, performance optimization, development process, workflows, governance, tools/technologies.
• Conduct end-user training on data solutions.

Requirements

• Bachelor's Degree and/or relevant technical training with no preferred certification.
• Five (5) to Seven (7) years of directly related experience.
• One (1) to Two (2) years of operational and/or technical business leadership experience.
• Five (5) years of experience with OLAP, industry-standard databases, structured query language, ETL, and reporting.
• Three (3) years of experience in analytics technologies like Tableau, preferred.
• Exceptional data analytical abilities.
• Exceptional communication skills and collaborative problem-solving skills.
• Strong analytical and project management skills, and attention to detail.

Benefits

• Medical, Dental, Vision insurance
• 401(k) with generous contributions
• Flexible Spending Account (FSA)
• Life Insurance
• Paid Time Off (PTO)
• Commuter Benefits
• Wellness Programs
• Regular telework schedule
• Opportunities for professional development courses and training