BIAA Senior Applications Engineer (Application Engineer, Sr.)

Team: IT

Location: US

Commitment: Full-time

Workplace Type: remote

Accountabilities

• Design, develop, and optimize enterprise ETL pipelines using technologies such as Epic Caboodle Console, SQL Server SSIS, Microsoft Fabric, Azure Databricks, Azure Data Lake Storage, and Azure Data Factory.
• Build and maintain scalable data structures, including star schemas, fact tables, dimension tables, slowly changing dimensions (SCDs), aggregates, and bridge tables.
• Develop advanced SQL and T-SQL solutions, including query optimization, data profiling, validation, source-to-target mapping, and troubleshooting.
• Support secure data ingestion and exchange processes with external partners through technologies such as SFTP and PGP workflows.
• Diagnose and resolve ETL failures, data quality issues, and performance challenges across hybrid on-premise and cloud environments.
• Develop and maintain business intelligence solutions, including Power BI data models, dashboards, semantic layers, and analytics assets.
• Build and support healthcare analytics structures, including Epic-based analytical models and reporting solutions.
• Collaborate with clinical teams, analysts, and operational leaders to create meaningful metrics and actionable insights.
• Participate in system upgrades, regression testing, implementation planning, and Agile/SDLC development processes.
• Create technical documentation for data models, pipelines, workflows, and system processes while providing guidance to developers, analysts, and end users.

Requirements

• Bachelor’s degree in computer science, business, or a related field with 8+ years of IT experience, or an equivalent combination of education and professional experience.
• 10+ years of IT, healthcare, clinical, or operational experience may also qualify.
• 2+ years of experience as an Application Engineer or Developer working with SQL Server SSIS.
• 2+ years of advanced SQL/T-SQL development experience, including performance tuning and troubleshooting.
• Strong experience with ETL development, dimensional modeling, metadata management, and technical documentation.
• 3+ years of experience working with relational databases and enterprise data environments.
• Deep understanding of data warehousing concepts, star-schema design, and slowly changing dimension methodologies.
• Strong analytical and problem-solving abilities with excellent attention to detail.
• Ability to manage multiple projects, document complex systems, and work effectively within Agile or SDLC frameworks.
• Strong communication skills with the ability to collaborate with technical teams and non-technical stakeholders.
• Ability to obtain Epic Caboodle Developer proficiency or certification within 6 months of hire.
• Ability to obtain Microsoft Power BI or Fabric certification within 9 months of hire.
• Experience with Epic Caboodle, Epic Clarity, healthcare data, claims data, Microsoft Fabric, Power BI, Azure Data Factory, Azure Databricks, or Azure Data Lake is highly preferred.

Benefits

• Fully remote work opportunity within the United States.
• Competitive compensation package with comprehensive employee benefits.
• Employer-covered healthcare benefits for full-time employees and significant dependent coverage.
• $50,000 employer-provided term life insurance at no cost.
• Two above-market pension plan options.
• Generous paid vacation allowance of up to 200 hours annually based on tenure.
• Paid sick leave of up to 96 hours per year.
• 9 paid holidays annually.
• Transportation discounts through regional transit programs.
• Employee Assistance Program and childcare service discounts.
• Tuition reimbursement opportunities.
• Employee discounts with local and national businesses.
• Opportunity to contribute to impactful healthcare analytics initiatives within a collaborative environment.