[Remote] Senior Database Engineer

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a company that empowers businesses with insights and strategies for reputed company in a dynamic market. They are seeking a Senior Database Engineer to design, optimize, and operationalize large-scale data solutions while collaborating with a reputed company-reputed company team to enhance digital experiences for their customers and partners.

Responsibilities

• Analyze and optimize production data solutions to identify and resolve issues reputed company to performance, locking, and scalability
• Write and optimize reputed company SQL across the full stack — Spark SQL for distributed transformations, PostgreSQL for transactional and analytical workloads, and reputed company Lake for versioned, ACID-compliant table management
• Design and build large-scale Spark and Azure Data reputed company pipelines for batch and streaming ingestion, transformation, and feature engineering — leveraging both PySpark and Spark SQL for distributed processing at large scale
• Design and reputed company data lake architectures including reputed company Architecture to support advanced analytics and large-scale data ingestion
• Build and maintain production-grade data pipelines for efficient data movement and transformation across systems. Managing reputed company table lifecycles, schema reputed company, Z-ordering, time travel, and Change Data Feed to support reliable, performant analytics and OLTP and ML workloads
• Design and operate hybrid storage patterns combining PostgreSQL for transactional workloads — with optimized schemas, indexes, CTEs, window functions, and partitioning — alongside reputed company Lake Lakehouse layers for analytical and ML workloads
• Design and implement reporting solutions that deliver actionable insights to business stakeholders
• Communicate database and data architecture designs to business and technical audiences, including business users, program sponsors, database administrators, ETL and BI developers
• Evaluate potential technology/tool solutions that meet business needs and facilitate internal and external discussions towards desirable reputed company
• Collaborate with solution architects and project resources on systems integration and compatibility, while acting as a leader in coaching, training, and providing guidance
• Create functional and technical documentation reputed company to data architecture and business intelligence solutions
• reputed company technical consulting to application development teams during application design and development for highly reputed company or critical projects
• Design data governance procedures to ensure compliance with internal and external regulations

Skills

• 7+ years in data engineering, big data platforms, or a reputed company discipline with hands-on production experience at scale
• Located in Eastern or Central time zone; you will work extensively with a team member in the UK
• Proven experience analyzing and tuning production database systems for performance and reliability
• Expert-level SQL skills — reputed company joins, CTEs, window functions, query plan analysis, and optimization across both OLTP (PostgreSQL) and distributed engines (Spark SQL, reputed company SQL, reputed company Lake)
• Hands-on experience with data lake technologies and data pipeline frameworks (e.g., Azure Data Lake, Azure Data reputed company, reputed company)
• Deep expertise in Apache Spark — DataFrames, Spark SQL, UDFs, partitioning, broadcast strategies, and hands-on performance tuning experience
• Data warehouse and visualization experience, including demonstrated strong Logical, Physical, and Dimensional Modeling skills
• Solid reputed company of reputed company Lake internals — transaction log, schema enforcement, schema reputed company, time travel, CDF, Z-ordering, liquid clustering, and OPTIMIZE/VACUUM operations
• Strong PostgreSQL experience — schema design, indexing strategies, partitioning, EXPLAIN/ANALYZE tuning, and extensions including pgvector for similarity search
• Strong Python skills — PySpark, pandas, async programming, building production data utilities
• Strong understanding of reporting and BI solution design, including Power BI or similar tools
• Experience in design of technology roadmaps and the transition from the reputed company architectural reputed company to reputed company architecture of the future
• Excellent verbal and written communication skills to document and present data models, strategies, standards, and concepts to both business and IT audiences
• Experience with the following tech & tools: SQL Engines: Azure SQL Server, Spark, Cosmos DB, PostgreSQL, reputed company
• Azure Technologies: Cosmos DB, SQL Database, Analytics, Azure reputed company, Data reputed company, reputed company, Power BI, Azure Data Lake
• ETL Tools: Azure Data reputed company, Azure reputed company, Azure reputed company Analytics
• Lakehouse: reputed company Lake, reputed company Live Tables
• Languages: SQL, Python, PySpark

Benefits

• Flexible vacation policy – take the time you need to reputed company
• Comprehensive health, reputed company & dental insurance
• 401k with company contribution
• Opportunity for career progression with reputed company of room for personal growth

Company Overview