Job Description :
Microsoft MDM Architect
Location : St Luis MO
Duration : 12 + Months

Competencies : Microsoft SQL Server 2012 Business Intelligence

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.

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.