Company Description
WhirlWind Technologies, LLC specializes in management consulting and technology solutions to help clients achieve their goals. We design, build, and manage secure systems that support data-driven decision-making and operational efficiency. As a growth-oriented company rooted in core values, we measure our success by the success of our customers. Our services focus on transforming government processes and enhancing the lives of citizens.
About the Role
We are seeking a Data Engineer to support large, complex data systems and contribute to ongoing database modernization efforts. This role will provide hands-on support for data processing environments that involve frequent import, processing, and export of data products across secure, multi-tenant datastores.
The Data Engineer will also support efforts to migrate legacy Oracle-based systems to PostgreSQL and assist development teams in refactoring data models and schemas as part of broader modernization initiatives.
The engineer will be embedded within project teams to provide critical ETL, data transformation, and migration expertise.
Responsibilities
Data Support & Processing
- Support large, complex data systems with frequent ingestion, processing, and dissemination of data products.
- Work with multi-tenant datastores that require secure and protected access controls.
- Support common and shared data models and schemas across systems.
- Perform in-depth ETL and statistic-driven updates as data is aggregated into data products.
- Perform datastore creation, data migration, data partitioning, and database/datastore optimization activities.
Oracle to PostgreSQL Migration
- Support database migration efforts from Oracle (clustered RDBMS) to more open-source and cloud-friendly technologies, with PostgreSQL as the primary target.
- Assist development teams in architecting data migration strategies.
- Rewrite or update existing Oracle PL/SQL code to function within PostgreSQL and new database/code bases.
- Support testing and validation of migrated data and database logic.
Refactoring Data Models & Schemas
- Support modernization of legacy data processing systems by refactoring data models and schemas into modern equivalents.
- Assist development teams with data migration following schema refactoring.
- Provide hands-on support for ETL and data transformation activities required to align data with new models.
- Collaborate closely with development teams as an embedded Data Engineer to ensure successful data modernization efforts.
Required Qualifications
- Experience supporting large-scale data processing systems.
- Experience with ETL processes and data transformation workflows.
- Experience working with relational databases, including Oracle and PostgreSQL.
- Experience supporting database schema changes and data migrations.
- Ability to work collaboratively as part of an embedded project team.
Preferred Qualifications
- Experience working with multi-tenant datastores and secure data access controls.
- Experience refactoring data models and schemas during system modernization efforts.
- Experience optimizing databases and datastores for performance and scalability.
WhirlWind Technologies, LLC