Data Engineer

SummaryWe are seeking a highly skilled Data Engineer to build and manage our data infrastructure. The ideal candidate will be an expert in writing complex SQL queries, designing efficient database schemas, and developing ETL/ELT pipelines. You will ensure data is accurate, accessible, and optimized for performance to support business intelligence, analytics, and reporting needs.Key ResponsibilitiesDatabase Design & Management: Design, develop, and maintain relational databases (e.g. SQL Server, ProgressSQL, Oracle) and cloud-based data warehouses.Strategic SQL and Data Engineering: Develop sophisticated, optimized SQL queries, stored procedures, and functions to process and analyze large, complex datasets for actionable business insights.Data Pipeline Automation & Orchestration:Help build, automate, and orchestrate ETL/ELT workflows utilizing SQL, Python, and cloud-native tools to integrate and transform data from diverse, distributed sources.Performance Optimization: Tune queries and optimize database schema (indexing, partitioning, normalization) to improve data retrieval and processing speeds.Data Integrity & Security: Ensure data quality, consistency, and integrity across systems. Implement data masking, encryption, and role-based access control (RBAC).Documentation: Maintain technical documentation for database schemas, data dictionaries, and ETL workflows.Required Skills and QualificationsEducation: Bachelor’s degree in computer science, Information Systems, or a related field.SQL Mastery: 5+ years of experience with advanced SQL (window functions, CTEs, query optimization).Database Expertise: Deep understanding of relational database management systems (RDBMS) and data modeling techniques.Cloud Platforms: Demonstrated experience with Azure Data Services and other data warehouse technologies.Programming: Proficiency in Python for scripting and data manipulation.ETL Tools: Familiarity with tools like SSIS or Azure Data Factory.Soft Skills: Strong analytical thinking, problem-solving, and communication skills.Nice to HaveExperience with NoSQL databases (Cosmos DB, MongoDB).Experience with big data frameworks (Apache Spark, Kafka).Relevant certifications (e.g., Microsoft Certified: Azure Data Engineer Associate, Google Professional Data Engineer).Typical Work EnvironmentTools Used: SQL IDEs (DBeaver, SSMS), Cloud Consoles, Git, Jira, SSIS.Industry: Leasing.Salary is $130-$140k