Data Warehouse Engineer - REMOTE

This position is for a defense/ military contractor so they need a US Person (Green Card or US Citizens) for this role. We do not do Corp to Corp for this position We need somebody who has Redshift experince for this role. Pay Range: $70 - 73/hr Job Description Sr. Data Warehouse Programmer Analyst The successful candidate will be a part of the team that is responsible for Enterprise Data Warehouse. This position requires the candidate understands and applies technical standards, principles, theories, concepts, techniques and provides solutions to a variety of technical problems of moderate to high scope and complexity. • The candidate develops deep knowledge and understanding of the data warehouse and data management assets available within our data platforms and act as the subject matter expert on the data and its utility for operational use. • The candidate will regularly interact with the customers, data management teammates, and product development partners, your expertise in large volume data in data lakes, data warehouses, or data marts using structured, semi-structured, and unstructured formats - will deliver on the client's Data and Analytics organization’s mission to enable data-driven decisions within any action. • The candidate will follow established procedures, and contribute to the completion of milestones associated with specific projects and keep up-to-date with the technology shifts through training and development. Skills Required: • Working knowledge of cloud-based data warehouse RedShift is a must have.. • Strong experience working with ETL/ELT concepts of data integration, consolidation, enrichment, and aggregation in large volume data sets. • Expert in SQL and/or SQL-based languages and performance tuning of SQL queries. • Working knowledge of Data Pipelines, stream processing and highly scalable ‘big data’ data stores. • Experience with various data storage technologies - e.g. RDBMS (Oracle, SQL Server, etc.), columnar, tabular, document store, NoSQL • Bachelor’s Degree in Computer Science, Information Systems or similar • 7+ years of experience • Strong understanding of Normalized/Dimensional model disciplines and similar data warehousing techniques. • Expert knowledge of AWS Redshift database. • • Experience with various data storage technologies - e.g. RDBMS (Oracle, SQL Server, etc.), columnar, tabular, document store, NoSQL • Experience with various ETL/ ETL tools – e.g. ODI, SSIS, Informatica Power Center, Talend, IICS, etc. • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. • Collaborate with business users on normalizing and aggregating large data sets based on business needs and requirements. • Data validation skills to verify data integrity, understand discrepancies and resolve them with the highest sense of urgency. • Demonstrated ability to share findings with non-technical or business stakeholders. • Familiarity with Analytical/Reporting Solutions like Tableau, Power BI is a plus • Virtual team collaboration tools such as WebEx, Zoom etc. • Experience with developing detailed migration plans, including data profiling, source/target mapping, transformation, data validation, deployment, data load and rollback strategies. • Create documentation covering all aspects of migration projects, including technical design, architecture diagrams, configurations, data lineage, migration procedures. • Experience working and leading large scale data migration projects ensuring clarity, accuracy, completeness and alignment with project objectives and compliance requirements. • Excellent written, verbal communication and Interpersonal skills • Excellent problem-solving skills