Position Title: Enterprise Data ArchitectPosition Summary:The Enterprise Data Architect plays a pivotal role in shaping the future of our data landscape. The Enterprise Data Architect is responsible for architecting, implementing, and optimizing enterprise-grade data solutions that leverage the power of SQL Server, Azure Cloud, and Snowflake. A trusted advisor to stakeholders, the Enterprise Data Architect collaborates closely with business leaders, developers, and IT teams to ensure data is accessible, reliable, and drives informed decision-making across the organization.Essential Duties and Responsibilities: (List in order of importance the essential functions of the job and the approximate percentage of time spent on each of the activities; describe what must be accomplished, not how it must be done; include supervision or management responsibilities, quality and quantity standards, physical, mental, and perceptual functions of the job)Designs, develops, and implements enterprise data architectures that meet business needs and complies with data governance standards. Leads the migration of on-premises data to Azure Cloud, including SQL Server databases and data warehouses. Designs and implements data lakes and data warehouses using Snowflake, ensuring scalability, performance, and cost-efficiency. Develops and maintains data pipelines and Extract Transform Load/Extract Load Transform (ETL/ELT) processes for data integration and transformation. Defines data models, schemas, and security protocols to ensure data integrity and access control. Collaborates with stakeholders to understand business requirements and translate them into technical data solutions. Monitors and optimizes data platform performance, identifies, and troubleshoots data quality issues. Stays abreast of the latest data engineering trends and technologies and applies them as appropriate and in alignment with enterprise data strategy.Minimum Qualifications:Education:
Bachelor's degree in Computer Science, Information Technology, or related field.
Ten plus years of relevant experience in data architecture and design.
Experience with data warehousing concepts, including dimensional modeling and data governance.
Strong experience with SQL Server, including database administration, T-SQL scripting, and data modelling.
Experience with Azure Data Factory, Azure Databricks, and Power BI.
Experience with Agile development methodologies.
Knowledge, Skills, and Abilities:
Strong programming skills in languages such as Python, Java, or Scala.
Strong understanding of cloud-based platforms, preferably Azure Synapse Analytics and Snowflake preferred.
Proven ability to build data pipelines and framework for a scalable solution to support the dynamic cloud environment.
Ability to work independently and as a part of a cross-functional team.
Excellent communication, collaboration, and problem-solving skills.
Familiarity with data security and compliance regulations (HIPAA, GDPR, etc.)
Physical Demands and Work Environment:(The physical demands and work environment characteristics described herein are representative of those that must be met by an employee to successfully perform essential functions of this position and/or may be encountered while performing essential functions. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)
While performing the essential duties of this position, an employee would frequently be required to stand, walk, and sit.
Specific vision abilities required by this position include close vision, distance vision, and the ability to adjust focus.
The noise level in the work environment is usually moderate.
Our company offers a dynamic hybrid work arrangement, which requires three days on-site, in the Sugar Land, TX office.
Disclaimer:The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.Texas Dow Employees Credit Union is an equal opportunity employer, dedicated to a policy of non-discrimination in employment on any basis including race, color, age, protected veteran status, sex, religion, disability, genetic information, national origin or other status protected by federal, state or local law. Consistent with the American Disabilities Act, applicants may request accommodations needed to participate in the application process.
