Enterprise Datawarehouse Architect - Dallas, TX

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 data's accuracy, consistency, completeness, and timelines.

Responsibilities:

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

Required Qualification :

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.