DATA WAREHOUSE ARCHITECT

DATA WAREHOUSE ARCHITECT

15 Jun 2024
Pennsylvania, Pittsburgh, 15201 Pittsburgh USA

DATA WAREHOUSE ARCHITECT

Vacancy expired!

Design, develop, implement, and support the data warehouse…Pyramid Consulting Group has a Pittsburgh client with an immediate contract need for an experienced DATA WAREHOUSE ARCHITECT.
Duties will include but are not limited to:
Design of the technical and information architecture for the data warehouse, including all information structures (staging area, data warehouse, data marts, and operational data stores).
Create 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 business, operations and engineering stakeholders to ensure overall requirements, 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.

The client is looking for the following background and skills:
Bachelors degree in Computer Science or related field; or, an equivalent combination of education and relevant business experience.
Five or more years of experience with data warehousing and business intelligence and/or large and complex database management systems.
Strong relational and dimensional data modeling and database design skills.
Hands-on experience using ETL tools.
Possesses interviewing, observing, questioning, and analyzing skills.
Working knowledge of data warehouse approaches, architecture and development.
Customer-oriented with excellent interpersonal communication skills.
Ability to investigate complex business problems, develop effective recommendations, negotiate and/or present solutions, and resolve problems in a highly professional and tactful manner.

Related jobs

  • Reference #: 51735 Vice President, Data Management and Quantitative Analysis (Hybrid) Bring your ideas. Make history. BNY Mellon offers an exciting array of future-forward careers at the intersection of business, finance, and technology. We are one of the world\'s top asset management and banking firms that manages trillions of dollars in assets, custody and/or administration. Known as the \"bank of banks\" - 97% of the world\'s top banks work with us as we lead and serve our customers into the new era of digital. With over 238 years of rich history and industry firsts, BNY Mellon has been built upon our proven ability to evolve, lead, and drive new ideas at every turn. Today, we\'re approximately 50,000 employees across 35 countries with a culture that empowers you to grow, take risks, experiment and be yourself. This is what #LifeAtBNYMellon is all about. We\'re seeking a future team member for the role of VP to join our Data Management and Quantitative Analysis. This role is located in Pittsburgh, PA / Lake Mary Florida. In this role, you\'ll make an impact in the following ways: Leads a small staff of individual contributors who compile, synthesize and report on the Banks or market data sources. May provide oversight on the management and mining of databases, data feeds, etc. as well as the extraction, cleansing, preparation and hand-off to internal clients. Understands and implements processes and may provide recommendations to increase efficiencies and improve processes Oversees the implementation of new data related technology enhancements / implementations. To be successful in this role, we\'re seeking the following: Bachelors or equivalent combination of education and experience is required Bachelors degree preferred 5+ years total experience Prior Financial services experience preferred Prior Management experience preferred. At BNY Mellon, our inclusive culture speaks for itself. Here\'s a few of our awards: Fortune World\'s Most Admired Companies & Top 20 for Diversity and Inclusion Bloomberg\'s Gender Equality Index (GEI) , Disability: IN - 100% score 100 Best Workplaces for Innovators, Fast Company Human Rights Campaign Foundation, 100% score Corporate Equality Index CDP\'s Climate Change \'A List\' Our Benefits: BNY Mellon offers highly competitive compensation, benefits, and wellbeing programs rooted in a strong culture of excellence and our pay-for-performance philosophy. We provide access to flexible global resources and tools for your life\'s journey. Focus on your health, foster your personal resilience, and reach your financial goals as a valued member of our team, along with generous paid leaves that can support you and your family through moments that matter.  This is a pipeline req, meaning no hires can be made against it.  Applying to this position demosntrates interest in current and future data mangement programs within the firm.

  • Medical Data Scientist

  • About Us

  • Reference #: 53370 BNY Mellon offers an exciting array of future-forward careers at the intersection of business, finance, and technology. We are one of the world\'s top asset management and banking firms that manages trillions of dollars in assets, custody and/or administration. Known as the \"bank of banks\" - 97% of the world\'s top banks work with us as we lead and serve our customers into the new era of digital. With over 239 years of rich history and industry firsts, BNY Mellon has been built upon our proven ability to evolve, lead, and drive new ideas at every turn. Today, we\'re approximately 50,000 employees across 35 countries with a culture that empowers you to grow, take risks, experiment and be yourself. This is what #LifeAtBNYMellon is all about. We\'re seeking a future team member for the role of Senior Associate, Data Scientist to join our team! This role is located in Lake Mary, FL. In this role, you\'ll make an impact in the following ways: Assembling large, complex sets of data that meet non-functional and functional business requirements Identifying, designing and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition Working with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues Working with stakeholders including the Executive, Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues To be successful in this role, we\'re seeking the following: Bachelor\'s degree in Computer Science Engineering or a related discipline, or equivalent combination of education and work experience required 2-3 years relevant experience Design & build cloud-based data lake and warehousing solution in Snowflake to enable storage and processing of data at scale Experience in Apache and Python Design & develop real-time/near real-time event-driven ingestion patterns using Kafka, Airflow & dBT Responsible for technical design, development and documentation of solution. At BNY Mellon, our inclusive culture speaks for itself. Here\'s a few of our awards: Fortune World\'s Most Admired Companies & Top 20 for Diversity and Inclusion Bloomberg\'s Gender Equality Index (GEI) Human Rights Campaign Foundation, 100% score Corporate Equality Index , Disability: IN - 100% score 100 Best Workplaces for Innovators, Fast Company CDP\'s Climate Change \'A List\' Forbes Blockchain 50 Our Benefits: BNY Mellon offers highly competitive compensation, benefits, and wellbeing programs rooted in a strong culture of excellence and our pay-for-performance philosophy. We provide access to flexible global resources and tools for your life\'s journey. Focus on your health, foster your personal resilience, and reach your financial goals as a valued member of our team, along with generous paid leaves that can support you and your family through moments that matter. BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer - Underrepresented racial and ethnic groups/Females/Individuals with Disabilities/Protected Veterans.

  • Apply Now Senior Data Science Manager at Duolingo (View all jobs)

  • Erwin Data Modeler

  • Pittsburgh Study Senior Data Scientist

Job Details

  • ID
    JC15469258
  • State
  • City
  • Job type
    Contract
  • Salary
    Depends on Experience
  • Hiring Company
    Pyramid Consulting Group, Inc
  • Date
    2021-06-07
  • Deadline
    2021-08-06
  • Category

Jocancy Online Job Portal by jobSearchi.