RSA Tech · 2 hours ago
Data Solutions Architect-W2
Jefferson City, MO
Contract
Onsite
Senior Level
$60/hr - $65/hrRSA Tech is seeking a Data Solutions Architect to lead the modernization of legacy data systems in the finance sector. The role involves designing, developing, and maintaining cloud-based data pipelines and solutions to enhance analytics and business intelligence capabilities.
AnalyticsInformation ServicesInformation Technology
Hiring Manager
Krish Gupta
Responsibilities
Provide technical leadership in modernizing legacy data ingestion, ETL/ELT, and databases to cloud technologies (AWS/Azure)
Implement data access, classification, and security patterns that comply with regulatory standards (PII, locational data, contractual obligations, etc.)
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 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
Qualification
Required
Experience in Finance Sector
Experience in designing and implementing data warehouse and analytics solutions (on-premise and cloud)
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
Experience with cloud data and cloud-native data lakes/warehouses. Microsoft Azure services (Fabric Lakehouse, ADF, Data Factory, Synapse, etc.)
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
Company
RSA Tech
RSA Tech is an information technology services and solutions company.
Founded in 2010
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase