Data Warehousing Programmer
Chugach Government Solutions, LLC
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
Chugach Government Solutions, LLC is seeking a Data Warehouse Programmer to design, develop, and maintain an enterprise data warehouse for USMC ITAM analytics. The role emphasizes ETL development, data governance, and performance optimization within a secure environment.
The candidate will integrate data from multiple sources, implement robust data quality measures, and support BI reporting and decision-making. Travel is limited to less than 10% between Stafford, VA and Quantico, VA.
Qualifications
- Must be a US citizen.
- Ability to obtain and maintain a Secret clearance.
- BS degree in Engineering, Computer Science, or a related discipline, or 5 years of related experience as Database analyst/Database programmer.
- Strong SQL skills - complex joins, nested queries, subqueries, ranking, etc.
- Experience with Power BI.
- Experience in Microsoft SQL Server development.
- SSMS familiarity.
- Travel under 10%.
Responsibilities
- Design, develop, implement, and maintain the data warehouse architecture and database solutions.
- Develop and modify data models and schemas to support reporting and analytics.
- Create and maintain ETL/ELT processes for data integration.
- Optimize SQL queries, indexes, and ETL processing for performance.
- Develop and support dashboards and BI reporting structures.
- Document data definitions, metadata, and governance procedures.
Skills
Education
Tools
Job description
When you work at Chugach Government Solutions (CGS), you join a proud legacy of supporting missions while sustaining culture.
The federal division of Chugach Alaska Corporation, CGS has been supporting critical missions as a government contractor for over 25 years. Our focus is to support facility maintenance, IT/technical services, construction and education. We are proud to have built, and continue to foster, an incredibly talented team spanning across the globe in hundreds of different fields - each team member proud to serve our country with first-class business services, while also making a difference for our Chugach shareholders.
At CGS, empowering employees is a part of our core, and that focus is one of the ways we build and foster high-performing teams. We empower our employees through competitive compensation and benefits package, professional growth opportunities, truthful communication, and more!
If you are looking for an opportunity to serve something bigger than yourself; if you want your day job to be one that creates meaningful value; if you are looking for an environment that highly values employees and respects individual differences - then Chugach Government Solutions may be the right fit for you!
This position is located in Stafford, VA with less than 10% of travel between job site in Quantico, VA.
In support of the U.S. Marine Corps (USMC) Asset Reporting Services (ARS) Team Technical Support Services contract, provide delivery of business intelligence support solutions for the enterprise. The Data Warehousing Programmer is responsible for the design, development, implementation, maintenance, and enhancement of an enterprise data warehouse solution that supports the IT Asset Management (ITAM) community within the Marine Corps. This solution provides organizational hardware and software asset reporting, business intelligence, and analytics that support decision-making activities. The incumbent develops and maintains data integration processes, database structures, and data models that consolidate information from multiple source systems into a centralized, secure, and reliable data warehouse environment.
The position requires expertise in database programming, data transformation, data quality management, and performance optimization to ensure the availability, integrity, and accessibility of organizational data assets.
Salary: $115,000.00/Yr - $130,000.00/Yr
- Design, develop, implement, and maintain the data warehouse architecture and database solutions.
- Create and maintain logical and physical data models.
- Develop and modify database schemas to support reporting and analytical requirements.
- Implement and maintain data warehouse structures using industry-standard design methodologies and best practices.
- Design, develop, test, and maintain Extract, Transform, and Load (ETL/ELT) processes.
- Integrate data from multiple internal and external systems into centralized repositories.
- Develop automated workflows for data acquisition, transformation, validation, and loading.
- Monitor and troubleshoot data integration processes to ensure reliable and timely data availability.
- Develop and maintain SQL scripts, stored procedures, views, functions, triggers, and other database objects.
- Create reusable programming components to support reporting and analytics initiatives.
- Develop and maintain data access mechanisms supporting business intelligence and reporting tools.
- Perform code reviews and implement programming standards to ensure maintainability and consistency.
- Implement processes to validate data accuracy, completeness, consistency, and reliability.
- Investigate and resolve data discrepancies, integrity issues, and system anomalies.
- Support organizational data governance initiatives and compliance requirements.
- Establish and maintain documentation related to data definitions, metadata, lineage, and business rules.
- Analyze and optimize SQL queries, indexes, and ETL processing routines.
- Recommend and implement performance enhancements to improve system efficiency and scalability.
- Collaborate with business stakeholders, analysts, and technical teams to determine reporting and analytical requirements.
- Develop and support data structures that enable dashboards, scorecards, ad hoc reporting, and business intelligence solutions.
- Assist in translating business requirements into technical data solutions.
- Support organizational decision-making by ensuring timely access to accurate and meaningful information.
- Prepare and maintain technical documentation, data dictionaries, and process flow diagrams.
- Document database designs, ETL processes, operational procedures, and configuration changes.
- Support configuration management, change control, and system lifecycle activities.
- Microsoft SQL Server
- Azure SQL Database
- Azure Data Factory
- SQL Server Management Studio
- SQL Server Integration Services (SSIS)
- Microsoft Visual Studio
- Power BI
- PowerShell
- Knowledge of data warehousing concepts, architectures, and methodologies.
- Knowledge of relational database management systems and database design principles.
- Knowledge of ETL/ELT development methodologies and tools.
- Knowledge of data governance, data quality, and information management practices.
- Skill in developing complex SQL queries, stored procedures, and database applications.
- Skill in troubleshooting and resolving database and data integration issues.
- Skill in analyzing business requirements and translating them into technical solutions.
- Ability to manage multiple projects and priorities simultaneously.
- Ability to communicate technical concepts effectively to both technical and non-technical audiences.
- Ability to work independently and collaboratively within cross-functional teams.
- Must be a US citizen
- Ability to obtain and maintain a Secret clearance
- BS degree in field of Engineering, Computer Science, or a related discipline from an accredited University, or 5 years of related experience as Database analyst/Database programmer.
- Strong SQL skills - complex joins, nested queries, subqueries, ranking, etc.
- Understanding SQL server jobs.
- Strong Power BI experience.
- Experience in Microsoft SQL Server development
- SQL Server Management Studio (SSMS)
- Ability to design tables/views and write T-SQL code.
- Ability to read existing T-SQL code and understand it.
- Ability to analyze large databases with over a thousand tables and views.
- BS degree in field of Engineering, Computer Science, or a related discipline from an accredited University, or 5 years of related experience as Database analyst/Database programmer.
- CompTIA Security+
- This position requires less than 10% of travel.
- Experience with business intelligence practices, data structures, and data modeling
- Experience with SQL Server and/or Oracle, analyzing and reporting techniques; Stored procedures; & Database triggers.
- Design and creation of tables and views.
- Possess a track record of developing and implementing various IT strategies and plans.
- Demonstrated ability to be process oriented with vast analytical and problem-solving skills.
- PowerShell
- Visual Studio
- Asset Management (especially Software Asset Management)
- Flexera Data Platform
The noise level in the work environment is moderate, typical of an office, lab, and server room environments. Light travel between job site in Quantico, VA to company site in Stafford, VA.
Light lifting (approximately 50 pounds) of computer equipment to include testing appliances, display monitors, and/or desktop computers.
Chugach Government Solutions is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, gender, sexual orientation, gender identity or expression, age, pregnancy, disability, genetic factors, protected veteran status or other characteristics protected by law.
Chugach will provide reasonable accommodations, according to applicable state and federal laws, to all qualified individuals with physical or mental disabilities. In compliance with the ADA Amendments Act (ADAAA), if you have a disability and would like to request an accommodation in order to apply for a position with Chugach Government Solutions or any of its subsidiaries, please email ada@chugachgov.com.
Chugach Government Solutions supports pay transparency and is committed to equitable and competitive compensation practices. Compensation for this role
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
