Data ArchitectLocation: USA remoteData Architect (Snowflake, Fivetran, DBT, Azure, and Workato)We are seeking a detail-oriented and proactive Data Architect to join our team. This role is responsible for maintaining and enhancing our data pipelines, data flows through system integrations, and reporting solutions. The ideal candidate has a strong background in data engineering and experience designing data architectures.Key ResponsibilitiesDesign, Build, and Maintain Data Pipelines: Maintain ETL/ELT processes for ingesting, transforming, and loading data from various sources (APIs, databases, flat files) into the data warehouse (e.g., Snowflake) through FivetranData Integration: Integrate data from internal and external systems, ensuring consistency, accuracy, and completenessData Quality & Cleansing: Implement data validation, cleansing, and enrichment processes to ensure high-quality, trusted dataPerformance Optimization: Monitor, troubleshoot, and optimize data pipelines and queries for efficiency and scalabilityData Warehouse Management: Support the administration, security, and ongoing maintenance of the data warehouse infrastructureCollaboration: Work closely with Data Product Owner and business stakeholders to understand data requirements and deliver solutionsReport Maintenance: Oversee the maintenance of existing Tableau dashboards and reports, ensuring data accuracy, performance, and accessibility for all usersDocumentation: Maintain thorough documentation of pipeline architectures, data models, data dictionaries, and report definitionsCompliance & Security: Ensure all reporting processes adhere to company policies and data governance standardsQualifications RequiredBachelor’s degree in Information Systems, Data Analytics, Computer Science, Business, or related fieldProficiency in SQL and experience with cloud data warehouses (e.g., Snowflake, Databricks, Azure SQL Data Warehouse)Experience with ETL/ELT tools and orchestration platforms (e.g., Fivetran, dbt, Airflow)Solid understanding of data modeling, data integration, and database design conceptsFamiliarity with API integration and RESTful web servicesStrong analytical and problem-solving skills with keen attention to detailExperience gathering requirements and translating them into effective data visualizationsExperience with BI tools (e.g., Tableau, Power BI, Looker) is a plusExcellent interpersonal and communication skills; comfortable working with business and technical teamsPreferredExperience in healthcare staffing or related healthcare industriesFamiliarity with data governance and compliance requirements in healthcareExperience with Tableau, Snowflake, dbt, and Fivetran specificallyExperience with Workato or other iPaaS solutionsExperience with source control (e.g., Git) and CI/CD pipelines“Disclaimer: E-Solutions Inc.
provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability.