Data Integration Analyst

Texas Tech University

Texas Tech University is seeking a Data Integration Analyst to play a crucial role in streamlining data systems, ensuring efficient integration, and enhancing communication of data insights. The position involves working with SQL and relational databases to uphold data integrity and accuracy, contributing significantly to the design of dashboards and reports.

In this role you can expect to have the responsibilities:

• Translate raw data from source systems to reporting datasets.
• Design and manage data integrations across systems.
• Create and optimize ETL processes and maintain process schedules.
• Perform in-depth data analysis to identify business trends.
• Ensure data integrity and security using SQL databases.
• Establish data governance policies.
• Monitor and resolve data quality issues.
• Collaborate with teams to meet data requirements.
• Resolve data integration and visualization issues.
• Document data processes and workflows.
• Develop dashboards and reports to visualize business metrics.
• Maintain production, UAT, and sandbox environments.
• Validate transformed data against source reporting platforms.

This role comes with the following benefits:

This role requires you to have:

• Bachelor's degree in a related field.
• Experience in data integration and ETL development.
• Proficiency in SQL and Microsoft SQL Server.
• Strong analytical and problem-solving abilities.
• Skill in data visualization and translation of complex data.
• Communication skills with teamwork capability.

You would benefit from having:

• Experience with cloud-based data platforms.
• Knowledge of data governance best practices.
• Familiarity with data warehousing concepts.
• Certification in data integration or data analysis tools.

This job description outlines general requirements for the position; other duties may be assigned as needed.