VP, Senior Data Engineer responsible for designing and developing cloud data solutions for insider risk in Information Security at SMBC. Collaborating with multiple teams to enhance cybersecurity data platform.
About the role
- Data Engineer responsible for designing, building, and optimizing data systems at a leading trading platform. Managing PostgreSQL environments and Airflow pipelines for regulatory reporting and analytics.
Responsibilities
- Design, implement, and optimize database objects and complex PL/pgSQL procedures to support regulatory reporting use cases.
- Build and maintain robust DB dependencies: primary/foreign keys, constraints, triggers, partitions, and scheduled maintenance routines.
- Own Postgres performance and hygiene: capacity planning, index maintenance, partition strategy, VACUUM/ANALYZE, and systematic tuning using EXPLAIN and pg_stat_statements.
- Develop, schedule, and operate data pipelines as DAGs (in Airflow): ingestion, transformations, validations, and deliveries to reporting targets.
- Implement proactive alerting and on-failure workflows.
Requirements
- 2+ years’ experience as a Data Engineer (or similar) working heavily with PostgreSQL.
- Expert SQL and strong PL/pgSQL: able to design, implement, and maintain complex stored procedures/functions.
- Deep PostgreSQL fundamentals: schema design and normalization, indexing strategies, constraints (PK/FK/UNIQUE/CHECK), triggers, table partitioning.
- Experience with EXPLAIN/ANALYZE, query optimization, VACUUM/ANALYZE, bloat detection/mitigation, and use of pg_stat_* views.
- Experience building and operating DAGs (Apache Airflow), including SLAs, retries, and dependencies.
- Experience with Version control & CI/CD (GitHub/GitLab), code reviews.
- Data quality and governance mindset: validation checks, lineage/documentation, and auditability.
- Nice to have domain familiarity with reporting in fintech/brokerage (e.g., trade/transaction reporting for CFD brokers; understanding of controls, reconciliations, and audit needs).
Benefits
- Competitive Salary: We believe great work deserves great pay! Your skills and talents will be rewarded with a salary that makes you feel valued and motivated.
- Work-Life Harmony: Join a company that genuinely cares about *you*—because your life outside of work matters just as much as your time on the clock.
- Annual Performance Bonus: Your hard work doesn’t go unnoticed! Celebrate your achievements with a well-deserved annual bonus tied to your performance.
- Generous Time Off: Need a breather? Our annual leave policy lets you recharge and enjoy life outside of work without a worry.
- Employee Referral Program: Love working here? Share the love! Bring your talented friends on board and get rewarded for growing our awesome team.
- Comprehensive Health & Pension Benefits: From medical insurance to pension plans, we’ve got your back. Plus, location-specific benefits and perks!
- Workation Wonderland: Live your digital nomad dreams with 30 extra days to work remotely from anywhere in the world (some restrictions apply). Adventure awaits!
- Volunteer Days: Make a difference! Take two additional paid days each year to support causes you care about and give back to the community.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
No Education Requirement
Tech skills
Location requirements
Data Engineer responsible for architecting, developing, and maintaining Allegiant’s enterprise data infrastructure. Overseeing transition to cloud hosted data warehouse and developing next - generation data tools.
Senior Data Engineer developing Azure - based data solutions for clients in the Data & AI department. Collaborating with architects and consultants to enhance automated decision making.
Data Engineer II focusing on strategic ingestion product for Travelers. Building data solutions and collaborating across teams to support analytic transformation.
Data Engineer at Tatum focusing on scalable data solutions and blockchain technology. Collaborating with teams to ensure data integrity and manage data infrastructure in a hybrid setup.
Senior Lead Data Engineer at Capital One collaborating with Agile teams and mentoring developers. Leading full - stack development and driving cloud - based solutions for financial empowerment.
Senior Data Engineer responsible for developing data pipelines and collaborating with US business teams. Working at Beghou Consulting, a life sciences company providing advanced analytics and technology solutions.
Data Solutions Architect designing enterprise - scale Azure and Databricks Lakehouse solutions for clinical trials and life sciences data enabling advanced analytics and compliance.
Data Architect at ADEO ensuring interoperability of IT systems through architecture design and data knowledge diffusion. Collaborating with teams to maintain data integrity and quality standards in an international setup.
Consultant, Data Engineer leading end - to - end data solutions and analytics. Collaborating with clients to improve data strategies and deliver actionable insights.