RESPONSIBILITIES: Kforce has a client in search of a Senior Data Warehouse Developer in Doral, Florida (FL).
Summary: The Senior Data Warehouse Analyst is responsible for the design, development, and maintenance of the Operational Data Store (ODS), Enterprise Warehouse (EDW), Data Mart, CRM/Guest Loyalty and Big Data integrations and reporting business solutions with minimal guidance from the Supervisor, Data Warehouse Supervisor or Information/Data Warehouse Architect.
Essential Functions: * Design, develop, and document complex code integrating warehouse and transactional business applications using current knowledge of enterprise application technologies and development techniques - 30% * Design, develop, and test dimensional data model extensions using Star & Snow Flake schema methodologies under the Kimball and Inmon methodologies - 20% * Lead troubleshooting and debugging of software integration and performance problems; Conduct performance analysis, and suggest potential solutions for highly complex integrations and reporting needs - 10% * Partner with the Business Intelligence teams in defining the end state reporting goals and/or dashboard requirements; Design and develop data-based solutions that meet either a 'publish or 'subscribe' data requirement - 10% * Construct and maintain the necessary support Run-Book, scheduling, and Embarcadero data model documentation and artifacts in accordance with our client System Development Methodology (SDM) - 10% * Assist in developing and then meet agreed-upon deadlines and perform other project duties as assigned -10% * Communicate technical and non-technical information clearly, concisely, and effectively both orally and in writing; Present findings, recommendations, and specifications in formal reports and/or oral presentations - 10%
REQUIREMENTS: * Bachelor's degree in Computer Science * Years and area of Professional experience (required for the role) 8+ years * Experience in analysis, design, and construction of high-volume data * Expert understanding of PL/SQL developer, functions, procedures, packages and triggers * Expert understanding of SQL Navigator and/or Toad; Recent experience developing on Oracle 11G/10G * Expert understanding of the concept of code objects re-use and business rules standardization * Expert understanding of PL/SQL developer, functions, procedures, packages and triggers * Expert experience with Informatica Power Center version 9.x. including Workflow Manager, Workflow Monitor, Repository Manager, Designer, Server Manager, Power Exchange and ETL * Knowledge of Business Intelligence tools utilization including Hyperion, SAS, Tableau, and Microsoft
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.