Data Warehouse Architect Job at ProFocus

ProFocus United States

$150,000 a year
TITLE: Sr. Data Warehouse Architect
LOCATION: Onsite West Jordan, Utah
PAY: $130-150k
ENGAGEMENT TYPE: Direct Hire

WHAT YOU’LL BE DOING?
We are seeking a highly skilled Data Warehouse Architect to join our team. In this role, you will be responsible for designing, implementing, and maintaining our data warehouse architecture. You will lead the migration from Oracle to Snowflake, re-architect our current warehouse, design ETL processes, and develop Tableau and Power BI reports. You will also work closely with our AWS data lake tooling team to design and implement a self-service environment.

WHO WE’RE LOOKING FOR?
  • Bachelor’s degree in computer science or a related field.
  • 7-10+ years of experience in data warehousing architecture and design.
  • Design and implement a data warehouse architecture to support our business needs.
  • Lead the migration from Oracle to Snowflake, including data modeling, schema design, and ETL processes.
  • Re-architect our current warehouse to optimize performance, scalability, and maintainability.
  • Design and develop ETL processes to integrate data from various sources into the data warehouse.
  • Work closely with our AWS data lake tooling team to design and implement a self-service environment for data consumers.
  • Develop Tableau and Power BI reports to provide business insights to data consumers.
  • Write complex SQL queries to support reporting and data analysis.
  • Ensure the security, availability, and integrity of the data warehouse.
  • Develop and maintain technical documentation, including data models, schema designs, and ETL processes.
  • Stay current with the latest trends and technologies in data warehousing, ETL, and reporting.
  • Experience with Snowflake data warehouse, including data modeling, schema design, and ETL processes.
  • Experience with AWS data lake tooling, such as S3, Glue, and Athena.
  • Strong SQL skills, including writing complex queries and performance tuning.
  • Experience with Tableau and Power BI report development.
  • Strong understanding of data warehouse concepts, such as star schema, dimension modeling, and ETL.


Authorization to work in the US is a precondition of employment - we do not sponsor work visas

Please NO Third-Party Applicants

ABOUT OUR CLIENT
Our client is a rapidly growing company with an excellent reputation and great work/life balance. West Jordan is located at the foot of the Oquirrh Mountains, offering beautiful views and opportunities for outdoor recreation. There are several parks, trails, and recreational areas in the city that provide access to hiking, biking, and skiing. The city offers many family-friendly events and activities throughout the year, such as farmers markets, concerts, and festivals. Located just 15 miles south of Salt Lake City, West Jordan offers easy access to all the cultural, entertainment, and business opportunities of a major city.

WHY ProFocus:
  • Candidates come first. ProFocus is a six-time winner of Best in Staffing for Talent Satisfaction.
  • Quality process. We invest the time to understand your background and career goals. We only introduce you to opportunities that are the right fit.
  • Access to hiring managers. We have close relationships with some of the most respected local companies, from small businesses to Fortune 500 companies. These relationships give is access to roles that may not be available anywhere else.
  • Excellent benefits. We offer medical, dental, vision, 401k match, education reimbursement, sick leave, and employer-paid disability and life insurance. Review our detailed benefits here.
Want to learn more? Contact one of our recruiters here or email info@ProFocusTechnology.com.
Want to apply? Email your resume to Resume@ProFocusTechnology.com.
Visit our Job Seekers page to learn more and review other opportunities.

ProFocus is an equal opportunity employer. We value diversity in our workplace and encourage all qualified applicants regardless of race, color, age, sex, religion, national origin, physical or mental disability, pregnancy, marital status, veteran or military status, genetic information, sexual orientation, or any other characteristic protected by federal, state, or local laws.
#DICE



Please Note :
www.epokagency.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, www.epokagency.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.