remote
Staff Software Engineer, Data Warehouse - Pivotal Health
Software Engineer
Seeking a Staff Software Engineer with expertise in Data Warehousing to design, build, and maintain scalable data solutions. Leverage Python and SQL to drive data initiatives and optimize data pipelines.
About the role
Key Responsibilities
- Design, develop, and maintain robust and scalable data warehouse solutions.
- Implement and optimize ETL processes for data ingestion and transformation.
- Develop and maintain complex SQL queries and stored procedures.
- Collaborate with cross-functional teams to understand data requirements and deliver solutions.
- Contribute to data modeling and schema design for optimal performance and usability.
- Ensure data quality, integrity, and security across the data warehouse.
Requirements
- Proven experience as a Software Engineer with a focus on Data Warehousing.
- Strong proficiency in SQL and experience with relational databases.
- Experience with ETL tools and methodologies.
- Proficiency in a programming language such as Python for data manipulation.
- Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and their data services.