Data Warehouse Architect

3 weeks ago

Dallas, United States BravoTECH Full time

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.

  • Data Warehouse Architect

    1 month ago

    Dallas, United States Agile Premier Full time

    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...

  • Data Warehouse Architect

    6 days ago

    Dallas, United States Agile Premier Full time

    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...

  • Data Warehouse Architect

    3 weeks ago

    Dallas, United States Agile Premier Full time

    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...

  • Data Warehouse Architect

    1 month ago

    Dallas, United States Agile Premier Full time

    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...

  • Data Warehouse Architect

    1 day ago

    Dallas, United States Agile Premier Full time

    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...

  • Data Warehouse Architect

    7 hours ago

    Dallas, United States Agile Premier Full time

    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...

  • Enterprise Data Warehouse Architect

    2 weeks ago

    Dallas, United States Brinker Full time

    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 life for our Team Members, Guests and community. Through our cultural beliefs,...

  • Data Architect

    7 days ago

    Dallas, United States APN Consulting Full time

    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 and Functional Data Detail Flow Designs Detail Data Design, Organization, and Solutioning Erwin...

  • Data Architect

    1 week ago

    Dallas, United States Saxon Global Full time

    Data Architect: III (Senior)- Description: Description: This role will be part of a team focused on cloud transformation, modernizing analytics platforms and improving agility. The role requires hands-on experience in building and managing analytics solutions in SnowFlake, Provide direction on adoption of Cloud technologies (Snowflake) and industry best...

  • Data Architect

    2 weeks ago

    Dallas, United States NlitenData LLC Full time

    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 Architect, you will be responsible for developing strategic data architecture...

  • Data Architect

    2 weeks ago

    Dallas, United States NlitenData LLC Full time

    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 Architect, you will be responsible for developing strategic data architecture...

  • Data Architect

    2 weeks ago

    Dallas, United States NlitenData LLC Full time

    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 Architect, you will be responsible for developing strategic data architecture...

  • Data Architect

    5 days ago

    Dallas, United States Novocure Full time

    Description: JOB SUMMARY: The Data Architect will be a member of Novocure's corporate analytics & data strategy team, participating in designing, architecting, and building the foundation for Business Intelligence activities for broad corporate initiatives. This role will provide the technical and analytical capabilities necessary to support...

  • Azure Data Warehouse Architect

    1 week ago

    Dallas, Texas, United States Digital Realty - Multi-Lingual 2023 Full time

    Position Title: Azure Data Warehouse ArchitectYour roleIf 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 architect for our Azure Cloud Data Warehouse and Analytics environment with a strong focus...

  • Azure Data Warehouse Architect

    1 day ago

    Dallas, Texas, United States Digital Realty - Multi-Lingual 2023 Full time

    Position Title: Azure Data Warehouse ArchitectYour roleIf 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 architect for our Azure Cloud Data Warehouse and Analytics environment with a strong focus...

  • Data Architect

    2 weeks ago

    Dallas, United States Request Technology, LLC Full time

    NO SPONSORSHIPPrincipal, Data ArchitectureSALARY: $195k - $200k plus 27% bonusLOCATION: Chicago, ILHybrid 3 days in office and 2 days remote Looking for a candidate that does data architecture and design. Datalakes, data warehouse solutions. schema designs relational nonrelational data messaging design of data science data analytics Kafka and protocol...

  • Azure Data Warehouse Architect

    2 weeks ago

    Dallas, United States Digital Realty Full time

    Job DescriptionPosition 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 architect for our Azure Cloud Data Warehouse and Analytics environment with...

  • Azure Data Warehouse Architect

    1 week ago

    Dallas, United States Digital Realty - Multi-Lingual 2023 Full time

    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 architect for our Azure Cloud Data Warehouse and Analytics environment with a...

  • GCP Data Architect

    2 weeks ago

    Dallas, United States Avant Digital, Inc. Full time

    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, developers, and architecture teams to understand requirements and translate them...

  • Data Architect

    3 days ago

    Dallas, United States Programmers.io Full time

    Hi Folks,One of our clients is looking for Data Architect at Dallas TXNote: This is an on-site position.We have multiple openings.Candidate must have experience on the below mentioned job description:Title – Data ArchitectLocation- Dallas TXTerms- Full TimeResponsibilities Designing and architecting data solutions on the Azure platform, specifically...