# Data Architect — USM Business Systems

- Location: Windsor, CT
- Posted: Jun 23, 2016
- Status: open (checked Nov 21, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/usm2/93694103
- Employer record: https://visajobs.io/company/usm-business-sytems.md

## Sponsorship history
- Tier: Some history
- Occupation (SOC): Database Architects (15-1243)
- Employer's certified LCAs for this occupation in CT, FY2024–FY2026: 0
- …in the whole US: 1
- With this exact title: 0
- Median DOL prevailing wage, level I / II: $97k / $119k
- Staffing / consulting firm: 97% of its H-1B applications place workers at client sites (FY2024–FY2026)

## Description
Job Description
Job Title: Data Architect
Duration: 6+ months
Location: Windsor, CT
Rate $55 – 60/hr on C2C or 1099 and $53/hr on W2 without benefits
Consultant need to work on USM W2
Job description:
Responsibilities:
· ​Support data strategy work and deliver designs & data models that enable our project.
· Design data solutions for complex projects.
· Collaborate with project teams to design end-to-end data solutions.
· Deliver data models supporting design conforming to an enterprise conceptual model.
· Align solutions to roadmaps for existing data mart and data management solutions across multiple business lines.
· Contribute to data strategies for the migration of legacy applications.
· Develop data reference architecture and promote those standards across the organization.
· Contribute to data tool standards and governance processes.
· Assist with evaluating data complexity for projects during project initiation.
· Assist with reviewing data designs, data models for projects during architectural review meetings.
· Maintenance of data dictionary and/or metadata repositories.
· Mentor project team members in the development of complex data/ETL/BI solutions.
· Partner with other data architects to influence and support data needs.
· Present and socialize data strategy with business and IT leaders
​
REQUIRED:
· Bachelor’s degree in Computer Science preferred.
· 10+ years’ experience in the area of data management, modeling, data analysis, and/or reporting.
· Strong technical documentation and technical writing skills.
· Prior experience with financial services, retirement, insurance, or medical records industry highly desirable.
· Expertise with Star, Snowflake, and 3NF data modeling techniques as well as data warehousing & data mart principles and methodologies.
· Hands on expertise with data modeling tools such as ERwin or Embarcadero ER Studio.
· Hands on experience working with relational databases such as Oracle, SQL Server, DB2, Sybase.
· Hands on experience working with ETL tools such as Informatica or SSIS.
· Familiarity with master data management tools and concepts.
· Familiarity with industry standard models like ACORD or IIA.
· Hands on experience with designing and modeling ODS/Warehouses.
· Expertise on dimensional modeling and slowing changing dimensions.
· Familiarity with BI tools like Business Objects, OBIEE, etc.
· Knowledge of Big Data technologies a plus.
· Ability to collaborate in a multi-site matrixed work environment.
· Proficient with enterprise architecture and data architecture concepts.
· Eagerness to learn new tools and technologies.
· Experience working in an agile or continuous improvement environment.
· Eagerness to learn new tools and technologies
Thanks & Regards
Mahesh Gunnam
USM Systems Inc.
703-880-4184
Additional Information
If my requirement matches your resume, then please do reply on my email id gmahesh@usmsystems(dot)com or can directly call me at 703-880-4184.

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
