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 Services. We have a vast portfolio of clients across the country. 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.
Role : BI Developer
Location: Hybrid_ Richmond, VA
Duration: 6 months _10days
Complete Description:
The Client Investment Decision Support (IDS) team are the primary data stewards for the Investments Department. IDS connects data to investment analysis by overseeing all aspects of the data management life cycle. They work closely with investment programs to understand their business data and decision support requirements, develop tools to extract valuable and timely information, and continuously improve processes and systems to ensure high levels of data integrity and availability. The IDS team is seeking seasoned SQL development and testing expertise to successfully assist with ongoing business initiatives.
Responsibilities:
The Investment Decision Support team is seeking an experienced SQL Developer/Tester with strong database, programming, and analytical skills to actively participate in the following scope of work:
Assist with overall SQL Support (development, performance tuning, testing, documentation) related to quarterly projects and other efforts as needed. Activities may include:
Development - SQL Development support to include creation of stored procedures or underlying queries. Provide support in the design, development, and implementation of ETL packages with SQL Server Integration Services (SSIS).
Performance Tuning - Review existing SQL Queries, Execution Plans, etc. to determine performance enhancements for long running queries.
Data Manipulation - Provide alternative options to existing data manipulation techniques. Examples would be converting Excel manipulation activities into SSIS packages that reduce process/cycle time of data preparation.
SQL Development Processes - Review existing development processes and provide recommendations on how to enhance core development activities (i.e., Code Promotion, Code Reviews).
Testing – Develop test plans and cases and thoroughly test reports and workflows.
Minimum Qualifications:
5+ years of experience in SQL database development and programming
3+ years in a QA/testing role
3 years Experience with SQL Server Integration Services
3 Years Experience writing technical documentation (requirements, process maps, etc.)
3 Years Excellent communicator and ability to produce clear and concise documentation
3 Years Demonstrated experience working in a team environment
3 Years Demonstrated experience working independently with only high-level guidance
Additional Preferred Skills:
Nice to Have:
1 Year Experience with automation tools such as Power Automate
1 Year Experience with data governance best practices/procedures
1 Year Investment/financial market industry experience.
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.
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.
Never miss an opportunity! Create an alert based on the job you applied for.