JD :: Data Solution Architect :: Jefferson City, MO – Onsite

[Raj Malhotra]

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: ra...@simplisoftwaresolutions.com

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