Data Warehouse Architect

3 weeks ago

Dallas, United States BravoTECH Full time

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 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 architecture frameworks such as Zachman or TOGAF is a plus.

· Certifications in Agile/Scrum methodology is a plus.

  • 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

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

  • GCP Data Architect

    1 week 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 into...

  • GCP Data Architect

    2 hours 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 into...

  • Data Architect

    1 week ago

    Dallas, United States Century Interactive Full time

    Job Type Full-time Description Call Box exists to grow people. We believe that everyone wants to become a better version of themselves, and we work hard to provide a product and a culture that maximizes that growth mindset. We hire smart and ambitious doers and set them loose in an exciting and complex technology business where they will design, architect,...

  • Data Architect

    3 hours ago

    Dallas, United States Century Interactive Full time

    Job Type Full-time Description Call Box exists to grow people. We believe that everyone wants to become a better version of themselves, and we work hard to provide a product and a culture that maximizes that growth mindset. We hire smart and ambitious doers and set them loose in an exciting and complex technology business where they will design, architect,...

  • Senior Data Architect

    1 week ago

    Dallas, United States Abode Techzone LLC Full time

    Senior Data Architect (Azure) Onsite at Dallas TX 12 Months Contract Looking for 12 - 15 years' experience Should have worked as an Architect for at least 2 recent projects Experience in designing and hands-on development in cloud-based analytics solutions. Expert level understanding on Azure Data Factory, Azure Synapse, Azure SQL, Azure...

  • Senior Data Architect

    49 minutes ago

    Dallas, United States Abode Techzone LLC Full time

    Senior Data Architect (Azure) Onsite at Dallas TX 12 Months Contract Looking for 12 - 15 years' experience Should have worked as an Architect for at least 2 recent projects Experience in designing and hands-on development in cloud-based analytics solutions. Expert level understanding on Azure Data Factory, Azure Synapse, Azure SQL, Azure...

  • Data Architect

    4 hours ago

    Dallas, United States Entellimetrix LLC Full time

    Entellimetrix, a leading Data Analytics consulting services company is hiring for a seasoned Data Architect to support one of our consumer products clients in Dallas TX. There is an opportunity to convert to full time employment with our client after 6 months on contract. ROLE: Data Architect The Enterprise Data Architect leads the design and development of...

  • DB2 Architect

    6 days ago

    Dallas, United States Noblesoft Technologies Full time

    Job DescriptionJob DescriptionJob Role: DB2 Architect Rate : Rate depends on Experience and Relevance to Job Role /hr on C2C - FlexibleRemoteIndividual will be expected to design and architect database deployment, Replication architecture and automation solutions. Enterprise Database Architects are responsible for designing and managing complex database...

  • Data Architect With Druid

    3 hours ago

    Dallas, United States Codebase Full time

    Title : Data Architect With DruidLocation :: Dallas, TX & Basking Ridge ,NJ (Hybrid)Please look for Druid exp along with Data Architecture exp. Rest go through the below must have. Must have:• Experience with building real-time data ingestion pipelines for high velocity and high volume data• Experience in architecting and building distributed computing...

  • Data Architect

    4 weeks ago

    Dallas, United States Sigmaways Inc Full time

    We are looking for an innovative and mission-driven Data Architect to play a pivotal role in building the most critical engineering solutions for our direct client.In this new role, you will work with the Product Owner to understand the business strategy and work together to define the roadmap of product feature development over the next couple of years....

  • Data Architect

    4 weeks ago

    Dallas, United States Sigmaways Inc Full time

    We are looking for an innovative and mission-driven Data Architect to play a pivotal role in building the most critical engineering solutions for our direct client.In this new role, you will work with the Product Owner to understand the business strategy and work together to define the roadmap of product feature development over the next couple of years....

  • Qlik Architect

    1 week ago

    Dallas, United States Bridge Technologies and Solutions Full time

    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 system documentation for ETL processes Collaborate with business analysts, source...

  • Qlik Architect

    13 hours ago

    Dallas, United States Bridge Technologies and Solutions Full time

    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 system documentation for ETL processes Collaborate with business analysts, source...

  • Data Architect

    1 week ago

    Dallas, United States Patriot Technology and Business Partners, Inc. Full time

    Job Description: PATRIOT® is an Information Technology and Management Consulting firm able to provide end-to-end technical and technology support services to both the federal government and enterprise corporations. With a proven record of consistent, timely service and subject matter expertise, we make insurmountable tasks possible to overcome. We are...

  • Data Architect

    1 day ago

    Dallas, United States Patriot Technology and Business Partners, Inc. Full time

    Job Description: PATRIOT® is an Information Technology and Management Consulting firm able to provide end-to-end technical and technology support services to both the federal government and enterprise corporations. With a proven record of consistent, timely service and subject matter expertise, we make insurmountable tasks possible to overcome. We are...

  • Senior Data Architect

    1 week ago

    Dallas, United States Trinity Industries Full time

    Trinity Industries is searching for a Senior Data Architect at our Dallas, TX HQ!  Trinity Industries is at the forefront of expanding data infrastructure and analytics capabilities. In the role of Senior Data Architect, you will be instrumental in architecting, implementing, and optimizing our data processing and analytics platform based on Databricks for...

  • Principal Data Architect

    11 minutes ago

    Dallas, United States ServiceNow Full time

    Job Description We’re not yesterday’s IT department, we're Digital Technology. The world around us keeps changing and so do we. We’re redefining what it means to be IT with a mindset centered on transformation, experience, AI-driven automation, innovation, and growth. We’re all about delivering delightful, secure customer and employee experiences...

  • Senior Data Architect

    1 week ago

    Dallas, United States TrinityRail Full time

    Trinity Industries is searching for a Senior Data Architect at our Dallas, TX HQ! Trinity Industries is at the forefront of expanding data infrastructure and analytics capabilities. In the role of Senior Data Architect, you will be instrumental in architecting, implementing, and optimizing our data processing and analytics platform based on Databricks for...