Overview
On Site
Full Time
Skills
Reengineering
Data Security
Privacy
PL/SQL
Scalability
Data Structure
Data Conversion
Data Masking
Encryption
Analytics
Budget
Vendor Management
Accounts Payable
Incident Management
Disaster Recovery
Computer Science
Systems Analysis
Data Warehouse
SQL
Data Modeling
Performance Tuning
Access Control
Migration
Microsoft Power BI
Microsoft Excel
ODBC
JDBC
Oracle
Database
Stored Procedures
SaaS
Cloud Computing
Extract
Transform
Load
Informatica
Data Architecture
Data Governance
Data Quality
Amazon Web Services
Amazon Redshift
Business Intelligence
Snow Flake Schema
Management
Reporting
SAP BASIS
Law
IT Service Management
Innovation
Collaboration
Recruiting
Insurance
Finance
Professional Development
Training
Leadership
CompTIA
Customer Service
Career Counseling
Oracle Application Express
Apex
Job Details
Job#: 2085056
Job Description:
Apex Systems is a world class technology services business that incorporates industry or insights and experience to deliver solutions that fulfill our clients' digital visions.
Apex has an opportunity for a Data Analyst. For applicants who are interested in this opportunity, send your updated resume to Mike Konjoian, Account Manager, at .
Here are the details:
Position: Data Analyst
Location: 1 Ashburton Place, Boston MA
**Candidates Must Already Sit Locally In New England**
Rate: Negotiable Based on Experience
About the Role
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
Required Qualifications
Preferred Qualifications
Work Environment & Schedule
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. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .
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. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.
Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.
Job Description:
Apex Systems is a world class technology services business that incorporates industry or insights and experience to deliver solutions that fulfill our clients' digital visions.
Apex has an opportunity for a Data Analyst. For applicants who are interested in this opportunity, send your updated resume to Mike Konjoian, Account Manager, at .
Here are the details:
Position: Data Analyst
Location: 1 Ashburton Place, Boston MA
**Candidates Must Already Sit Locally In New England**
Rate: Negotiable Based on Experience
About the Role
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
- 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
- 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
- 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 & 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: Monday-Friday, 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. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .
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. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.
Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.
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.