Data Architect

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

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.