Role: Data Solution Architect Location: Jefferson City, MO – Onsite
Contract-to-Hire (9 months contract) Only GC/ USC Must have Previous experience in banking sector. Must be in recent projects. Primary Skills: Azure Fabric, Azure Data Factory (ADF), Azure Synapse Data Solution Architect The ideal candidate will have a deep understanding of Microsoft data services, including Azure Fabric, Azure Data Factory (ADF), Azure Synapse, and ETL/ELT processes. This role focuses on designing, developing, and maintaining cloud-based data pipelines and solutions to drive our analytics and business intelligence capabilities. Key Responsibilities: * Provide technical leadership in modernizing legacy data ingestion, ETL/ELT, and databases to cloud technologies (AWS/Azure). * Demonstrate a self-driven, ownership mindset to navigate ambiguity, resolve constraints, and mitigate risks with minimal supervision. * Implement data access, classification, and security patterns that comply with regulatory standards (PII, locational data, contractual obligations, etc.). * Build strong relationships with technical teams through effective communication, presentation, and collaboration skills. * Collaborate with stakeholders, business analysts, and SMEs to translate business requirements into scalable solutions. * Integrate data from multiple sources into cloud-based architectures, collaborating with cross-functional teams. * Work closely with data scientists, analysts, and stakeholders to meet data requirements with high-quality solutions. * Function within a matrixed team environment, sharing responsibilities across various teams. * Perform data profiling and analysis on both structured and unstructured data. * Design and map ETL/ELT pipelines for new or modified data streams, ensuring integration into on-prem or cloud-based data storage. * Automate, validate and maintain ETL/ELT processes using technologies such as MS Fabric, Databricks, ADF, SSIS, Spark, Python, and Scala. * Proactively identify design, scope, or development issues and provide recommendations for improvement. * Conduct unit, system, and integration testing for ETL/ELT solutions, ensuring defects are resolved. * Create detailed documentation for data processes, architectures, and workflows. * Monitor and optimize the performance of data pipelines and databases. Required Skills and Qualifications: * 4+ years of experience in designing and implementing data warehouse and analytics solutions (on-premise and cloud). * 3+ years of expertise in data warehousing concepts (ETL/ELT, data quality management, privacy/security, MDM) with hands-on experience using ADF, Data Factory, SSIS, and related tools. * 3+ years of experience with cloud data and cloud-native data lakes/warehouses. Microsoft Azure services (Fabric Lakehouse, ADF, Data Factory, Synapse, etc.). * 2+ years of experience in Python, Scala, or Java for use with distributed processing and analytics, such as Spark. * Familiarity with CI/CD practices and tools such as Azure DevOps, Git, or Jenkins. Please fill all the details its mandatory: Candidate Details Full Legal Name (As per SSN) Email ID Contact Number & Alternate Number Best way for communication & Best Time to Reach Current Location Relocation Visa Status & Validity Salary/Rate Current Project Status Interview Availability Joining Availability LinkedIn Profile Employer Details When did you enter in US and on what Visa? Last 4 Digit of SSN Month/Date (DOB) Highest Degree (University, Stream & Year of Passing) Bachelor (University, Stream & Year of Passing) Any Vacation Plan Any offer or Interview in Pipeline Thanks & Regards Raj Malhotraa Technical Recruiter E: [email protected]<mailto:[email protected]> P: +1 (508)-471-5167, +1 (989)-218-5282 (WhatsApp Number) A: 20 Dunia Lane, Northborough, MA, 01532 W: https://www.simplisoftwaresolutions.com/ L: https://www.linkedin.com/in/raj-malhotraa-371130238/ USA / Canada / Europe / England / India -- You received this message because you are subscribed to the Google Groups "Powerbuilder Assignments" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/powerbuilder-assignments/BYAPR10MB283858C09EBB01C1C22E4061C696A%40BYAPR10MB2838.namprd10.prod.outlook.com.
