Data Architect
At a glance
Mid-level Data Architecture & Governance role at USM. Windsor · no salary stated · we estimate $97,988–$155,000 across the United States.
USM has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Turn data strategy into project designs and models that follow the enterprise conceptual model
- Work with project teams to plan complete data solutions for complex initiatives
- Keep designs consistent with data mart and management roadmaps across business lines
- Establish architecture guidance, contribute to tool and governance standards, and maintain metadata records
- Review project models, gauge data complexity, and mentor teams building data, ETL, and BI solutions
What you bring
- At least ten years in data management, modeling, data analysis, or reporting
- Strong command of Star, Snowflake, and 3NF modeling, along with warehouse and data mart practices
- Practical use of ERwin or ER Studio, relational databases, and ETL platforms
- A computer science bachelor's degree is preferred
Who this fits
This is a mid-level role based onsite in Windsor, Connecticut. It suits someone comfortable working across project teams and locations, presenting data strategy to business and IT leaders, and mentoring project colleagues.
From the employer
USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.
Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.
Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps.
USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area – Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.
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.
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.