Business Intelligence Analyst III (ETL Developer III) - Hybrid
USAC works with contributors, service providers, and program beneficiaries to achieve the program goals articulated by the FCC for each of these programs.
The FCC has reformed the USF to support further investment in and access to evolving broadband infrastructure, making the programs a primary vehicle to support this critical national priority. USAC, as the administrator of the USF, plays a critical role in supporting the ambitious vision to ensure that all citizens in the United States have access to high-speed broadband. The organization has approximately 500 employees with an operating budget of more than $200 million. USAC works in close partnership with the FCC and other federal and state partners to support the achievement of the USF program goals.
USAC administers the USF programs—High Cost, Lifeline, Rural Health Care, and Schools and Libraries. USAC strives to provide efficient, responsible stewardship of the programs, a key national asset in making important telecommunications and Internet services available to consumers, health care providers, schools, and libraries throughout the United States. The program divisions are supported by additional USAC personnel in Finance, General Counsel, Information Systems, Internal Audit, the Enterprise Program Management Office and Human Resources. Consistent with FCC rules, USAC does not make policy for or interpret unclear provisions of statutes or the FCC’s rules.
Universal service is paid for by contributions from telecommunications carriers, including wireline and wireless companies, and interconnected Voice over Internet Protocol providers, including cable companies that provide voice service, based on an assessment of their interstate and international end- user revenues. These contributions are most typically passed through to consumers through a universal service fee line item on their telephone bills.
Additional information on USF programs can be found at: https://www.usac.org/about/
USAC offers a comprehensive benefits package, ongoing professional development opportunities, including vacation and sick leave.
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 ETL Developer III within our Information Technology team.
Reporting to the Data Warehouse Manager, you will:
-
Guide the team in design and implementation of each solution and will implement improvements of technical standards, development processes, governance, and technologies.
This is an outstanding career opportunity for an individual interested in a genuine professional challenge in support of a public-spirited mission. Working in a creative and fast-paced environment, the ETL Developer III will coordinate with scrum masters / project managers on optimizing scheduling, work allocations, and story assignments.
Among others, your responsibilities will include the following:
-
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.
-
Other specific duties as assigned.
About You:
-
The successful candidate will excel at operating in a diverse and fluid environment, and will be crucial for the success of the Information Technology Division.
-
You have Bachelor Degree and/or relevant technical training with no preferred certification.
-
You have 5 to 7 years of directly related experience.
-
You have 1 to 2 years of operational and/or technical business leadership experience.
-
You have 5 years of experience with OLAP, industry standard databases, structured query language, ETL, reporting.
-
You have 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.
To apply, please apply here: https://careers.usac.org/careers-home/jobs/3074?lang=en-us
About Universal Service Administrative Co:
The USF + USAC + FCC As an independent not-for-profit designated by the FCC, USAC administers the Universal Service Fund (USF). The USF is almost $10 billion and is available annually thanks to the companies and institutions that make universal service possible. USF Programs With the guidance of policy created by the FCC, we collect and deliver funding through four programs focused on places where broadband and connectivity needs are critical. These programs serve people in rural, underserved, and difficult-to-reach areas. E-Rate Keeping students and library patrons connected to broadband services. Rural Health Care (RHC) Supporting healthcare facilities in bringing medical care to rural areas. Lifeline Lowering the monthly cost of phone or internet service High Cost Expanding voice and broadband networks in underserved areas. Service Providers Telecommunications companies support our mission in two critical ways: contributing money to the Universal Service Fund and participating in the USF and Congressional Response Programs. Learn more about both service provider roles. Congressional Response Programs In response to the COVID-19 pandemic, Congress created multiple programs to help people stay connected during and beyond this disruptive period. The FCC designated USAC to administer these programs and funds.