Job Description
KAYGEN is an emerging leader in providing top talent for technology-based staffing services. We specialize in providing high-volume contingent staffing, direct hire staffing and project-based solutions to companies worldwide ranging from startups to Fortune 500 and Managed Service Providers (MSP) across a wide variety of industries.
Title: Technical Engineer Contractor
Duration: Through 5/1/27
Location: Hybrid in Dallas, TX or Jersey City, NJ
The Role
We need a hands-on Technical Lead to own our PostgreSQL data warehouse end to end. You will lead onshore and offshore development and PROD support teams, make architectural decisions, resolve upstream and downstream data issues, and work directly with business stakeholders to deliver reliable analytical reporting.
Responsibilities
- Lead: Guide offshore development and PROD teams through sprint planning, code reviews, release readiness, and incident management.
- Architect: Recommend and decide on data models (star/snowflake, Data Vault, ODS), partitioning, and performance strategy. Set standards for PL/pgSQL, ETL, logging, and reconciliation.
- Build: Develop complex PL/pgSQL procedures and functions, and optimize high-volume batch and incremental ETL/ELT pipelines. Build the analytical reporting layer (aggregates, materialized views, reporting datasets).
- Own data quality: Triage upstream issues (late or bad feeds, schema changes), manage downstream impact on reports and extracts, and deliver root-cause fixes with proactive checks and alerts.
- Partner with the business: Translate requirements into solutions and communicate risks and status clearly to senior stakeholders.
- PostgreSQL core: Internals (MVCC, WAL, autovacuum, query planner), PL/pgSQL (dynamic SQL, exception handling, cursors), advanced SQL (recursive CTEs, window functions, MERGE/ON CONFLICT, JSONB), triggers, materialized views, COPY bulk loading
- Performance tuning: EXPLAIN (ANALYZE, BUFFERS), pg_stat_statements, indexing (B-tree, GIN, GiST, BRIN, partial), declarative partitioning with pg_partman, bloat management, config tuning
- Extensions: postgres_fdw, file_fdw, pg_cron, pg_trgm, pgcrypto, pg_repack
- HA and DR: Streaming and logical replication, Patroni/repmgr, PgBouncer/pgpool-II, pgBackRest/Barman, PITR, pg_upgrade
- Security and monitoring: RBAC, row-level security, pgaudit, pgBadger, Prometheus/Grafana, and managed Postgres (AWS RDS/Aurora, Azure, Cloud SQL/AlloyDB)
- Data warehousing and ETL: Dimensional modeling, SCD types, CDC, reconciliation frameworks, orchestration (Airflow or equivalent), Oracle-to-PostgreSQL migration (Ora2Pg)
- Leadership: Proven record leading offshore dev and PROD teams, strong stakeholder management, and a calm, ownership-driven approach to production incidents
Rate: $50 - 65
At KAYGEN, people are at the heart of everything we do. We foster a diverse, inclusive, and employee-driven culture where every individual is valued, empowered, and encouraged to bring their authentic self to work. Our candidate-first approach means we are committed to understanding your career goals and connecting you with opportunities that align with your aspirations, skills, and potential. Whether you're taking the next step in your career or searching for your dream opportunity, KAYGEN is more than a staffing partner—we're a community dedicated to helping you grow, succeed, and thrive. Join us and discover a place where your talent is recognized, your ambitions are supported, and your future is built alongside a team that invests in your success every step of the way.
Our team of experienced staffing experts will work with you to find you the best opportunity. For more information, please visit us at www.kaygen.com.
Benefits:
- Free Healthcare Insurance
- 401(k) Retirement Plan
- Free Life Insurance
- Sick Time Off
- Mentorship Program
- Certifications
- Referrals
- Family and Wellness benefits
- Continuous Growth and Career Development
Numbers & Facts
| Location | Dallas, TX |
| Industry | Computer/IT Services |
| Salary | $50–$65 Per Hour |
| Company Size | 100 to 499 employees |
| Year Founded | 2003 |
| Website | http://www.kaygen.com |
Benefits
Paid Sick Days, Professional Development, 401K, Employee Referral Program, Flexible Spending Accounts, Employee Events, Life Insurance, Merchandise Discounts
About Company
Kaygen, an award-winning technology consulting and talent firm, assists organizations to achieve digital transformation. From structuring data to the Cloud and visualization, Kaygen leads the digital transformation of global clients.
Kaygen, from the Japanese word, kaizen, for continuous improvement, signifies how we continuously seek to bring expert tech talent to our client engagements to create a sustainable competitive advantage. However, there is more. Our company is diverse, and minority woman owned and operated by expert data technologists who have conceived and developed the very strategic technology initiatives that we now engage in for our clients with our talent.
Our core belief in diversity, complemented by the principles of kaizen, ensures we bring the best expert data talent to work transparently, collaboratively, and with the flexibility to ensure client success.
Visit http://www.kaygen.com/ for a solutions overview.
.
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesResume Builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Resume Builder