Data Engineer at ThompsonGas LLC

Frederick, Maryland, United States -

Full Time

Start Date

Immediate

Expiry Date

25 Aug, 26

Salary

75000.0

Posted On

27 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Sql, Data Modeling, Etl, Python, Azure Synapse, Sap Datasphere, Data Warehousing, Api Integration, Relational Databases, Analytical Problem Solving, Technical Documentation, Uat

Industry

Oil and Gas

Description

ThompsonGas is the nation’s fastest growing propane retailer, and we are looking for innovative, outside of the box thinkers who want to make an impact. We are rethinking the way we do business and, as a result, our employees are empowered to take an idea and run with it. If you are looking for an environment that will allow you the freedom to drive change, create an unrivaled customer experience and have fun while you’re doing it – then ThompsonGas is for you! Essential Job Duties: * Collaborate with key stakeholders in various departments to translate complex business activities into robust data models that power downstream business intelligence tools, reporting, and analytics. * Develop and maintain scalable data pipelines and API integrations to support continuing increases in data volume and complexity. * Script well-performing queries in SQL and conduct UAT on database objects for use in downstream analytics. * Perform research on the root cause of data anomalies uncovered through the normal course of analysis and provide solutions. * Stay up to date with the latest features, updates, and industry trends related to all current ThompsonGas data systems to propose enhancements and improve data warehousing capabilities. * Resolve tickets about data or performance issues related to Business Intelligence deliverables and systems. * Participate in multiple enterprise-wide projects by providing data expertise to project leaders. * Create clear and comprehensive internal documentation for data processes, methodologies, and systems, ensuring that technical information is accessible and understandable for all relevant stakeholders. * Provide support and training to team members to enhance their ability to utilize data in reporting. * Collaborate with IT department in maintenance on SQL Server, Azure Synapse, SAP Datasphere, and all other ThompsonGas data management software. * Assist in maintenance and monitoring of data security within ThompsonGas data warehousing ecosystem. Education and Experience: * Bachelor’s degree in Computer Science or a related field, or 4+ years of comparable industry experience. * A solid understanding of Relational Databases, Data Warehousing, and ETL concepts required. * Advanced SQL development experience required. * Python development experience preferred. * Experience with Azure Synapse preferred. * Experience in SAP Datasphere is a plus. * Ability to assess and learn new data processing and management software. * Strong analytical and problem-solving abilities. * Excellent verbal and written communication skills. * An understanding of the Propane industry is a plus! PERKS WITH US! * Medical, Dental, Vision, and 401k with IMMEDIATE eligibility * Disability and life insurance * Paid time off that increases with tenure * Daily Pay Option that offers great flexibility and financial control * Employee training programs with career development/advancement opportunities * Employee recognition program * Quarterly bonus potential * Paid maternity and parental leave benefits * Tuition reimbursement program ThompsonGas provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, ThompsonGas complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, and transfer, leaves of absence, compensation and training.

Responsibilities

The role involves collaborating with stakeholders to create robust data models and scalable data pipelines to power business intelligence and analytics. Additionally, the engineer will maintain data warehousing systems, resolve performance issues, and provide technical documentation and training.