• Architect - Data Warehousing

    Posted Date 4 weeks ago(4 weeks ago)
    # of Openings
  • Overview

    We are currently seeking an experienced, dynamic and collaborative professional to serve as a Data Warehouse Architect within our Information Technology team.  Reporting to the Manager of Application Delivery you will:

    • spearhead the design and development of a new, high performance enterprise data warehouse for the organization, using industry best practices and data modeling techniques.

    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 Data Warehouse Architect will collaborate with important stakeholders, including division-based data stewards as well as technical system owners to establish an understanding of the organization’s vast processes and data.  Among others, your responsibilities will include the following:

    • Designs, builds and maintains flexible and scalable data warehouse solutions to support Business Intelligence (BI) and Reporting projects.
    • Provides expertise in the creation and refinement of agile technical stories for data architecture and development.
    • Translates business requirements into technical architecture vision and implementation plans.
    • Provides hands-on development of solutions and supports the analysis and discovery processes.
    • Serves as Subject Matter Expert in data warehouse concepts (Kimball, Inmon, star schema, snowflake schemas, and normalized and de-normalized data models).
    • Helps to develop, implement, and maintain appropriate data governance on the data warehouse and associated metadata for purposes of data quality, integrity, availability, and security.
    • Proactively monitors and analyzes performance to identify and recommend optimizations.
    • Coordinates with team members and leads the implementation of Master Data Management, in conjunction with the new data warehouse.
    • Leads the integration of the data warehouse with a modern, leading business intelligence platform.
    • Proven experience with requirements analysis, design, development, testing, and deployment of BI Solutions (End-to-End), over multiple technologies, size and scale of projects.
    • 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 a Bachelor's degree in Information Technology (IT) or Management Information Systems (MIS) or have equivalent related experience.
    • You are an expert in using standard modeling tools like Erwin, ER Studio.
    • You have experience with multiple database platforms, such as SQL Server, Oracle, Postgres.
    • You have experience with data governance tools such as Collibra.
    • You have experience with high performance big data concepts, such as Hadoop architectures and columnar databases such as Vertica.
    • You have experience with solution delivery frameworks and tools such as Agile, Scrum, Kanban, JIRA.
    • You have experience with configuration management and code repositories such as Git / Stash.
    • You have the ability to recognize issues, take ownership and drive to resolution with minimal supervision, and to escalate issues appropriately.
    • You can demonstrate leadership, decision making, analytical and problem solving skills.
    • You have the ability to work independently as well as collaboratively in a team environment.
    • You have strong attention to detail, thoroughness, quality and customer service orientation.
    • You have excellent verbal, written and presentation skills, with demonstrated ability to translate technical information to a non-technical audience at all levels of the organization.
    • You have excellent interpersonal skills, with the ability to work collaboratively and build and maintain effective working relationships with all stakeholders.
    • You have excellent organizational and time management skills, with the ability to deliver commitments while juggling multiple projects and priorities under a deadline.
    • You have 10 years of IT experience, with a focus on data.
    • You have 6 years of recent Data Warehouse Architecture experience to build and articulate conceptual, logical and physical dimensional data models and third normal form artifacts.
    • You have 5 years of data warehouse architecture experience; or an appropriate combination of education and experience.
    • You have 5 years of experience with business intelligence technologies and solutions.
    • You have 5 years of experience leading teams on IT initiatives, particularly those related to big data.
    • You have 2 years of experience with leading data quality tools.

    The following skills are desired:

    • You have a Master’s degree preferred.


    About USAC

    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. Specifically, the USF programs provide funding for the expansion of telecommunications and broadband access to rural communities and health care facilities, schools and libraries across the country, and low income households. Through program administration, auditing, and outreach, 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: http://www.usac.org/about/about/who-we- are/default.aspx


    USAC offers a comprehensive benefits package, ongoing professional development opportunities, including vacation and sick leave.


    USAC is an Equal Opportunity Employer. Only principals will be accepted. No agencies please.


    To apply, please submit a cover letter and resume, click the “Apply For This Job Online” button.


    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.



    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.