Data Warehouse Architect - Virtual - open to any location in US
- Location
- San Jose, CA
- Listed
- Yesterday
How well does your resume fit this job?
Upload your resume to see your score for this Direct Staffing role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
The Senior Data Warehouse Engineer will help architect, build, and maintain a robust, scalable, and sustainable business intelligence platform. Surrounded by a diverse group of fun and dedicated individuals, this role will tackle highly scalable systems with complex data models, heterogeneous ETL technologies, and large volumes of internet log and transactional data.
This is a highly visible and strategic role as our business decisions are driven by data. As we grow, it will become even more important that we have the right data to make the right decisions. As the Sr. Data Warehouse Engineer, you are responsible for analysis, design, requirements gathering, functional/technical specification, development, deployment, and testing work related to the data warehouse.
Essential Responsibilities • Design, develop, and maintain highly scalable ETL & Data Warehousing-related systems that use a variety of technologies to aggregate data from across various external entities and from within the business. • Engineer data warehousing solutions through the use of multiple technologies including: DBMS (Oracle, SQL Server, MySQL), App Dev (Java, Ruby, C++ etc), ETL tools (Informatica, Ab Initio, SSIS), OS (Solaris, HP-UX, Windows, Linux), scripting (Shell, Python, Perl).
- Integrate third party data into our enterprise data warehouse. Create and maintain the logical and physical dimensional data model. • Provide data streams from front-end/third-party systems to drive real-time business metrics and decisions • Invest time and effort to constantly learn latest technologies related to BI and big data applications. • Document business requirements, design specifications, and ETL operational manuals. • Join forces with analysts and stakeholders to gather, understand, and develop technical requirements • Recommend standards and methodology for creation, capture, maintenance, and integration of metadata • Provide expertise and leadership on making technical decisions, thus delivering a platform that provides business value and meets end user goals • Be flexible, adaptable, and available for full production support during off-business hours on a regular basis.
Qualifications & Requirements
- Bachelor's degree in computer science, engineering, or information systems • 8+ years of experience in data warehousing (including dimensional modeling concepts) business requirements analysis, data-source analysis, data mapping, technical solution design, and database applications development with SQL databases. • 5+ years experience working as a developer in a Data Engineering, Data Warehousing / Business Intellegence team. • Comfortable in both a sole developer role as well as one of the members of a larger development team. • 5+ years of experience in data warehousing including data cleansing, optimization, high-volume (>2 terabytes – min 2 years), and near real-time ETL process design & development • Broad understanding of multiple technologies – including DBMS (Oracle, SQL Server, MySQL), Recent experience in application development (Java, Ruby, C++ etc), ETL tools (Informatica, Ab Initio, SSIS), OS (Solaris, HP-UX, Windows, Linux), scripting (Shell, Python, Perl). • Hands-on with at least 1 Big Data technology such as: Redshift, Hadoop, Candandra, Netezza, Mongo DB, etc. • Experience in integration with third party APIs • Interest in using cutting-edge technologies and modern languages to find new answers to old problems • Ability to learn new paradigms, tools, and processes quickly • Thrives in a fast-paced, rapidly-changing, exciting work environment • Ability to prioritize and work autonomously yet collaboratively when needed • Excellent communication skills and ability to convey ideas accurately and concisely to both technical and non-technical employees • Added advantage, if the candidate is experienced in some the following areas: • Open source data warehousing / business intelligence / ETL / big-data platforms & tools • Modern OLAP concepts and analytic tools, e.g., Tableau, ClikView, etc. • Experience with Amazon Redshift • Experience with emerging technologies such distributed file systems, document stores, and clustered databases (e.g. Hadoop, MapReduce, Greenplum, Vertica, Cassandra) • Data mining • Statistical analysis using R and related tools • Machine learning Required Skills • Ability to design, code, debug, and execute very large database solutions that meet specifications • Ability to gather and document specifications from monitoring business needs • Effective analytic and problem-solving skills to solve production problems very fast • Ability to prioritize and deal with conflicting demands • Strong verbal and written communication skills FYI Skills Requirements Absolute Requirements •
Additional Information
All your information will be kept confidential according to EEO guidelines.
Direct Staffing Inc
About the Company
Advertising / Marketing / PR
From Direct Staffing's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Data Warehouse Architect - Virtual - open to any location in US role at Direct Staffing, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
- Data Warehouse EngineerTEKsystems · Pittsburgh, PA
- Data Warehouse SpecialistCollabera · Hebron, KY
- Data Warehouse DeveloperIdealforce · Phoenix, AZ
- Data Warehouse QA Engineer (Only Locals)Jobsbridge · San Ramon, CA
- Data Warehouse Developer (Teradata & Informatica)Sonsoft · Charlotte, NC
- Data Warehouse/ETL Tester - USC/GC or GCEAD no sponcershipUSM Business Systems · Reston, VA
Common questions
Where is the Data Warehouse Architect - Virtual - open to any location in US job at Direct Staffing located?
This Data Warehouse Architect - Virtual - open to any location in US position at Direct Staffing is located in San Jose, CA. Always check Direct Staffing's application page for specific state eligibility or relocation policies.
How do I apply for the Data Warehouse Architect - Virtual - open to any location in US position at Direct Staffing?
This listing links directly to Direct Staffing's SmartRecruiters application page. You can apply directly on Direct Staffing's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.