Landmark Health

SQL Data Developer

Job Locations US-CA-Huntington Beach
Posted Date 5 days ago(7/29/2020 11:02 AM)
Information Technology
Regular Full-Time
Job ID


The SQL Data Developer will assist in the design and development of data feeds, interfaces, data warehouses and enterprise reporting. The SQL Data Developer must demonstrate strong working knowledge of extract, transform, and load (ETL) development using SQL Server Integration Service (SSIS) and ability to interact with non-technical business customers to determine requirements and apply the business rules to the data. Experience and familiarity with various types of healthcare-related data—membership, claims, laboratory, pharmacy, authorizations, etc.—utilized in healthcare organization that take insurance risk is highly desirable. This individual will work closely with internal departments and with counterparts with health plans during implementation and through ongoing operations.


• Responsible for designing, developing, testing and troubleshooting SSIS packages that implement complex ETL processes
• Analyze, develop, test, maintain and support complex data/process models, and processes in an ETL environment using SSIS
• Design, develop, and support complex integration processes (including interfaces) using SQL Server technology, stored procedures and SQL program code
• Translate business requirements into technical designs to map and load data from source systems to data warehouses, downstream applications, and trading partners.
• Work closely with operations and IT to ensure all necessary Client data (eg. Eligibility, Lab, Rx, Claims/Encounters) feed into Landmark data warehouse
• Ensure quality and accuracy of the data mapped from staging environments to the target reporting environments.
• Maintaining data repository with data definitions, relationships, linkages and sources.
• Communicate open items and issues to key stakeholders, including management, development teams, and business areas.
• Perform root cause analysis for issues and provide effective and timely resolution.
• Provide leadership and mentoring to team members as required on industry standard business processes.
• Prior exposure to Hadoop and big data technologies.
• Provide ad-hoc reports, analysis and operational support to successfully complete business needs.


• Bachelor’s degree in Computer Science, Information Systems or equivalent experience.
• 5+ years of experience utilizing Microsoft technologies in development and operation of Data Warehouse, ETL, and application integration solutions via Microsoft SSIS. Must have strong understanding of DW processes and OLAP concepts
• In-depth knowledge of SQL Server Integration Services (SSIS).
• At least 1-year experience working in health care industry.
• Expert knowledge in SQL Queries and Stored Procedure writing.
• SQL Server Reporting Services (SSRS) experience.
• Health care experience is a must.
• Ability to work under pressure to resolve critical production issues.
• High energy, demonstrates an ability to function in a creative, entrepreneurial environment and think outside the box
• Good problem solving and debugging skills
• Adapt to learn new technologies as required.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.