Perform day-to-day administrative duties on Microsoft SQL Server instances, develop and maintain SSIS jobs and write Transact-SQL code for database management and optimization, and conduct performance tuning.
Responsibilities
Perform day-to-day administrative duties on Microsoft SQL Server instances, including backup, restore, and general troubleshooting
Develop and maintain SSIS jobs and write Transact-SQL code for database management and optimization
Conduct performance tuning to enhance database efficiency and responsiveness
Collaborate with software engineers to develop solutions using open-source PostgreSQL or other cost-effective alternatives
Participate in initiatives to modernize infrastructure, reducing reliance on SQL Server by leveraging cloud technologies
The Associate Director, Applied Informatics role serves as a senior technical contributor responsible for designing, developing, and advancing the data infrastructure, automation frameworks, and analytical enablement capabilities that support SCA Health's Enterprise Analytics organization.
Compensation
USD $125,000.00/Yr. USD $135,000.00/Yr.
Responsibilities
Design, create, and maintain enterprise data solutions utilizing Microsoft SQL Server technologies, including stored procedures, functions, views, and SSIS package development using Visual Studio.
Serve as technical review steward for the team’s full development lifecycle, ensuring adherence to enterprise standards for data quality, coding, performance, scalability, and technical best practices.
Serve as a technical lead for complex healthcare data integration, transformation, and analytics enablement initiatives while supporting the implementation of enterprise data governance principles.
Establish scalable, reusable data architectures that support enterprise reporting and advanced analytics, while recommending technical approaches that maximize value while minimizing complexity and maintenance burden.
Support long-term modernization and standardization efforts across analytics platforms, database environments, data movement processes, and ETL workflows.
Serve as the strategic and technical leader for workforce analytics, reporting, and HR data intelligence, acting as a trusted advisor to HR and business leaders to transform workforce data into actionable insights that influence talent strategy, labor optimization, workforce planning, and organizational performance.
Compensation
USD $115,000.00/Yr. USD $130,000.00/Yr.
Responsibilities
Serve as the primary workforce analytics advisor to HR and business leaders, providing insights that drive talent and business decisions.
Lead workforce planning, forecasting, predictive analytics, and deep-dive analyses related to retention, hiring, engagement, labor costs, and organizational effectiveness.
Deliver executive-ready dashboards, reports, and recommendations that support strategic decision-making.
Own and optimize workforce analytics data infrastructure, including SQL Server environments, SSIS packages, ETL processes, and data pipelines.
Ensure accurate integration and governance of workforce data across HR systems and enterprise platforms.
Requirements
Bachelor's degree in HR, Business, Analytics, Statistics, Computer Science, Information Systems, or a related field.
The Lead Data Developer is a senior individual contributor (IC) and technical leader responsible for designing, delivering, and evolving enterprise data platforms and solutions that support clinical, operational, and financial outcomes across SCA Health.
Compensation
USD $130,000.00/Yr. USD $150,000.00/Yr.
Responsibilities
Serve as technical owner for assigned initiatives, accountable for architecture, design quality, delivery outcomes, and long-term maintainability
Lead and coordinate design, development, testing, deployment, and support of data solutions
Partner with resource managers to align staffing, skillsets, and priorities to delivery needs
Direct technical execution across assigned team members, ensuring alignment to standards and timelines
Drive delivery with limited information, clarifying requirements and resolving ambiguity proactively
Requirements
Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field
Experienced Data Platform Engineer to support the existing RepSaS data landscape, focusing on legacy support, operational stability, troubleshooting, and controlled retirement of existing databases and data solutions using Microsoft SQL Server and BI.
Responsibilities
Analyze and resolve production incidents, technical issues, and data quality problems within existing RepSaS solutions
Troubleshoot and maintain T-SQL code, Stored Procedures, Views, Functions, SQL Agent Jobs, and ETL pipelines
Analyze and optimize SQL queries, database objects, execution plans, indexes, loading processes, and overall database performance
Maintain, stabilize, and selectively refactor long-established database and reporting logic
Monitor production environments, perform root-cause analysis, and document bug fixes and workarounds
The Data Analytics Engineer III is responsible for designing and creating tables within data marts, data lakes and data warehouse and all related extraction, transformation and load of data functions. Work in a variety of settings to build systems that collect, manage, and convert raw data into usable information for analytics developers and business analysts to interpret.
Compensation
Data Analytics Engineer $82,931.74 - $114,031.14
Responsibilities
Design and create tables within data marts, data lakes and data warehouse
Perform extraction, transformation and load of data functions
Build systems to collect, manage, and convert raw data into usable information
Develop and test architectures for data extraction and transformation for predictive or prescriptive modeling
Expand and optimize data and data pipeline architecture
Requirements
Bachelor's Degree in Business, Computer Science, Engineering, Information Systems, Public Health, or related field
Master's Degree in Computer Science, Business, Healthcare Management, Information Systems, or related field