*Please send reply to mohan.ga...@somasoftsol.com * *-All our requirements are Direct client Requirements.* *-Please share the resumes only after you discuss with your consultant.* *-Resumes with Linkedin URL / 2 Professional references only will be processed.*
Senior Database Engineer 3-6 months contract San Ramon, CA Job Summary : The Sr. Database Engineer role is a combination of data warehouse developer and Business Intelligence (BI) developer. This individual is responsible for enhancing and maintaining a centralized data warehouse, as well as building and maintaining multi-dimensional cubes for decision support. Along with the data warehouse and data cube responsibilities, the Sr. Database Engineer is also responsible for developing reports that utilizes the data warehouse and/or multi-dimensional cubes . To accomplish these responsibilities, this individual must be able to deploy and maintaining data support tools, metadata inventories consisting of data definitions. The Sr. Database Engineer will work with multiple lines of business to understand their business objectives and provide solutions to help meet those objectives. She/he will design, implement and maintain BI solutions that include ETL integration, data warehouse design with star and/or snowflake schemas, complex relational and/or cube based interactive reports. The Sr. Database Engineer will be responsible for ensuring high levels of BI availability through operations support functions and in-depth testing. The Sr. Database Engineer is responsible for ensuring that the data warehouse and OLAP servers are operation ready. The Sr. Database Engineer will work closely with Project Managers and staff to interpret and document business and reporting requirements, propose/develop solutions, troubleshoot data warehouse or report performance issues, and assist with software evaluations and implementations. This position is expected to act with independent judgment and is to use self-initiative to make business decisions within the realm of their responsibilities. The Sr. Database Engineer is expected to participate in organizational quality improvement projects, and exhibit best practice quality work. Essential Job Functions: Keep up to date with OPO industry direction, guidance and requirements. AOPO, UNOS, CMS, FDA, AATB, EBAA and HIPAA. Devise, develop, and deploy required data queries in response to business user needs. Act as an advocate for BI benefits across the organization; promote BI usage to relevant departments. Keep up to date on developments and trends in the BI and data warehousing industry. Attend training seminars, conferences, and trade shows to broaden knowledge of current and future Business Intelligence issues and technologies. Will participate in audit events as needed. Strategy & Planning Create data mining architectures, coding standards, statistical reporting, and data analysis methodologies. In conjunction with data owners and department managers, develop data models and protocols for mining production databases. Assist in the development of data management policies and procedures to ensure the integrity and availability of databases and their accompanying software. Assess and cultivate long-term strategic goals for BI development in conjunction with project managers, department managers, staff and other stakeholders. Keep up to date on developments and trends in the BI and data warehousing industry and make strategic recommendations to management. Acquisition & Deployment Conduct research and make recommendations on data mining products, services, protocols, and standards in support of procurement and development efforts. Support the evaluation and selection of database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions. Operational Management Collaborate with project managers, department managers, end users, IT staff, and other stakeholders to integrate data mining applications with existing systems and ensure a tight fit between the BI environment and business requirements. Work with project managers to design end user reporting. Enhance and maintain the corporate data warehouse. Develop and maintain SSRS reports, dashboards and functions to meet business needs. Develop and maintain KPI business dashboards, graphs and portal interfaces. Design, build, test and revise SSAS reports as needed. Design and implement ETL systems for merging DONOR NETWORK WEST donor management and BI applications using MS-SQL Server Integration Services (SSIS). Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system. Perform database transaction and security audits. Implement user requirements for reports, forms, queries, and data extraction. Communicate schedule, updates and issues to BI requestors. Support the quality assurance/quality control process for client data. Design, code, test, and document all new or modified data mining systems, applications, and programs. Develop the semantic layer, metadata, reports, and report definitions. Develop, implement, and maintain change control and testing processes for modifications to databases. Develop and deliver standardized client reports to regulatory agencies on a consistent basis. Assist in the design of databases and data warehouses to ensure interoperability with BI solutions Provide and apply quality assurance best practices for data mining/analysis services across the organization. Create data definitions for new database file/table development and/or changes to existing ones. Determine required network components to ensure data access, as well as data consistency and integrity. Develop and deploy end-user best practices and tools for data extraction, queries, and data manipulation in accordance with business processes. Creating and delivering end-user training and documentation and providing second-line support to power users who develop reports for their departments Work with project management and development staff to coordinate the creation and management of data queries. Build, test and deploy reports Work with project managers to ensure that data entry, retrieval, change, and delete functions meet business requirements for project completion. Ensure effective protection and integrity of data assets. Design, install, monitor, maintain, and performance-tune production databases where required. Monitor data mining system details within the database, including stored procedures and execution time, and implement efficiency improvements. Respond to and resolve database access and performance issues. Assist in monthly data upload process to UNOS as needed. Perform data quality checks and corrections to National DSA Dashboard from UNET as needed. Perform data quality checks and uploads for AOPO monthly data reports as needed. Provide tier 2-3 help desk support as needed. Attend training seminars, conferences, and trade shows to broaden knowledge of current and future portal and business intelligence issues and technologies. Manage and/or provide guidance to junior members of the team. May be required to perform other duties as assigned. KNOWLEDGE, SKILLS AND ABILITIES : Strong understanding of data mining models, structures, theories, principles, and practices. Excellent knowledge with database design applications with focus on Microsoft Visual Studio. Strong knowledge of data modeling tools Experience with tier-one applications, databases, BI tools and data warehouses, such as Microsoft SQL Server 2008, SSAS, SSIS, SSRS, SharePoint, and others. Strong familiarity with data preparation, processing, classification, and forecasting. Direct experience with data management techniques. Strong knowledge of SQL, TSQL, ASP.NET and .NET language. Demonstrated ability with Microsoft ETL tools. Broad knowledge of reporting and query tools and practices. Experience with computer graphic and multimedia design. Experience with data processing flowcharting techniques. Ability to design, code and document data delivery specifications. Hands-on database tuning and troubleshooting experience. Ability to translate business needs into data analysis and reporting solutions. Project management experience. Strong understanding of the organizations goals and objectives. Knowledge of applicable data privacy practices and laws. Education and/or Experience : Education: The minimum qualifications for this position are A college diploma or university degree in the field of computer science. 7- 9 years of equivalent work experience may be substituted for education requirement. Experience: 9 years of direct work experience. Healthcare experience and statistical reporting background highly desirable. Certification/License: Microsoft Certified Professional Developer (MCPD) or Microsoft Certified Database Administrator (MCDBA), or Microsoft Certified Information Technology Professional with BI focus (MCITP) desired. Required experience: Minimum 5 years of Statistical Reporting, Data Warehouse Developing and/or Business Intelligence Developing Thanks & Regards, *Mohan Ganti* Mail: mohan.ga...@somasoftsol.com *Disclaimer: We respect your Online Privacy. This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact Information and a method to be removed from our mailing list. If you are not interested in receiving our emails then please reply with a "REMOVE" in the subject line and mention all the email addresses to be removed with any email addresses.* -- You received this message because you are subscribed to the Google Groups "SAP Workflow" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-workflow+unsubscr...@googlegroups.com. To post to this group, send email to sap-workflow@googlegroups.com. Visit this group at http://groups.google.com/group/sap-workflow. For more options, visit https://groups.google.com/d/optout.
