Data Engineer; Tampa

Data Engineer (Tampa)

Company:
Peoples Gas System

Location:

Florida - Tampa

Shift: 8 Hr. X 5 Days

Peoples Gas System is the fastest growing natural gas utility in the Southeast with career opportunities that fit your future. Our organization is diverse – in people, opportunities, and careers. We foster a dynamic and inclusive workplace where safety, innovation and collaboration are at the heart of everything we do.

The Data Engineer – PGS is responsible for the creation, maintenance, and support of the complex computer database systems and data models. Plan, coordinate, and implement schedule updates to the production Business Development data models. Develop and support data sources, data models, connections, ingestion and utilization. Work with development teams, affiliates, business owners and other stakeholders to design, develop and deliver database solutions to the business to enable data migration, governance and management of the organization’s data, analytics, predictive modeling and decision‑making capabilities.

With minimal oversight, independently performs technically complex assignments within established policies and procedures and in compliance with established company standards.

• Bachelor’s degree in Information Technology, Computer Science, Business Administration, Engineering, Mathematics, Information Systems or other related field from regionally accredited college/university.
• 5 years of work experience related to the Duties & Responsibilities of this position, or 2 years as a DBA or Data Engineer.
• Demonstrated database programming language such as Python, R or SQL.
• Demonstrated database management systems such as Oracle, Microsoft SQL Server, SAP HANA and others.
• Cloud data platforms such as Microsoft Azure, Snowflake, Google Cloud Platform, AWS.
• Ability to effectively organize own work and teamwork, maintain an extremely high level of accuracy, check own work and the work of others, and keep accurate and auditable records.
• Demonstrated interpersonal skills, including collaboration and teamwork.

• Perform all database-related activities during application system evaluations, development projects, and subsequent implementations. Identify opportunities to reduce data‑redundancy and utilize single sources of data with integration of systems through database design and access methods. Coordinate and prioritize work assignments based on business and technical requirements.
• Plan and perform database monitoring and tuning activities to ensure optimal performance and response time. Provide consulting and support to systems development team members (and others performing similar functions outside of IT) in efficient SQL and No
  
  SQL coding techniques for optimum database and application performance.
• Create, conceptualize, design and maintain data processes, data reliability, data efficiency, data quality, data storage, data models, data performance, data ingestion, all in support of PGS data and AI strategies for data analytics and data visualization.
• Plan, coordinate, and implement data models and updates into production on a regularly scheduled basis follow PGS and IT standard SDLC and change management processes and procedures.

• Support systems development team members in understanding application data requirements and developing logical database models. Convert logical database designs to physical database models and develop the Data Definition Language (DDL) to create appropriate database objects. Review, test, and make appropriate revisions to vendor-supplied DDL to ensure database integrity.
• Design and implement appropriate database backup and recovery strategies based on requirements provided by systems development team members and IT Business Partners. Perform database recovery and restoration as needed.
• Participate in technical projects that ensure the ongoing integrity of all corporate-wide databases and database architecture. Perform upgrades to DBMS and data integration products, which include impact analysis,…