Enterprise Data Warehouse Architect
Information Systems
Dallas, TX
April 22, 2024
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, Brinker empowers its Team Members to positively impact our 4 Key Results: Engaging Team Members, Bringing Back Guests, Growing Sales and Increasing Profits.
Brinker International is an equal opportunity employer; we foster an inclusion environment that promotes respect, diversity of thought and success for all.
Job Summary
The position is responsible for the architecture, oversight, build, enhancements, and maintenance of the Enterprise Data Warehouse and end-to-end BI solution. This position will be responsible for the accuracy, consistency, completeness, and timeliness of the data.
Your Key Job Functions
- The role will work closely with a cross functional business stakeholders, business analysts, and developers on a regular basis to collaborate, gather requirements and to oversee the building and maintenance of the Enterprise Data Warehouse and BI solution.
- Analyze and profile source data to find underlying data/domain relationships and gaps.
- Leading teams to ensure completion with data extraction, transformation, and loading.
- Ensure and track model deployments across all the environments.
- Provide walkthroughs & publish changes to all technology teams before every release rollout.
- Employ code repositories for version control and documentation, adhering to standard methodologies in data management.
- Advocate for standard processes in managing large datasets, applying star schema and other techniques to maintain data integrity and performance.
- Apply your expertise to optimize data read/write, ensuring efficient storage, retrieval, and processing of data.
- Ability to listen carefully to business needs, be able to communicate effectively with various levels of the organization including stakeholders, peers, and supervisor.
- Lead the evaluation, selection, and implementation of Teradata-based solutions to support data warehousing, analytics, and reporting requirements.
- Provide technical leadership and guidance to development teams in the design and implementation of data-centric applications and solutions.
- Responsible for documenting technical specifications, providing workable solutions, architecting integrations and ETL, developing design documents, creating data mapping documents and technical diagrams, and implementing impactful Business Intelligence solutions for the business.
What You Bring to the Team
· Bachelor’s degree in a data-focused discipline, or the equivalent in skill and training.
· 10+ Years of experience in data warehousing with a solid understanding of relational databases and ETL concepts.
· Understanding of dimensional modeling, relational modeling, business process relationships, and best practices in enterprise data and data warehouse design.
· Experience with SQL Server, Teradata, Informatica, and SSIS preferred.
· Strong coding skills in Standard SQL.
· Strong experience designing and architecting ETL processes and have hands-on experience leading data extraction, data cleansing, data mapping, data transformation, data loading, and data validation using tools like SSIS, Informatica. Etc.
· Experience architecting and designing Data Warehouses, BI dashboards, KPIs, metrics and reports.
· Experience working with cloud and on-premise data sources and targets.
· Strong understanding of SQL, ETL, designing data integrity and error handling techniques, and reviewing change history.
· In-depth knowledge and hands-on experience with Teradata technologies, including Teradata Database, Teradata SQL, Teradata Utilities, Teradata Tools and Utilities, and Teradata QueryGrid a plus.
· Knowledge in using data quality and data governance tools such as Informatica Data Quality and Informatica Data Catalog.
· Familiarity with standard change control procedures and documentation best practices for data movement.
· Proficient in MS Office.
· Be customer centric; listening, understanding, and responding to customer needs while being committed to the customer first philosophy, including both internal and external customers.
· Proven team player with willingness to learn and help others.
· Proven ability to keep information confidential.
· Detail oriented and highly organized; perform duties with a high level of accuracy.
· Effective interpersonal skills; ability to communicate effectively and professionally with all levels of the organization.
· Excellent oral and written communication skills. Ability to communicate technical issues clearly.
· Excellent time management skills to complete all responsibilities. Ability to identify and eliminate low return tasks.
· Exhibit the ability to improvise, adapt, and overcome unforeseen obstacles to achieve desired results.
· Excel at working independently; ability to handle responsibilities and/or problems with little supervision.
Why Brinker
We offer a competitive benefits package including medical/dental/vision, life insurance, paid vacation/holidays, and 401(k) with company match and generous dining discounts. Every team member working at the Restaurant Support Center (aka Brinker headquarters) is eligible for annual bonus potential.
Our campus includes an onsite gym plus opportunities to increase your wellbeing with onsite Yoga and boot camp programs. Work/Life/Fun balance in a casual and collaborative work environment! Team members enjoy company-wide events and celebrations. Regular volunteer opportunities with our community give back programs
Check our Careers page for more exciting opportunities! Brinker Careers
Join our talent communities! Brinker LinkedIn
#LifeisShortWorkHappy
#brinkerjobs
#brinkerhead