What are the responsibilities and job description for the Data Warehouse Architect II position at CapMetro?
Job Description
WHO WE'RE LOOKING FOR
The Data Warehouse Architect II is responsible for managing CapMetro's Data Warehouse and promoting its usage across the organization. The role will be responsible for the design, architecture, and development of the Data Warehouse to ensure that the data needs of the organization are consistently and accurately served.
Responsibilities
WHAT YOU'LL BE DOING
Note : The duties and primary responsibilities below are intended to describe the general content of and requirements of this job and are not intended to be an exhaustive statement of duties.
- Work cross-functionally with various departments to evangelize and support enterprise data warehouse roadmap across the agency.
- Leads the evolution of the Data Warehouse Architecture, based on enterprise analytics needs and technical roadmap.
- Supports the data warehouse architecture, including all information structures such as staging area, data lake, data marts, and operational data stores. Ensures overall health and performance of the data warehouse environment.
- Focuses on enterprise-wide data modeling and database design. Translates business needs into long-term architecture solutions.
- Manage metadata according to various ETL processes and perform tests on data. Resolve data warehouse issues.
- Designs, develops, tests, monitors, manages, and validates data warehouse activity, including data extraction, transformation, movement, loading, cleansing, and updating processes.
- Oversee master data management and ensure integrity of data in data warehouse.
- Document and maintain metadata for data warehouse and integrations. Develop user documentation and FAQ.
- Provide assistance with documents necessary to procure required systems, licenses, maintenance, and support. Ensure any renewals are completed before expiration and CapMetro is compliant with vendor licensing requirements.
- Participate in on-call rotation for after-hours IT support.
- Partner with stakeholders to undertake full IT ownership of the systems and projects assigned and become proficient in the technical and functional aspects of these systems.
Qualifications
WHAT YOU BRING
Knowledge, Skills and Abilities
WHAT YOU SHOULD KNOW
As a Mobile position, the incumbent is expected to work in the office as needed. There will be access to touchdown / collaboration spaces when on site. Must be in-office for socialization, strategic collaboration, supervision, oversight, and accountability as needed. CapMetro reserves the right to modify work status based on business needs.
This position is based in Austin, Texas. Successful out-of-state candidates must relocate to the state of Texas prior to start date and may have the opportunity to work remotely anywhere in Texas after a specified period.
About Us
CapMetro is Austin's regional public transportation provider. We've been around since 1985 and work every day to give residents, commuters, and visitors the best possible transit options available to match their busy everyday lives.
We're always on the move, connecting people with jobs, schools, restaurants, shops, festivals, and other great places to hang out. In fact, we have more than 31 million boardings each year.
About the Team
At CapMetro, we work to empower, enhance, and serve the region and its communities through the responsible delivery of safe, reliable, high-quality transportation. We are driven by a culture of Safety, Equity, Transparency, Sustainability, and Innovation . These values guide us in our daily activities, and decision-making and position us to be a great community partner and to better serve our riders who trust us to get them where they're going!
WHAT'S IN IT FOR YOU
WHAT YOU SHOULD KNOW
CapMetro is deeply committed to building a workplace where inclusion is not only valued but prioritized. We are proud to be an equal-opportunity employer and committed to creating a welcoming and diverse environment. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, pregnancy, age, or any other protected characteristic as outlined by federal, state, or local laws. CapMetro makes hiring decisions based solely on qualifications, merit, and organizational needs at the time.
