Prutech Solutions
Get AI-powered advice on this job and more exclusive features.
PruTech Solutions is a technology and consulting firm that provides innovative IT solutions and professional services to government and commercial clients. With over 25 years of experience, we specialize in digital transformation, cloud services, data analytics, cybersecurity, and IT staffing. Our mission is to help clients achieve operational excellence through secure, scalable, and cutting-edge technologies.
Position Overview:
PruTech Solutions is seeking an experienced
Data Architect
to support a major
government agency client
in modernizing legacy data systems. This role will focus on transitioning from a mainframe-based Model 204 (M204) environment to modern SQL-based platforms within a
hybrid architecture leveraging Microsoft Azure and SQL Server . The ideal candidate will have deep experience in
data modeling, data migration, reporting frameworks , and
modernization of legacy systems . Key Responsibilities: Lead data architecture and modeling activities for enterprise-wide modernization projects. Design scalable, secure, and optimized database solutions in hybrid environments (on-prem SQL and Azure SQL). Manage and guide the
transition from M204 mainframe systems
to SQL-based relational databases. Oversee end-to-end data migration strategy, including extraction, transformation, and loading (ETL) processes. Collaborate with business stakeholders and technical teams to define data requirements and reporting needs. Ensure data integrity, performance tuning, and compliance with government data standards and security policies. Develop data governance practices and support metadata management. Provide guidance on analytics and reporting frameworks to enable business intelligence capabilities. Participate in architecture reviews and present recommendations to government IT leadership. Required Qualifications: 8+ years of experience as a Data Architect or Data Engineer. Proven experience with
Model 204 (M204)
or similar mainframe database systems. Strong hands-on expertise with
SQL Server ,
Azure SQL , and other relational database technologies. Experience architecting and implementing solutions in
hybrid cloud environments (Azure/on-premises) . In-depth knowledge of
data modeling tools , ER diagrams, and database normalization techniques. Experience in large-scale
data migration
projects and associated risk mitigation strategies. Understanding of
reporting tools
and frameworks such as Power BI, SSRS, or similar. Familiarity with
government IT projects , compliance, and data privacy standards. Strong communication and stakeholder engagement skills. Preferred Qualifications: Azure Data Architect certification or equivalent cloud certifications. Experience with data warehousing and analytics platforms. Background in working with public sector or government agencies. Knowledge of ETL tools such as Azure Data Factory, SSIS, or Informatica. Competitive salary and performance-based bonuses Comprehensive health, dental, and vision coverage 401(k) with company match Paid time off and holidays Flexible work environment Opportunity to work on mission-critical public sector modernization projects All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin. Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
IT Services and IT Consulting Referrals increase your chances of interviewing at PruTech Solutions, Inc. by 2x Inferred from the description for this job
Medical insurance Vision insurance 401(k) Get notified when a new job is posted. Sign in to set job alerts for Data Architect roles.
Technical Data Architect at New York, NY / Tampa, FL - Onsite - Fulltime
Danbury, CT $130,000.00-$150,000.00 1 week ago New York, NY $175,000.00-$215,000.00 2 weeks ago New York City Metropolitan Area 1 week ago New York, NY $150,000.00-$200,000.00 3 months ago Jersey City, NJ $124,000.00-$171,000.00 1 month ago Jersey City, NJ $131,000.00-$171,000.00 1 month ago New York, NY $185,000.00-$210,000.00 5 days ago United States $150,000.00-$230,000.00 5 days ago New York, NY $176,720.00-$265,080.00 1 week ago Senior Data Analyst, LUS Revenue Reporting
New York, NY $128,000.00-$160,000.00 6 days ago Senior Data Architect - to 230k + bonus!
New York, NY $210,000.00-$230,000.00 3 weeks ago Stamford, CT $165,000.00-$180,000.00 2 weeks ago Solutions Architect, Enterprise (New York City)
New York, NY $162,000.00-$196,000.00 5 days ago New York City Metropolitan Area 2 weeks ago Edison, NJ $75,000.00-$165,000.00 4 days ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Data Architect
to support a major
government agency client
in modernizing legacy data systems. This role will focus on transitioning from a mainframe-based Model 204 (M204) environment to modern SQL-based platforms within a
hybrid architecture leveraging Microsoft Azure and SQL Server . The ideal candidate will have deep experience in
data modeling, data migration, reporting frameworks , and
modernization of legacy systems . Key Responsibilities: Lead data architecture and modeling activities for enterprise-wide modernization projects. Design scalable, secure, and optimized database solutions in hybrid environments (on-prem SQL and Azure SQL). Manage and guide the
transition from M204 mainframe systems
to SQL-based relational databases. Oversee end-to-end data migration strategy, including extraction, transformation, and loading (ETL) processes. Collaborate with business stakeholders and technical teams to define data requirements and reporting needs. Ensure data integrity, performance tuning, and compliance with government data standards and security policies. Develop data governance practices and support metadata management. Provide guidance on analytics and reporting frameworks to enable business intelligence capabilities. Participate in architecture reviews and present recommendations to government IT leadership. Required Qualifications: 8+ years of experience as a Data Architect or Data Engineer. Proven experience with
Model 204 (M204)
or similar mainframe database systems. Strong hands-on expertise with
SQL Server ,
Azure SQL , and other relational database technologies. Experience architecting and implementing solutions in
hybrid cloud environments (Azure/on-premises) . In-depth knowledge of
data modeling tools , ER diagrams, and database normalization techniques. Experience in large-scale
data migration
projects and associated risk mitigation strategies. Understanding of
reporting tools
and frameworks such as Power BI, SSRS, or similar. Familiarity with
government IT projects , compliance, and data privacy standards. Strong communication and stakeholder engagement skills. Preferred Qualifications: Azure Data Architect certification or equivalent cloud certifications. Experience with data warehousing and analytics platforms. Background in working with public sector or government agencies. Knowledge of ETL tools such as Azure Data Factory, SSIS, or Informatica. Competitive salary and performance-based bonuses Comprehensive health, dental, and vision coverage 401(k) with company match Paid time off and holidays Flexible work environment Opportunity to work on mission-critical public sector modernization projects All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin. Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
IT Services and IT Consulting Referrals increase your chances of interviewing at PruTech Solutions, Inc. by 2x Inferred from the description for this job
Medical insurance Vision insurance 401(k) Get notified when a new job is posted. Sign in to set job alerts for Data Architect roles.
Technical Data Architect at New York, NY / Tampa, FL - Onsite - Fulltime
Danbury, CT $130,000.00-$150,000.00 1 week ago New York, NY $175,000.00-$215,000.00 2 weeks ago New York City Metropolitan Area 1 week ago New York, NY $150,000.00-$200,000.00 3 months ago Jersey City, NJ $124,000.00-$171,000.00 1 month ago Jersey City, NJ $131,000.00-$171,000.00 1 month ago New York, NY $185,000.00-$210,000.00 5 days ago United States $150,000.00-$230,000.00 5 days ago New York, NY $176,720.00-$265,080.00 1 week ago Senior Data Analyst, LUS Revenue Reporting
New York, NY $128,000.00-$160,000.00 6 days ago Senior Data Architect - to 230k + bonus!
New York, NY $210,000.00-$230,000.00 3 weeks ago Stamford, CT $165,000.00-$180,000.00 2 weeks ago Solutions Architect, Enterprise (New York City)
New York, NY $162,000.00-$196,000.00 5 days ago New York City Metropolitan Area 2 weeks ago Edison, NJ $75,000.00-$165,000.00 4 days ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr