General Dynamics Federal Health Sector is actively seeking a Software Developer Senior Advisor to support the Centers for Medicare & Medicaid Services (CMS) Chronic Conditions Warehouse (CCW) Program. The CCW is a research database providing researchers with Medicare and Medicaid beneficiary, claims, and assessment data linked by beneficiary across the continuum of care.
This position will be responsible for designing, developing, and evaluating code relevant to the CCW program needs. This includes maintenance and monitoring of data within Snowflake and Databricks, data validation, security, and documentation.
This is a remote based role; applicants must reside in the United States.
In this role, a typical day will include:
Performing data warehouse architecture development and management across one or more data warehouse solutions including Oracle, AWS RDS, and Snowflake.
Provide rotation-based production support for ETL batch loads including off-hours and weekends.
Developing schemas, testing for quality assurance, administering RDBMS, and monitoring of one or more relational databases including Postgres, MySQL, Oracle, Snowflake and SQL Server.
Analyzing and resolving complex hardware/software compatibility and interface design considerations.
Conducting investigations and tests of considerable complexity.
Maintaining data documentation on processes and procedures.
Tracking multiple data feeds, business rules, and statuses to ensure management receives accurate data and information.
Continually assess processes for improvements and efficiencies.
Participate in special projects as required.
WHAT YOU’LL NEED:
BS in Computer Science, Software Engineering or equivalent, or a Bachelor’s in an unrelated field with at least 5+ years of software development experience. A relevant master’s degree is a plus.
4+ years’ experience working with claims data and reporting.
Experience working with data elements, data modeling, user documentation, and data collection.
Excellent verbal and written communication skills, including issue resolution, and conflict management.
High proficiency with MS Office applications (i.e., Word, Excel, PowerPoint, etc.).
US Citizen or Permanent Resident.
Ability to obtain and maintain a Public Trust.
Experience with telecommuting, working from a home office.
Experience and proficiency with Amazon AWS or Microsoft Azure cloud platforms.
Experience with Snowflake and Databricks a plus.
Experience with dimensional modeling techniques and their applications.
Ability to operate with general direction/minimal supervision.
WHAT GDIT CAN OFFER YOU:
401K with company match
Internal mobility team dedicated to helping you own your career
Rewards program for high-performing employees
The likely salary range for this position is $116,000 - $174,000, this is not, however, a guarantee of compensation or salary; rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.
We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.
GDIT does not have a vaccination mandate applicable to all employees. To protect the health and safety of its employees and to comply with customer requirements, however, GDIT may require employees in certain positions to be fully vaccinated against COVID-19. Vaccination requirements will depend on the status of the federal contractor mandate and customer site requirements.
GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.