This job is closed
We regret to inform you that the job you were interested in has been closed. Although this specific position is no longer available, we encourage you to continue exploring other opportunities on our job board.
MMC Group - Austin, TX
posted 19 days ago
About the position
The Senior Software Engineer specializing in Applications/Software Development - Snowflake is responsible for designing and optimizing data structures, creating blueprints for data storage and processing, and ensuring the efficient use of Snowflake's features. This role involves collaborating with data engineers, scientists, and analysts to meet their requirements while implementing secure data access strategies and optimizing performance. The position is remote, with a preference for candidates in the Austin, TX area, and is set to last from January 20, 2025, to August 31, 2025.
Responsibilities
- Design and optimize data structures, ensuring full utilization of Snowflake's features.
- Create blueprints for data storage, processing, and access within Snowflake.
- Optimize data pipelines and workflows for performance, scalability, and cost-efficiency.
- Design and optimize ETL/ELT processes and data storage strategies.
- Integrate Snowflake with other cloud services, third-party tools, and on-premises systems.
- Implement strategies for secure data access, including encryption and role-based access control.
- Collaborate with data engineers, scientists, and analysts to meet their requirements.
- Monitor and optimize Snowflake performance, automating tasks with SQL and scripting languages.
- Manage Snowflake Virtual Warehouses and configure alerts for data pipeline issues.
Requirements
- 8+ years of experience in data modeling, integration, warehousing, governance, and security.
- Proficiency in Snowflake architecture and components, including databases, procedures, tasks, and streams.
- Expertise in Snowflake cloning, warehouse management, and performance optimization.
- Experience with Snowflake RBAC, SSO, SCIM, and data integration tools like Informatica and ADF.
- Strong technical writing and diagramming skills, with proficiency in tools like Visio and Erwin.
- Experience on agile sprint teams and with JIRA software.
- Knowledge of Informatica 10.5 and Cognos Analytics 11.1.
Nice-to-haves
- Familiarity with CI/CD pipelines.
- Healthcare industry experience.
- Working with PII or PHI data.
- Prior experience with HHS agencies, HL7 data, and Azure.
- Bachelor's degree in computer science, information systems, or a related field.
