Senior Business Analyst

Job# : 2049900

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 Senior Data Architect . For applicants who are interested in this opportunity, send your updated resume to Derek Downing, Account Manager, at .

Here are the details :

Position : Senior Data Architect

Location? 100 Hancock St. Quincy

Duration : : 1+ year(s) w / renewal

Rate : Negotiable Based on Experience

POSITION OVERVIEW : Senior Data Architect

The Executive Office of Health and Human Services - Data Office is seeking a Senior Cloud Data Architect to play a crucial role in Data platform architecture design and implementation.

The Data Office will be supporting Department of Public Health (DPH) in the implementation of a Local Public Health Data Platform.

This platform will serve as a key operational and reporting interface for the 351 local and regional boards of health in Massachusetts, housing key workflows, such as inspections and permitting;

collecting pertinent data from local boards of health; and allowing reporting out to local boards of health using data held by the Department of Public Health, such as immunization rates and other key public health information.

Utilizing a combination of Salesforce, Mulesoft, Snowflake, Informatica(IICS), and Tableau, the new local public health data platform will represent a major transformation in how information flows between the state and municipal governments.

An outside consultancy is responsible for the build and implementation of the application. Data Office staff, including this role, will serve as assistance and internal subject matter experts through the implementation.

This role will be expected to become familiar with the business case and outcomes, understand what is being proposed and built by the vendor, and to approve and validate what has been proposed and built.

There will be opportunities to build key infrastructure and reports to support the business, and participate in other DPH workstreams, such as the Data Modernization Initiative.

Post-implementation, the EHS Data Office will support and maintain the data and reporting infrastructure that has been built as well as support the Office of Local and Regional Health to meet their data-driven goals.

The ideal candidate is an expert in Design and implementation of Cloud Data platforms. You can clearly articulate and present different data architecture principles and standards.

In this role, you are comfortable speaking to both business and technical stakeholders to ensure combined understanding and collaborative solutions.

This role will be expected to own tasks and follow-up related to cloud data platform Design and development activities and establish well documented best practices and processes.

DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES :

• Designs and develops architecture of cloud-based data management systems.
• Proficiency and practical experience in implementing Centralized (Data Warehouse) and decentralized (Data Mesh) data architectures.
• Creates data models including data storage, access, and usage patterns for cloud environments.
• Defines data security policies, authentication, and authorization mechanisms for cloud-based platforms.
• Collaborates with cross-functional teams to architect highly scalable, highly available, and highly performant cloud data solutions.
• Evaluates and recommends new cloud products and services for efficient data storage and processing.
• Ensures compliance with data governance policies and best practices in the cloud.
• Implements data management and data governance processes for cloud data.
• Conducts thorough analysis and documentation of cloud data architecture strategies and designs.
• Establish regular overall system performance assessment processes and action plans.
• Provide direction for the design and development of the data layers including review of ETL requirements.
• Capable of leading team design sessions and facilitating decisions.
• Experience in Data Integration leveraging Snowflake, Informatica IICS, SQL, Mulesoft and Python code to solve complex use cases
• Excellent understanding and practical experience on Salesforce CRM
• Ensure timely delivery of solutions meeting requirements and expectations

QUALIFICATIONS : Minimum experience / skills :

• 5+ years of experience in Cloud Data Architecture, data warehousing, data modeling, ETL, enterprise and business information system architectures, and system engineering
• Thorough knowledge and Implementation experience of data warehouse and Enterprise Data architecture principles.
• 3-5 years of experience architecting / developing Cloud-based (AWS) data solutions.
• 5+ years of Cloud database platform experience such as Snowflake.
• Experience in creating, reviewing and maintaining end-to-end data architectures.
• Strong communication skills comfortable explaining / proposing solutions to technical stakeholders, vendors, and business consumers.
• Proficiency with Unix, Linux, and shell scripting
• Experience working with a large, multi-terabyte enterprise data platform in Cloud.
• Experience with system administration, database administration, storage architectures, backup & recovery, and networking.
• Informatica (IICS) ETL and Mulesoft experience
• Salesforce Experience
• Experience working with highly sensitive health care information and familiar with HIPAA and other data privacy controls.

Preferred experience / skills :

• Amazon Web Services (AWS) Certification or Cloud Data architect Certification
• Snowflake certification
• Tableau reporting experience
• Salesforce experience

Additional Benefits :

For this opportunity, you will also be eligible for benefits through Apex for the contract period, 401K, medical / health benefits options, a W2 hourly rate, weekly pay, and direct deposit!

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 844-463-6178.

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.