Navitas Partners, LLC is seeking a BEST Program Data Engineer & Reporting Developer to lead the migration of reporting solutions from legacy platforms to Snowflake, ensuring data integrity, security, and optimized performance.
Requirements
- Strong experience with Oracle and Snowflake, including data modeling, SQL, and stored procedures.
- Hands-on experience with Snowflake performance tuning, security, and role-based access control.
- Proficiency with reporting tools such as Power BI and Excel integrations.
- Experience migrating reporting workloads from legacy platforms to cloud-based solutions.
- Familiarity with ETL tools, BI tools, and AWS Redshift is a plus.
- Strong problem-solving and documentation skills.
- Experience in financial or government enterprise data environments preferred.
Responsibilities
- Lead migration of reporting solutions from legacy platforms (Oracle, SQL Server, AWS Redshift) to Snowflake.
- Convert Oracle SQL, data types, and stored procedures into Snowflake equivalents.
- Analyze data structures, map data elements, and ensure data integrity post-migration.
- Implement role-based access, data masking, and other security measures within Snowflake.
- Optimize Snowflake data warehouse performance, storage, and query efficiency.
- Collaborate with SMEs to understand report requirements and business logic.
- Support financial and operational reporting across multiple areas including Procure-to-Pay, Record-to-Report, Grants, Budgeting, Vendor Management, and operational management metrics.
Other
- Hybrid work arrangement in Boston, MA.
- 11 Months (Tentative) duration.
- Minimum of 5 years of experience in database development, business intelligence/reporting, and data warehousing.
- Experience with SaaS cloud implementations and financial or reporting modernization projects.
- Knowledge of data architecture, data quality, and data governance practices.
