Data Warehousing Programmer
-
IT/Tech
Job Description & How to Apply Below
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!
Position LocationThis position is located in Stafford, VA with less than 10% of travel between job site in Quantico, VA.
Job OverviewIn 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: $/Yr - $/Yr
Responsibilities EssentialJob Duties Data Warehouse Development
- 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…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction