Data Engineer – Snowflake

This is a fully remote position, open to applicants in Texas.

📋 Description

• Engage in in-depth discussions with business stakeholders to comprehend reporting requirements, data extraction needs, and subsequent data usage patterns.

• Create reverse-engineering documentation for existing data extracts to facilitate business reporting and extraction requirements.

• Design and execute ETL/ELT pipelines that transfer data into Snowflake utilizing approved tools and methodologies.

• Convert business needs into functional and technical specifications for upcoming self-service analytics.

• Collaborate with data engineers and architects on data modeling, schema design, and transformation logic within Snowflake.

• Create new database schemas that align with business and technical specifications.

• Ensure data quality and reconcile source-to-target outcomes across Mainframe, Lonestar, Open Systems, and Snowflake environments.

• Formulate data conversion and system implementation strategies and secure approval for system and programming documentation.

• Assist in the development of Power BI datasets, semantic models, and dashboards, using Snowflake as the primary data source.

• Resolve data issues throughout the pipeline from Lonestar or Open Systems extraction to Snowflake loading and Power BI visualization.

• Document technical processes, data flows, and system dependencies.

• Participate in code reviews, testing phases, and production support tasks.

• Offer technical guidance, support, and recommendations regarding report development.

⛳️ Requirements

• 8 years of practical experience with Snowflake, including SQL, data loading, transformations, and performance optimization.

• 4 years of experience with ETL/ELT concepts, data pipelines, and data integration techniques.

• 5 years of experience in analyzing complex data flows and troubleshooting issues across various systems.

• 4 years of experience with enterprise information management processes and methodologies, relational database management systems, and metadata management.

• 2 years of experience in fast-paced and evolving environments, meeting project deadlines, analyzing complex information, and developing strategies to resolve identified issues.

• 2 years of experience leveraging interpersonal skills, including collaborating with individuals under pressure, negotiating among multiple parties, resolving conflicts, and maintaining effective working relationships with personnel at various levels.

• Previous experience with the Railroad Commission of Texas or a background in the oil and gas industry is highly preferred.

• 3 years of experience with Informatica, Matillion, Azure Data Factory, or similar data integration tools is preferred.

• A degree from an accredited four-year college or university with major coursework in data processing, computer science, business administration, or a related field is preferred.

• Candidates must possess authorization to work in the U.S.

• Availability to work outside of regular business hours, including weekends, evenings, and holidays may be required.

🏝️ Benefits

• Work remotely from home.

• Monday to Friday, 8:00 AM to 5:00 PM schedule.

• Excludes State holidays.