Data Engineer IV/Data Architect, Day Shift, Information Technology (REMOTE)

Adventist HealthCare; Gaithersburg (MD); Remote; USD 127,000 - 192,000; Full time

Job summary

A non-profit healthcare organization in the United States is seeking a Data Engineer IV to lead ETL processes and maintain data warehouses. The ideal candidate will have over 7 years of experience in ETL development and data warehousing, with skills in Java, SQL, and various BI tools. This remote position offers a competitive salary and a comprehensive benefits package, emphasizing work-life balance and professional growth.

Benefits

Medical, Dental, and Vision coverage

Paid Time Off

Tuition Reimbursement

Employer retirement contribution

Free Employee parking

Qualifications

• 7+ years’ experience in data integration and ETL architecture.
• Experience with large scale data warehouses.
• Advanced knowledge of database security and performance monitoring.

Responsibilities

• Lead ETL processes for data onboarding into the data warehouse.
• Design and maintain data warehouse schemas and marts.
• Develop dashboards and reports for data visualization.

Skills

Java

SQL

XML

Data Visualization

ETL Development

Data Warehousing

AWS

Azure

Tableau

PowerBI

Education

Bachelor’s degree in computer science or related field

Tools

Talend

SSIS

Snowflake

SQL Server Management Studio

IBM Cognos

Job description

Data Engineer IV/Data Architect, Day Shift, Information Technology (REMOTE)

Support Center

Adventist HealthCare seeks to hire an experienced Data Engineer IV who will embrace our mission to extend God’s care through the ministry of physical, mental, and spiritual healing.

As a Data Engineer IV you will:

• Lead the creation and supports the ETL process to facilitate the on-boarding of data into the data warehouse and distribution of data across data stores from wide variety of sources using different ETL tools and technologies.
• Lead the design and develop the physical and virtual Data warehouse table schemas, database, data marts for new and existent data sources for the business’s data warehouse.
• Lead the development and maintenance of informative and actionable data visualizations and reports for analysis, problem solving, and business solutions that highlights relevant business trends and opportunities for improvement.
• Lead all service operational tasks including but not limited to database setup, maintenance, configuration, programming, troubleshooting, debugging, testing, fulfilling support requests, resolving incidents, and managing problems.
• Lead the creation and support of routine and ad hoc data load processes through database refreshes and updates.
• Optimize data integration platform to provide optimal performance under increasing data volumes.
• Lead the preparation and maintenance of comprehensive understanding of data warehousing and ETL application lifecycle, technical architecture, data, configuration, and operational support requirements.
• Maintains detailed charts, diagrams, and flow charts outlining systems, hardware, interfaces, and configurations related to data warehousing, ETL jobs, Data visualization, Data analytics and other similar.
• Provide expertise in the design and development of best practice for big data stacking, data warehousing, data lake, ETL architecture, data federation, virtualization, data modeling procedures, data visualization, and workflows including technical documents.
• Lead the analytics support to generate insights in the form of dashboards, metrics, or reports for healthcare solutions including the collection of detail business analytics requirements from stakeholders and the development of standardized functional requirement documents.
• Lead the preparation of presentations and demonstrates business intelligence solutions to end users.
• Lead in the training of end users on new reports and dashboards
• Assist in leading the preparation of documents related to data governance, definitions, key metrics, and sample reports, ensuring alignment and consistency in reporting across the organization and standardized data analytics, visualization, and business intelligence reports.
• Lead the data Integration and data warehousing application portfolio support in the timely resolution of technology incidents while adhering to SLA prioritization and success measures including 24x7 on call support.

Qualifications

