Data Warehouse Architect 3 (Hybrid)
DPP is seeking a Data Warehouse Architect for an opportunity in Dimondale, Michigan.
Work arrangement:
Hybrid, the candidate will need to be onsite from day 1, two days a week (Tuesdays and Wednesdays are required to be onsite for this position) W2 position; 6 months with possibility of extension Position description:
The Data Warehouse Architect designs, implements, and supports data warehousing.
Implements business rules via stored procedures, middleware, or other technologies.
Defines user interfaces and functional specifications.
Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse.
Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning.
Demonstrated problem resolution skills with team of persons, and strong leadership with implementation team Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models.
Development experience in implementation of data warehousing utilizing RDBMS.
Understanding of data warehouse Metadata concepts, tools and different data warehouse methodologies.
Expertise in SQL and proficiency in database tuning techniques.
Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments.
Develop strategies for flexibility and scalability, and define the future technical architecture direction for the business intelligence reporting physical environment.
Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.
Top skills:
12
years of experience in the field is required Experience building a data warehouse Experience creating ETL designs
Responsibilities:
Translate business requirements and models into feasible and acceptable data warehouse designs.
Provide support to all data warehouse initiatives.
Define all metadata standards for the data warehouse.
Develop data warehousing hardware and software platforms and integrate systems to ensure that integration is effective and meets client specifications.
Prepare a design for all metadata relating to various Extract/Transform/Load (ETL) processes.
Create ETL designs to provide easy accession to data marts.
Conduct troubleshooting on all ETL processes and effectively resolve any issues.
Analyze every data warehouse architecture goal and identify what skill requirements they require.
Evaluate all proposals and requests and help implement the chosen items that will improve the data warehouse structure.
Assist in the definition, documentation, and development of mapping rules for movement of data from desperate data sources and into the various components and subject areas.
Create data models including robust data definitions, entity-relationship-attribute models, as well as relational and/or dimensional models.
A good understanding of the design and development of complex business reports.
Design and oversee the implementation of data transformation and change processing procedures to ensure that data from multiple sources is aggregated, normalize, and update and then publish to multiple target environments.
Provide hands-on data modeling (relational and dimensional) for Data Warehouse/Data Marts Test and monitor alterations in designs.
Create database models which serve as blueprints for project engagements of all complexities.
Must be familiar with DevOps best practices and automation of processes like building, configuration, deployment, documentation, testing, and monitoring.
Required knowledge, skills, and abilities:
Experience in Data Modeling and designing Datawarehouse databases.
Required 10
years.
Experience in developing ETL models.
Required 5
years Experience in Data Replication using tools like Oracle Golden Gate, 5
years.
Experience in Oracle Database administration, PL/SQL, packages, security, and stored procedures, required 12
years.
Knowledge in design, development, implementation, and documentation of data systems Working knowledge of relational database design, logical data modeling, data warehousing, and relational database management systems preferably Oracle 19c, Experience in performance tuning, required 10
years.
Vast experience in LINUX systems, required 10
years.
Extensive working experience in RAC environments, required 10
years.
Experience using Oracle Data Guard / Fast Start Failover, Required 5
years.
Database programming experience in data migration and conversion practices, required 8
years Writing Oracle packages, procedures, and functions, required 10
years Designing, creating, normalizing and maintenance of oracle database objects, required 10
years.
Designing logical and physical database model, required 10
years Data analysis and management, required 10
years Interested? Learn more:
Click the apply button or contact our recruiter Daniel at to learn more about this position (#23-00777).
DPP offers a range of compensation and benefits packages to our employees and their eligible dependents.
Call today to learn more about working with DPP.
Authorized US Worker - s and those authorized to work in the US are encouraged to apply.
We are unable to sponsor at this time.
EOE/AA/V/D Data Warehouse Architect 3 (Hybrid) Recommended Skills Architecture Automation Blueprinting Business Intelligence Business Requirements Computing Platforms Estimated Salary: $20 to $28 per hour based on qualifications.
Work arrangement:
Hybrid, the candidate will need to be onsite from day 1, two days a week (Tuesdays and Wednesdays are required to be onsite for this position) W2 position; 6 months with possibility of extension Position description:
The Data Warehouse Architect designs, implements, and supports data warehousing.
Implements business rules via stored procedures, middleware, or other technologies.
Defines user interfaces and functional specifications.
Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse.
Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning.
Demonstrated problem resolution skills with team of persons, and strong leadership with implementation team Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models.
Development experience in implementation of data warehousing utilizing RDBMS.
Understanding of data warehouse Metadata concepts, tools and different data warehouse methodologies.
Expertise in SQL and proficiency in database tuning techniques.
Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments.
Develop strategies for flexibility and scalability, and define the future technical architecture direction for the business intelligence reporting physical environment.
Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.
Top skills:
12
years of experience in the field is required Experience building a data warehouse Experience creating ETL designs
Responsibilities:
Translate business requirements and models into feasible and acceptable data warehouse designs.
Provide support to all data warehouse initiatives.
Define all metadata standards for the data warehouse.
Develop data warehousing hardware and software platforms and integrate systems to ensure that integration is effective and meets client specifications.
Prepare a design for all metadata relating to various Extract/Transform/Load (ETL) processes.
Create ETL designs to provide easy accession to data marts.
Conduct troubleshooting on all ETL processes and effectively resolve any issues.
Analyze every data warehouse architecture goal and identify what skill requirements they require.
Evaluate all proposals and requests and help implement the chosen items that will improve the data warehouse structure.
Assist in the definition, documentation, and development of mapping rules for movement of data from desperate data sources and into the various components and subject areas.
Create data models including robust data definitions, entity-relationship-attribute models, as well as relational and/or dimensional models.
A good understanding of the design and development of complex business reports.
Design and oversee the implementation of data transformation and change processing procedures to ensure that data from multiple sources is aggregated, normalize, and update and then publish to multiple target environments.
Provide hands-on data modeling (relational and dimensional) for Data Warehouse/Data Marts Test and monitor alterations in designs.
Create database models which serve as blueprints for project engagements of all complexities.
Must be familiar with DevOps best practices and automation of processes like building, configuration, deployment, documentation, testing, and monitoring.
Required knowledge, skills, and abilities:
Experience in Data Modeling and designing Datawarehouse databases.
Required 10
years.
Experience in developing ETL models.
Required 5
years Experience in Data Replication using tools like Oracle Golden Gate, 5
years.
Experience in Oracle Database administration, PL/SQL, packages, security, and stored procedures, required 12
years.
Knowledge in design, development, implementation, and documentation of data systems Working knowledge of relational database design, logical data modeling, data warehousing, and relational database management systems preferably Oracle 19c, Experience in performance tuning, required 10
years.
Vast experience in LINUX systems, required 10
years.
Extensive working experience in RAC environments, required 10
years.
Experience using Oracle Data Guard / Fast Start Failover, Required 5
years.
Database programming experience in data migration and conversion practices, required 8
years Writing Oracle packages, procedures, and functions, required 10
years Designing, creating, normalizing and maintenance of oracle database objects, required 10
years.
Designing logical and physical database model, required 10
years Data analysis and management, required 10
years Interested? Learn more:
Click the apply button or contact our recruiter Daniel at to learn more about this position (#23-00777).
DPP offers a range of compensation and benefits packages to our employees and their eligible dependents.
Call today to learn more about working with DPP.
Authorized US Worker - s and those authorized to work in the US are encouraged to apply.
We are unable to sponsor at this time.
EOE/AA/V/D Data Warehouse Architect 3 (Hybrid) Recommended Skills Architecture Automation Blueprinting Business Intelligence Business Requirements Computing Platforms Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
