EPIC Certified ETL Architect
Location
United States
Posted
23 hours ago
Salary
0
Seniority
Mid Level
Job Description
EPIC Certified ETL Architect
Northeast Georgia Health System
Role Description ETL Architect is a high-level business intelligence professional that is a key part of the Data and Analytics Team and will be generally responsible for: - Dimensional model design - End to end ETL architecture design - ETL development and implementation of data models - Development of Data Migration and Data Warehousing solutions - Requirements analysis and source data profiling - Identifying data quality issues - Designing transformation logic to address data quality issues - Designing for data warehouse/data mart solutions - Extensive interaction with operational team members and leadership - Analysis of business data and analytics requirements - Mentoring of other team members on ETL concepts and strategies - Keeping the ETL Environments updated periodically Qualifications - Epic Revenue or Clinical Data Model or Cogito Project Manager Certificate required (must be obtained within 6 months of date of hire) - Bachelors Degree in Computer Science or related field, or 11 years progressively responsible experience in the field Requirements - A minimum of seven (7) years experience with BI and analytic reporting software applications, strong preference for EPIC, SQL, and Crystal Report Writing - Prior experience providing production level support and/or development in BI/EDW environments - Experience in database development and management tasks - Working knowledge of data warehouse concepts and enterprise data management - Strong analytical and interpersonal skills - Advanced understanding of Data Migration/Data Warehousing/Data Mart delivery life cycle - Strong experience with concepts of data profiling and data quality issues - Excellent communication skills - Ability to function in a dynamic environment with changing schedules and priorities - Hands-on ability to design and re-design schemas, data models, and entity relationships - Experience in designing, building, testing, executing, and performance tuning of ETL and reporting applications Benefits - Service-oriented approach with customers - After-hours on-call support on a scheduled basis - Adherence to service level agreements Essential Tasks and Responsibilities - Designs end to end ETL architecture for Data Migration, Data Warehousing or Data Mart Solutions using Microsoft SSIS tool - Stands up a DW/ETL Center of Excellence to document and enforce best practices - Implements a reference data management system - Answers staff and client questions in person, via email and via phone - Works with leaders in IT and operations to identify data from other source systems - Participates in and contributes to the data governance program - Assists with all upgrade, update or enhancement efforts associated with the ETL tool - Builds and maintains SQL scripts, indexes, and complex queries for data analysis - Prepares and maintains key documents and technical specifications for new and existing solutions - Monitors incident management queue and efficiently troubleshoot issues Physical Demands - Weight Lifted: Up to 20 lbs, Occasionally 0-30% of time - Weight Carried: Up to 20 lbs, Occasionally 0-30% of time - Vision: Moderate, Frequently 31-65% of time - Kneeling/Stooping/Bending: Occasionally 0-30% - Standing/Walking: Frequently 31-65% - Pushing/Pulling: Occasionally 0-30%
Related Guides
Related Categories
Related Job Pages
More Architect Jobs
Sr. Solutions Architect
CedarCedar is the AI-powered healthcare financial experience platform, built for the rising cost and complexity of healthcare payments. We help millions of people every year understand and resolve their medical bills with clarity and compassion, while helping healthcare organizations operate more efficiently. We’re combining AI, smart design, and empathy to fix one of healthcare’s most urgent crises.
Our healthcare system is the leading cause of personal bankruptcy in the U.S. Every year, over 50 million Americans suffer adverse financial consequences as a result of seeking care, from lower credit scores to garnished wages. The challenge is only getting worse, as high deductible health plans are the fastest growing plan design in the U.S. Cedar’s mission is to leverage data science, smart product design and personalization to make healthcare more affordable and accessible. Today, healthcare providers still engage with its consumers in a “one-size-fits-all” approach; and Cedar is excited to leverage consumer best practices to deliver a superior experience. U.S. healthcare is frustrating and deeply flawed. Cedar’s mission is to drive better outcomes for everyone involved, including providers, insurance companies and the people they serve. At a time when consumer-friendly healthcare experiences are more critical than ever, our platform is uniquely equipped to solve problems that lead to billing issues and administrative waste. At Cedar, know that your work will have a meaningful impact on people’s lives. The Role: The Delivery organization owns the process of getting our new clients from implementation kickoff through launch to stability and handoff to the client management team. We're seeking a Senior Solutions Architect to lead the integration of Cedar's platform to our clients' healthcare management platforms. Solutions Architects are among the first "Cedarians" our clients get to know and are adept at building those client relationships alongside Cedar's other commercial teams. Simply put, Cedar doesn't realize its vision of improving the patient financial experience without our implementation team. Cedar is committed to a flexible work environment, so this, as well as many of our roles, is U.S. remote-friendly. Responsibilities: - Conduct technical and operational discovery with clients to define requirements, dependencies, and implementation risks. - Translate client data structures and file formats into Cedar’s infrastructure, schemas, and integration design. - Lead data validation and UAT efforts to identify root causes, resolve data mismatches, transformation issues, and load failures, and confirm the solution performs as expected across data quality, access, functionality, and performance. - Ability to communicate complex concepts to technical and operational stakeholders regarding networking, security, change approval processes, user authentication, and technical reviews. - Manage multi-threaded, complex projects and succinctly convey progress against goals/milestones. - Serve as the voice of the customer to internal stakeholders - engineering teams, account management, and product managers. - Critical thinking through ambiguity in technical and operational workflows. Solutions should meet client requirements and a high bar for technical sustainability and quality. - Comfortable operating independently on ambiguous projects while balancing multiple concurrent workstreams, making sound tradeoff decisions, and grounding decisions in core technical concepts. - Thoughtful in using AI and other emerging technologies in day-to-day work to accelerate analysis, documentation, troubleshooting, and execution while maintaining strong judgment and accuracy. - Curious about new technologies and motivated to apply them pragmatically to improve delivery quality, efficiency, and team effectiveness. Skills & Experience: - 8-10 years of professional experience, with 5+ years experience in client-facing roles driving technical project leadership in an enterprise setting - Background working with any of the following: enterprise health care systems, digital consumer payments or backend payment processing technologies, enterprise system integrations or an Electronic Health Record company. - Comfortable working with data structures, relational databases, and cloud infrastructure - Strong analytical capabilities with high proficiency in SQL. Experience with Python and API integrations is preferred. - Effective and credible leading outcomes-focused client conversations - Experience communicating clear technical and business requirements to engineering - You feel comfortable working in a thriving entrepreneurial environment and have some level of comfort navigating through times of ambiguity. - Lastly, you should be excited about Cedar's mission of improving the healthcare financial experience Applicants must be currently authorized to work in the United States on a full-time basis. Compensation Range and Benefits - Salary Range* - $165,750 - 195,000 - This role is also bonus and equity eligible - This role offers a competitive benefits and wellness package *Subject to location, experience, and education #LI-RD1 #LI-REMOTE What do we offer to the ideal candidate? - A chance to improve the U.S. healthcare system at a high-growth company! Our leading healthcare financial platform is scaling rapidly, helping millions of patients per year - Unless stated otherwise, most roles have flexibility to work from home or in the office, depending on what works best for you - For exempt employees: Unlimited PTO for vacation, sick and mental health days–we encourage everyone to take at least 20 days of vacation per year to ensure dedicated time to spend with loved ones, explore, rest and recharge - 16 weeks paid parental leave with health benefits for all parents, plus flexible re-entry schedules for returning to work - Diversity initiatives that encourage Cedarians to bring their whole selves to work, including three employee resource groups: be@cedar (for BIPOC-identifying Cedarians and their allies), Pridecones (for LGBTQIA+ Cedarians and their allies) and Cedar Women+ (for female-identifying Cedarians) - Competitive pay, equity (for qualifying roles), and health benefits, including fertility & adoption assistance, that start on the first of the month following your start date (or on your start date if your start date coincides with the first of the month) - Cedar matches 100% of your 401(k) contributions, up to 3% of your annual compensation - Access to hands-on mentorship, employee and management coaching, and a team discretionary budget for learning and development resources to help you grow both professionally and personally About us Cedar was co-founded by Florian Otto and Arel Lidow in 2016 after a negative medical billing experience inspired them to help improve our healthcare system. With a commitment to solving billing and patient experience issues, Cedar has become a leading healthcare technology company fueled by remarkable growth. "Over the past several years, we've raised more than $350 million in funding & have the active support of Thrive and Andreessen Horowitz (a16z). As of November 2024, Cedar is engaging with 26 million patients annually and is on target to process $3.5 billion in patient payments annually. Cedar partners with more than 55 leading healthcare providers and payers including Highmark Inc., Allegheny Health Network, Novant Health, Allina Health and Providence.
• Own API strategy, architecture, and governance for enterprise integration initiatives • Architect, design, and implement API management solutions on Google Apigee (X, Hybrid, or Edge) • Define API standards, governance frameworks, and enterprise best practices • Develop API proxies, shared flows, and custom policies for traffic management, security, mediation, and caching • Implement API security: OAuth 2.0, OIDC, JWT, API key validation, mTLS, threat protection • Migrate legacy integrations to Apigee and modernize the API landscape • Build CI/CD pipelines for API deployments (Jenkins, GitHub Actions, Maven, Terraform/Apigee CLI) • Establish monitoring, analytics, and alerting using Apigee Analytics and Google Cloud Monitoring • Provide technical leadership and mentorship to integration development
Consulting Architect – Public Sector
EndgameMilitary-grade endpoint protection that's as simple as anti-virus
• Plan, lead, and oversee Elastic consulting engagements (remote and on-site) to maximize customer value from Elastic products. • Architect, implement, configure Elastic solutions, focusing on platform architecture, solution design, and capacity planning in mission-critical environments. • Build strong relationships as a customer advocate, ensuring excellent communication and collaboration. • Develop and present demos and proof-of-concepts that showcase the value of the Elastic Stack. • Conduct data modeling, query development, optimization, and cluster tuning for scalable, high-performance search and analytics. • Collaborate with other consultants to solve complex technical challenges in a team-oriented environment. • Review and approve technical consulting reports that articulate project outcomes and recommendations. • Mentor and coach consultants through enablement programs, shadowing, and ongoing training. • Participate in technical interviews to assess and onboard new consultants. • Work effectively in a remote, highly distributed team environment, with periodic on-site engagements.
Salesforce Solution Architect CRM
OffpremTechnologyAs a client facing organization we value integrity and authenticity throughout our hiring process. Candidates may be asked to validate technical knowledge, experience, education, and certifications through structured assessment and credential verification prior to hire. *Offprem Technology provides equal employment opportunities to all employees and applicants for employment without regard to race, color, gender, sexual orientation, gender identity, religion, national origin, age, disability, genetic information, or protected veteran status.
Role Description - Lead solution discovery and technical design across multiple Salesforce clouds and implementations - Translate complex business requirements into scalable, maintainable Salesforce solutions - Guide discovery, lead design sessions, and facilitate stakeholder alignment through successful completion of projects - Deliver fixed-scope or rapid implementation projects - Work as part of a project team alongside both internal and external clients - Mentor internal team members and contribute to the technical standards and best practices - Demonstrate genuine passion for Salesforce solutions and fostering team collaboration Qualifications - Bachelor’s Degree or equivalent experience - Salesforce Certified Platform Administrator certification - Ability to run discovery sessions, document requirements, and translate them into scalable configurations - Experience delivering fixed-scope or rapid implementation projects using Salesforce best practices - Hands-on experience implementing Sales Cloud and/or Service Cloud with strong emphasis on Sales, Financial Services, and Experience Clouds - Agentforce project experience is a plus - Experience with agile delivery models and consulting environments - 5 years proven success in client-facing roles such as a Solution Architect, Technical Lead, or Senior Consultant - Strong grasp of Salesforce architecture, configuration, automation (Flows), and integration best practices - Ability to manage multiple projects simultaneously - Excellent communication skills and ability to present technical concepts to business stakeholders - Ability to work across disciplines and adapt to unfamiliar technologies or business processes - 5 years of Salesforce solution design and delivery experience, preferably in a consulting or partner environment - Strong understanding of Salesforce data model, security, and standard automation tools (Flows, validation rules, approvals) - Experience supporting data imports, basic integrations, and go-live readiness including deployment best practices - Comfort managing multiple concurrent projects with tight timelines Requirements - 2-3 of the following Salesforce Certifications: - Salesforce Certified Platform Administrator - Salesforce Certified Platform Administrator II - Salesforce Certified Business Analyst - Salesforce Certified Platform App Builder - Salesforce Certified Sales Cloud Consultant - Salesforce Certified Service Cloud Consultant Benefits - Remote first culture - yes we have an office, but we don’t force you to come in! - Unlimited PTO - 4% 401k match - Medical, dental and vision insurance from day one! - Company paid STD, LTD and life insurance - 11 paid holidays, including the day after the Superbowl! - Volunteer Program, including volunteer time off and matching donations - Tuesday start dates for new hires, because who wants to start on a Monday? - Bonus or commission eligible, depending upon your role



