Acentra Health ยท 13 hours ago
Senior Health Intelligence Programmer
United States
Full-time
Remote
Senior Level, Lead/Staff
$70K/yr - $120K/yr
10+ years exp
Maximize your interview chancesHealth Care
Insider Connection @Acentra Health
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Participate in the migration and re-engineering of existing SQL databases to AWS Redshift
Analyze and design database systems and reports to determine the new report database requirements
Develop and implement database objects and code to address business requirements
Optimize and debug SQL queries, stored procedures, database transformations, and processes for both Redshift and SQL Server to ensure efficiency
Maintain and enhance scalable database structures to ensure high performance and reliability
Create and manage database objects such as tables, views, indexes, stored procedures, and triggers
Write new stored procedures and design optimized views to improve database functionality and performance
Collaborate with internal and external stakeholders to define database design requirements and specifications
Mentor junior programmers and provide guidance on best practices in AWS Redshift and database design
Design and implement data pipelines and ETL processes to facilitate efficient data flow and integration
Research and resolve data inconsistencies and issues in database systems
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelor's degree in information systems, Computer Science, or a related field (Master's degree preferred)
10+ years of hands-on experience with SQL, database programming, and performance tuning
5+ years of experience in agile development environments
5+ years of experience with healthcare claims, HR, finance, and utilization management data
5+ years of extensive experience creating and maintaining database objects, including tables, views, stored procedures, triggers, and functions
Expertise in database design and programming, with a focus on SQL and AWS services
Advanced skills in SQL query optimization, stored program development, and performance tuning
Proficiency in AWS services (Redshift, S3) and associated tools for data processing and analytics
Proficiency in Microsoft SQL tools (SSMS, SSRS, SSAS, SSIS)
Proficiency in Python
Proficiency in conceptual, logical, and physical data modeling
Strong analytical and troubleshooting skills for resolving database issues
Strong background in business intelligence and data warehousing methodologies
Strong data analysis skills
Strong skills in gathering and documenting requirements for database projects
Preferred
Familiarity with Visual Studio and Azure DevOps for source control
Familiarity with BI tools such as Tableau and Power BI
Benefits
Comprehensive health plans
Paid time off
Retirement savings
Corporate wellness
Educational assistance
Corporate discounts
Company
Acentra Health
Acentra Health is a provider of clinical services and technological solutions to government healthcare organizations.
1001-5000 employees
H1B Sponsorship
Acentra Health has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (14)
Funding
Current Stage
Late StageTotal Funding
unknown2022-11-09Acquired
Leadership Team
Grant Christie
Senior Vice President, Market Strategy and Solutions
Ryan Bosch
Executive Vice President, Chief Health and Informatics Officer
Company data provided by crunchbase
