Kennesaw State University · 2 weeks ago
Data Infrastructure Engineer
Kennesaw State University is one of the largest public institutions in the country, focused on academic excellence and innovative research. The Data Infrastructure Engineer will build and maintain data infrastructure, ensuring secure and efficient data transfer for enterprise reporting and analytics.
Education
Responsibilities
Develops, tests, and implements data pipelines to efficiently, securely, and reliably ingest data from various data sources into the enterprise data lake or data warehouse
Collaborates with data architects and data source SMEs to understand requirements and designs data pipelines accordingly
Develops and maintains robust data integrity checks, ensuring data accuracy, timeliness, and consistency
Utilizes cloud tools and custom scripts for validation, set up automated anomaly detection, and collaborates with stakeholders to align quality checks with data requirements
Enables integration of data from various data sources, such as databases, cloud services and APIs, to facilitate seamless data flow for enterprise and self-service reporting and analytics
Monitors and optimizes data pipelines, identifies and troubleshoots issues using tools such as Azure Monitor or similar system
Implements automated alerts and collaborates with architects to adopt best practices in pipeline design for enhanced performance
Maintains compliance with data security policies and regulations in the data infrastructure
Implements encryption, manage access controls, conduct security audits, and stay updated with security best practices to safeguard data integrity and privacy
Manages the storage structure within the data lake or data warehouse, optimizing resource utilization and ensuring efficient integration with data transformation and modeling processes
Supports senior technical staff in project planning and the development of standard operating procedures
Contributes to the establishment of best practices, ensuring project alignment with technical standards and organizational goals
Creates and regularly updates technical documentation for data pipeline processes
Ensures clear, comprehensive, and accessible documentation is available, covering all aspects of pipeline design, operation, and maintenance
Qualification
Required
High school diploma or equivalent
Five (5) years of related IT experience
Commitment to continuous learning and staying updated with the latest trends and best practices in data engineering
Able to handle multiple tasks or projects at one time meeting assigned deadlines
Familiarity with data protection and privacy laws and regulations (i.e., FERPA, HIPAA, etc.)
Knowledge of various file formats used in data storage, like parquet, avro, csv, etc., and their implications on performance and storage
Understanding of cloud storage services, such as blob storage, data lakes, data lakehouses, and data warehouses
Understanding of data warehouse architecture patterns (e.g., Medallion Architecture, OBT, Materialized View Pattern, Star-Schema, etc.)
Knowledge of data warehousing principles, including data quality, data enrichment and standardization, and data modeling
Knowledge of data warehouse architecture patterns, such as star schema, One Big Table (OBT), materialized view architecture, etc
Knowledge of best practices in data pipelines orchestration
Knowledge of data security practices, including encryption/decryption, and compliance with data governance policies and guidelines
Excellent interpersonal, initiative, teamwork, problem solving, independent judgment, organization, communication (verbal and written), time management, project management and presentation skills
Demonstrated skills in relational databases (e.g., SQL Server, Oracle, MySQL, etc.)
Demonstrated skills in data engineering tools (e.g., Azure Data Factory, SSIS, Informatica, Pentaho, Oracle Data Integrator, etc.)
Skills in identifying bottlenecks in data pipelines and optimizing for efficiency and scalability
Skills in developing efficient and scalable data ingestion pipelines between cloud-based and on-premises data sources and destinations
Proficient with computer applications and programs associated with the position (i.e., Microsoft Office suite and other collaboration tools)
Proficiency with SQL and its variants (e.g., PL/SQL, T-SQL, etc.)
Proficiency in programming/scripting languages (e.g., Python, Java, PowerShell, etc.)
Proficiency in data engineering technologies and tools (e.g., Azure Data Factory, Apache Spark, Azure Synapse Analytics, Python, Airflow, etc.)
Strong attention to detail and organization skills
Strong customer service skills and phone and email etiquette
Preferred
An undergraduate or advanced degree from an accredited institution of higher education in Computer Science, Information Systems, Business Administration or related field
Experience working with reporting tools such as Power BI, Tableau, etc
Previous work experience in Higher Education
Company
Kennesaw State University
Kennesaw State University is a public, coeducational, comprehensive university located in Kennesaw, Georgia
H1B Sponsorship
Kennesaw State University has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (32)
2024 (30)
2023 (26)
2022 (19)
2021 (24)
2020 (43)
Funding
Current Stage
Late StageTotal Funding
$0.31MKey Investors
National Cemetery Administration
2024-06-17Grant· $0.31M
2022-03-02Grant
Leadership Team
Recent News
News-Medical.Net
2025-11-23
Company data provided by crunchbase