▶Apply

Data Engineer & Reporting Developer

Trillium Professional is now seeking a Data Engineer & Reporting Developer in Boston for a Hybrid position.

This is a contract position lasting 18-24 months. Pay rate is $76/hour.

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.

The BEST 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 following best practices.

The Data Engineer & Reporting Developer will work with business and the system integrator and product vendor to identify opportunities for improving the availability of data for reporting and analytics by understanding the solution’s capacities in this area, sharing that information with business and documenting implementation options with owners of other Commonwealth data engineer and reporting developer resources.
The Data Engineer & Reporting Developer will support data access for users in the following areas, working to improve data quality and access in the new solution:

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.

Apply now!

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.

 

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.