Remote Data Warehouse

Job responsibilities: - Consolidate and optimize available data warehouse infrastructure - Ensure data is verified and quality-checked - Work on analytics and business intelligence platform for clients, including internal and third-party clients - Design and implement ETL procedures to intake data from both internal and external sources - Design and implement ETL processes and data architecture - Collaborate with key stakeholders to finalize data warehouse architecture development and utilization - Conduct database performance monitoring, tuning, and analysis - Assist in data mart, meta data, and data model designs and extension - Ensure data warehouse architecture code maintenance within a version control system Job requirements: - Bachelor’s/Master’s degree in Engineering, Computer Science, IT (or equivalent experience) - At least 3+ years of experience in data warehouse architecture development and management (rare exceptions for highly skilled developers) - Profound experience with technologies like SQL Server, and also SSIS and stored procedures - Proficient in developing codes, testing for quality assurance, administering RDBMS, and monitoring of database - Expertise in highly efficient dimensional modeling techniques and their applications - Proven working experience with Tableau, SportFire, TIBCO, QlikView, MicroStrategy, Information Builders, and other reporting and analytical tools - Strong knowledge of SAS and R programming language - Good understanding of Hadoop, Impala, Pig, Hive, YARN, and other Big Data technologies - Fluency in English language for effective communication - Ability to work full-time (40 hours/week) with a 4 hour overlap with US time zones