Snowflake, dbt, and AWS Professional Services Contractor
CCS Global Tech
Dice Job Match Score™
⏳ Almost there, hang tight...
Job Details
Skills
- Professional Services
- UI
- Information Technology
- Network
- Microsoft
- Tier 1
- Cloud Computing
- Training
- Partnership
- Communication
- Code Refactoring
- Database
- UDP
- Management
- SQL
- Microsoft Power BI
- Dashboard
- Migration
- Legacy Systems
- Writing
- Testing
- Remote Desktop Services
- Amazon RDS
- Amazon DynamoDB
- Recruiting
- Test Suites
- Infrastructure Architecture
- Amazon Web Services
- Python
- Snow Flake Schema
- Data Modeling
- Data Processing
- Integration Testing
- Continuous Integration
- Continuous Delivery
- IBM WebSphere MQ
- Oracle Linux
Summary
Roles/Responsibilities:
- Task 1: Streamlit App Development
As needed and as authorized, Contractor shall develop Streamlit applications over various Snowflake datasets. Many of these will be CRUD, "spreadsheet-style" user experiences directly on top of datasets, while others will be more nuanced applications with conditional logic, complex views, and more advanced functionality.
Task 1 Deliverable: Write code and develop technical configuration to various Streamlit Apps.
- Task 2: Merit Bridge -> Snowflake Migration
As needed and as authorized, Contractor shall rebuild Merit Bridge schemas in dbt/Snowflake, refactoring AWS database connection code to point to Snowflake, migrating the data.
Task 2 Deliverable:
Document and write database schemas and definitions.
- Task 3: Build dbt/Snowflake data objects
As needed and as authorized, Contractor will translate and migrate legacy data models in DHR Snowflake in UDP Snowflake. Refactor current Position Management Dashboard SQL and PowerBI queries into dbt-standardized data objects. Build dbt objects based on SME-developed schemas, queries, and data models.
Task 3 Deliverables:
- Contribute to (in part or in whole) dashboard and query migration from legacy systems.
- Contribute to writing dbt data objects and models.
- Task 4: Build AWS and Snowflake testing infrastructure
As needed and as authorized, Contractor will build unit and integration tests for Python codebase spanning AWS Services (Lambda, RDS, DynamoDB) and Snowflake to integrate within CI/CD infrastructure.
Task 4 Deliverables:
- Develope test suites for internal DHR hiring systems.
- Execute test suites against internal technical systems and produced documented results.
- Task 5: Consult on CI/CD Infrastructure design
As needed and as authorized, Contractor will provide recommendations and input on CI/CD Infrastructure design.
Task 5 Deliverable: Produce documented best-practices, recommendations, and/or guidelines about infrastructure development and design.
Mandatory Skills:
- MQ1 Provide at least one prior project which involves each of the following:
- Leveraging AWS Python Lambdas to integrate data across systems
- dbt/Snowflake data modeling
- Data processing and optimizing over large (not hyper-large) datasets
- Unit and integration testing
- CI/CD and/or infrastructure as code
- MQ2 Contractor must be available to be on-site when needed.
Desirable Skills: N/A
- Dice Id: 10290999
- Position Id: 2026-7285/63177
- Posted 16 hours ago
Company Info
Headquartered in Poway, California and eight international offices, CCS Global Tech is a Certified Minority Business Enterprise (MBE) and a leading provider of enterprise solutions. We provide solutions that cover the full business spectrum from application development, data warehouse software, real time data warehousing, business analysis software, and web-based application development. Our clients span the globe and benefit from our comprehensive support capabilities.
Our tools and technical expertise have repetitively proven to reduce the time and costs associated with software and custom solution development. CCS Global Tech begins each project with quality analysis and business due diligence in order to deliver quality solutions for our clients. Our team of international talent asks critical questions that illuminate the fine details of the project scope. Once we have a clear and comprehensive view of the objectives sought, we set to work to bring your vision to life.
We have a complementary matrix of skills and talents across multiple platforms that allow us to identify, target and bridge technical gaps. Regardless of the size and scope of your business application, data warehouse initiative, or enterprise-wide project, our team supports service, technical capabilities and cost effective solutions that are unmatched by our competition. We focus on delivering state-of-the-art technology, application development, warehousing and support to our clients. With the scope and flexibility to optimize development schedules and products to fit any budget requirements, CCS Global Tech is aptly positioned to not only meet unique, strategic IT objectives of diverse organization, but also complement organizational goals.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs