icrunchdata Network Westmont, IL, USA
Nov 16, 2019Full-time
RESPONSIBILITIES: Kforce has a client that is seeking a Data Warehouse Architect in Westmont, Illinois (IL). Summary: The Data Warehouse Architect is an expert well-versed in Data Warehousing and Business Intelligence technologies who demonstrates extensive abilities interacting with end-users to understand and document business and functional requirements, data sources, metadata, and conceptual data models for complex analytics application across a global enterprise. Responsibilities: Design and develop data warehouse solution architecture Gather requirement and translate business requirement into technical design Design, develop, and implement ETL codes Support production ETL bug fixes Coordinate, lead, and mentor offshore ETL developers Develop solution architecture using business stakeholders' requirement and transforming into conceptual data models, including socializing and implementing logical and physical data warehouse/data mart data models; Identify data sources and metadata (including business rules, definitions, attributes, etc.) to deliver analytic requirements Design and development of data models, extraction code and cleansing routines utilizing typical data quality functions, i.e. standardization, transformation, rationalization, linking and matching that leverages data standards, processes and technology management for data, master data, and metadata, and data security (including data masking and related data protection techniques) REQUIREMENTS: Bachelor's degree in Computer Science or related field plus required experience 7 years of Data Warehouse ETL design, development and maintenance with successful implementation of large Enterprise BI solutions 5 years of experience with RDBMS platforms (i.e. Oracle, Teradata, DB2, MS SQL Server), SQL, ETL tools (Talend, Informatica PC, Business Objects Data Integrator, SSIS and others), big data architecture and related technologies (i.e. Spark) At least two full lifecycle implementations, BI/SQL, DW/SQL/ETL/Modeling tools and other related technologies involving: BI and enterprise DW data management, modeling, integration and/or synchronization, quality, security, conversion and analysis, star schema and relational reporting models, enterprise data management policies, procedures, compliance and risk management and/or database administration Experienced with java, Python and OOP concept Hands on experience working on Windows and Linux environments and Unix scripting Identifiable leadership skills on generating a vision, establishing direction and motivating developers and other team members, creating an atmosphere of trust, leveraging diverse views, coaching staff, and encouraging improvement and innovation Must be self-starter and able to demonstrate experience working in an agile environment to deliver robust and well tested solutions Strong interest in learning new technologies Able to stay on mission some nights/weekends during Team Sprints and production support Demonstrated experience in various phases of the Systems Development Life Cycle DBA or database development experience (a plus) 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.