BEST Program Data Engineer & Reporting Developer

Overview

On Site
Accepts corp to corp applications
Contract - Contract

Skills

BEST Program Data Engineer
Reporting Developer

Job Details

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