Jobs
>
Dallas

    Data Warehouse Architect - Dallas, United States - BravoTECH

    Default job background
    Real Estate
    Description

    Data Warehouse Architect

    • Direct Hire role
    • Onsite in Dallas TX
    • Company is not able to sponsor visa candidates at this time.

    POSITION OVERVIEW

    The Data Warehouse Architect Role involves strategically designing and implementing data warehouses, data marts, and data stores as well as requisite ETL (Extract, Transform, Load) and visualization (reporting) development while ensuring high levels of data availability. This individual is also responsible for collaborating to define enterprise data standards and models for warehouse architectures. The Data Warehouse Architect will also evaluate and provide input on infrastructure components such as software, hardware, database management systems, and networking capabilities. The individual is expected to have expertise in the underlying technology and function effectively at collaboratively defining business solutions and technology policies, while remaining hands-on within the technology environment. This position will office in the client's Dallas, Texas corporate office, and report to the SVP, Technology Business Solutions.

    PRIMARY RESPONSIBILITIES

    Strategy & Planning

    · Assess and cultivate long-term strategic goals for data warehousing in conjunction with IT architect(s), data users, department managers, clients, and other key stakeholders.

    · Coordinate and work with other technical staff to develop database architectures, coding standards, and quality assurance policies and procedures.

    · Plan and implement capacity and resource expansion to ensure data warehouse scalability.

    · Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets.

    Acquisition & Deployment

    · Conduct research and make recommendations on data warehouse products, services, protocols, and standards in support of procurement and development efforts.

    · Evaluate, recommend, and select data warehouse components, including hardware, database management systems, ETL (extract, transform, load) software, data mining tools, and meta data management tools.

    Operational Management

    · Oversee data collection and master data and database(s).

    · Work with end users to identify, create, and deliver reports according to requirements.

    · Create models for new data warehouse development and/or changes to existing data stores.

    · Create and support relevant supporting ETL layer needed for enterprise data warehouse platform.

    · Design and manage data warehouse improvement and growth projects.

    · Identify inefficiencies and gaps in current data warehouses and leverage solutions to ensure data standards.

    · Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.

    · Diagnose and resolve data warehouse access and performance issues.

    · Install and configure relevant components to ensure data warehouse access.

    · Execute data warehouse configuration and performance tuning.

    · Monitor system details within the data warehouse, including stored procedures and execution time, and implement efficiency improvements.

    · Develop, implement, and maintain change control and testing processes for modifications to data systems.

    Support Operations


    • Troubleshoot and resolve Tier 2/3 domain system issues or malfunctions.


    • Coordinate Tier 3 escalations to relevant vendor.


    • Analyze the current business and IT environment to detect critical deficiencies and recommend solutions for improvement.


    • Work with the SVP Technology Business Solutions and BSMs to ensure the successful delivery of key strategic projects.

    Manage Projects


    • Plan and Manage SharePoint and Teams project schedules, resources, budgets, and manage stakeholder expectations, providing timely communications and reporting.

    · Technical projects and upgrades

    · Business functional projects

    QUALIFICATIONS

    Knowledge & Experience

    · Working technical experience with designing, building, installing, configuring and supporting multi-terabyte data warehouses.

    · Experience with database platforms, including SQL Server and/or Azure.

    · Experience developing analytics within PowerBI.

    · Experience transforming data via ETL concepts.

    · Strong understanding of relational database structures, theories, principles, and practices.

    · Hands-on experience with data architecting, data mining, large-scale data modeling, and business requirements gathering/analysis.

    · Knowledge of Windows operating system, as well as Power BI, and Office 365 including diagnostic tools preferred.

    · Experience with data processing flowcharting techniques.

    · Proven project management (Waterfall+Agile) experience.

    · Good knowledge of applicable data privacy practices and laws.

    Formal Education & Certification

    · College diploma or university degree in the field of computer science, information systems, or computer engineering and 5+ years of relevant work experience.

    · Certifications in Agile/Scrum methodology is a plus.

    · Experience in Commercial Real Estate (CRE) Industry is a plus.



  • BravoTECH Dallas, United States

    Data Warehouse Architect- Direct Hire · The Data Warehouse Architect Role involves strategically designing and implementing data warehouses, data marts, and data stores as well as requisite ETL (Extract, Transform, Load) and visualization (reporting) development while ensuring hi ...


  • Agile Premier Dallas, United States

    The Data Warehouse Architect Role involves strategically designing and implementing data warehouses, data marts, and data stores as well as requisite ETL (Extract, Transform, Load) and visualization (reporting) development while ensuring high levels of data availability. This ind ...


  • BravoTECH Dallas, United States

    Data Warehouse Architect- Direct Hire · Any additional information you require for this job can be found in the below text Make sure to read thoroughly, then apply. · The Data Warehouse Architect Role involves strategically designing and implementing data warehouses, data marts ...


  • Brinker Dallas, United States

    Enterprise Data Warehouse Architect Information Systems Dallas, TX April 22, > Enterprise Data Warehouse Architect Dallas TX What does it mean to be a BrinkerHead? We play like a team, take pride in our culture and seek every opportunity to make people feel special. Life is short ...


  • Brinker Dallas, United States

    Enterprise Data Warehouse Architect · Dallas TX · What does it mean to be a BrinkerHead? We play like a team, take pride in our culture and seek every opportunity to make people feel special. Life is short. Work happy. · At Brinker, we connect, serve and give to create the best ...


  • Brinker International Inc Dallas, United States

    What does it mean to be a BrinkerHead? We play like a team, take pride in our culture and seek every opportunity to make people feel special. · Life is short. Work happy . · At Brinker, we connect, serve and give to create the best life for our Team Members, Guests and community ...


  • Digital Realty Dallas, United States

    Job Description · Position Title: Azure Data Warehouse Architect · Your role · If you are a proven data & analytics superstar, this is a unique opportunity to make a significant strategic impact on a fast-growing market leader where technology meets real estate. You will be the ...


  • Digital Realty - Multi-Lingual 2023 Dallas, United States

    Position Title: Azure Data Warehouse Architect · Your role · If you are a proven data & analytics superstar, this is a unique opportunity to make a significant strategic impact on a fast-growing market leader where technology meets real estate. You will be the primary data archit ...

  • Talent Consulting Experts

    VP of Accounting

    5 days ago


    Talent Consulting Experts Dallas, United States

    · Join a leading technology group in the heart of Dallas as we expand our dedicated family office team. We offer a dynamic work environment where innovation and precision are at the forefront of our operations. We are seeking a seasoned SAP EWM Solution Architect to play a pivot ...

  • MCKESSON

    SAP ATTP

    4 days ago


    MCKESSON Irving, United States Full time

    McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you a ...


  • MCKESSON Irving, United States Full time

    McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you a ...

  • Noblesoft Technologies

    DB2 Architect

    3 weeks ago


    Noblesoft Technologies Dallas, United States

    Job Description · Job DescriptionJob Role: DB2 Architect · Rate : Rate depends on Experience and Relevance to Job Role /hr on C2C - Flexible · Remote · Individual will be expected to design and architect database deployment, Replication architecture and automation solutions. Ent ...

  • NlitenData LLC

    Data Architect

    1 week ago


    NlitenData LLC Dallas, United States

    We are looking for an experienced Data Architect to lead the design and management of data architecture solutions across multiple environments, including data warehouses, operational data stores (ODS), data replication/ETL, and other data management initiatives. As a Senior Data ...


  • mProgen Dallas, United States

    Dallas, TX- Hybrid · Business information Architect / Data Modeling · Job Description: · Strong experience in Banking functionalities and understanding in banking taxonomy · Experience in industry reference model (IBM BDW , IBM IFW , FLSDM , BIAN etc. ) & industry best practices ...

  • Keylent Inc

    Tech Lead

    2 weeks ago


    Keylent Inc Dallas, United States

    Position 1 :- Data Solution Architect TECHM-JOB-23017 · Location :- Remote · Job Description · Minimum 6+ years in a Data Solution Architect role supporting warehouse and big data platforms/environments. · Business Analyst mindset/aptitude to understand domain data requirement ...

  • Avant Digital, Inc.

    GCP Data Architect

    2 weeks ago


    Avant Digital, Inc. Dallas, United States

    Job Description: · Job Summary · We seek a highly experienced and passionate GCP Architect to join our team. As a GCP Architect, you will be responsible for designing and implementing scalable and efficient data solutions on the Google Cloud Platform. You will work with clients, ...

  • Keylent Inc

    Tech Lead

    3 weeks ago


    Keylent Inc Dallas, United States

    Position 1 :- Data Solution Architect TECHM-JOB-23017Location :- RemoteJob DescriptionMinimum 6+ years in a Data Solution Architect role supporting warehouse and big data platforms/environments.Business Analyst mindset/aptitude to understand domain data requirements for project s ...

  • Evolution Recruitment Solutions, USA

    Data Engineer

    3 weeks ago


    Evolution Recruitment Solutions, USA Dallas, United States

    Data Engineer - Must be a US citizen or Green Card Holder · Contract: 6 months initial and full-time after 6 months · Rate: $70-$90 per hour · Location: Dallas 2 days on-site per week · We are seeking a skilled Data Engineer with extensive experience in DBT, Snowflake, and Azur ...

  • Bridge Technologies and Solutions

    Qlik Architect

    2 weeks ago


    Bridge Technologies and Solutions Dallas, United States

    The Architect is responsible for working with business analysts and business users to gather and interpret business requirements for multiple system data sources including large data warehouses. Follows data standards, resolves data issues, completes unit testing and completes sy ...

  • APN Consulting

    Data Architect

    2 days ago


    APN Consulting Dallas, United States

    Title: Data Architect · Location: Remote · Job Description: · High Level Designs and Business Rule identification · Detail Designs and Business Rule identification · Data Exploration, Discovery, and Profiling · High Level Data Exploration, Discovery, and Profiling · Conceptual ...