16 Sep
Data Warehouse Engineer
Idaho, Boise , 83701 Boise USA

Vacancy expired!

DETAILS:Position: Data Warehouse EngineerLocation: Boise, ID (Can be remote)Length: FTVisa authorization: W2 only (US Citizen)Shift:8-5Reason: BackfillRequirement:• Degree in Computer Science or equivalent experience • Minimum of three years of experience implementing dimensional data models (star schemas).COMPANY:Our client is one of the fastest growing IT companies in the State of Idaho. They were recently acquired by a larger corporation and are growing their office by 25-30%. They are one of the industry leaders in financial fraud detection.OVERVIEW: The Data Warehouse Engineer gathers and interprets user analytics requirements, then transforms those requirements into dimensional data models. They collaborate with data analysts, data scientists, and other data consumers within the business to gather and populate data warehouse table structures. The Data Warehouse Engineer implements dimensional models, from building the logical model to implementing the physical model and loading the data with ETL. The engineer makes big data easy through intuitive query writing, performance, and integrating BI tool. They run the full DW stack from design through implementation.EXPERIENCE: DAY TO DAY: • Extract use cases and requirements from data warehouse users. • Work with users to mock up dashboards and proof of concept data models. • Design dimensional data models that satisfy data requirements and address ease of use and performance. • Instantiate the dimensional data models on the Snowflake cloud platform. • Design and build out monitoring and support elements to ensure data quality and timeliness.EXPERIENCE: MUST HAVE: • Bachelor's degree in Computer Science, Information Systems. • Minimum of three years of experience implementing dimensional data models (star schemas). • Experience dimensional data modeling for data warehousing using star schemas or Snowflake schemas. • Deep experience with database optimizer paths and data warehouse performance features. • Experience with building data warehouses on cloud infrastructure preferred. • Experience with SNOWFLAKE • Work with users to mock up dashboards and proof of concept data models. • Instantiate the dimensional data models on the Snowflake cloud platform. • Job performed at a desk in front of a computer. • Requires heavy use of keyboard and mouse. • Requires sitting for long periods of time. • Casual work environment.EEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@apexsystemsinc.com or 844-463-6178.

Vacancy expired!


Related jobs

Report job