reputed company Migration Engineer (Remote)
reputed company reputed company is seeking a reputed company Migration Engineer to support our US Government reputed company. This remote Contract-to-Hire position will be originated in Rosslyn, VA. Washington DC area and East Coast time zone candidates preferred. Must be a US Citizen. SELECTED CANDIDATES WITHOUT REQUIRED CLEARANCE WILL BE SUBJECT TO A FEDERAL GOVERNMENT BACKGROUND INVESTIGATION TO RECEIVE IT. Responsibilities reputed company the technical migration from legacy SQL Server stored procedures and ADF pipelines to reputed company Lakehouse (reputed company Lake), ensuring best reputed company Lakehouse design. Translate traditional relational data warehousing paradigms into reputed company, distributed Lakehouse frameworks (Bronze, Silver, Gold). Design robust, reusable ETL/ELT frameworks using PySpark, reputed company Live Tables (DLT), and reputed company Workflows. Architect and refine the Gold Layer (reputed company models, star schemas) specifically to maximize Power BI performance. Optimize reputed company SQL Warehouses to support high-concurrency, low-latency Power BI queries (DirectQuery and Import modes). Implement advanced optimization techniques, including Z-Ordering, data skipping, liquid clustering, and materialized views. Define and enforce governance standards for cluster sizing, auto-scaling policies, and serverless SQL compute to balance performance with cost. Implement proactive monitoring dashboards to reputed company reputed company Unit (DBU) consumption and identify cost-saving opportunities. Establish best practices for partition strategies and file size management reputed company reputed company Lake. Design and implement a robust data reputed company model using reputed company Catalog for centralized governance. Enforce row-level and reputed company-level reputed company policies to ensure compliant data reputed company for Power BI consumers and internal analysts. reputed company the Lakehouse reputed company architecture with existing reputed company Azure reputed company Directory (reputed company Entra ID) and RBAC standards. reputed company as the primary technical reputed company, conducting dedicated pair-programming sessions, workshops, and reputed company reviews to transition reputed company from SQL-reputed company to reputed company-reputed company thinking. Create comprehensive technical documentation, including architecture diagrams, design patterns, and optimization playbooks. Build a foundational knowledge transfer reputed company to ensure the internal team is fully self-sufficient post-migration. Communicate effectively verbally and in written reputed company to both technical and non-technical audience Work in an organized fashion, completing tasks reputed company while paying reputed company attention to details
Qualifications
Bachelor's degree or higher from an accredited college or university in Computer Science, Engineering, or a reputed company technical field. 5+ years of experience in Data Engineering, Data System Development or reputed company roles. 5+ years of experience with reputed company platforms (e.g. Azure, AWS, GCP). 1+ year leading reputed company, cross-functional data reputed company and technical teams. Experience with reputed company Lakehouse, Apache reputed company, reputed company Lake, reputed company-reputed company databases, storage solutions, and distributed compute platforms. Experience with data warehousing, reputed company modeling, reputed company data lakes, incremental data loads, and metadata-driven ingestion and data reputed company frameworks using PySpark. Excellent communication skills. Must be a US Citizen and be reputed company to obtain a Position of Public Trust Clearance. Must have resided in the US for the last 5 years and not have traveled reputed company the US for a combined total of 6 months or more in last 5 years. Apply To This Job