Lead ETL Developer (Data Modeling)

  • Washington, DC
  • Posted 60+ days ago | Updated 11 hours ago

Overview

On Site
USD 105,000.00 - 145,000.00 per year
Full Time

Skills

End-user training
SQL
Attention to detail
Data modeling
Life insurance
Online learning
Professional development
Collaboration
Health care
Data warehouse
Business intelligence
IT management
Access control
Data marts
Performance tuning
Technical training
Problem solving
Project management
Leadership
Extract
transform
load
FSA
Broadband
Administration
Telecommunications
Insurance
Telecommuting
Training
Creativity
Value engineering
Reporting
Design
Governance
Scrum
Scheduling
Management
Data
Meta-data management
Scripting
Database
Analytics
IMPACT
Planning
EDS
Workflow
OLAP
Tableau
Analytical skill
Communication
SAFE

Job Details

USAC's target compensation range for a new hire into this position is $105,000 - $145,000 USD per year. Actual salary may vary depending on job-related factors based on knowledge, skills, and experience, as evaluated throughout the interview process. In addition, this position may be eligible for an annual performance bonus. USAC has a comprehensive benefits package that includes Medical, Dental, Vision, 401 (k), FSA, Life Insurance, Paid Time Off, Commuter Benefits and Wellness Programs.

Why Work Here?

Our mission to achieve universal service addresses America's current critical needs to build out broadband capabilities for telehealth, online learning, and keeping families connected. Join us and help USAC accomplish our mission to bridge the digital divide. Through its administration of the $10 billion Universal Service Fund (USF) programs on behalf of the FCC, USAC works to promote the availability of quality services at just, reasonable and affordable rates and to increase access to advanced telecommunications services throughout the nation. Additional information on USF programs can be found at:

Benefits

USAC supports our employees well beyond their salary with a system of benefits that rivals the top organizations in the country. Simply put: if you are committed to improving the lives of others, we are committed to improving yours. USAC provides low-premium, top-of-the-line medical, dental, and vision insurance in addition to disability and life coverage. Generous 401k contribution, Federal and floating holidays, paid sick leave and vacation time that increases every year. Regular telework schedule and opportunities to take professional development courses and training.

A Multicultural Team

We have actively built an organization that doesn't just celebrate our diversity; we depend on it. The challenges of achieving universal service require creative and unique perspectives. Our accepting and inclusive community will challenge you to grow and learn from others while always recognizing the value of your contribution.

USAC employees are passionate about our mission. Our work contributes to the success of all Americans. We've worked together to build a culture that is collaborative, ambitious, outcome-oriented, and feedback-focused

As USAC continues to support universal service impacting health care providers, educators, and consumers, it is critical now more than ever that we hire people equally passionate and committed to helping fulfill our mission. We are currently seeking an experienced, dynamic and collaborative professional to serve as a Software Developer IV to join our IT team. Reporting to the Data Warehouse Manager you will:
  • Execute on implementing business intelligence solutions across all divisions of the organization. The individual in this role will guide the team in design and implementation of each solution and will implement improvements of technical standards, development processes, governance, and technologies.
  • 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.
  • Develops complex ETL (extract, transform and load) SQL scripts to gather data from various databases and systems to make data available for enterprise analytics and reporting. Evaluate, test and implement new or upgraded software.
  • Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution.
  • 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.

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


USAC is committed to providing a safe and healthy workplace for all employees. All offers of employment with USAC are conditioned on completing and passing a background and reference check. USAC is an Equal Opportunity Employer. No agencies please.

About USAC