MicroHealth logo
MicroHealth

Putting the “Health” in Healthcare IT

Senior SQL Application Developer, SQL, Crystal Reports, ETL

Analytics EngineerAnalytics EngineerFull TimeRemoteSeniorTeam 51-200H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

4 days ago

Salary

$125K - $140K / year

Seniority

Senior

Job Description

Senior SQL Application Developer, SQL, Crystal Reports, ETL

MicroHealth

• Administer Microsoft SQL Server databases in both Windows and Linux environments supporting NPIRS production and development systems • Monitor SQL Server health, performance, storage utilization, and database availability across multiple platforms • Perform routine server monitoring and daily operational health checks • Develop, schedule, monitor, and troubleshoot SQL Server Agent jobs, automated database processes, alerts, Database Mail notifications, and scheduled operational workflows • Execute scheduled SQL Server maintenance activities, including weekly server patching and maintenance windows • Troubleshoot SQL Server performance issues, database connectivity problems, and production incidents • Maintain database security, permissions, access controls, and ensure compliance with organizational standards • Support disaster recovery readiness, high availability solutions, and coordinate infrastructure upgrades • Manage Linux-based database systems including shell scripting and system administration • Design, develop, test, and maintain complex SQL queries, stored procedures, views, functions, and reusable database components • Develop and optimize advanced SQL solutions utilizing Microsoft SQL Server and IBM DB2 healthcare data sources • Develop cross-platform SQL solutions integrating SQL Server reporting environments with DB2 databases • Translate complex healthcare reporting requirements and legacy report logic into validated SQL business rules, including exception handling, reconciliation, and data-quality controls • Optimize SQL code for performance and scalability across multiple database platforms • Create validation scripts and resolve database-related defects • Implement data models and database structures according to best practices • Design, develop, modify, validate, and maintain SQL Server Reporting Services (SSRS) reports • Lead modernization efforts by converting SAP Crystal Reports to SSRS while maintaining functionality • Translate legacy Crystal Reports business logic into validated SSRS solutions while preserving business rules and report functionality • Interpret healthcare reporting requirements and convert them into validated SQL datasets, report parameters, reconciliation logic, exception processing, and data-quality controls • Develop and maintain standardized reporting templates • Perform report validation, peer reviews, and maintain SDLC documentation • Develop, maintain, troubleshoot, and optimize SSIS packages supporting enterprise reporting and healthcare data integration • Support automated processing, scheduled data loads, ETL workflows, and validation • Support data integration initiatives across multiple systems and platforms • Perform database migrations and conversions between platforms with minimal downtime • Migrate databases and reports between different environments • Support cloud database platform initiatives • Ensure data integrity throughout migration processes • Provide production support for NPIRS operational systems • Monitor production database jobs, reporting services, SQL Server Agent jobs, and automated workflows • Perform proactive morning operational monitoring and respond to infrastructure incidents • Support production deployments, server patching, and operational documentation • Collaborate with cross-functional teams to implement technical solutions

Job Requirements

  • Bachelor's degree in Computer Science, Information Technology, or related field
  • Minimum 10 years of experience with SQL database development and administration
  • Advanced SQL programming skills with demonstrated experience optimizing complex queries
  • Strong Linux administration experience, including shell scripting and system management
  • Proven experience migrating databases and reports between different platforms
  • Demonstrated experience with Linux environments hosting database systems
  • Proven track record of successful database migration projects
  • Strong experience with both Crystal Reports and SSRS development
  • Healthcare data experience preferred
  • Experience with federal healthcare compliance requirements preferred
  • Microsoft SQL Server Administration (Windows and Linux)
  • IBM DB2 and cross-platform SQL development
  • Advanced T-SQL programming
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS)
  • SQL Server Agent and Database Mail
  • SAP Crystal Reports
  • Healthcare reporting methodologies and data models
  • Business-rule translation and validation
  • Database performance tuning and optimization
  • Windows Server and Linux administration
  • Production support methodologies
  • Database security implementation and best practices
  • Knowledge of high availability and disaster recovery solutions
  • ETL processes and data integration
  • Data modeling techniques
  • Familiarity with cloud database platforms (Azure preferred)

Benefits

  • comprehensive and competitive benefits package
  • access to programs designed to support workforce needs
  • recognition and support for personal growth and retirement plans

Related Categories

Related Job Pages

More Analytics Engineer Jobs

Stellus Rx logo

Senior Analytics Engineer

Stellus Rx

Trusted, pharmacist-led health support in every moment that matters.

Full TimeRemoteTeam 201-500Since 2022

• Data Quality & Preparation • Data Modeling & Transformation • BI & Reporting Delivery • Integration & Pipeline Ownership • Documentation & Data Governance • AI Tooling Adoption • Stakeholder Enablement & Training • Analytics Project Leadership

Peru

Analytics Application Developer

Solventum

Solventum is dedicated to improving healthcare options and health outcomes through cutting-edge solutions in health, materials, and data science. The company ai

• Leading healthcare analytics software solutions for HIS products and clients, collaborating within an agile team of engineers and developers • Implementing enterprise scale application, and reporting solutions. • Determining the design, coding, and delivery of Solventum HIS products and customer solutions. • Supporting Solventum HIS product development for customers across the US and the globe. • Working closely with other teams to deliver our data driven products.

United States
$71.2K - $97.9K / year
Standard Metrics logo

Data Solutions Engineer

Standard Metrics

Portfolio collaboration tools built for venture capital firms and startups.

Full TimeRemoteTeam 11-50H1B Sponsor

• Partner directly with customers to identify data challenges and design technical solutions - connecting data sources, configuring integrations, automating recurring workflows, and deploying custom reports • Deploy and optimize AI-powered tools and workflows for customers; educate customers and internal teams on prompt engineering, LLM capabilities, and best practices for leveraging AI in their data operations • Build and extend internal tooling (importers, parsers, and reporting pipelines) to reduce manual burden on the Customer Experience team and improve platform reliability • Execute bespoke data operations such as custom SQL reports, bulk data operations, and backend queries for customers with unique data needs • Own API schemas, ingestion cadence, error handling, Snowflake data shares, and database connections • Identify repeatable patterns across customers and translate them into product requirements, filing tickets and partnering with Engineering to productize solutions • Support internal engineering workflows as a secondary function by helping to triage and resolve quality-of-life bugs and enhancements that are too small for core Engineering but directly impact the Customer Experience team and customers • Carry a light book of data parsing work alongside your teammates to stay grounded in the team's day-to-day workflows and build supporting solutions

United States
Full TimeRemoteTeam 10,001+Since 1915H1B Sponsor

• Design, develop, and deploy scalable AI, machine learning, and advanced analytics solutions to drive business value • Build and maintain robust data pipelines, data models, and enterprise data assets that support reporting, analytics, and AI initiatives • Partner with business stakeholders to translate requirements into data-driven solutions and actionable insights • Implement data governance, quality, security, and responsible AI practices to ensure trusted and compliant use of enterprise data • Support the development and enhancement of AI capabilities through predictive modeling, automation, and continuous innovation • Play a key role in advancing Carrier's AI and data transformation strategy through innovative analytics and AI solutions • Support high-visibility, enterprise-scale initiatives and programs that directly impact business performance and decision-making • Collaborate with global cross-functional teams across business and technology functions to deliver scalable digital solutions • Contribute to strategic programs with significant business impact while gaining exposure to enterprise data, analytics, and AI leadership initiatives

Florida
$96K - $192K / year