T-SQL Developer
Apply on
Availability Status
This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.
Beacon Systems, Inc, delivers Program Management, Science, Engineering, and Technology Solutions to Federal, Commercial State, and Local Agencies. We are a subsidiary of Radiant Digital Solutions. Our Technology support to many DoD Agencies, NASA, Voice of America, FDA, and State Agencies such as State of FL, RI, MS, ND, VA, and WV extends our delivery of solutions worldwide.
We are looking for a T-SQL Developer position at Remote - Jackson, MS.
Request you to make sure your updated Resume highlights all the below-mentioned required Skills & Experience.
Position: T-SQL Developer
Duration: 16 Months
Location: Remote - Jackson, MS 39202
PROJECT NAME - OTSS
PROJECT DETAILS
- The Mississippi Department of Education (MDE) is implementing the Generate tool developed by the Center for Integration of IDEA Data (CIID). ;/li>
- The current Generate application is based on an older version of the CEDS data warehouse. The latest version of the warehouse is version 10. ;/li>
- This project includes updating the Generate data model to utilize version 10 of the CEDS data warehouse and the update ETL processes that generate federal reports (EDFacts files) using the data model. JOB DESCRIPTION
- This position will require qualified T-SQL Developers to take the lead in the following tasks:
- Rationalizing and mapping data between transactional and dimensional database models/systems
- Working closely with the database and system administrators to develop stored procedures and ETL processes related to the data warehouse system
- Working in collaboration with vendors and other agency staff to design, develop and manage the creation of federally required reports using the Generate application
- Translate application storyboards and use cases into functional applications
- Ability to work independently and cooperatively as part of a team.
- Ability to work under severe time constraints.
- Must possess analytical and complex problem-solving skills.
Required Degree
- Bachelor s degree
Required Skills/ Experience
- Extensive experience with development of stored procedures and ETL processes using T-SQL
- Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas
- Use of ALM tools for work item management, version control, code analysis, and testing
- Broad and extensive knowledge of the software development process and its technologies
- Familiarity with continuous integration
- Experience creating and scheduling elastic jobs
Preferred Skills/Experience
- Experience with student information management systems and K-12 data and reporting
- Experience with Common Education Data Standards (CEDS)
- Experience with EDFacts Federal Reporting
- Experience with designing and modeling database structures based on business use cases
- .Net/Angular experience
- Azure Synapse pipeline experience
Compensation
Compensation for roles at Beacon Systems Inc depending on a wide array of factors including, but not limited to, the specific office location, role, skill set, and level of experience. As required by applicable law, BeaconGov provides reasonable range of compensation for this role.
EEO Statement
Beacon Systems is dedicated to fostering an inclusive and diverse work environment. We ensure equal employment opportunities for all individuals, regardless of their race, color, religion, gender, national origin, age, disability, or any other legally protected characteristic. Our commitment to being an equal-opportunity employer extends across all aspects of employment, from recruitment and hiring to promotions and benefits. We firmly believe in treating all employees and applicants fairly, based on their qualifications, skills, and performance.