Role : Enterprise Data Modeler
Location : Austin,TX
Duration : 6+ Months
Job Description :
As an Enterprise Data Modeler, the Worker must be innovative and creative in solving complex solutions. The Worker must have a strong background in developing comprehensive automated processes to extract data from disparate source systems, transform data as per business requirements, and load data into a data warehouse and various presentation models.
The Worker will be responsible for:
- analyzing evolving sources of data, determining and implementing extraction methodologies
- loading operational data models and data marts and re-architecting and standardizing existing ETL processes
- working with users and business analyst to ensure that the correct data is being sourced into the Enterprise Data Warehouse and the sourced data is in conformance with data governance guidelines
- developing processes and procedures in support of a large enterprise BI/DW environment
- working with Business Customers, Section Managers, Project Managers, Business Analysts and Subject Matter Experts (SMEs) in a professional and collaborative manner to define strategies and implementation approaches
- Following software development processes, preparing detailed documentation and generating work estimates in an SDLC environment.
WORKER SKILLS AND QUALIFICATIONS
- Must possess strong written, verbal, and interpersonal communication skills.
- Must be able to work independently in a team environment with local and remote teams
- Must possess knowledge of project management methodologies both traditional and Agile/Scrum
- Must possess problem-solving skills and ability to multi-task with readiness to put in extra efforts when necessary
- Must perform related work as assigned
Minimum Requirements:
Extensive experience in architecting ETL Solutions, automation, and best practices | |
Expertise in source data analysis, defining data granularity, data element mapping, and data warehouse design. | |
Hands-on experience with data conversion, performance tuning, and managing conceptual and physical data models. | |
Extensive knowledge of/experience with data integration, data quality, multi-dimensional design and ETL tools, processes and methodology | |
Experience with IBM Infosphere DataStage v8.x and above | |
Knowledge and experience with both DW and BI security architecture, especially involving disparate platforms preferably Enterprise Resource Planning (ERP) software and Active Directory (AD) | |
Experience with implementing security and privacy requirements in a large enterprise environment | |
Experience preparing all required artifacts accurately and in a timely fashion for the project |
Preferences:
Proficient with the Microsoft Windows and Office products | |
Public sector experience (Federal, State or Local Government) | |
Experience working with IT and business customers |