Data Engineer

Title: Data Engineer Company: Peoples Gas System State and City: Florida - Tampa Shift: 8 Hr. X 5 Days WHO WE ARE? 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. HOW YOU’LL HELP DRIVE THE FUTURE OF NATURAL GAS? The Data Engineer – PGS is responsible for the creation, maintenance, and support 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. WHAT YOU NEED TO SUCCEED? 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. PRIMARY DUTIES & RESPONSIBILITIES Data and AI Design and Development 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 NoSQL 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. Project and Database Support 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, testing, data conversion and implementation. Create and maintain documentation that supports a historical record of changes made to any data model and display for audit purposes. Thought Leadership Maintain knowledge of existing and emerging database technologies and recommends adoption of new technologies where appropriate. Evaluate and recommend database-related products, services, and procedures to enhance productivity and effectiveness. Must maintain sufficient knowledge of the business processes and systems. Evaluate the data modeling team tasks status and resource utilization and recommend changes to improve the team’s effectiveness. Develop training and procedure documentation and materials for the data modeling team and facilitate both formal and informal training. WHAT WILL GIVE YOU A COMPETITIVE EDGE? 2 years of experience with cloud technologies and platforms such as Microsoft Azure, Amazon Web Services (AWS) or Google Cloud Platform (GCP). Demonstrated knowledge of utility industry operations and business processes. Experience working on data modeling teams requiring expert technical skills and solid understanding of business functions. Demonstrated competence with cloud storage, cloud tools and Big Data. WHO WILL BE A PART OF YOUR TEAM? Staff augmentation, contractor and/or technical support team. IT Architects, IT Strategic Planning, Development Staff and Support of various business application towers, Project Management Office, other IT and Business Stakeholders etc. Consultants (System Integrators, Offshore Teams), Contractors, Customers, Vendors. HOW YOU’LL CONTRIBUTE? Cultivates Innovation and Embraces Change. Drives Operational Excellence for Customers. Speaks Up on Safety, Health, and the Environment. Takes Ownership & Acts with Integrity. Think Strategically & Exercises Sound Judgment. WHY YOU’LL LOVE WORKING WITH US? We proudly offer a competitive total rewards package and other perks to help keep you thriving: Performance Bonus: Earn an annual incentive bonus that recognizes your hard work. Comprehensive Health Coverage: Enjoy medical, prescription drug, dental, and vision insurance. Retirement Planning: Secure your future with a 401k Retirement Savings Plan and a comprehensive Pension plan. Ownership Opportunities: Participate in Emera’s Employee Common Share Purchase Plan and share in our success. Time to Recharge: Enjoy Paid Time Off (PTO), paid company holidays, comprehensive mental, financial and physical wellness resources, and paid Parental Leave Growth and Development: Take advantage of tuition reimbursement and other training and development opportunities to enhance your skills and career. And much more! Whether you’re launching your career or looking to advance it, Peoples Gas is the perfect place for you, offering exciting opportunities for a long‑term career with a dynamic, growing company. EMERGENCY RESPONSE REQUIREMENTS TECO Energy and its companies serve a role in providing critical services to our community during an emergency. Team members are required to participate in the response/recovery activities related to emergencies/disasters to maintain service to our TECO Energy customers. Team members are required to work in their normal job duties or other assigned activities. Proper compensation will be made in accordance with the company's rules and procedures. A pre‑employment drug screening, as well as a background check (including education, employment, criminal and motor vehicle) will also be conducted as part of the pre‑employment screening. A physical may be conducted if required for the role. #J-18808-Ljbffr