Business Intel Technical Lead III

Job Opportunity Candidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI).Job Description:DOT is looking for a candidate that can help us build our Next Generation Data Lake, Data Warehouse & BI practice, by implementing best practice design, architecture, and development methodologies.Responsibilities:The candidate will lead design, including data design, database architecture, metadata, ETL design, reporting & dashboard design, development, testing, implementation and maintenance of data warehouse and data integration initiatives.Develop ETL templates, standards, processes & procedures for loading information into Data Lake & Data Warehousing systems and for ensuring reliability of information loaded.Seek continuous improvement in performance & tuning and ensure security of data. Lead Data Lake, Data Warehouse, BI, Cloud software & tools evaluations and implement solutions.Assist with PowerCenter and other Informatica suite tool implementations and upgrades.Recognized as advanced individual contributor.Subject matter expert with additional experience and/or education in field.Conducts highly complex work critical to the organization.Works with other IT technical teams and Business users to understand requirements and recommend & implement end-to-end solutions.Works without supervision with extensive latitude for independent judgment.Assist less experienced peers and provide technical guidance.Prepare and deliver presentations to Senior Management and Business Partners.Skills:Typically requires 10 years experience or equivalent education. Ideal candidate will have minimum of 10 years skills and experience in the following areas:Strong skills in data lake, data warehousing process design, ETL development, performance & tuning using the Informatica tool suiteExcellent skills in the architecture of cloud, data lake, data warehouse and data integration strategies and solutionsDemonstrated skills in establishing cloud, data lake & data warehouse best practice standardsExcellent knowledge and programming in relational data base technologies; e.g. Oracle, DB2, SQL ServerStrong skills working with relational and dimensional data modelsStrong skills working with slowly changing dimensionsStrong data management and data analysis using SQLFamiliarity with Business Object and Tableau SoftwareFamiliarity with PeopleSoft FinancialsStrong verbal and written communication skills, including facilitation of meetings with customers and technical staff, and delivering presentations to senior managementKnowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support)Demonstrated knowledge and skills in requirements gatheringEffective interpersonal relations skills, ability to effectively collaborate with others and work as part of a teamSkills in navigating a large organization in order to accomplish resultsAbility to initiate and follow through on complex projects of both short and long term durationExcellent organizational and time management skills.Excellent analytical and problem solving skillsWorks independently, assumes responsibility for job development and training, researches and resolves questions and problems, requests supervisor input and keeps supervisor informedProficiency with MS Office suite, MS Visio, and MS OutlookAbility to complete projects of substantial depth and complexity, and work with customers at many levels in the organizationRequired Skills: Business Analysis, ETL, Oracle. Additional Skills: Analyst, Business Analyst. This is a high PRIORITY requisition.