The Intersect Group is seeking a Senior Database Administrator/Engineer for our direct client, where you will handle the development of all aspects of data processing, including database management, architecture/modeling, and ETL processing. Create and deliver analytical solutions using various tools. Collaborate with corporate data analytics team and business stakeholders to collect requirements and translate them into technical specifications and process documentation. Work on the architecture and development of an event-driven data warehouse, streaming, batch, data modeling, and storage. Provide technical guidance. Review code and test results. Review pull requests and scripts for production development. Work on advanced databases, to write and optimize SQL queries, stored procedures, functions, partition data, indexing, and reading execution plans. Write and debug Python/PySpark scripts to generate extracts, clean, conform, and deliver data for consumption. Implement ETL architecture, data profiling, process flow, metric logic, and error handling. Support continuous improvement by exploring and presenting alternatives to processes and technologies.
REQUIREMENTS:
- Bachelor’s degree in Computer Science or related field
- 7+ years' experience in Data Engineering with expertise in MS SQL Server (SQL, SSRS, SSIS) and Azure Data Services (Storage, Azure Data Factory, Synapse)
- Proven track record in designing and implementing OLTP and OLAP data processing solutions, including data warehouse architecture/modeling and ETL processing
- Expertise in writing and optimizing SQL queries, stored procedures, functions, partitioning data, indexing, and reading execution plans
- Knowledgeable in logical and physical dimensional data modeling, including Snowflake and Star schemas
- Proficiency in Python/PySpark scripting
- Strong written and verbal communication skills