Urgent Requirement || MDM Architect || St.Louis, MO || Contract

Job Designation : MDM Architect Job Location : St.Louis, MO Job Type : Contract USG direct client is looking for MDM Architect at St.Louis, MO. Please share your updated resume to Prince at princelamba@usgrpinc.com OR feel free to contact me at 6144959222 ext: 510. Job Description: Role name Developer Role Description Experience with the creation of Data Warehousing datamarts, ETL transformations, and tabular / cube structure. •Ability...

Job Designation : MDM Architect

Job Location : St.Louis, MO

Job Type : Contract

USG direct client is looking for MDM Architect at St.Louis, MO.

Please share your updated resume to Prince at princelamba@usgrpinc.com OR feel free to contact me at 6144959222 ext: 510.

Job Description:

Role name Developer

Role Description

Experience with the creation of Data Warehousing datamarts, ETL transformations, and tabular / cube structure.

•Ability to install, maintain and upgrade Microsoft SQL Server.

•Ability to back up, recover, reorganize, and monitor performance and utilization of multiple types of databases, database structures, and DBMS.

•Disseminate information regarding tools, reports, or metadata enhancements.

•Conduct or coordinate tests to ensure that intelligence is consistent with defined needs.

•Synthesize current business intelligence or trend data to support recommendations for action.

•Maintain or update business intelligence tools, databases, dashboards, systems, or methods.

•Manage timely flow of business intelligence information to users.

•Identify and analyze industry or geographic trends with business strategy implications.

•Maintain library of model documents, templates, or other reusable knowledge assets.

•Create or review technical design documentation to ensure the accurate development of reporting solutions.

•Communicate with customers, competitors, suppliers, professional organizations, or others to stay abreast of industry or business trends.

•Document specifications for business intelligence or information technology (IT) reports, dashboards, or other outputs.

•Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs.

Generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.

Competencies Microsoft SQL Server 2012 Business Intelligence

Experience (Years) 10 & Above

Essential Skills Microsoft MDM Architect [MDM skill is mandatory]

This position is responsible for design and maintenance of datawarehousing structures,data management, various datamarts, business rules, various reports, dashboards, scoreboards, and other solutions to fulfill business intelligence requests.

The Data Warehouse Architect will work closely with different department leaders to design, develop and support business intelligence reports, scorecards, data structures, and dashboards..

Database Analyst:

1. Consulting with internal and external clients to model complex data structures.

2. Develop and maintain the database architecture

3. Develop and maintain the appropriate operational documentation for databases Plan and execute data conversions, data structures and migrations Business Intelligence Analyst:

4. Develop complex reporting information and present results to management and customer.

5. Utilize, update and manage BI tools such as SQL, SSRS, Power BI, Business Analytics

6. Ensure the accuracy, performance and consistency of the database information

7. Oversee database capacity planning, forecasting, and tuning Manage database security and control access permissions and privileges Performance Management:

8. Perform health checks to ensure the integrity of the schema and the data

9. Perform health checks to ensure the synchronization of database replicas 10. Liaise with  applications, and infrastructure teams to resolve complex application performance analysis

•Apply knowledge of Microsoft SQL server, supporting operating systems, transaction managers, database tools, utilities, gateways, and middleware to sustain operations.

•Knowledge of information technology topics (distributed data architecture and databases, data replication and warehousing, information access methods, distributed database design and connectivity, performance monitoring and tuning, operating system administration, and database operations, procedural languages, etc.).

Thanks,

Prince Lamba

United Software Group Inc..

565 Metro Place S. Suite # 110

Dublin, OH 43017

Phone: 6144959222 EXT 510

Fax: 1-866-764-114

princelamba@usgrpinc.com