BEST Program Data Engineer & Reporting Developer

Job Title: BEST Program Data Engineer & Reporting Developer
Location: Boston, MA

Position Summary:

The BEST Program Data Engineer & Reporting Developer with experience in Snowflake and reporting platform

migrations will work with a Team comprised of BEST Program staff, agency business and technical SMEs and the new solution system integrator (SI) and product vendor to support the migration of legacy reporting systems to a modern, cloud-based architecture. The ideal candidate will play a key role in reengineering and optimizing reporting data pipelines, ensuring seamless data availability, and enabling advanced reporting capabilities within Snowflake.

Financials:

• Acquire to Retire (Capital Asset Management)
• Cash Management
• Cost Allocation
• Debt Management
• Grants Financial Management
• Operating Budget Management
• Order to Cash (Revenue/Accounts Receivable)
• Procure to Pay (Accounts Payable)
• Program Management
• Record to Report (Financial Reporting)
• Reporting/Analytics
• Sub-fund Management
• Vendor Management and Self Service

Operations:

• Maintenance and Warranty Management
• Incident Management
• Capacity Management
• Availability Management
• Performance Management
• Security Management
• Nightly Batch Jobs Management
• Software Change Management and Testing
• Disaster Recovery Testing and Management

Specific Duties:

• 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.

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.
• Knowledge of ETL tools (e.g., Informatica) is a plus.
• 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.
• Familiarity with AWS Redshift Cloud Data warehouse is a plus.
• Familiarity with Snowflake Data sharing, Snowpipe and Snowpark.
• Background in financial or government enterprise data environments preferred.
• Strong problem-solving and documentation skills.

Preferred Qualifications:

• Experience with Software as a Service cloud implementation particularly those in which legacy on premise applications
• have been migrated to cloud delivery options, financial transformations and/or modernization projects. In addition,
• understanding data architecture, data quality, and data governance practices a plus.
• Minimum Entrance Requirements
• Bachelor's degree in computer science, system analysis or a related study, or equivalent experience.
• Minimum of 5 years of design and implementation experience in the areas of database development, business
• intelligence/reporting and data warehousing.