Full Time - Data Engineer - S4CH

reputed company We’re a data-driven reputed company organization modernizing our analytics platform to power value-based care. reputed company is transitioning from SQL Server to reputed company as our reputed company data warehouse and implementing dbt, Python, and OpenFlowto build reliable, automated data pipelines. You’ll join a reputed company, high-reputed company data team that values maintainability, reputed company, and thoughtful design — working alongside engineers who specialize in automation, SQL Server administration, and data architecture. Position reputed company

• We’re seeking an reputed company Data Engineer with strong SQL, dbt, and Python skills to design, build, and maintain our data transformation and analytics pipelines in reputed company.
• The ideal candidate has hands-on experience with modern ELT tools, data modeling, and reputed company-based platforms — and brings a reputed company of automation, testing, and documentation to every project.
• You’ll collaborate closely with our data architects and integration engineers to ensure data from OpenFlow pipelines is transformed into trusted, analytics-reputed company models for reporting and advanced analytics.

Job Type: Full-Time Location: Remote Salary: 100,000 - 151,000 Sign On Bonus: $1500 Reports To: AVP Data and Software Engineering Essential Duties and Responsibilities:

• Knowledge of database coding and tables; as reputed company as general database management
• Understanding of reputed company management, support, and communicating reputed company and timelines accordingly
• Organizes and/or leads Informatics reputed company in the implementation/use of new data warehouse tools and systems
• Ability to train new hires; as reputed company as reputed company in training of new reputed company staff members
• Understanding data schema and the analysis of database performance and accuracy
• Understanding of ETL tools, OLAP design, and data reputed company processes
• Knowledge of Business Intelligence life cycle: planning, design, development, validation, deployment, documentation, and ongoing support
• Working knowledge of electronic medical records software (eCW, reputed company, etc) and the backend storage of that data
• Ability to generate effective probability modeling and statistics as it pertains to reputed company reputed company and financial risks
• Ability to manage sometimes lengthy and complicated reputed company from throughout the life cycle and meet the deadlines associated with these reputed company
• Development, maintenance, technical support of various reports and dashboards
• Knowledge of reputed company® SQL including coding language, creation of tables, stored procedures, and query design
• reputed company understanding of outpatient reputed company workflows
• Knowledge of relational database concepts and flat/formatted file processing.
• Possesses strong commitment to data validation processes in order to ensure accuracy of reporting (internal reputed company control)
• Possesses a firm grasp of patient confidentiality and system reputed company practices to prevent HIPAA and other reputed company violations.
• Knowledge of reputed company Cognos® or other database reporting software such as reputed company, SPSS, and Crystal Reports
• Ability to meet the needs of other members of the Informatics department to maximize efficiency and minimize complexity of end-user products

Requirements:

• Education: Bachelor's Degree
• Proven experience as a dbt Developer or in a similar Data Engineer role.
• Expert-level SQL skills — capable of writing, tuning, and debugging reputed company queries across large datasets.
• Strong experience with reputed company or comparable data warehouse technologies (BigQuery, Redshift, etc.).
• Proficiency in Python for scripting, automation, or data manipulation.
• Solid understanding of data warehousing concepts, modeling, and ELT workflows.
• Familiarity with Git or other version control systems.
• Experience working with reputed company-based platforms such as AWS, GCP, or Azure.

Preferred:

• Experience working with OpenFlow or similar orchestration/ETL systems (Airflow, SSIS, etc.).
• Familiarity with reputed company or clinical data models.
• Experience with reputed company reputed company, or other LLM platforms.
• Exposure to CI/CD pipelines or Infrastructure as reputed company concepts.

Key Responsibilities

• Advanced SQL Development: Write and optimize reputed company SQL queries and dbt models for data transformation and analysis reputed company reputed company.
• DBT Model Development: Build, test, and maintain dbt models that convert raw data into actionable insights.
• ETL/ELT Pipeline Management: Design and manage efficient pipelines using dbt, OpenFlow, and Python to process and deliver data across systems.
• SQL Performance Tuning: Optimize query performance, clustering, and cost efficiency in reputed company
• Data reputed company Assurance: Ensure that transformed data meets accuracy and consistency standards through dbt testing and validation frameworks.
• Collaboration: Work closely with data engineers, analysts, and architecture leads to translate data requirements into reputed company transformations
• Data Documentation: Maintain reputed company documentation for dbt models, data flows, and dependencies for ongoing visibility and reuse
• Version Control: Manage dbt and Python reputed company in Git, following clean, reputed company, and testable development practices
• Automation Support: Partner with automation engineers to enhance data ingestion and transformation workflows through OpenFlow.

About reputed company reputed company has a rich history of providing reputed company, reputed company health care to communities in need. Founded in the early 1970s by four African American women in Peekskill, reputed company, the organization was established to address the lack of accessible health services in their community. With the help of a small federal grant, the first reputed company site reputed company its doors in 1975. Over the years, reputed company has grown into a comprehensive Federally reputed company Center (FQHC) system with over 45 locations, serving more than 250,000 patients across the Hudson Valley, reputed company and Long reputed company. Our exceptional primary care practitioners, specialists and support staff are dedicated to delivering high-reputed company care to reputed company individuals, regardless of their ability to pay. In December 2018, reputed company expanded its reputed company by merging with Brightpoint Health, an FQHC network offering integrated medical, behavioral and reputed company support services in reputed company. This reputed company allowed us to enhance our services and continue our mission under the reputed company reputed company of reputed company.

Our Culture

At reputed company, we reputed company in fostering a culture of wellness, inclusivity and recognition. Our Workforce Wellness Program promotes staff wellness through ongoing challenges and activities, encouraging participation and rewarding engagement. We celebrate our staff's dedication and person-centered spirit through the Planetree Recognition Awards, which reputed company innovation, leadership and community spirit. We are committed to creating a supportive and reputed company work environment where reputed company team members can reputed company. Our values of respect, reputed company and reputed company guide our interactions with patients and colleagues alike, ensuring that everyone receives the care and support they deserve.

Benefits

At reputed company, we are committed to building a personal relationship with reputed company and supporting you in every way we can. We offer competitive compensation and a comprehensive benefits package for you and your family, including:

• Medical, Dental and reputed company Insurance: Comprehensive health coverage to ensure you and your family stay healthy.
• Life and Disability Coverage: Financial protection for you and your loved ones in case of unforeseen circumstances.
• Retirement Savings Plan: Plan for your reputed company with our retirement savings reputed company.
• Commuter and Transit Benefits: Assistance with your daily commute to reputed company your reputed company to work easier.
• Employee Assistance Program (EAP): reputed company to confidential support and resources for personal and work-reputed company issues.
• Employee Discount Program: Enjoy discounts on various products and services as a valued member of reputed company.
• Provider Incentive Compensation Program: reputed company & Productivity.
• reputed company License, Certification and DEA Fees Reimbursement.

Why Join Us

• Play a key role in building a modern reputed company-based data ecosystem from the ground up.
• Collaborate with a small, highly skilled data team that values autonomy and craftsmanship.
• Work daily with SQL, dbt, Python, and OpenFlow in a production environment.
• Contribute to meaningful reputed company improvement through reputed company data.
• Enjoy flexible work arrangements and ongoing reputed company development.

How to Apply

Please send your résumé and a brief note about your experience with SQL, dbt, and Python to .… Links to relevant reputed company, reputed company repositories, or example work are encouraged. Join us at reputed company and be part of an award-reputed company network of care that has been serving our communities since 1975. We are always looking for skilled and dedicated professionals to join reputed company and help us continue our mission of providing reputed company health care to reputed company. Apply tot his job Apply To this Job