Designs and implements Snowflake ETL/ELT pipelines, data models, schemas, and transformations. Partners with stakeholders to define reporting and extract requirements, documents data flows, validates data quality across multiple systems, and supports Power BI datasets, semantic models, and dashboards. Troubleshoots end-to-end data issues, develops implementation plans, participates in testing and code reviews, and provides production support and technical recommendations.
This is a remote position.
The Snowflake Data Engineer will support the Railroad Commission of Texas (RRC). This role works with business stakeholders to understand reporting needs, data extract requirements, and downstream data consumption patterns. The engineer will design and implement ETL/ELT pipelines that move data into Snowflake and will translate business requirements into functional and technical specifications for future self-service analytics. The position also covers documenting existing data extracts, validating data quality across Mainframe, Lonestar, Open Systems, and Snowflake environments, and supporting Power BI reporting built on Snowflake. The engineer will provide technical advice, assistance, and recommendations on report development.
Responsibilities
- Participate in detailed sessions with business stakeholders to understand reporting needs, data extract requirements, and downstream data consumption patterns.
- Develop reverse-engineering documentation for existing data extracts to support business reporting and extract needs.
- Design and implement ETL/ELT pipelines that move data into Snowflake using approved tools and frameworks.
- Translate business requirements into clear functional and technical specifications for future self-service analytics.
- Collaborate with data engineers and architects on data modeling, schema design, and transformation logic in Snowflake, including new database schemas that meet requirements.
- Validate data quality and reconcile source-to-target results across Mainframe, Lonestar, Open Systems, and Snowflake environments.
- Develop data conversion and system implementation plans, and prepare and obtain approval of system and programming documentation.
- Support the creation of Power BI datasets, semantic models, and dashboards using Snowflake as the primary data source.
- Troubleshoot data issues across the full pipeline, from Lonestar or Open Systems extract to Snowflake load to Power BI visualization.
- Document technical processes, data flows, and system dependencies, and participate in code reviews, testing cycles, and production support activities.
Requirements
Minimum Qualifications - Candidates must meet all minimum qualifications
- 8 years of hands-on experience with Snowflake, including SQL, data loading, transformations, and performance tuning.
- 4 years of experience with ETL/ELT concepts, data pipelines, and data integration patterns.
- 5 years of experience analyzing complex data flows and troubleshooting issues across multiple systems.
- 4 years of experience with enterprise information management processes and methodologies, relational database management systems, and metadata management.
- 2 years of experience working in fast-paced, changing environments, achieving project delivery and deadlines, analyzing complex information, and developing plans to address identified issues.
- 2 years of experience applying interpersonal skills, including working with people under pressure, negotiating among multiple parties, resolving conflicts, and maintaining effective working relationships with personnel at various levels.
Preferred Qualifications
- Former Railroad Commission of Texas experience or an oil and gas industry background is strongly preferred.
- 3 years of experience with Informatica, Matillion, Azure Data Factory, or similar data integration tools.
- Graduation from an accredited four-year college or university with major coursework in data processing, computer science, business administration, or a related field.
Additional Requirements
- Candidates must be authorized to work in the U.S.
- The candidate may be required to work outside normal business hours, including weekends, evenings, and holidays, as requested.
Work Location and Schedule
Location: Work from Home.
Schedule: Monday through Friday, 8:00 AM to 5:00 PM, excluding State holidays.
Work Arrangement: Remote.
Similar Jobs
Information Technology • Software • Consulting
Design and optimize Snowflake data models and dbt transformation workflows, modernize Oracle ETL processes, build Python automation, and support scalable data architecture. The role involves troubleshooting data quality and performance issues, contributing to DevOps and deployment activities, owning technical deliverables, and participating in client-facing discussions and solution design.
Top Skills:
DbtEltETLKubernetesOraclePower BIPythonSnowflake
Database • Analytics
Leads the design, development, optimization, and migration of modern data platforms in Snowflake. Builds pipelines with dbt, Python, and cloud services; gathers client requirements; creates solution designs and project plans; advises on Snowflake performance, cost, security, and workload management; integrates BI, governance, and AI/ML tools; contributes to accelerators and mentors junior engineers. The role is remote, client-facing, consultative, and focused primarily on technical delivery rather than sales.
Top Skills:
Apache AirflowAWSAzureCloverdxDbtFivetranGoogle Cloud PlatformInformaticaLookerPower BIPythonSnowflakeSnowparkSnowpipeSQL
Artificial Intelligence • Cloud • Information Technology • Consulting
Design and optimize Snowflake data warehouses, dbt transformation models, and scalable ETL/ELT pipelines. Develop ingestion utilities, improve SQL and warehouse performance, establish data quality and governance controls, and maintain CI/CD workflows using Git. Collaborate with analysts, data scientists, and business stakeholders across manufacturing, supply chain, and operations. The role also supports modern DataOps practices and may involve orchestration tools and cloud platforms.
Top Skills:
Apache AirflowAWSAzureDagsterDbtGCPGitGithub ActionsGitlab CiOraclePrefectPythonSAPScalaSnowflakeSQL
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
