Data Warehousing Programmer

Chugach Government Solutions•STAFFORD, KS

3d•Onsite

About The Position

The Data Warehousing Programmer supports the U.S. Marine Corps Asset Reporting Services (ARS) Team Technical Support Services contract by delivering enterprise business intelligence support solutions. The role designs, develops, implements, maintains, and enhances an enterprise data warehouse for the Marine Corps IT Asset Management community. The solution supports organizational hardware and software asset reporting, business intelligence, analytics, and decision-making by consolidating information from multiple source systems into a centralized, secure, and reliable environment. The position requires expertise in database programming, data transformation, data quality management, and performance optimization to ensure organizational data assets remain available, accurate, and accessible. The position is located in Stafford, Virginia, with less than 10% travel between the Stafford and Quantico, Virginia sites. The work environment includes office, lab, and server room settings with moderate noise. The role involves light lifting of computer equipment weighing approximately 50 pounds. The stated salary range is $115,000 to $130,000 per year.

Requirements

Must be a U.S. citizen.
Must be able to obtain and maintain a Secret clearance.
Bachelor’s degree in Engineering, Computer Science, or a related discipline from an accredited university, or five years of related experience as a database analyst or database programmer.
CompTIA Security+.
Strong SQL skills, including complex joins, nested queries, subqueries, and ranking.
Understanding of SQL Server jobs.
Strong Power BI experience.
Experience developing with Microsoft SQL Server.
Experience with SQL Server Management Studio (SSMS).
Ability to design tables and views and write T-SQL code.
Ability to read and understand existing T-SQL code.
Ability to analyze large databases with more than a thousand tables and views.
Ability to travel less than 10% between job sites.
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 technical and non-technical audiences.
Ability to work independently and collaboratively within cross-functional teams.

Nice To Haves

Experience with business intelligence practices, data structures, and data modeling.
Experience with SQL Server and/or Oracle, including analysis and reporting techniques, stored procedures, and database triggers.
Experience designing and creating tables and views.
A track record of developing and implementing IT strategies and plans.
Process-oriented approach with strong analytical and problem-solving skills.
PowerShell experience.
Visual Studio experience.
Asset Management experience, especially Software Asset Management.
Flexera Data Platform experience.

Responsibilities

Design, develop, implement, and maintain data warehouse architecture and database solutions.
Create and maintain logical and physical data models.
Develop and modify database schemas for reporting and analytical requirements.
Implement and maintain data warehouse structures using established design methodologies and best practices.
Design, develop, test, and maintain ETL/ELT processes.
Integrate data from 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, timely data availability.
Develop and maintain SQL scripts, stored procedures, views, functions, triggers, and other database objects.
Create reusable programming components for reporting and analytics initiatives.
Develop and maintain data access mechanisms for business intelligence and reporting tools.
Conduct code reviews and apply programming standards for maintainability and consistency.
Validate data accuracy, completeness, consistency, and reliability.
Investigate and resolve data discrepancies, integrity issues, and system anomalies.
Support data governance initiatives and compliance requirements.
Maintain documentation of data definitions, metadata, lineage, and business rules.
Analyze and optimize SQL queries, indexes, and ETL processing routines.
Recommend and implement performance improvements to increase efficiency and scalability.
Collaborate with stakeholders, analysts, and technical teams to determine reporting and analytics requirements.
Develop and support data structures for dashboards, scorecards, ad hoc reporting, and business intelligence solutions.
Translate business requirements into technical data solutions and support decision-making through timely access to accurate information.
Prepare and maintain technical documentation, data dictionaries, and process flow diagrams.
Document database designs, ETL processes, operating procedures, and configuration changes.
Support configuration management, change control, and system lifecycle activities.