Be an early applicantLess than 25 applicantsPosted by Agency

Company

ACS Consultancy Services, Inc · 8 hours ago

Data Architect

United States

Full-time

Remote

Mid Level

Maximize your interview chances

ConsultingInformation Services

Insider Connection @ACS Consultancy Services, Inc

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Design, implement, and optimize Snowflake data warehouse solutions to meet business needs.

Create and maintain Snowflake objects such as databases, procedures, tasks, and streams.

Leverage Snowflake’s cloning capabilities to create efficient database and schema structures.

Manage Snowflake warehouses, monitor performance, and optimize queries for efficiency.

Implement and maintain Snowflake RBAC (Role-Based Access Control), including roles and privileges.

Integrate Snowflake with SSO and SCIM for secure identity management and access.

Automate administrative tasks using Snowflake SQL and scripting languages like Python or Shell.

Develop and implement data integration workflows using tools like Informatica and Azure Data Factory (ADF).

Monitor and troubleshoot Snowflake environments, including query profiling and usage tracking.

Apply Snowflake security features such as data masking, encryption, and network policies to ensure data safety.

Collaborate with cross-functional teams to prioritize tasks and meet project deadlines.

Develop reports using Cognos Analytics and support data-driven decision-making.

Contribute to technical documentation and create diagrams using tools like Visio or Erwin.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Snowflake architectureData modelingData integrationETL/ELT processesSnowflake security featuresOraclePostgreSQLPythonShell scriptingAgile methodologiesInformaticaAzure Data FactoryCI/CD pipelinesHealthcare industrySensitive data handlingInformatica 10.5Cognos Analytics 11.1Azure cloud servicesDiagramming skillsMicrosoft Office SuiteHHS agenciesTechnical writing

Required

Experience in data modeling, integration, warehousing, governance, and security.

Proficiency in Snowflake architecture, components, and administration.

Expertise in Oracle and/or PostgreSQL, particularly in high-availability deployments.

Strong understanding of ETL/ELT processes with tools like Informatica and ADF.

Advanced technical skills in scripting languages like Python or Shell.

Experience with Snowflake features such as cloning, RBAC, SSO, and SCIM integration.

Hands-on experience with Snowflake security features and optimization techniques.

Proficiency with Agile methodologies and tools like JIRA.

Strong technical writing and diagramming skills using Microsoft Office Suite and modeling tools.

Ability to work with multiple teams concurrently, delivering high-quality results on time.

Preferred

Experience with CI/CD pipelines and version control for Snowflake code deployments.

Prior experience in the healthcare industry or with HHS agencies.

Experience working with sensitive data, including PII, PHI, and HL7 formats.

Knowledge of Informatica 10.5 and Cognos Analytics 11.1.

Working experience with Azure cloud services.

Bachelor’s degree in Computer Science, Information Systems, or related field.

Company

ACS Consultancy Services, Inc

ACS Consultancy Services Inc is a Small Business that is New York State and New York City Certified Minority and Women-Owned Business Enterprise (MWBE).

Founded in 2011