Apex Systems
Data Analyst
Apex Systems is a world class technology services business that incorporates industry insights and experience to deliver solutions that fulfill our clients' digital visions. Apex has an opportunity for a Data Analyst. 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. Key responsibilities include: Lead migration of reporting solutions from legacy platforms (Oracle, SQL Server, AWS Redshift) to Snowflake. Reengineer and optimize reporting data pipelines for performance and scalability. Analyze and map data structures from BCV Oracle to Snowflake, ensuring schema reconciliation and data conversion. Convert legacy SQL queries and stored procedures to Snowflake equivalents. Implement role-based access controls, data masking, and encryption for secure data access. Tune Snowflake queries for performance efficiency. Document data models, configurations, and developed reports. Collaborate with business users, technical SMEs, and system integrators to improve data availability and quality. Support reporting and analytics across financial and operational domains including: Financials: Grants, Budget, Vendor Management, Revenue, Accounts Payable, etc. Operations: Incident Management, Performance, Security, Disaster Recovery, etc. Required qualifications include: Bachelor's degree in Computer Science, Systems Analysis, or related field (or equivalent experience). Minimum 5 years of experience in database development, BI/reporting, and data warehousing. Strong proficiency in SQL and working with large datasets. Hands-on experience with Snowflake including data modeling, performance tuning, and access control. Experience migrating reporting workloads to cloud-based solutions. Familiarity with reporting tools (Power BI, Excel integrations, ODBC/JDBC). Knowledge of Oracle database concepts and stored procedures. Experience with Snowflake features like Snowpipe, Snowpark, and data sharing. Preferred qualifications include: Experience with SaaS cloud implementations and financial modernization projects. Familiarity with ETL tools (e.g., Informatica). Understanding of data architecture, data governance, and data quality practices. Background in financial or government enterprise data environments. Experience with AWS Redshift and BI tool integration with Snowflake. Work environment and schedule: Hybrid work model: Minimum of 4 days/month onsite in Boston (2 set by management, 2 by employee). Must be able to report onsite with little or no notice. Full-time schedule: MondayFriday, 8 hours/day (40 hours/week). Initial training and orientation may require more frequent onsite presence. EEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package.
Apex Systems is a world class technology services business that incorporates industry insights and experience to deliver solutions that fulfill our clients' digital visions. Apex has an opportunity for a Data Analyst. 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. Key responsibilities include: Lead migration of reporting solutions from legacy platforms (Oracle, SQL Server, AWS Redshift) to Snowflake. Reengineer and optimize reporting data pipelines for performance and scalability. Analyze and map data structures from BCV Oracle to Snowflake, ensuring schema reconciliation and data conversion. Convert legacy SQL queries and stored procedures to Snowflake equivalents. Implement role-based access controls, data masking, and encryption for secure data access. Tune Snowflake queries for performance efficiency. Document data models, configurations, and developed reports. Collaborate with business users, technical SMEs, and system integrators to improve data availability and quality. Support reporting and analytics across financial and operational domains including: Financials: Grants, Budget, Vendor Management, Revenue, Accounts Payable, etc. Operations: Incident Management, Performance, Security, Disaster Recovery, etc. Required qualifications include: Bachelor's degree in Computer Science, Systems Analysis, or related field (or equivalent experience). Minimum 5 years of experience in database development, BI/reporting, and data warehousing. Strong proficiency in SQL and working with large datasets. Hands-on experience with Snowflake including data modeling, performance tuning, and access control. Experience migrating reporting workloads to cloud-based solutions. Familiarity with reporting tools (Power BI, Excel integrations, ODBC/JDBC). Knowledge of Oracle database concepts and stored procedures. Experience with Snowflake features like Snowpipe, Snowpark, and data sharing. Preferred qualifications include: Experience with SaaS cloud implementations and financial modernization projects. Familiarity with ETL tools (e.g., Informatica). Understanding of data architecture, data governance, and data quality practices. Background in financial or government enterprise data environments. Experience with AWS Redshift and BI tool integration with Snowflake. Work environment and schedule: Hybrid work model: Minimum of 4 days/month onsite in Boston (2 set by management, 2 by employee). Must be able to report onsite with little or no notice. Full-time schedule: MondayFriday, 8 hours/day (40 hours/week). Initial training and orientation may require more frequent onsite presence. EEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package.