Overview
On Site
Hybrid
USD 70.00 per hour
Full Time
Skills
Computer Science
Systems Analysis
Database
Data Modeling
Performance Tuning
Microsoft Power BI
Microsoft Excel
ODBC
JDBC
Business Intelligence
Conflict Resolution
Problem Solving
Cloud Computing
Extract
Transform
Load
Informatica
Finance
Amazon Web Services
Amazon Redshift
Data Conversion
Data Security
Privacy
SQL
Migration
Collaboration
Reporting
Data Structure
Data Quality
PL/SQL
Stored Procedures
Data Integrity
Oracle
Access Control
Data Masking
Encryption
Documentation
Snow Flake Schema
Data Warehouse
Storage
Videoconferencing
Industrial Relations
Law
LOS
Recruiting
Immigration
Job Details
Date Posted: 08/11/2025
Hiring Organization: Rose International
Position Number: 486827
Industry: Government
Job Title: Data Engineer and Reporting Developer
Job Location: Boston, MA, USA, 02108
Work Model: Hybrid
Work Model Details: 4 days a month onsite
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 12
Min Hourly Rate($): 70.00
Max Hourly Rate($): 75.00
Must Have Skills/Attributes: Data Engineer, Report Developer, Snowflake, SQL
Experience Desired: Snowflake experience including data modeling, performance tuning, and role-based access control (5+ yrs); Proficiency with reporting tools such as Power BI, Excel integrations, or ODBC/JDBC-based access (5+ yrs)
Required Minimum Education: Bachelor's Degree
Job Description
***Only qualified Program Data Engineer & Reporting Developer candidates located in the Boston, MA area to be considered due to the position requiring an onsite presence***
Required Education:
Bachelor's degree in computer science, system analysis or a related study, or equivalent experience
Required Skills:
Strong understanding of Oracle and Snowflake database concepts, including data modeling, SQL, stored procedures and data types
Hands-on experience with Snowflake, including data modeling, performance tuning, and role-based access control
Proficiency with reporting tools like Power BI, Excel integrations, or ODBC/JDBC-based access
Strong proficiency in SQL and experience working with large datasets
Experience in migrating reporting workloads from legacy platforms to cloud-based solutions
Solid understanding of BI tools and their integration with Snowflake
Strong problem-solving and documentation skills
Desired Skills:
Familiarity with AWS Redshift Cloud Data Warehouse is a plus.
Knowledge of ETL tools (e.g., Informatica) is a plus
Familiarity with Snowflake Data sharing, Snow pipe and Snowpark
Background in financial or government enterprise data environments
Program Data Engineer & Reporting Developer will work with the BEST Senior Data Architect to lead and execute the migration of reporting solutions from legacy platforms (e.g., Oracle, SQL Server, AWS Redshift etc.) to Snowflake; transform legacy queries and procedures into a modern, scalable, and maintainable Snowflake-based solution; analyze the data structures in BCV Oracle; and map data elements appropriately in Snowflake, doing schema reconciliation and data conversion. This role will also onboard the CTR users in the CTR Snowflake instance for data access, create role-based access policies and data masking rules for data security and privacy. The engineer will work on tuning SQL queries on Snowflake for performance efficiency
Job Duties and Responsibilities:
Design and implement strategies for migration of reporting solutions from legacy platforms to Snowflake
Collaborate with subject matter experts (SMEs) to understand report purpose, usage frequency, and business logic
Analyze data structures and relationships in Oracle, understand data quality rules, and map data elements to Snowflake's structure
Convert Oracle SQL, data types, and stored procedures to Snowflake equivalents
Validate data integrity between Oracle and Snowflake, identify discrepancies, and ensure data accuracy
Implement security measures within Snowflake, such as role-based access control, data masking, and encryption
Create and maintain documentation for data models, developed reports and Snowflake configurations.
Optimize Snowflake data warehouse performance, storage, and query efficiency
Interview Process: Initial contact by phone, interview may be conducted in-person or by video conference
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Hiring Organization: Rose International
Position Number: 486827
Industry: Government
Job Title: Data Engineer and Reporting Developer
Job Location: Boston, MA, USA, 02108
Work Model: Hybrid
Work Model Details: 4 days a month onsite
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 12
Min Hourly Rate($): 70.00
Max Hourly Rate($): 75.00
Must Have Skills/Attributes: Data Engineer, Report Developer, Snowflake, SQL
Experience Desired: Snowflake experience including data modeling, performance tuning, and role-based access control (5+ yrs); Proficiency with reporting tools such as Power BI, Excel integrations, or ODBC/JDBC-based access (5+ yrs)
Required Minimum Education: Bachelor's Degree
Job Description
***Only qualified Program Data Engineer & Reporting Developer candidates located in the Boston, MA area to be considered due to the position requiring an onsite presence***
Required Education:
Bachelor's degree in computer science, system analysis or a related study, or equivalent experience
Required Skills:
Strong understanding of Oracle and Snowflake database concepts, including data modeling, SQL, stored procedures and data types
Hands-on experience with Snowflake, including data modeling, performance tuning, and role-based access control
Proficiency with reporting tools like Power BI, Excel integrations, or ODBC/JDBC-based access
Strong proficiency in SQL and experience working with large datasets
Experience in migrating reporting workloads from legacy platforms to cloud-based solutions
Solid understanding of BI tools and their integration with Snowflake
Strong problem-solving and documentation skills
Desired Skills:
Familiarity with AWS Redshift Cloud Data Warehouse is a plus.
Knowledge of ETL tools (e.g., Informatica) is a plus
Familiarity with Snowflake Data sharing, Snow pipe and Snowpark
Background in financial or government enterprise data environments
Program Data Engineer & Reporting Developer will work with the BEST Senior Data Architect to lead and execute the migration of reporting solutions from legacy platforms (e.g., Oracle, SQL Server, AWS Redshift etc.) to Snowflake; transform legacy queries and procedures into a modern, scalable, and maintainable Snowflake-based solution; analyze the data structures in BCV Oracle; and map data elements appropriately in Snowflake, doing schema reconciliation and data conversion. This role will also onboard the CTR users in the CTR Snowflake instance for data access, create role-based access policies and data masking rules for data security and privacy. The engineer will work on tuning SQL queries on Snowflake for performance efficiency
Job Duties and Responsibilities:
Design and implement strategies for migration of reporting solutions from legacy platforms to Snowflake
Collaborate with subject matter experts (SMEs) to understand report purpose, usage frequency, and business logic
Analyze data structures and relationships in Oracle, understand data quality rules, and map data elements to Snowflake's structure
Convert Oracle SQL, data types, and stored procedures to Snowflake equivalents
Validate data integrity between Oracle and Snowflake, identify discrepancies, and ensure data accuracy
Implement security measures within Snowflake, such as role-based access control, data masking, and encryption
Create and maintain documentation for data models, developed reports and Snowflake configurations.
Optimize Snowflake data warehouse performance, storage, and query efficiency
Interview Process: Initial contact by phone, interview may be conducted in-person or by video conference
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.