Reuben Cooley, Inc.
Job Details:
Job Title: Data Engineer and Reporting Developer
Location: Boston, MA (Hybrid)
Duration: 12 Months
Job Details:
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
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
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
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
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