Database Developer

Database DeveloperHot JobFully Remote • IRS Remote (job post use) - Reston, VA 20190OverviewLevel: Experienced Position Type: Full Time Job Shift: DayDescriptionWhy Brillient?At Brillient, you'll join an award-winning digital transformation company dedicated to helping government agencies evolve from analog processes to digital solutions and advanced analytics that drive smarter decisions and mission success.We are guided by four core values:Value – Delivering meaningful results for our clients and employeesIntegrity – Building trust through honesty, accountability, and ethical business practicesFlexibility – Embracing agility and collaboration to adapt to changing needsInnovation – Continuously improving processes, technologies, and solutionsWe are committed to fostering a professional, respectful, and collaborative workplace where employees are supported, recognized for their contributions, and empowered to succeed. What Sets Us ApartCommitment to Sustainability: We strive to be an environmentally conscious organization through sustainable business practices.Community Impact : We believe in giving back and making a positive difference in the communities where we live and work.At Brillient, we hire talented, driven individuals who are passionate about helping clients achieve their mission objectives through innovation and excellence. As a client-focused and employee-centered organization, we take pride in our collaborative culture, commitment to professional growth, and dedication to delivering exceptional results.Benefits & Perks: We offer a comprehensive benefits package designed to support your well-being and work-life balance, including:Generous Paid Time OffMedical, Dental, and Vision InsuranceCompany-Paid Life Insurance and Short-Term Disability CoverageEmployee Assistance Program (EAP)Voluntary Life Insurance and Long-Term Disability CoverageWellness Programs401(k) Retirement PlanCompetitive CompensationPosition OverviewBrillient Corporation is seeking an ETL Developer/Engineer to support a mission-critical IRS data warehousing initiative. In this role, you will design, build, and maintain ETL processes that extract data from source systems, transform it according to business rules, and load it into our data warehouse. You'll work closely with data architects, business analysts, and data quality specialists to ensure data is accurate, consistent, and available to business users.This role supports Compliance Data Warehouse (CDW) operations within RAAS, providing data analysis, process improvement recommendations, and research and evaluation of emerging technologies. These services optimize RAAS data availability and analytics to deliver improved services and value to RAAS stakeholders.Within RAAS, our team maintains the Compliance Data Warehouse — a non-IT data warehouse containing all the IRS's return, entity, information return, regulatory, enforcement, web, and security data. The team provides technical guidance and executes work across extract-transform-load, database administration, SQL development, Bash development, SAS administration, system security, COTS ETL development, metadata, customer service, web design, data quality, and intergovernmental data exchanges. Key ResponsibilitiesDesign and DevelopmentMove data and tables from Unix operating systems, performing extract, transformation, and load (ETL) operations into Sybase IQRefactor existing jobs and build new solutions as needed, including:Supporting users with documentation on moving data into Sybase IQ and providing metadata for the metadata repositoryDeveloping an object-oriented, UNIX-based framework and engine of scripts and stored procedures to execute and monitor multiple ETL and statistics processesTroubleshoot errors in shell and SQL; configure and operate SSH clients across serversParticipate in Scrum and client meetings, create documentation, and update Kanban board cardsOptimization and PerformanceOptimize ETL processes for efficient, timely data processingMonitor ETL jobs and resolve performance bottlenecksData QualityEnsure data accuracy and integrity through validation, cleansing, and auditingPartner with the Data Quality team to resolve data inconsistencies and issuesCollaboration and DocumentationWork with Data Architects to design data models and schemas that meet business needsPartner with Business Analysts to understand transformation requirementsDocument ETL processes, workflows, and data dictionaries for transparency and future referenceTroubleshooting and SupportDiagnose and resolve ETL process failures in a timely mannerSupport business users with data-related queries and issuesContinuous ImprovementStay current on ETL tools and techniquesRecommend and implement improvements to ETL processes and infrastructureQualificationsRequired Education and Qualifications:Bachelor's degree in Computer Science, Information Systems, or a related fieldMinimum ten (10) years of experience in ETL development, preferably with SQL, with a focus on load, select, and update commandsMust be able to obtain a Public Trust Security ClearanceHigh proficiency in Linux/Unix operating systems, Sybase Database, and Sybase SQL scriptingWorking experience with Postgres Database, Postgres SQL scripting, SecureCRT, and SecureFXFamiliarity with additional technologies, including: DBeaver, Visual Studio Code, GitLab, Wiki, JSON, Airflow, SAP Data Services, and shell scripting tools (KSH, BASH, SSH, sed, awk, Perl)We are proud to be an equal opportunity workplace and an 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, protected veteran status or any other status protected under applicable law.DISCLAIMER: The above statements are intended to describe the general nature and level of work performed. They are not intended to be an exhaustive list of all responsibilities, duties, skills, efforts, requirements, or working conditions. Management reserves the right to revise the job or to require that other or different tasks be performed as assigned in accordance with business demands and/or contractual requirements.