IT Cloud Data Integration Architect

Advocate Health Care

  • Oak Brook, IL
  • Permanent
  • Full-time
  • 7 days ago
Department: 12295 Advocate Aurora Health Corporate - Enterprise Cloud Data EngineeringStatus: Full timeBenefits Eligible: YesHours Per Week: 40Schedule Details/Additional Information:Full Time RemotePay Range $62.15 - $93.25Major Responsibilities:Develop solutions architecture and evaluate architectural alternatives. Define and articulate an integration strategy, architecture, design patterns, and standards.Drive scope definition, requirements analysis, data and technical design, pipeline build, product configuration, unit testing, and production deployment.Introduce new integration solutions from design to rollout. Drive scope definition, requirements analysis, functional and technical design, application build, product configuration, unit testing, and production deployment.Design scalable ingestion processes to bring on-prem, API drive, 3rd party, end user generated data sources to integrate in common cloud infrastructure.Design reusable assets, components, standards, frameworks, and processes to accelerate and facilitate data integration projects.Provide technical leadership and guidance to development teams, ensuring best practices indata integrationProvide technical expertise and ownership in the diagnosis and resolution of an issue, including the determination and provision of workaround solution or escalation to service ownersBuild processes supporting data transformation, data structures, metadata, dependency and workload management.Ensure delivered solutions meet/perform to technical and functional/non-functional requirements.Ensure delivered solutions are realized in time frame committed; work in conjunction with project sponsors to size and manage scope and risk.Maintain overall industry knowledge on latest trends, technologies, etc.Licensure, Registration, and/or Certification Required:None Required.Education Required:Bachelor's Degree in Computer Science or related field.Experience Required:Typically requires 7 years of experience in at least two IT disciplines, including technical architecture, application development, middleware, database management or operations.Knowledge, Skills & Abilities Required:Capable of communicating and presenting complex information to technical and nontechnical stakeholders.Experience in developing and producing Integration and Technical Architecture Documents to include Requirements, Conceptual Technical Models, Platform, Performance and Operational RequirementsExperience defining, designing, and developing solutions with cloud data integration platforms/toolsProven experience building and optimizing data pipelines, and data sets.Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.Hands-on experience working with cloud based modern ELT tools and technologies like Fivetran, HVR, dbt, Airflow etc.Proficiency in Python and SQL for scripting and building data transformation processes is preferred.Experience in test automation with a focus on testing integrations, including APIs and data flows between enterprise systems.Must have experience end-to-end implementation of cloud data warehouse solutionsMust have experience with DevOps tool chains and processes.Must have hands-on experience with Snowflake Data Cloud.Must have experience of Agile development methodologiesExperience with healthcare data systems and data models is a plus.Physical Requirements and Working Conditions:This position does not require travel.#Remote#LI-RemoteDISCLAIMERAll responsibilities and requirements are subject to possible modification to reasonably accommodate individuals with disabilities.This job description in no way states or implies that these are the only responsibilities to be performed by an employee occupying this job or position. Employees must follow any other job-related instructions and perform any other job-related duties requested by their leaders.Our Commitment to You:Advocate Health offers a comprehensive suite of Total Rewards: benefits and well-being programs, competitive compensation, generous retirement offerings, programs that invest in your career development and so much more – so you can live fully at and away from work, including:Compensation
  • Base compensation listed within the listed pay range based on factors such as qualifications, skills, relevant experience, and/or training
  • Premium pay such as shift, on call, and more based on a teammate's job
  • Incentive pay for select positions
  • Opportunity for annual increases based on performance
Benefits and more
  • Paid Time Off programs
  • Health and welfare benefits such as medical, dental, vision, life, and Short- and Long-Term Disability
  • Flexible Spending Accounts for eligible health care and dependent care expenses
  • Family benefits such as adoption assistance and paid parental leave
  • Defined contribution retirement plans with employer match and other financial wellness programs
  • Educational Assistance Program
About Advocate Healthis the third-largest nonprofit, integrated health system in the United States, created from the combination of Advocate Aurora Health and Atrium Health. Providing care under the names in Illinois; in the Carolinas, Georgia and Alabama; and in Wisconsin, Advocate Health is a national leader in clinical innovation, health outcomes, consumer experience and value-based care. Headquartered in Charlotte, North Carolina, Advocate Health services nearly 6 million patients and is engaged in hundreds of clinical trials and research studies, with serving as the academic core of the enterprise. It is nationally recognized for its expertise in cardiology, neurosciences, oncology, pediatrics and rehabilitation, as well as organ transplants, burn treatments and specialized musculoskeletal programs. Advocate Health employs 155,000 teammates across 69 hospitals and over 1,000 care locations, and offers one of the nation’s largest graduate medical education programs with over 2,000 residents and fellows across more than 200 programs. Committed to providing equitable care for all, Advocate Health provides more than $6 billion in annual community benefits.

Advocate Health Care