Hi Partner. *Location*:- Omaha,NE.
*Main *skills is SSAS with CUBE, ETL,SSMS, TSQL, SSIS, SSRS, Business Objects, Crystal Reports, Excel, SAS experience * POSITION SUMMARY:* Design, develop, and maintain the corporate data, enterprise data warehouse and business intelligence solutions within our clients system. Deliver timely, accurate and actionable data critical to the business decision-making process. Facilitate the identification, analysis, development, manipulation and reporting of company data and information to gain knowledge of the factors that affect overall company performance. Provide continuous improvement efforts to enhance data transformation and manipulation performance while providing increased functionality and support to production information systems based on the business needs. *DUTIES AND RESPONSIBILITIES:* Essential functions of the position include, but are not limited to: 1. Work in a highly collaborative team environment following the Agile methodology to assist other department personnel in the successful accomplishment of strategic and divisional objectives.Take the necessary steps to ensure our customers' needs are met to the maximum extent possible in an accurate and timely manner.Lead and collaborate in the data management efforts including operational data support to provide a high level of data integrity, security and availability for internal and external customers. 2. Establish and maintain a scalable, extensible and maintainable architecture for the enterprise data warehouse and business intelligence system. Summarize enterprise data into an intuitive analysis framework for understanding the current and future performance of the company. Provide the design, development, testing and maintenance of ETL processes, reporting and dashboards to support Association strategic objectives. 3. Collaborate with Risk Management and other business unit leaders for various projects involving enterprise data. Ensure the appropriate capture and retention of enterprise data. Work with Business Analysts to translate various business needs into warehousing, analytics, reporting, and dash-boarding requirements. Educate other business units and Information Technology teams about the analytics and reporting advantages available to them through Business Intelligence. 4. Provide expertise to achieve system integration through database design, including data and dimensional modeling, logical and physical table design, complex queries, stored procedures and triggers, data transformation, aggregation and enterprise application integration. Develop and implement data warehouse and business intelligence standards and best practices.Mentor, support and provide direction to lesser experienced teammates. 5. Support the analytical needs of business units by researching and analyzing data from various sources, and incorporate data into existing processes and systems as needed by using expert level understanding of how data, technology and credit processes work together to serve our customers. 6. Conduct analysis on datasets, including efficient extraction, manipulation, and analysis of complex datasets. Analyze data and information in innovative ways to assist with strategic decisions, balance portfolio risk, and optimize process efficiencies. Ensure all necessary data elements are available for model building and strategy analysis. 7. Research emerging technologies, trends and benchmark data to make recommendations to improve customer experience, architecture, processes and tools. Additional functions of the position may include: 1. Performs other related duties as assigned. * JOB SPECIFICATIONS:* Bachelor’s degree in Computer Science, MIS, Statistics, Finance or equivalent training and experience required. Ideal candidate will have a minimum of two years of experience in data warehouse and/or business intelligence development, or comparable IT field. * Duties require:* * Strong computer literacy and proficiency in data manipulation and reporting tools which may include: SSMS, TSQL, SSIS, SSRS, Business Objects, Crystal Reports, Excel, SAS * Ability to work effectively in a collaborative team environment and effectively demonstrate team building attitude and skills * Basic knowledge of database design and data warehouse development including replication, staging, ETL, stored procedures, triggers, scheduling tools and data marts * Familiar with a variety of industry standards regarding Microsoft database development concepts, best practices, and procedures * Basic analytical, data mining, data modeling and data management skills, and ability to utilize data to drive strategic business decisions * Proficient in the latest Windows environment using the most recent versions of Microsoft Office and SharePoint * Database and report development experience with Visual Studio, Excel Services, PerformancePoint, PowerView and ER/Studio a plus * Ability to provide sound technical advice to leadership and other staff in the subject field(s) related to this position * Willing to be flexible and perform a variety of roles such as analyst, tester, and mentor * Experienced with providing users access to data by building reports and queries using various data querying tools * Strong collaboration, interpersonal, relationship and project management skills * Ability to analyze, evaluate, and develop solutions to complex problems * Excellent presentation and writing skills * Ability to interpret policy, programs, and regulations Ideal candidate will have a minimum of five years of experience in data warehouse and/or business intelligence development, or comparable IT field. Experience in architecting large scale data warehouse. Microsoft MCDBA certification, CBIP or other data warehouse certification, MBA or Master Degree in related field is preferred. * Duties require:* * Strong computer literacy and proficiency in data manipulation and reporting tools with demonstrated highly skilled knowledge of SSMS, TSQL, SSAS, SSIS, SSRS, Excel and PowerPivot * Ability to work effectively in a collaborative team environment and effectively demonstrate team building attitude and skills * High level of proficiency with database and data warehouse development including replication, staging, ETL, stored procedures, partitioning, change data capture, triggers, scheduling tools, cubes and data marts * Experience with a variety of industry standards regarding Microsoft database development concepts, best practices, and procedures * Strong analytical, data mining, data modeling and data management skills, and ability to utilize data to drive strategic business decisions * Proficient in the latest Windows environment using the most recent versions of Microsoft Office and SharePoint * Database and report development experience with Visual Studio, Excel Services, PerformancePoint, PowerView and ER/Studio. * Experience providing sound technical advice to leadership and other staff in the subject field(s) related to this position * Demonstrated ability to be flexible and perform a variety of roles such as analyst, tester, and mentor * Advanced experience with providing users access to data by building reports and queries using various data querying tools * Strong collaboration, interpersonal, relationship and project management skills * Leadership and judgment to analyze, evaluate, and develop solutions to complex problems * Ability to interpret policy, programs, and regulations Excellent oral, written and presentation skills *Swami.* * It Pros Of Nebraska Inc,* * [email protected] <[email protected]>.* -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.
