Etl architect jobs near me

- 609 jobs

Software Architect (Clinical Trials Platform)
Azra Ai
Remote etl architect job
About the Role We are seeking a Software Architect to design, develop, and lead the architecture of a modern clinical trials platform. This system will integrate directly with EMRs/EHRs, receive and normalize clinical data from multiple sources (HL7, FHIR, CCD, and APIs), standardize coded clinical information (ICD-10, SNOMED, LOINC), and support automated downstream decision and workflow engines. You will define the architectural direction for secure integrations, ingestion pipelines, clinical data models, and event-driven processing. This role is both highly strategic and hands-on, partnering closely with engineering, data, and clinical informatics teams to build a scalable, compliant platform used across diverse healthcare environments. Salary Range: $150-$180k Key Responsibilities System Architecture & Platform Design Architect end-to-end systems for ingesting, normalizing, and operationalizing clinical data. Create scalable, fault-tolerant service architectures using microservices, event-driven patterns, or modular domain-driven design. Produce architectural diagrams, integration patterns, data models, and API standards. Define platform-wide guidelines for service decomposition, state management, data contracts, and code quality. EMR Integrations & Clinical Data Ingestion Architect and implement secure, compliant EMR/EHR integrations using: HL7 v2 (ADT, ORU, ORM, SIU, custom Z-segments) FHIR R4 resources and RESTful APIs CCD / C-CDA documents Vendor interfaces (Epic, Cerner, Athenahealth, Meditech, etc.) Build ingestion pipelines for pathology, radiology, diagnostic data, labs, medications, problems, encounters, and other clinical artifacts. Normalize and standardize data using clinical coding systems, including: ICD-10 SNOMED CT LOINC RxNorm Implement clinical data validation, deduplication, reconciliation, and identity matching. Interoperability & Integration Framework Design reusable interoperability frameworks for onboarding new health systems. Establish secure communication channels (VPN, SFTP, APIs, FHIR Subscriptions, eventing). Ensure alignment with HIPAA, SOC2, HITRUST, and enterprise privacy/security policies. Define repeatable onboarding patterns for rapid integration with hospital IT teams. Application & Backend Development Build core backend services using modern application frameworks (Java/Kotlin, Go, Python, etc.). Develop APIs and event-driven microservices for data ingestion, normalization, storage, and downstream workflows. Optimize system performance with caching, concurrency, streaming, and resilience patterns. Provide hands-on engineering, code review, and mentorship to the development team. Data Architecture & Storage Design Define operational schemas for patient demographics, encounters, clinical observations, diagnostic results, and provider data. Partner with data engineering teams on schema design, warehouse patterns, and lineage. Create separation layers between real-time ingestion, normalized stores, and analytical datasets. Ensure data integrity, primary/foreign key mappings, ICD/SNOMED/LOINC code handling, and longitudinal patient histories. Quality, Security, & Compliance Implement architectural patterns for encrypted PHI handling, IAM policies, access controls, and audit trails. Establish automated testing strategies: contract tests, schema tests, integration tests, and workflow validation. Ensure the platform meets healthcare compliance and interoperability expectations across diverse clients. Required Qualifications Experience in Healthcare Application Architecture 5+ years as a software architect or senior engineer designing distributed platforms. Demonstrated experience with EMR/EHR integrations (HL7, FHIR, CCD, or vendor APIs). Understanding of clinical data structures, patient-centric workflows, and healthcare interoperability standards. Technical Expertise Proficiency in one or more backend languages: Java/Kotlin, Python, Go, etc. Experience with event-driven systems (Pub/Sub, Kafka, SNS/SQS, or similar). Strong understanding of cloud platforms (GCP preferred; AWS or Azure acceptable). Experience with operational and NoSQL databases for structured and semi-structured healthcare data. Interoperability & Clinical Data Knowledge Hands-on experience with HL7 v2 message structures and FHIR resources Understanding of coded clinical systems, including ICD-10, SNOMED CT, LOINC, and RxNorm. Architecture & Development Skills Deep understanding of system design, API architecture, and microservices. Ability to build scalable, high-availability systems. Strong foundation in CI/CD, DevOps practices, infrastructure-as-code, and observability. Bonus Skills (Preferred but Not Required) Experience with workflow engines Familiarity with AI/ML models for clinical text processing or structured data interpretation. Experience with GCP analytics tools (BigQuery, Dataflow, Dataform/dbt/Sqlmesh). Background in pathology, radiology, or structured and unstructured clinical document processing. Experience building healthcare SaaS platforms. Why Join Us? Architect a modern clinical data platform used across large healthcare systems. Work at the intersection of interoperability, cloud architecture, and real-world clinical data. Collaborate with engineering, clinical informatics, and data teams to build mission-critical healthcare technology. Work with modern, cloud-native tools in a fully remote environment with high autonomy and ownership. Fully remote opportunity with a high-impact role.
$150k-180k yearly 5d ago
ETL Architect
Quartz 4.5
Remote etl architect job
Come Find Your Spark at Quartz! The ETL Architect will be responsible for the architecture, design, and implementation of data integration solutions and pipelines for the organization. This position will partner with multiple areas in the Enterprise Data Management team and the business to successfully translate business requirements into efficient and effective ETL implementations. This role will perform functional analysis, determining the appropriate data acquisition and ingestion methods, and design processes to populate various data platform layers. The ETL Architect will work with implementation stakeholders throughout the business to evaluate the state of data and constructs solutions that deliver data to enable analytics reporting capabilities in a reliable manner. Skills this position will utilize on a regular basis: Informatica PowerCenter Expert knowledge of SQL development Python Benefits: Opportunity to work with leading technology in the ever-changing, fast paced healthcare industry. Opportunity to work across the organization interacting with business stakeholders. Starting salary range based upon skills and experience: $107,500 - $134,400 - plus robust benefits package. Responsibilities Architects, designs, enhances, and supports delivery of ETL solutions. Architects and designs data acquisition, ingestion, transformation, and load solutions. Identifies, develops, and documents ETL solution requirements to meet business needs. Facilitates group discussions and joins solution design sessions with technical subject matter experts. Develops, implements, and maintains standards and ETL design procedures. Contributes to the design of the data models, data flows, transformation specifications, and processing schedules. Coordinates ETL solution delivery and supports data analysis and information delivery staff in the design, development, and maintenance of data implementations. Consults and provides direction on ETL architecture and the implementation of ETL solutions. Queries, analyzes, and interprets complex data stored in the systems of record, enterprise data warehouse, and data marts. Ensures work includes necessary audit, HIPAA compliance, and security controls. Data Management Collaborates with infrastructure and platform administrators to establish and maintain scalable and reliable data processing environment for the organization. Identifies and triages data quality and performance issues from the ETL perspective and see them through to resolution. Tests and validates components of the ETL solutions to ensure successful end-to-end delivery. Participates in support rotation. Qualifications Bachelor's degree with 8+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP (Online Transaction Processing) environments, semantic layer modeling experience, and SQL programming experience. OR associate degree with 11+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP environments, semantic layer modeling experience, and SQL programming experience. OR high school equivalence with 14+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP environments, semantic layer modeling experience, and SQL programming experience. Expert understanding of ETL concepts and commercially available enterprise data integration platforms (Informatica PowerCenter, Python) Expert knowledge of SQL development Expert knowledge of data warehousing concepts, design principles, associated data management and delivery requirements, and best practices Expert problem solving and analytical skills Ability to understand and communicate data management and integration concepts within IT and to the business and effectively interact with all internal and external parties including vendors and contractors Ability to manage multiple projects simultaneously Ability to work independently, under pressure, and be adaptable to change Inquisitive and seek answers to questions without being asked Hardware and equipment will be provided by the company, but candidates must have access to high-speed, non-satellite Internet to successfully work from home. We offer an excellent benefit and compensation package, opportunity for career advancement and a professional culture built on the foundations of Respect, Responsibility, Resourcefulness and Relationships. To support a safe work environment, all employment offers are contingent upon successful completion of a pre-employment criminal background check. Quartz values and embraces diversity and is proud to be an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, gender identity or expression, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified person with disability. We can recommend jobs specifically for you! Click here to get started.
$107.5k-134.4k yearly Auto-Apply 39d ago
Data/ ETL Architect - Tallahassee, FL
AHU Technologies Inc.
Remote etl architect job
Job Description Scope of Work/Job Characteristics The Data Architects, under the working job title of Extract, Transform, Load (ETL) Architects, will serve as the principal line of communication for the project team. The ETL Architects will drive the development of data integration pipelines, enabling efficient, reliable access to critical data within the Correction Information Management System (CIMS) Data Warehouse/Data Lake on Azure. They will work with Azure Data Factory (ADF), Azure Databricks, Azure Synapse, Power BI, and Azure Purview. The ETL Architects will be at the forefront of transforming complex data into actionable insights. The ETL Architects will be responsible for ensuring data integrity, security, and performance, all while meeting mission-critical needs. The specific duties and responsibilities of this position are as follows: ETL Pipeline Design and Development: Lead the design and development of high-performing ETL processes to integrate and transform data across disparate sources; Deliver efficient, reliable pipelines that meet business needs and maintain the highest standards of security; and Utilize ADF to automate and streamline data workflows, ensuring smooth transitions from source to target. Data Integration and Transformation: Build and manage complex ETL workflows that extract, transform, and load data for downstream analytics and reporting, ensuring data is accurate, timely, and secure; and Take ownership of data quality and validation, creating resilient ETL processes that ensure only trusted data reaches its destination. Cloud Platform Expertise: Leverage the full power of the Azure ecosystem ADF, Databricks, Synapse, and Purviewto manage and process high volumes of structured and unstructured data, delivering solutions that are scalable and performance-optimized; and Integrate large datasets into Azure Synapse Analytics, enabling analytics teams to deliver data-driven insights that support the Departments mission. Performance Optimization: Continuously optimize ETL jobs to minimize latency and maximize throughput; and Ensure the architecture supports fast, reliable data access for end-users and systems, meeting stringent performance metrics. Security and Compliance: Embed security and compliance best practices in every step of the ETL process;. Protect sensitive data by adhering to industry standards and ensuring compliance with the Departments data governance policies; and Use Azure Purview to enforce data governance, track data lineage, and ensure that data handling meets the highest standards of integrity. Collaboration and Stakeholder Engagement: Partner with cross-functional teams (e.g., data engineers, analysts, business stakeholders, and security experts) to design and implement ETL solutions that meet the Departments evolving needs; and Act as a technical leader and mentor, helping guide junior team members and providing expert guidance on data processing and transformation best practices. Documentation and Best Practices: Develop and maintain clear, detailed documentation for ETL processes, ensuring the team can consistently deliver high-quality, reliable solutions; and Establish and enforce best practices for data handling, ETL development, and security, driving a culture of excellence and accountability. Required Qualifications A bachelors degree from an accredited college or university in Computer Science, Information Systems, or a related field is required. Alternatively, equivalent work experience, including experience in Service-Oriented Architecture (SOA) and Microsoft Azure Cloud Solutions, can be substituted for the educational requirement on a year-for-year basis, when applicable. The Department requires the following experience, skills, and knowledge for this position: Seven (7) or more years of experience in ETL development and data engineering; Three (3) or more years of hands-on experience working with ADF, Azure Cloud, Azure Databricks, Azure Synapse Analytics, and Azure Purview; Proven track record of building and optimizing large-scale ETL pipelines for high-performance, high-availability environments; Extensive expertise in Spark, Python, and/or Scala for large-scale data transformations; Strong Structured Query Language (SQL) proficiency and experience working with complex data structures; In-depth knowledge of data governance, security protocols, and role-based access control (RBAC) within the Azure ecosystem; and Ability to design ETL processes that are resilient, efficient, and fully compliant with regulatory standards. Preferred Qualifications The Department prefers the Candidates to have the following experience, skills, and/or knowledge for this position: Possession of a Microsoft Office Certification as an Azure Data Engineer Associate, Azure Solutions Architect Expert, and Azure Fundamentals; and Azure Databricks Certification as a Data Engineer Associate. This is a remote position.
$101k-136k yearly est. 19d ago
ETL Architect
E*Pro 3.8
Etl architect job in Columbus, OH
E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website ****************** Job Description Title : ETL Architect Location : Columbus, OH Type : Fulltime Permanent Work Status : US Citizen / GC / EAD (GC) Required Skills: • Responsible for Architecture, Design and Implementation of Data Integration/ETL, Data Quality, Metadata Management and Data Migration solutions using Informatica tools • Execute engagements as Data Integration-ETL Architect and define Solution Strategy, Architecture, Design and Implementation approach • Expertise in implementing Data Integration-ETL solutions which include components such as ETL, Data Migration, Replication, Consolidation, Data Quality, Metadata Management etc. using Informatica products (e.g. Power Center, Power Exchange, IDQ, Metadata Manager) • Responsible for Detailed ETL design, Data Mapping, Transformation Rules, Interfaces, Database schema, Scheduling, Performance Tuning, etc • Lead a team of designers/developers and guide them throughout the implementation life cycle and perform Code review • Engage client Architects, SMEs and other stakeholders throughout Architecture, Design and implementation lifecycle and recommend effective solutions • experience in multiple Databases such as Oracle, DB2, SQL Server, Mainframe, etc • Experience in Industry models such as IIW, IAA, ACORD, HL7, etc. and Insurance products (e.g. Guidewire) will be plus Additional Information All your information will be kept confidential according to EEO guidelines.
$92k-122k yearly est. 3h ago
ETL Architect
Unity Health Insurance 4.7
Remote etl architect job
Come Find Your Spark at Quartz! The ETL Architect will be responsible for the architecture, design, and implementation of data integration solutions and pipelines for the organization. This position will partner with multiple areas in the Enterprise Data Management team and the business to successfully translate business requirements into efficient and effective ETL implementations. This role will perform functional analysis, determining the appropriate data acquisition and ingestion methods, and design processes to populate various data platform layers. The ETL Architect will work with implementation stakeholders throughout the business to evaluate the state of data and constructs solutions that deliver data to enable analytics reporting capabilities in a reliable manner. Skills this position will utilize on a regular basis: * Informatica PowerCenter * Expert knowledge of SQL development * Python Benefits: * Opportunity to work with leading technology in the ever-changing, fast paced healthcare industry. * Opportunity to work across the organization interacting with business stakeholders. * Starting salary range based upon skills and experience: $107,500 - $134,400 - plus robust benefits package. Responsibilities * Architects, designs, enhances, and supports delivery of ETL solutions. * Architects and designs data acquisition, ingestion, transformation, and load solutions. * Identifies, develops, and documents ETL solution requirements to meet business needs. * Facilitates group discussions and joins solution design sessions with technical subject matter experts. * Develops, implements, and maintains standards and ETL design procedures. * Contributes to the design of the data models, data flows, transformation specifications, and processing schedules. * Coordinates ETL solution delivery and supports data analysis and information delivery staff in the design, development, and maintenance of data implementations. * Consults and provides direction on ETL architecture and the implementation of ETL solutions. * Queries, analyzes, and interprets complex data stored in the systems of record, enterprise data warehouse, and data marts. * Ensures work includes necessary audit, HIPAA compliance, and security controls. * Data Management * Collaborates with infrastructure and platform administrators to establish and maintain scalable and reliable data processing environment for the organization. * Identifies and triages data quality and performance issues from the ETL perspective and see them through to resolution. * Tests and validates components of the ETL solutions to ensure successful end-to-end delivery. * Participates in support rotation. Qualifications * Bachelor's degree with 8+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP (Online Transaction Processing) environments, semantic layer modeling experience, and SQL programming experience. * OR associate degree with 11+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP environments, semantic layer modeling experience, and SQL programming experience. * OR high school equivalence with 14+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP environments, semantic layer modeling experience, and SQL programming experience. * Expert understanding of ETL concepts and commercially available enterprise data integration platforms (Informatica PowerCenter, Python) * Expert knowledge of SQL development * Expert knowledge of data warehousing concepts, design principles, associated data management and delivery requirements, and best practices * Expert problem solving and analytical skills * Ability to understand and communicate data management and integration concepts within IT and to the business and effectively interact with all internal and external parties including vendors and contractors * Ability to manage multiple projects simultaneously * Ability to work independently, under pressure, and be adaptable to change * Inquisitive and seek answers to questions without being asked Hardware and equipment will be provided by the company, but candidates must have access to high-speed, non-satellite Internet to successfully work from home. We offer an excellent benefit and compensation package, opportunity for career advancement and a professional culture built on the foundations of Respect, Responsibility, Resourcefulness and Relationships. To support a safe work environment, all employment offers are contingent upon successful completion of a pre-employment criminal background check. Quartz values and embraces diversity and is proud to be an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, gender identity or expression, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified person with disability.
$107.5k-134.4k yearly Auto-Apply 38d ago
ETL Developer II (Remote - US)
Jobgether
Remote etl architect job
This position is posted by Jobgether on behalf of a partner company. We are currently looking for an ETL Developer II in the United States. We are seeking a skilled ETL Developer II to design, enhance, and maintain robust data integration processes across internal systems. This fully remote role offers the opportunity to work closely with a small, collaborative team to ensure seamless data flow, accurate reporting, and reliable insights for decision-making. The ideal candidate will be responsible for building scalable ETL pipelines, working with APIs, and supporting business teams with efficient and automated data solutions. This position is critical to the development of data-centric tools that drive organizational success, while allowing autonomy, professional growth, and a strong work/life balance. Accountabilities Design, develop, and maintain ETL processes to support business functions and internal teams. Administer the ETL ecosystem, ensuring data accuracy, integrity, and optimal performance. Collaborate with stakeholders to understand business logic and deliver effective integration solutions. Generate reports and queries from databases to facilitate data-driven decision-making. Automate workflows and continuously improve processes for efficiency and reliability. Integrate data through APIs and other tools to support seamless information exchange. Troubleshoot and resolve issues in data pipelines to maintain smooth operations. Requirements 3+ years of experience with relational databases and SQL. Bachelor's degree in Computer Science, Information Systems, or related field. 3+ years of hands-on experience with ETL tools (e.g., Talend, SSIS, Informatica). Proficiency in Excel for data manipulation, reporting, and analysis. Experience with API testing tools (e.g., Postman) and data integrations. Familiarity with BI and reporting tools (e.g., Power BI, Tableau). Strong problem-solving, troubleshooting, and critical thinking skills. Excellent written and verbal communication skills to convey technical concepts to non-technical stakeholders. Preferred: Knowledge of data governance, cloud platforms (AWS, Azure, Google Cloud), and data quality best practices. Benefits Fully remote, work-from-home position. Generous paid time off and paid holidays. Annual bonus potential. Retirement savings plans with company support. Paid training and professional development opportunities. Career growth and advancement within a global organization. Supportive and collaborative work environment fostering diversity and inclusion. Jobgether is a Talent Matching Platform that partners with companies worldwide to efficiently connect top talent with the right opportunities through AI-driven job matching. When you apply, your profile goes through our AI-powered screening process designed to identify top talent efficiently and fairly. 🔍 Our AI evaluates your CV and LinkedIn profile thoroughly, analyzing your skills, experience, and achievements. 📊 It compares your profile to the job's core requirements and past success factors to determine your match score. 🎯 Based on this analysis, we automatically shortlist the 3 candidates with the highest match to the role. 🧠 When necessary, our human team may perform an additional manual review to ensure no strong profile is missed. The process is transparent, skills-based, and free of bias - focusing solely on your fit for the role. Once the shortlist is completed, we share it directly with the company that owns the job opening. The final decision and next steps (such as interviews or additional assessments) are then made by their internal hiring team. Thank you for your interest! #LI-CL1
$81k-105k yearly est. Auto-Apply 8d ago
ETL Developer (VM)
Blue Coding
Remote etl architect job
Why Blue Coding? At Blue Coding, we specialize in hiring excellent developers and amazing people from all over Latin America and other parts of the world. For the past 11 years, we've helped cutting-edge companies in the United States and Canada build great development teams and develop great products. Large multinationals, digital agencies, Saas providers, and software consulting firms are just a few of our clients. Our team of over 150 engineers, project managers, QA, UX/UI designers, and many more is distributed in more than 10 countries across the Americas. We are a fully remote company working with a wide array of technologies, and we have expertise in every stage of the software development process. Our team is highly connected, united, and culturally diverse, and our collaborators are involved in many initiatives around the world, from wildlife preservation to volunteering at local charities. We stand for honesty, fairness, respect, efficiency, hard work, and cooperation. This position is open exclusively to candidates based in LATAM countries. What are we looking for? In this opportunity, we are looking for an ETL Developer to work with one of our foreign clients, a market leader in the consultation, design, procurement, implementation, and ongoing managed services for technology services for mid to large global enterprises. As a Telecom Managed Service company, they partner with over 300 service providers globally to help customers with technology design and find the best solutions to meet their needs. Our client is modernizing their data infrastructure with AWS Glue, Redshift, and S3, replacing legacy ETL tools. We need a hands-on ETL Developer to build and maintain scalable pipelines that power analytics and business decisions. You'll work closely with Data Engineering and BI teams to ensure clean, efficient, and well-documented data flows, from SQL Server (RDS) to their Redshift data warehouse. This role is critical in eliminating manual processes and enabling self-service data access If you are independent, a great communicator, a problem solver, and have a strong attention to detail, this is a great fit for you! Our jobs are fully remote; as long as you have the skills and can get the work done well, you can work anywhere in the listed countries you want.Here are some of the exciting day-to-day challenges you will face in this role: Develop and automate ETL workflows using AWS Glue (Python/PySpark) to ingest, transform, and load data into Redshift and S3. Monitor and troubleshoot pipelines, ensuring data accuracy and SLA adherence. Optimize S3 storage (partitioning, lifecycle policies) for cost-effective data lake management. Collaborate on data modeling (star schema, dimensional modeling) for analytics-ready datasets. Document data flows, ERDs, and lineage for clarity and governance. Profile and validate data to catch issues early and maintain trust in reporting. Support BI teams by resolving data discrepancies and improving pipeline efficiency Conduct ad hoc analysis and exploratory data work as needed. Contribute to the documentation of system specifications, testing procedures, and operational support materials. Participate in code reviews and continuous improvement of development standards. Provide production support and assist with troubleshooting and resolving data issues. You will shine if you have: Bachelor's degree in Computer Science or a related field, or equivalent work experience. 3+ years of related work experience as an ETL Developer, with AWS cloud experience (Glue, Redshift, S3). Strong SQL & Python (PySpark preferred). Experience building batch ETL pipelines (not just drag-and-drop tools). Knowledge of data warehousing (ODS, dimensional modeling, slowly changing dimensions). Ability to troubleshoot pipeline failures and optimize performance/cost. Clear communicator who can explain technical details to non-engineers. Excellent problem-solving and analytical skills. Strong organizational skills and attention to detail. Here are some of the perks we offer you: Salary in USD Long-term Flexible schedule (within US Time zones) 100% Remote Ready to learn more? Apply below!
$81k-105k yearly est. Auto-Apply 60d+ ago
Remote Oracle Data Integrator ETL Developer
Global Channel Management
Remote etl architect job
Remote Oracle Data Integrator ETL Developer needs 5 years data warehousing development, implementation and support experience Remote Oracle Data Integrator ETL Developer requires: 3 years Oracle Data Integrator(ODI) Strong SQL analysis skills and experience in database tuning and optimization. Experience two years experience with data modeling. 5 years data warehousing development, implementation and support Remote Oracle Data Integrator ETL Developer duties: Designed, developed, and maintained the data warehouse using Oracle database and Oracle Data Integrator (ODI) for ETL. Work with stakeholders to gather and analyze requirements for data warehousing solutions. Develop ETL jobs using ODI to extract, transform, and load data from various sources into the data warehouse. Perform performance tuning of the data warehouse, ETL jobs, and SQL queries to ensure optimal performance and scalability. Develop and maintain data models for the Data Warehouse. Support data operations by monitoring, troubleshooting, and resolving data issues. Collaborate with the development team to integrate data warehouse solutions with other enterprise systems. .
$74k-97k yearly est. 60d+ ago
ETL Tester - Remote
It Vision Group
Remote etl architect job
Must To Have Hands on knowledge in python ETL Testing Good to have b. APIs testing c. experience with test automation d. AWS s3 GxP is not needed/optional. DB testing is one of the key stills mentioned. Resource need not be in person - this is a remote role. So anyone who can provide 100% EST overlap is good.
$69k-88k yearly est. 15d ago
ETL DEVELOPER II
Palco 4.1
Remote etl architect job
Palco is a visionary company pioneering an emerging health-care movement that empowers people with disabilities and those aging to live independent and quality lives. Made possible by our amazing team, Palco provides technology and financial services to aid individuals and their families to thrive in their home and communities. Partnered with government agencies and fortune 500 managed care organizations across the country, we are dedicated to creating exceptional outcomes for our clients and the millions of people that count on them. We are a highly organized company that offers a solid work/life balance, autonomy, generous paid time off, bonus potential, and career advancement opportunities. Our staff make long-lasting impact on the lives of people every day. We are seeking an ETL Developer II to join our growing team. This is a fully remote, work-from-home position. The ideal candidate will be responsible for creating, enhancing, and administering ETL processes, ensuring seamless data integration across internal systems, and supporting various teams with reliable data solutions. This role is integral to the development of data-centric tools and processes and will work closely with a small, remote team. Duties and Responsibilities Design, create, and enhance ETL processes to support internal teams and business functions. Administer and maintain the ETL ecosystem, ensuring data accuracy, integrity, and performance. Collaborate with key stakeholders to understand application business logic and deliver effective integration solutions. Generate reports and queries from various databases to support data-driven decision-making or business processes. Continuously improve and automate data workflows, identifying opportunities to enhance efficiency and reliability. Work with APIs and integration tools to facilitate data exchange between systems. Proactively identify and resolve issues in data pipelines, ensuring smooth operations. Requirements 3+ years of experience working with relational databases and SQL. Bachelor's degree in Computer Science, Information Systems, or related field. 3+ years of experience with ETL tools (e.g., Talend, SSIS, Informatica, or similar). 3+ years of experience using Excel for data manipulation and reporting. Experience with API testing tools (e.g., Postman) and working with APIs for integrations. Familiarity with BI and reporting tools (e.g., Power BI, Tableau, or similar). Strong troubleshooting, problem-solving, and critical thinking skills. Ability to apply smart, effective solutions to unique data challenges. Excellent written and verbal communication skills, with the ability to explain technical concepts to non-technical stakeholders. Preferred Qualifications Familiarity with data governance and data quality best practices. Knowledge of cloud platforms and services (e.g., AWS, Azure, or Google Cloud). Join Us This position is remote/work-from-home role. Enjoy the convenience of working from home and maximize your time by unplugging at the end of your workday. Company benefits designed for you: Generous Paid time off. Annual bonus potential. Retirement Savings: We will support you as you save for your future. Career Growth Opportunities: We help you thrive, so together, we can grow. We provide opportunities to advance your career with a vast portfolio of businesses and a global footprint. Paid Training: Earn while you learn and continue to grow with access to internal and external learning opportunities. Great Work Environment: We are proud of our company culture of collaboration and the recognition we have received for our diversity efforts. Benefits package: Employer shared Health Insurance cost Paid Time Off Remote work environment Paid holidays When you join Palco, you are engaged in creating the future - both our company's, the people we serve, and your own. We understand that our success is directly related to the success of our team. We strive to create a culture where you can: Bring your authentic self to work. Grow and thrive, both personally and professionally. Make a difference with our clients, in our communities, and with the millions of people we support. Experience work/life balance. Feel value and a greater purpose through the work you do. Palco, Inc. is an Equal Employment Opportunity (EEO) employer and does not discriminate in any employer/employee relations based on race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.
$70k-90k yearly est. Auto-Apply 20d ago
ETL Tester (w2 ONLY- REMOTE)
Instantserve
Remote etl architect job
We are looking for a skilled QA Consultant to join our Agile development team supporting the Engineering Servicing business unit. You'll play a critical role in testing systems that manage engineering visit scheduling and order processing, while helping to consolidate legacy applications. Key Responsibilities: Perform manual testing on application functionality, backend logic, and ETL workflows. Test SQL queries, stored procedures, and validate ETL processes for data accuracy. Collaborate on introducing test automation based on team priorities. Coordinate with QA and development teams to maintain testing standards. Support UAT and ensure systems meet business requirements. Work across technologies such as .NET, C#, SQL, SSIS, React, and REST APIs. Qualifications Qualifications: Strong experience in manual QA, SQL, stored procedures, and ETL testing (required). Knowledge of Agile practices and working closely with cross-functional teams. Familiarity with .NET, SSIS, React, REST APIs is a plus. Excellent communication and analytical skills. Experience with test automation frameworks and tools like Selenium or Cypress is a bonus. Team & Project Overview: Join a collaborative team of engineers, analysts, and a product owner. Contribute to legacy system retirement and platform consolidation. Opportunity to lead QA best practices and improve automation coverage. Additional Information Why Join Us? InstantServe offers a dynamic work environment where you can make a significant impact on the healthcare industry. We provide competitive compensation, opportunities for professional growth, and a supportive team culture. All your information will be kept confidential according to EEO guidelines.
$66k-83k yearly est. 60d+ ago
ETL Developer (Clearance Required) (Remote)
Yudrio
Remote etl architect job
ETL Developer Clearance Required: Active IRS MBI Clearance Yudrio is seeking a highly skilled ETL Developer with extensive experience in Informatica PowerCenter development and related component technologies (e.g., ETL Designer). The ideal candidate will have a proven track record in building, maintaining, and optimizing ETL processes, stored procedures, functions, and inline SQL. This role requires strong performance tuning skills, familiarity with Agile methodologies, and the ability to work independently across all phases of the Software Development Life Cycle. Key Responsibilities Design, develop, and maintain ETL processes using Informatica PowerCenter and related tools. Create, optimize, and manage stored procedures, functions, and SQL scripts. Perform performance tuning for Informatica sources, mappings, targets, and sessions. Participate in all phases of the SDLC, with emphasis on Agile project environments. Work with Greenplum (PostgreSQL) and/or Oracle SQL/PLSQL for database development and optimization. Monitor, support, and resolve issues for applications leveraging technologies such as Informatica, Greenplum, and Mainframe systems. Provide support during production maintenance windows and participate in on-call rotations as needed. Required Qualifications Active IRS MBI Clearance (required for consideration). 7+ years of experience as a software developer with the specified technologies. 3+ years of experience using Rational Team Concert or equivalent tools. Demonstrated experience with Control-M (specific to ETL development). Hands-on experience with Greenplum or a similar database platform. Professional Skills Strong oral and written communication skills with the ability to engage stakeholders at all organizational and technical levels. Excellent time management skills and the ability to meet deadlines in a fast-paced environment. Proven ability to work effectively in a collaborative, high-performing team environment. Proficiency with Microsoft Office Suite (Word, PowerPoint, Excel, SharePoint).
$79k-103k yearly est. 60d+ ago
Architect - BI & Analytics
3Cloud 3.9
Remote etl architect job
Are you looking for a role that motivates and challenges you? Are you ready for an opportunity for growth? Do you want to work on teams where people roll up their sleeves to take on tough problems together, and regularly blow the doors off our clients with their outstanding teamwork? If you answered yes to those questions, 3Cloud might just be for you! At 3Cloud, we hire people who aren't afraid to experiment or fail. We hire people who are willing to give direct and candid feedback to their managers, leaders, and team members. We hire people who jump at those opportunities because they care about our collective growth and success. We hire people who challenge and hold each other accountable for living 3Cloud's core values because they know that it will result in amazing experiences and solutions for our clients and each other. Responsibilities: • Conduct customer discovery meetings to determine reporting requirements • Understand and work with customers on Power BI Licensing, and understand the limits/advantages of each licensing platform • Create well-performing star schema data models for use with Power BI, including properly calculated columns and measures • Creating Power BI solutions for customers including importing data from multiple sources, building reports and dashboards, and creating appropriate data elements using DAX and source queries • Guide customers on deploying Power BI solutions to the Power BI service (Gateways, DirectQuery, DataFlows, Data Updates) • Estimate and plan work for large technical solutions • Develop Power BI governance solutions to support various forms of self-service Business Intelligence models for customers • Optimize tabular models and Power BI report performance • Experience deploying and designing Power BI solutions using Power BI Embedded • Develop relationships with clients to uncover future analytic needs • Design, develop and implement user interfaces to ensure ease of use and minimal knowledge by the functional work group that will be using the database Requirements: • Bachelor's degree in computer, engineering, data science or a related field; or equivalent work experience • 5+ years working with data and business intelligence solutions on the Microsoft tool stack for Business Intelligence (SSRS, Power BI, or PowerPivot (Excel) or PerformancePoint), or other vendor Business Intelligence tools (Business Objects, MicroStrategy, Qlik, SAP) • Deploying cloud-based solutions using Microsoft Azure data services including Azure Data Factory, Azure Data Lake, and Azure SQL DB • Power BI tenant and workspace management to support development, testing and deployment • Experience with analytics and custom visualizations for Power BI using Python, R • Expertise of TSQL, data modeling, reporting using Power BI or other Microsoft tools • Experience creating complete Power BI report solutions based on business questions with linked content, drilldowns, and nested parameters • Knowledge of data mashups and transformations using Power Query/M language • Ability to report visual choices and visual interactions • Ability to gather requirements and conduct focus groups to determine the processes needed to assist and grow the business • Experience leading technical teams and eager to contribute in a team-oriented environment • Excellent communication (written and oral) and interpersonal skills for both technical and nontechnical teams • Passionate about learning new technologie Don't meet every single requirement? At 3Cloud we are dedicated to building a diverse, inclusive and authentic workplace, so if you're excited about this role but your experience doesn't align perfectly with every qualification in the , we encourage you to apply anyway. At this time, we cannot sponsor applicants for work visas This Job Posting will expire on Monday, December 15th, 2025. 3Cloud Total Rewards Highlights Include: Flexible work location with a virtual first approach to work! 401(K) with match up to 50% of your 6% contributions of eligible pay Generous PTO providing a minimum of 15 days in addition to 9 paid company holidays and 2 floating personal days Two medical plan options to allow you the choice to elect what works best for you! Option for vision and dental coverage 100% employer paid coverage for life and disability insurance Paid leave for birth parents and non-birth parents Option for Healthcare FSA, HSA, and Dependent Care FSA $67.00 monthly tech and home office allowance Utilization and/or discretionary bonus eligibility based on role Employee Assistance Program to help with everyday challenges 3Cloud offers competitive compensation. In addition to base pay employees are eligible to receive an annual discretionary/utilization bonus. If you are hired at 3Cloud your final base salary is based on factors such as skills, education, experience and/or geographic location. Please keep in mind that the range mentioned above includes the full base salary range for the role. It is not typical for offers to be made at or near the top of the range. Base Salary Range$108,200-$156,900 USD Don't meet every single requirement? At 3Cloud we are dedicated to building a diverse, inclusive and authentic workplace, so if you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description, we encourage you to apply anyway. At this time, we cannot sponsor applicants for work visas.
$108.2k-156.9k yearly Auto-Apply 10d ago
Senior ETL Developer - Seattle, WA, USA
Photon Group 4.3
Remote etl architect job
Greetings Everyone Who are we? For the past 20 years, we have powered many Digital Experiences for the Fortune 500. Since 1999, we have grown from a few people to more than 4000 team members across the globe that are engaged in various Digital Modernization. For a brief 1 minute video about us, you can check ***************************** What will you do? What are we looking for? Job Title: Senior ETL Developer - Data Services Team Key Duties • Plays a lead role in the areas of ETL design, data modeling, and ETL development. • Facilitates best practice guidelines around all stages of development. • Provides technical leadership to serve as point of escalation, review, and approval for key issues, significant projects, and decisions. • Able to work with stakeholders, and translate requirements to design and build a solution that will meet Business needs and integrate seamlessly with the EDW. • Gain team and stakeholder approval for all designs, and effort estimates. • Research and analyze current systems, subsystems and interfaces to understand the current or new process flow. • Document work via Functional and Tech Specs. • Develop unit tests, performance tests, and take into account security requirements. • Prepare and participate in design and code reviews. • Analyzes processes for gaps and weaknesses, building future state models and creating the roadmaps and migration plans to get there. • Communicate progress and work using the Agile Methodology. Job-Specific Skills • Required: o 5+ years of experience of with Oracle o 5+ years of experience with Data Warehousing: building relational databases, star schemas o 5+ years of experience with Data Modeling o 4+ years of experience with ODI (Oracle Data Integrator Tool) or Informatica IDMC. o 3+ years of experience with Databricks Lakehouse and/or Delta tables. o 2+ years of experience in the design, implementation, and support of a Kimball method data warehouse on SQL Server or Oracle o Strong SQL reading and writing skills o Business and/or technical background in the areas of Data Integration (ETL), Data Security, and Enterprise Data Warehouse development o Experience in Change Management, Release Management, and Source Code control practices Education • High school diploma or equivalent is required. • A Bachelor of Arts or a Bachelor of Science degree, with a focus in computer science, systems analysis, or a related area, is preferred. Compensation, Benefits and Duration Minimum Compensation: USD 44,000 Maximum Compensation: USD 176,000 Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role. Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees. This position is also available for independent contractors No applications will be considered if received more than 120 days after the date of this post
$87k-113k yearly est. Auto-Apply 60d+ ago
BI Architect
Factor Systems, Inc. 4.5
Remote etl architect job
Factor Systems, LLC d/b/a Billtrust is seeking a BI Architect for its office in Hamilton Township, NJ. Define the end-to-end architecture and standards for our core data platforms, data engineering pipelines; drive the implementation of a Modern Data Stack to ensure proper code driven version control, idempotent data pipelines (Airflow, etc), Transform layers (DBT) as well as optimization of Extract/Load logic. The position requires a Master's degree in Business Administration, or a related field, and a minimum of 5 years' experience in the job offered or any related occupation, to include 5 years of experience in Business Intelligence tools, reporting, and database technologies; 5 years' experience utilizing Python for data analysis, automation, and integration tasks; 5 years' experience designing containerized solutions using Kubernetes/Docker; and 5 years' experience with AWS cloud infrastructure and services. Remote work from home permitted anywhere in the U.S. Employer will accept any suitable combination of education, experience, and training. Experience may have been gained concurrently. Interested individuals should apply online at ********************************** using keywords “BI Architect” Don't meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At Billtrust, we celebrate and support diversity and are committed to creating an inclusive environment for all employees. So, if your experience aligns but doesn't exactly match each and every qualification, apply anyway. You may be exactly what we are looking for! What You'll Get: Work from Anywhere: Your home, a coffee shop, a company paid WeWork.... you decide! A Culture that Lives its Values: Our values are not just words or window dressing, they guide our decisions - big and small - each and every day. Flexible Working Hours: We support your lifestyle- the results are what count. Open PTO: Work-life balance is important. We believe in giving our employees time to truly relax and recharge. Sabbatical: A paid leave to reward longevity and commitment to Billtrust. Paid Parental Leave: To promote parent-child bonding and increase gender equity at home and in the workplace. Opportunities for Growth: Professional development can take many shapes. Join one of our seven ERGs or participate in our Mentor-Mentee, and Leadership development programs- we foster an environment where all employees can grow. Recognition: From Billtrust Bucks and CEO Shoutouts to Culture Champion and CEO Excellence Awards, our employees are recognized for hard work and outcomes achieved. Benefits: Medical, dental, vision, 401(k) with company match, short-term and long-term disability, flexible spending accounts, HSA, and life, cancer, and AD&D insurance. Minimal Bureaucracy: An entrepreneurial environment of ownership and accountability allows you to get work done. Who We Are: Finance leaders turn to Billtrust to control costs, accelerate cash flow and improve customer satisfaction. As a B2B order-to-cash software and digital payments market leader, we help the world's leading brands get paid faster while transitioning from expensive paper invoicing and check acceptance to efficient electronic billing and payments. With over 2,600 global customers and more than $1 trillion invoice dollars processed, Billtrust delivers business value through deep industry expertise and a culture relentlessly focused on delivering meaningful customer outcomes. #LI-Remote
$107k-150k yearly est. Auto-Apply 59d ago
ETL developer
Nuanza
Etl architect job in Columbus, OH
Job Description Primary Responsibilities: Manages and maintains all productions and non-production Teradata and other Data Warehouse MPP database systems Works with (EDW) Enterprise Data Warehouse team with workload management standards for groups, roles, priorities Lead and mentor Strong presentation and verbal communications skills are essential Must Have: Management / Administration of MPP (Massively Parallel Processing) databases MPPs = Teradata, Snowflake, Greenplum, Netezza or Redshift (Amazon/AWS) Setting up Monitoring alerts for Workflow Management Audit procedures and Database Security LDAP requirements documentation Scripting programming, any language to move the data, like Python or Linux Strong Plus: Teradata Certification Knowledge or Retail Industry ETL experience with tools ODI or Ab Initio
$74k-97k yearly est. 15d ago
ETL Developer (AB Initio)
Technoconsulting
Etl architect job in Columbus, OH
ETL Developer (AB Initio) :: Columbus, Ohio 43219 Skills/Experiences: Looking for an ETL developer with multiyear in depth experience using Abinitio if they have Open Text Dialogue or Quadient GMC Inspire experience that would be a plus but far from required. Candidate should have 4-5 years of experience in Industry. Can should have around 1-2 years of experience with Ab initio. Additional Information All your information will be kept confidential according to EEO guidelines.
$74k-97k yearly est. 3h ago
ETL Developer
Zoe Staffing 3.8
Etl architect job in Columbus, OH
Company DescriptionDESCRIPTION: Our client is a leading retailer based in central Ohio with an enterprise initiative to overhaul their data warehouse, business intelligence, and analytic platform. Job Description ETL Developer - Custom Development Full Time Permanent Position in Columbus OH The business driver for this initiative is to enable the enterprise to make effective decisions based on data, thus reducing risk for the business and enabling agility in the business. This multi-year program involves a new architecture, tools, and processes to build and implement this environment. It also involves conversion from the existing platform. The manager for the team is seeking a strong developer to build ETL programs and processes for the new platform. This role will involve working with architects, business stakeholders, and team members to analyze the design, and do the detail technical design and development for new ETL programs. The architecture and design for the ETL environment is custom development using Korn Shell Scripting (KSH), SQL, and related tools. The data warehouse environment is Teradata. While a high degree of technical expertise is needed, this is not a “heads down” coding position. The successful candidate will have strong interpersonal and communication skills, coupled with five or more years' experience focused on the development of ETL processes. Technical expertise will focus on KSH, SQL, Linux / Unix, and related skills. RESPONSIBILITIES: As part of the ETL team, develop, review, and refine technical design for ETL processes. Learn and support the data model and architecture for the new environment. Analyze and enhance ETL processes to determine data sources and destinations. Develop, test, and implement ETL process for new platform. As required, support for the current data warehouse environment. Work with business and technology stakeholders to understand business requirements and technology needs. Qualifications SKILLS / KNOWLEDGE / EXPERIENCE: Strong written and oral communication skills. Ability to adapt communications for various audiences. The ability to work as a collaborative team member yet be self-managed and directed as needed. Initiative to take action towards objectives when faced with ambiguity. Exceptional skills developing with Korn Shell Scripting, SQL, and related Unix / Linux tools. Strong database experience with Teradata, Oracle, PL/SQL, and relational and multi-dimensional designs. Typically, four to seven years' experience working in a data warehouse / BI environment, specifically in custom development of ETL processes. Proven ability to build ETL packages / scripts from scratch. Strong testing skills. Understanding of data warehouse architectures and designs including Star Schemas, Snowflake Schemas, Slowly Changing Dimensions, and Aggregation Techniques. Data cleansing, data modeling, and other data related experience. Performance tuning and optimization experience. Additional experience in Oracle OD / RA, SSIS, MicroStrategy BI, and Message Based integration is a plus. Additional Information All your information will be kept confidential according to EEO guidelines.
$69k-88k yearly est. 60d+ ago
System Integration & Automation Architect
Ayr Global It Solutions 3.4
Etl architect job in Delaware, OH
AYR Global IT Solutions is a national staffing firm focused on cloud, cyber security, web application services, ERP, and BI implementations by providing proven and experienced consultants to our clients. Our competitive, transparent pricing model and industry experience make us a top choice of Global System Integrators and enterprise customers with federal and commercial projects supported nationwide. Job Description Title: System Integration & Automation Architect Location: Delaware, Duration: 6+ Months Contract Qualifications Requirements: Looking for architect level consultants with 8-10 years' experience in system integration and automation projects. Good in-depth knowledge experience in developing a design specification, framework upon considering the risk associated. Familiar with implementation processes and procedures. The person should have good knowledge and exposure to manage all the elements of IT Infra like End user systems, Servers, networks, storage, Deployment, active directory, LDAP, database & cloud infrastructure. Experience in system integration and automation through different tool sets Experience in designing, deployment and Implementation of Ansible, Morpheus CMP, PowerShell, Java scripts and Puppet. Experience and ability to produce a detailed design document that covers the necessary products, tools and development efforts, etc. to achieve the goals of the project. Project / program management skills with relevant certification Person should have very good interpersonal and communication skills with different stake holders Additional Information If anyone might be intersted please send resumes to kmarsh@ayrglobal (dot) com or you can reach me direct at **************
$95k-137k yearly est. 3h ago
Integration Architect
Hexaware Technologies 4.2
Remote etl architect job
JD: 12+ years of experience in IT industry with relevant experience in IBM integration stack
$84k-114k yearly est. Auto-Apply 15d ago

Learn more about etl architect jobs

Updated December 5, 2025

Browse computer and mathematical jobs

Etl architect jobs near me

Software Architect (Clinical Trials Platform)

ETL Architect

Data/ ETL Architect - Tallahassee, FL

ETL Architect

ETL Architect

ETL Developer II (Remote - US)

ETL Developer (VM)

Remote Oracle Data Integrator ETL Developer

ETL Tester - Remote

ETL DEVELOPER II

ETL Tester (w2 ONLY- REMOTE)

ETL Developer (Clearance Required) (Remote)

Architect - BI & Analytics

Senior ETL Developer - Seattle, WA, USA

BI Architect

ETL developer

ETL Developer (AB Initio)

ETL Developer

System Integration & Automation Architect

Integration Architect

Learn more about etl architect jobs

ETL Architect related jobs

ETL Architect related careers

What similar roles do

Resume for related jobs