Technical Data Analyst

About The Company

Apex Systems is a leading global technology services business renowned for delivering innovative solutions that align with clients' digital transformation goals. With a focus on industry insights and extensive experience, Apex Systems provides tailored IT staffing, consulting, and project-based services across various sectors. The company prides itself on fostering a collaborative environment that promotes continuous learning, professional growth, and excellence in service delivery. Recognized for its commitment to diversity and inclusion, Apex Systems maintains a strong reputation as an employer of choice, offering comprehensive benefits and development opportunities to its team members.

About The Role

The position of Technical Data Analyst at Apex Systems offers an exciting opportunity to support enterprise data initiatives for the Commonwealth of Massachusetts, specifically within the Environmental Health Services (EHS) division. The successful candidate will play a pivotal role in ensuring data quality, facilitating data migration and integration projects, and developing insightful reporting solutions. This role requires a highly analytical professional capable of assessing large datasets, identifying data inconsistencies, and implementing cleansing and validation processes. The Technical Data Analyst will collaborate closely with technical and business stakeholders to support data governance, enterprise data management, and system integration efforts. The position is based in Boston, MA, with an initial duration through June 30, 2027, and the potential for extension based on project needs and performance.

Qualifications

The ideal candidate will possess a bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent professional experience. A minimum of five years of experience in data analysis, data quality management, or data governance within enterprise environments is essential. Strong proficiency in SQL and scripting languages such as Python or PowerShell is required, along with experience supporting data visualization tools like Tableau and Microsoft Power BI. Familiarity with enterprise data integration tools, API support, and cloud-based platforms, including MuleSoft and REST APIs, is highly desirable. Experience with Salesforce CRM, ETL processes, and data quality platforms such as Cloudingo, DemandTools, Informatica, or Talend will be advantageous. Candidates should demonstrate excellent analytical, troubleshooting, and communication skills, with the ability to work effectively in collaborative, Agile environments.

Responsibilities

The primary responsibilities of the Technical Data Analyst include performing comprehensive data profiling and quality assessments to identify issues such as duplicates, inconsistencies, and validation errors across enterprise datasets. The analyst will design and execute data cleansing, standardization, transformation, and reconciliation activities to enhance data integrity. Developing automated routines for data validation and exception reporting will be a key component of the role. Additionally, the analyst will build and maintain interactive dashboards and reports using Tableau and/or Power BI, developing KPIs to monitor data quality, migration readiness, and operational performance. Supporting enterprise data migration efforts involves creating detailed data mapping documents, validation templates, and reconciliation reports, ensuring data accuracy during system transitions. The role also encompasses scripting and automation tasks, leveraging SQL, Python, or PowerShell to streamline data processes. Supporting API integrations and enterprise data exchanges using MuleSoft and REST APIs is essential, including testing, troubleshooting, and resolving integration issues. The analyst will work closely with cross-functional teams, including business stakeholders, technical teams, and data governance groups, to define data requirements, ensure compliance with quality standards, and support enterprise data lifecycle management initiatives. Participation in Agile project environments and contributing to project planning and execution are also expected.

Benefits

Apex Systems offers a comprehensive benefits package designed to support the health, well-being, and professional development of its employees. Benefits include medical, dental, and vision insurance, life and disability coverage, and access to an Employee Assistance Program (EAP) with counseling services. The company also provides a 401(k) plan with company matching contributions, a Health Savings Account (HSA) for eligible plans, and an Employee Stock Purchase Program (ESPP). Employees benefit from various professional development resources, including on-demand training, certification prep, and access to technical and leadership courses. Additional perks include corporate discounts, wellness programs, and support for industry certifications through partnerships with organizations such as CompTIA and IIBA. Apex Systems is committed to fostering a supportive environment that encourages continuous learning and career growth.

Equal Opportunity

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, marital status, disability, veteran status, political affiliation, union membership, or any other characteristic protected by law. We are committed to creating an inclusive environment where all employees and applicants are treated with respect and fairness. Qualified applicants with criminal histories will be considered in accordance with applicable laws. If you require accommodations during the application or interview process under the Americans with Disabilities Act, please contact our Human Resources department for assistance.