IT Lead Data Solutions Architect

Trinity River Authority Of Texas • Arlington, TX

391d

About The Position

The Lead Data Solutions Architect is responsible for designing and managing data architecture, implementing data warehousing solutions, and ensuring high data quality and system performance. This role centralizes data into a unified repository, creates complex reports and dashboards for actionable insights, and enhances data-driven decision-making to improve operational efficiency and support regulatory compliance.

Requirements

• Bachelor's degree in computer science, Computer Engineering, Management Information Systems, Data Science, Cybersecurity, or related field.
• Minimum of 4 years of experience in data management, data warehousing, data integration, data modeling, ETL processes, and data analytics.
• CompTIA Security+ certification (Required).
• Valid Texas Driver's License (Required).
• Relevant certifications such as Certified Data Management Professional (Preferred).
• Additional IT, Cybersecurity, or Project Management Certifications (Preferred).
• In-depth understanding of data warehousing concepts, architecture, and implementation.
• Comprehensive knowledge of ETL (Extract, Transform, Load) processes, tools, and techniques for data integration.
• Expertise in data modeling methodologies and best practices for designing and optimizing data structures.
• Proficiency in various database management systems (DBMS) such as SQL Server, Oracle, and others.
• Strong grasp of data analytics, including statistical analysis, predictive modeling, and data visualization.
• Familiarity with business intelligence (BI) tools like Tableau, Power BI, or similar platforms for creating reports and dashboards.
• Knowledge of programming languages such as SQL, Python, or R for data manipulation and analysis.
• Familiarity with big data technologies and frameworks.
• Knowledge of secure development principles and the application of cybersecurity in a data management and/or cloud environment.

Nice To Haves

• Relevant certifications such as Certified Data Management Professional.
• Additional IT, Cybersecurity, or Project Management Certifications.

Responsibilities

• Design and Develop Data Architecture: Create and maintain a robust data architecture framework that supports the organization's data warehousing, integration, analytics, and future data needs.
• Implement Data Warehousing Solutions: Establish and manage a centralized data warehouse to integrate data from multiple systems and ensure a unified and accessible data repository.
• Extract, Integrate, and Model Data: Perform data extraction, integration, and modeling tasks to consolidate information, optimize data structures, and ensure effective analysis and reporting.
• Develop and Execute Data Management Strategy: Create and implement a comprehensive data management strategy, including governance, quality, security, and lifecycle management, to ensure data consistency and reliability.
• Leverage Cloud Solutions for Big Data: Design and deploy cloud-based solutions for big data storage, processing, and analytics, ensuring scalability, security, and cost-effectiveness.
• Produce Reports and Dashboards: Generate and maintain standardized reports and interactive dashboards to provide actionable insights and support data-driven decision-making.
• Monitor Data Quality and System Performance: Continuously oversee and improve data quality, system performance, and reliability, addressing issues as they arise.
• Provide Technical Expertise and Guidance: Serve as a technical advisor, offering guidance on tools, processes, and design for data-related projects across the organization.

Benefits

• Competitive starting salary range.
• Comprehensive benefits package including insurance programs, savings programs, paid time off and holidays.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Waste Management and Remediation Services
• Education Level: Bachelor's degree