• Bachelor’s degree in computer science, information technology, or a related field.
• 7+ years’ experience and knowledge of coding languages, including Java, XML, and SQL to extract data from various relational databases, application systems, flat files, XML documents, and load into data warehouses.
• 7+ years’ experience in warehousing architecture techniques, including MOLAP, ROLAP, ODS, DM, and EDW.
• 7+ years’ experience as an ETL developer using integration tools such as Talend and SSIS.
• Experience working on cloud-based environment such as AWS or Azure.
• Experience working with large scale data warehouses and related technologies.
• 7+ years working on building meaningful data analytics, reports, and visualizations in health care environment.
• Snowflake experience is preferred.
• Experience in metadata management and related tools.
• Advanced knowledge of database security, integrity, backup and recovery, and performance monitoring standards.
• 3 Years Supervisory Experience.
• Preferred Cloud-Data Warehouse certification or ETL Certification or Data Visualization.
• Experience with business intelligence software applications such as Tableau, PowerBI, SQL Server Management Studio, IBM Cognos.

Work Schedule and Location

Day Shift. REMOTE position within the United States.

Pay Range

$127,850.69 - $191,776.04

If the salary range is listed as $0 or if the position is Per Diem (with a fixed rate), salary discussions will take place during the screening process.

Under the Fair Labor Standards Act (FLSA), this position is classified as: United States of America (Exempt)

Benefits and Provisions

• Work life balance through nonrotating shifts
• Recognition and rewards for professional expertise
• Free Employee parking
• Medical, Prescription, Dental, and Vision coverage for employees and their eligible dependents effective on your date of hire
• Employer-paid Short & Long-Term Disability, Basic Life Insurance and AD&D, (short-term disability buy-up available)
• Paid Time Off
• Employer retirement contribution and match after 1-year of eligible employment with a 3-year vesting period
• Voluntary benefits include flexible spending accounts, legal plans, and life, pet, auto, home, long term care, and critical illness & accident insurance
• Subsidized childcare at participating childcare centers
• Tuition Reimbursement
• Employee Assistance Program (EAP) support

As a faith-based organization, Adventist HealthCare has earned a reputation for high-quality, compassionate care. If you want to make a difference in someone’s life every day, consider a position with a team of professionals who are doing just that, making a difference.

Join the Adventist HealthCare team today, apply now to be considered!

Legal and Compliance

COVID-19 Vaccination Adventist HealthCare strongly recommends all applicants to be fully vaccinated for COVID-19 before commencing employment. Applicants may be required to furnish proof of vaccination.

Tobacco and Drug Statement Tobacco use is a well-recognized preventable cause of death in the United States and an important public health issue. In order to promote and maintain a healthy work environment, Adventist HealthCare will not hire applicants for employment who either state that they are nicotine users or who test positive for nicotine and drug use. Some jurisdictions allow medical marijuana, but marijuana remains illegal under the federal Controlled Substances Act; medical marijuana use will not be accepted as a valid explanation for a positive drug test result.

Adventist HealthCare will withdraw offers of employment to applicants who test positive for Cotinine (nicotine) and marijuana. Those testing positive can re-apply after 90 days if they can attest no nicotine use in the past 90 days and pass follow-up testing. (Nicotine products include cigarettes, cigars, pipes, chewing tobacco, e-cigarettes, vaping products, hookah, and nicotine replacement products.)

Equal Employment Opportunity Adventist HealthCare is an Equal Opportunity/Affirmative Action Employer. We are committed to attracting, engaging, and developing the best people to cultivate our mission-centric culture. We do not discriminate in employment opportunities or practices on the basis of race, ethnicity, color, religion, sex, national origin, age, disability, sexual orientation, gender identity, pregnancy and related medical conditions, protected veteran status, or any other characteristic protected by law. We will make reasonable accommodations for applicants with disabilities, in accordance with applicable law. Applicants who wish to request accommodations should contact the Support Center HR Office.

About the company

Adventist HealthCare, based in Gaithersburg, Md., is a faith-based, not-for-profit organization of dedicated professionals who work together each day to improve the health and well-being of people and communities through a ministry of physical, mental, and spiritual healing.

Notice

Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. Talentify provides reasonable accommodations to qualified applicants with disabilities. Federal law requires Form I-9 and proof of identity and U.S. work eligibility. An Automated Employment Decision Tool (AEDT) will score job-related skills. Bias-audit & data-use details: www.talentify.io/bias-audit-report . NYC applicants may request an alternative process or accommodation at [e-mail].