Senior Architect DWH/NoSQL - IT

Uou will provide best-fit architectural solutions for one or more projects; assist in defining scope and sizing of work; and anchor Proof of Concept developments. You will provide solution architecture for the business problem, platform integration with third party services, designing and developing complex features for clients' business needs. You will collaborate with some of the best talent in the industry to create and implement innovative high quality solutions, participate in Pre-Sales and various pursuits focused on our clients' business needs.

You will also contribute in a variety of roles in thought leadership, mentorship, systems analysis, architecture, design, configuration, testing, debugging, and documentation. You will challenge your leading edge solutions, consultative and business skills through the diversity of work in multiple industry domains.

Responsibilities:

- Participates in the design of the technical and information architecture for the traditional and modern data warehouse, including all information structures (staging area, data warehouse, data marts, and operational data stores).

- Focuses on enterprise-wide data modeling and database design.

- Creates logical and physical data models, mapping logical to physical.

- Designs, develops, tests, monitors, manages, and validates data warehouse activity, including data extraction, transformation, movement, loading, cleansing and updating processes.

- Coordinates with other Data Warehouse IT stakeholders to ensure overall health and performance of the data warehouse environment.

- Works with end users to translate business questions and requirements into applications that employ the appropriate reporting tools.

- Assists in monitoring system performance, reliability, availability, and recoverability of the DW environment.

- Assists in the evaluation, selection, testing, and optimization of BI/DW related hardware and software products.

- Develops and applies sound fundamental design, analysis, and data administration concepts, practices, and procedures.

- Designs and develops BI reporting deliverables.

Required Skills:

- Five or more years of experience with data warehousing and business intelligence and/or large and complex database management systems (NoSQL, Oracle autonomous, IBM DB2, SAP Datawarehouse, Terradata, vertica etc.)

- Strong relational and dimensional data modeling and database design skills.

- Hands-on experience using ETL tools.

- Creates logical and physical data models, mapping logical to physical.

- Designs, develops, tests, monitors, manages, and validates data warehouse activity, including data extraction, transformation, movement, loading, cleansing and updating processes.

- Coordinates with other Data Warehouse IT stakeholders to ensure overall health and performance of the data warehouse environment.

- Work in collaboration with business leaders and end users to translate business questions and requirements into solutions that employ the appropriate tools and reporting.

- Assists in monitoring system performance, reliability, availability, and recoverability of the DW environments.

- Assists in the evaluation, selection, testing, and optimization of BI/DW related hardware and software products.

- Translate business requirements and end user's needs into DW architecture blueprints that deliver cost effective, high performing and high-quality solutions in compliance with standards, policies and long-term technical strategies.

- Communicate database designs to business and technical audiences.

- Provide architectural expertise, thought leadership, direction, and assistance across entire organization for related data driven IT and BI initiatives.

- Assist Project Managers and delivery team leaders in estimating effort and resources for new projects and enhancement requests.

- Serve as a Subject Matter Expert of data principles (data analysis, modeling, ETL, storage and delivery).

- Stay current in new DW and BI technologies, evaluate them and make adoption recommendations.

- Participate in developing and documenting technical standards and best practices for the organization.

Preferred Skills:

- Manage data integrity and accuracy of the data warehouse data and analytic environments.

- Develop optimized SQL, code and scripts to implement ETL job steps and analysis services.

- Profile, monitor, diagnose and repair data loading and processing packages to ensure data integrity and efficiency

- BI Report and Dashboard Development (Tableau, PowerBI, etc.)

- DevOps and Agile Development processes