Data Developer / Princ Engr - Data Engineering (ETL)

Location: Irving, TX 75038 (Hybrid – 3 days in office)

Duration: 24 months (possible extension)

Description: We are seeking a skilled Data Developer to join our team. The ideal candidate will have expertise in designing, implementing, and maintaining ETL/ELT processes to facilitate data integration, migration, and transformation. This role requires proficiency in both cloud and local solutions, as well as a strong understanding of database management systems, data warehousing concepts, Python scripting, dbt (data build tool), and spatial data sources.

Responsibilities: Design, develop, and maintain ETL/ELT processes to extract data from various sources, transform it according to business requirements, and load it into target databases/data warehouses. Collaborate with stakeholders to understand data integration needs and translate them into ETL requirements. Implement solutions using both cloud-based platforms (such as AWS, Azure, or Google Cloud) and local solutions (such as Apache NiFi, Talend, Informatica, or custom scripts).Optimize workflows for performance, scalability, and reliability, considering factors like data volume, frequency, and complexity. Ensure data quality and integrity throughout the process by implementing data validation and error handling mechanisms. Monitor jobs, troubleshoot issues, and perform debugging and performance tuning as needed. Document processes, data mappings, and system configurations to maintain comprehensive documentation. Stay updated on industry trends and best practices. Must Have Skills (Most Important):Bachelor's degree in Computer Science, Information Technology, or related field. Proven experience as an ETL Developer or similar role, with a strong understanding of data concepts and methodologies. Proficiency in SQL and experience working with relational databases (e.g., MySQL, PostgreSQL, SQL Server, Oracle).Hands-on experience with tools and frameworks, both cloud-based (e.g., AWS Glue, Azure Data Factory, Google Cloud Dataflow) and local (e.g., Apache NiFi, Talend, Informatica).Proficiency in Python programming language for scripting, automation, and data manipulation tasks. Familiarity with spatial data sources and geospatial analysis tools (e.g., PostGIS, GeoPandas, ArcGIS) for handling location-based data. Strong understanding of GIS (Geographic Information Systems) concepts and spatial data formats (e.g., shapefiles, GeoJSON).Familiarity with data warehousing concepts, dimensional modeling, and data integration patterns. Knowledge of cloud computing platforms and services, including storage, compute, and networking. Strong analytical and problem-solving skills, with the ability to troubleshoot complex data pipeline issues. Excellent communication and collaboration skills, with the ability to work effectively in a team environment and interact with stakeholders at various levels of the organization.