Data Warehousing Programmer

Chugach Government Solutions, LLC; Virginia; Presencial; USD 115.000 - 130.000; Jornada completa

Descripción de la vacante

Chugach Government Solutions seeks a Data Warehousing Programmer to design, develop, and maintain an enterprise data warehouse for ITAM analytics supporting USMC programs. You will build data models, integrate multiple sources, and optimize ETL processes to ensure reliable reporting and BI capabilities.

The role requires strong SQL and data governance skills, experience with SSIS and Power BI, and the ability to work across teams in a government contracting environment in Stafford, VA with

Formación

• BS degree in Engineering, Computer Science, or related field or 5 years of related experience.
• Strong SQL skills including complex joins and T-SQL code.
• Experience with Power BI and data modeling for BI solutions.
• Ability to read and optimize large databases and write efficient ETL/ELT code.

Responsabilidades

• Design, develop, implement, and maintain data warehouse architecture and db solutions.
• Create and maintain data models and schemas to support reporting.
• Design, test, and maintain ETL/ELT processes for multiple sources.
• Develop and optimize SQL queries, stored procedures, and data access components.
• Support data governance, quality, and documentation efforts.
• Collaborate with stakeholders to translate requirements into technical data solutions.

Conocimientos

SQL skills

Ability to optimize performance

Analytical thinking

Communication

Educación

BS in Eng/CS

Herramientas

SQL Server

SSMS

Power BI

Azure Data Factory

Azure SQL Database

PowerShell

Visual Studio

Descripción del empleo

About Us

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 Location

This position is located in Stafford, VA with less than 10% of travel between job site in Quantico, VA.

Job Overview

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

Responsibilities

Essential Job 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.

Data Integration and ETL Development

• 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.

Database Programming

• 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.

Data Quality and Governance

• 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.

Performance Optimization

• Analyze and optimize SQL queries, indexes, and ETL processing routines.
• Recommend and implement performance enhancements to improve system efficiency and scalability.

Reporting and Analytics Support

• 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.

Documentation and Configuration Management

• 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.

Typical Tools and Technologies

• Microsoft SQL Server
• Azure SQL Database
• Azure Data Factory
• SQL Server Management Studio
• SQL Server Integration Services (SSIS)
• Microsoft Visual Studio
• Power BI
• PowerShell

Key Responsibilities

• 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.

Job Requirements

Mandatory

• 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.

Preferred

• 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

Working Conditions

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.

Physical Requirements

Light lifting (approximately 50 pounds) of computer equipment to include testing appliances, display monitors, and/or desktop computers.

Disclosures

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 [e-mail].

Chugach Government Solutions supports pay transparency and is committed to equitable and competitive compensation practices. Compensation for this role will be determined based on factors including job responsibilities, experience, skills, internal equity, geographic location, and applicable contract requirements. Where required by law, compensation ranges will be provided to candidates during the hiring process.

Privacy Policy for California Job Applicants