▶Apply

Senior Cloud Engineer

Trillium Professional is now seeking a Senior Cloud Engineer in Everett, MA  - Remote is an option. 

The Engineer will be hands-on working with a team of cloud Engineers, ETL developers, technical leads, DBAs, project managers and analysts to design and implement the Education portfolio data, data pipelines, and transformations in a more stream-lined, scalable and cost-effective set of solutions. 

Regular responsibilities include:
•    Create and manage cloud-native databases and services (e.g., RDS Oracle, Aurora, Postgres, Snowflake).
•    Track and tune query execution, compute scaling, and storage performance. 
•    Define policies for snapshots, PITR (point-in-time recovery), and cross-region replication. 
•    Implement encryption, access policies, masking, and auditing to meet FERPA/PII standards. 
•    Manage schema migrations, data pipelines, and versioned deployments. 
•    Hands-on discovery, solution designing, re-platforming and troubleshooting to migrate the EOE Legacy SSIS ETL code to a SQL based solution with Apache Airflow for scheduling and dependency management.
•    Tasks may include re-Engineering overall solution approach, constructing code packages, bug 
fixing, unit testing code and using GitHub code repository
•    Develop and guide implementation of Apache Airflow Scheduling and Dependency Framework
•    Performance tuning and optimizing solution implementation, benchmark the new solution against the on-prem solution to ensure that it performs comparably or better
•    Using Jira to review and work through assigned tasks
•    Using GitHub to check in and manage code, code reviews, pull requests

Pay rate is $89/hour. Apply now!

Required 
•    Experience working with Oracle RDS
•    Experience working with one or more AWS Cloud services such as S3 storage, Managed Airflow (MWAA), Data Migration Service (DMS) in support of building data pipelines
•    Experience working with a variety of backend data sources (e.g. SQL Server, Oracle, Postgres, DynamoDB, Snowflake)
•    Advanced SQL coding skills and ability to translate Oracle PL SQL and Stored Procedure code to alternative SQL platforms such as Snowflake 
•    Familiarity with data warehouse and data mart concepts such as normalization, facts, dimensions, slowly changing dimensions
•    Familiarity with Change Data Capture (CDC) concepts and implementations.  Knowledge of Kafka or similar replication tools is a plus
•    Understanding of common file formats such as JSON, XML, CSV
•    Basic experience using scripting tools to automate tasks (e.g.: Python, Windows PowerShell, bash)
•    Ability to write unit test scripts and be able to validate migrated ELT/ETL code

Preferred
•    Experience configuring, managing, and troubleshooting Airflow tool. Knowledge of Airflow DAGs and concepts for managing dependent graphs and complex steps
•    Knowledge of Snowflake data warehouse features such as Snowpipe streaming, cloning, time travel, role-based-access control
•    Prior experience working at other large organizations, preferably state or federal government 
•    Business domain knowledge in the Education and Student data management area.
•    Experience working with software development tools such as GitHub, Jira

 

Trillium has been recruiting and placing professionals for over 30 years. From Fortune 100 companies to small businesses, our philosophy remains the same: to achieve excellence by providing quality employees and an uncompromising level of service. We believe in honesty, integrity, and a simple philosophy of providing value to our customers and our employees. We strive to be unsurpassed in the recruitment and placement of quality and skilled professionals. Trillium is an Equal Opportunity Employer.

Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for the employers and the California Fair Chance Act.

By applying to this job, I agree to receive electronic communications including SMS text and email regarding future opportunities, referral bonus incentives, and other promotions from Trillium. You may opt out at any time from future communications by responding STOP to any electronic communication. You may view our full privacy policy at https://trilliumstaffing.com/jobs/privacy/.

Trillium offers a comprehensive benefit package that includes the ability to participate in health insurance and retirement plans, paid holidays, state required leave, and vacation days, if applicable. Trillium’s offerings are dependent on the state in which the assignment is located, length of time worked, and may change depending on assignment. Benefit packages for direct hire placements vary based on the client company.

 

Contact Us if you have any questions

Our intentions are to fill job vacancies as quickly as possible with qualified candidates. We are always accepting applications if a time sensitive job has an application deadline it is noted in the job description. Click on "Apply" to begin the apply process.