[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