Senior Snowflake Engineer
Spectraforce
Denver, Colorado
Remote
3 hours ago
Job Description
Senior Snowflake Engineer
REMOTE (Occasionally travel to Denver to meet team)
12 Months
** While team supports telecommuting / remote work, it is expected that the contractor performs the work within the State of Colorado and preferably in the Denver Metropolitan Area; there will be occasions where the contractor will have to collaborate with their colleagues and attend in-person meetings in one of the State offices**
Position Objective: The team is seeking a highly specialized Senior Operations and Data Engineer to serve as the primary administrator and technical lead for our Snowflake ecosystem. This role is a hybrid of platform operations and high-level data engineering, ensuring that sensitive state and federal data (FTI/CJIS) is managed within a secure, high-uptime, and cost-effective environment.
Preferred Qualifications: To be considered for this role, candidates should provide proof of the following:
Active Snowflake Certification
Background Clearance Readiness: Absolute eligibility to pass OIT, FTI (Federal Tax Information), and CJIS (Criminal Justice Information Services) background checks.
Key Responsibilities:
Platform Operations & Administration
Primary Deliverables:
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 60.00/hr.
REMOTE (Occasionally travel to Denver to meet team)
12 Months
** While team supports telecommuting / remote work, it is expected that the contractor performs the work within the State of Colorado and preferably in the Denver Metropolitan Area; there will be occasions where the contractor will have to collaborate with their colleagues and attend in-person meetings in one of the State offices**
Position Objective: The team is seeking a highly specialized Senior Operations and Data Engineer to serve as the primary administrator and technical lead for our Snowflake ecosystem. This role is a hybrid of platform operations and high-level data engineering, ensuring that sensitive state and federal data (FTI/CJIS) is managed within a secure, high-uptime, and cost-effective environment.
Preferred Qualifications: To be considered for this role, candidates should provide proof of the following:
Active Snowflake Certification
Background Clearance Readiness: Absolute eligibility to pass OIT, FTI (Federal Tax Information), and CJIS (Criminal Justice Information Services) background checks.
Key Responsibilities:
Platform Operations & Administration
- Snowflake Mastery: Act as the lead administrator for Snowflake environments; manage platform uptime, vendor escalations, and patch/versioning communications.
- Environment Provisioning: Configure Snowflake, including complex RBAC (Role-Based Access Control) and security permissions.
- Governance & CI/CD: Implement and manage DataOps and CI/CD pipelines to automate deployments for the broader implementation team.
- Financial Stewardship: Configure cost-management features such as Snowflake resource monitors, budgets, and consumption tracking; consult on chargeback models.
- Pipeline Architecture: Develop robust ETL/ELT pipelines to ingest data from transactional systems (Line of Business) into the analytical Snowflake environment.
- Analytical Modeling: Translate Data Architect visions into technical reality by building complex transformations and target schemas.
- Quality Management: Design and deploy automated data cleansing and quality-check pipelines.
- Performance Engineering: Optimize data flows for specific latency and frequency requirements while maintaining credit efficiency.
Primary Deliverables:
- Architectural Contributions: Design reviews, Architectural Plans, and Scope Documents.
- Deployment Assets: New account/environment deployments, security schemas, and permission assignments.
- Engineering Assets: Comprehensive ETL Pipeline Design Documents, Mapping Documents, and production-ready Pipelines.
- Product Backlog & Support Ticket Management; performance reports
- Weekly Status Reports
Applicant Notices & Disclaimers
- For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 60.00/hr.