Sr. Data Warehouse Engineer

DMI is a leading global provider of digital services working at the intersection of public and private sectors. With broad capabilities across IT managed services, cybersecurity, cloud migration and application development, DMI provides on-site and remote support to clients within governments, healthcare, financial services, transportation, manufacturing, and other critical infrastructure sectors. DMI has grown to over 2,100+ employees globally and has been continually recognized as a Top Workplace in both regional and national categories.

DMI, LLC is seeking a Sr. Data Warehouse Engineer to join us.

Duties and Responsibilities:

Responsible for making high-level design and architecture decisions related to data warehouses. They play a crucial role in shaping the strategic direction of the data warehouse, ensuring it aligns with business goals. Here are some key responsibilities for Senior Data Warehouse Developers:

Data Modeling: Create and maintain data models, including conceptual, logical, and physical data models. These models help organize and structure data within the warehouse.

• ETL Development: Design, develop, and optimize ETL (Extract, Transform, Load) processes. These processes extract data from various sources, transform it, and load it into the data warehouse.

• Database Design: Work on database design, including schema design, indexing, and optimization. This involves understanding business requirements and translating them into efficient database structures.

• Reporting and Analytics: Build and maintain reporting solutions, including dashboards, reports, and analytics. They ensure data accuracy and availability for business users.

• Performance Tuning: Optimize query performance, monitor system health, and troubleshoot performance issues. This includes tuning SQL queries, indexing strategies, and database configurations.

• Security and Data Governance: Implement security measures to protect data within the warehouse. Additionally, they adhere to data governance practices and ensure compliance with data privacy regulations.

• Collaboration: Collaborate with cross-functional teams, business analysts, and stakeholders to understand data requirements and deliver effective solutions.

Education and Years of Experience: BA/BS and 7+ yrs of experience

Required and Desired Skills/Certifications:

• Active Secret clearance
• Active Security+ certification

Min Citizenship Status Required: US Citizen

Physical Requirements: No Physical requirement needed for this position.

Location: Remote, US