Data Warehousing Architect with H1B

Job Description :The Data Architect job is actually to make sure that the company worth of it treatments and of enterprise information is maximized by using awareness of the company requires opportunities, the business processes, the current profile of it uses, as well as the present and emerging technology as well as IT service abilities, but many of all the, the particular information used by all these. They support as well as allow the execution of the technique as well as plans for the profile of uses. The person within this position is actually responsible for the delivery, assurance, and consultancy for that Data Architecture in selected business segments, and for preparation, steering and coordinating some materials which are necessary to do it. The Data Architect is going to be enthusiastic about data-driven info that will guide as well as influence critical business choices. This particular job will partner with inner customers to understand business inquiries, drive needs, propose answers and provide multiple cross-functional tasks as well as integrations between systems that are different.  Crucial Skillsets Harsh theoretical as well as practical details modeling abilities. Confidence translating and communicating information-driven insights as well as specialized ideas into straightforward terminology for internet business clients of different levels Enthusiastic about determining solving issues for clients as well as the capability to uncover company requires through strong interaction and qualitative and quantitative study to explain powerful solutions Certified growth experience with and understanding of relational databases as well as enterprise data warehouses, which includes work with MySQL, SQL Server, Oracle, and any other typical RDBMS Experience with great data technology (Hadoop, MapReduce, Apache Spark, etc.) The expertise of best methods as well as concepts for information modeling, as well as data mining Strong project management skills; capability to prioritize as well as control customer expectations throughout several projects Excellent written and verbal communication skills The effective candidate should be a self-starter, be in a position to work independently but be also a great contributor to a several teams Attention to detail, and ability to recognize problems    Responsibilities and role   Under limited supervision and far decision-making: Identifies, quantifies, and proposes answers to deal with information integrity as well as information quality problems, such as performing supply data analysis as well as information profiling to evaluate first details quality Responsible for discovering, developing, and using Master Data Management (MDM), Operational Data Stores (ODS), and Data Warehouse (DWH) data shops Grows as well as enhances worldwide details design concepts to guarantee an information alignment as well as connectivity across domains Applies Information Architecture Methodology and ensuring alignment of Data Architecture with Enterprise Architecture as well as business strategies Make suggestions regarding information collection techniques, data management, information definitions, and evaluation techniques in cooperation with inner stakeholders Help set up as well as explain validation, information cleansing, integration, and transformation practices Facilitate reporting as well as for analytics design assessment sessions Stay current with contemporary technology trends/concepts and function as an SME for the industry teams Handle bugs and issues to the causing tracking/ assistance systems; liaise with external and internal assets to facilitate closure and resolution Develops information designs (from information capture, via transformation, to visualization) needed to meet company task requirements Facilitates sustainment and upcoming create opportunities Provide expertise as well as architectural consulting of the areas of Data Governance, Master Data Management, Analytics, Data Warehousing, Scorecards, Dashboards, Business Performance Monitoring as well as Data Mining Provide technical and functional subject matter knowledge in different information management, warehousing, Big Data, and business intelligence strategies. Knowledge/Experience on producing all charts which are present on Spotfire (scatter, line, bar, combo, pie, etc.) and the way to adjust every property related to visualization (trellis, color, shape, sizing, etc.). Expertise in writing effective SQL queries, sights in relational databases like MS SQL Server as well as Oracle. Ability to integrate several data sources into one Spotfire DXP and also have the info linked through information table relations. Expertise in pc user training, resolving daily problems as well as coordination with TIBCO specialized support Create customized SQL to query complicated details types in the best way for the database as well as the application servers Provides performance tuning, improvement, balancing, automation and usability as needed. Evaluate as well as determine brand new systems for setup. Works with management on scope definition, estimation of job effort, and job breakdown Able to work independently with little supervision along with working inside a team atmosphere, based on existing job responsibilities. In a position to recognize as well as problem solves in an effective and efficient fashion. Execute in a quick pace delivery function as well as the target for supplying duties to satisfy the item release goal Qualifications Legal authorization to operate in the US on a full-time schedule for anybody apart from current employer Bachelor&39;s degree in a STEM discipline or even 10+ years of equivalent knowledge or even work experience Ten years of experience a multi-disciplined IT earth designing, maintaining, developing, and optimizing database as well as information warehouse answers with the Microsoft technologies stack 3+ years of expertise in the economic industry Full experience with Data Modeling and Database Design like Development, ETL Design, Database Support, Database Management, Data Security, and data Maintenance, and Technical Presentation Skills Requires hands-on with SQL Server 2012+ and SQL Server Integration Services Strong analytical and communication skills Experience with System Architect is actually a plus Working expertise of Insurance Industry or any other financial services preferred