guiding the design, development, and implementation of data warehouse solutions to support the business analytics and reporting needs of our Federal Government customers applications and capabilities. This role involves collaborating with business stakeholders, analysts, and data engineers to ensure the data warehouse meets the organization's requirements and supports strategic decision-making. In addition to providing technical leadership, mentoring team members, and implementing best practices in coding, architecture, and security, this role will also manage project timelines, optimize application performance, and stay abreast of industry trends to drive continuous improvement and innovation of web technologies. Delivery requires a strong presence in the National Capital Region while working in hybrid low and high-side development environments.
This position is located in our USA DC Washington however, a hybrid working model is acceptable. Lead the design and development of data warehouse architectures, including data models, schemas, and data flow diagrams to ensure the data warehouse structure supports efficient data storage, retrieval, and analysis.
Develop, implement, and maintain Extract, Transform, Load (ETL) processes to extract and integrate data from various sources, transform into suitable formats, and load into the data warehouse to provide a unified view of data for analysis and reporting.
Collaborate with business analysts, data scientists, and other stakeholders to understand their data needs and provide appropriate solutions ensuring the data warehouse meets the needs of the organization and supports decision-making.
Implement data security measures, including access controls, encryption, and auditing to protect sensitive data and ensure compliance with security policies and regulations.
Optimize the performance of the data warehouse, including query performance tuning, indexes, and partitions to ensure fast and efficient data storage, retrieval, and processing.
Create and maintain conceptual, logical, and physical data models to represent the structure and relationships of data within the data warehouse ensuring it supports business requirements and analytical needs.
Oversee all Data Warehousing work and present overview briefings and updates to Government leads, partners, and customers. This includes reporting on business area progress at performance improvement meetings as well as helping to identify opportunities for increased effectiveness, efficiency, scale, and impact.
Assist the CGI Program Manager (PM) and Deputy PM (DPM) in distilling Data Warehouse requirements, communicating them to contract staff, and tracking progress against them.
Work closely with technical leads, database architects, data scientists, and Information Systems Security Officers (ISSO) to build and integrate applications and ensure secure and seamless data flow and accessibility with both internal and external systems
Maintain daily communication with Government, CGI and other contractor leads on requirements, mission priorities, performance measures, program goals and milestones, and support needs.
Provide a technical need summary to the government program manager and government technical lead, giving the client a consolidated roundup across all development efforts, with a special focus on areas that need client intervention.
Notify Government, CGI PM and DPM of any issues or trends that pose a risk to mission priorities.
Collaborate and communicate effectively with internal and external teams of software developers, data scientists, system administrators, stakeholders, and clients.
Bachelors degree in engineering, computer science, data science, mathematics, or similar technical discipline.
Experience with managed cloud database services such as Amazon RDS and Redshift to perform tasks such as ETL, retrieval, analysis, and implementing cloud-native high availability and scaling.
Strong experience with business intelligence (BI) tools such as Tableau or Power BI to create interactive and shareable dashboards for effective visualization and reporting.
Strong understanding of Structured Query Language (SQL) fundamentals such as creating tables, views, stored procedures, joins, and writing complex queries. This includes knowledge of advanced SQL concepts like indexing, normalization, transactions, query performance optimization, and database schema design.
Familiarity with database modeling and tools like Cameo, ER/Studio, ERWin, or Toad Data Modeler can be useful for designing data warehouses and generating their schemas.
Familiarity with NOSQL databases such as MongoDB or DynamoDB is helpful since semi-structured and unstructured databases are becoming increasingly common.
Understanding of data security and privacy regulations along with knowledge of best practices and regulations like Risk Management Framework (RMF), Defense Information Systems Agency (DISA) Security Technical Implementation Guides (STIGs) guidance, and National Institute of Standards and Technology (NIST) Special Publication 800-53 catalog of database security controls.
Excellent written and verbal communication skills to facilitate collaboration and teamwork among teams, ensure documentation is clear, concise, and comprehensive to serve as both deliverables as well as a guide to users, developers, and future team members.
Active TS/SCI with CI Poly Required
Together, as owners, lets turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, youll reach your full potential becauseIf an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.
Join Anduril Industries as a Technical Data Steward to play a critical role in improving data management practices within the defense technology sector.
Join American Express as a Senior Data Engineer to shape data architecture while enjoying a comprehensive benefits package.
Join Mercy Medical Center as a Trauma Registrar, supporting critical data management for trauma care in our community.
Seeking an experienced Partnerships Manager with a passion for Big Data to drive strategic partnerships at Kyivstar, a top mobile operator in Ukraine.
Join Binance as a Senior Data Warehouse Engineer to architect and optimize enterprise-scale data solutions in the leading blockchain ecosystem.
Join CVS Health as a Data Engineer to innovate on reporting and data analytics in a collaborative team environment.
Join HIDI as a Senior ETL Developer and leverage your expertise in Azure ETL tools to improve data workflows in the healthcare sector.
Lab49 is on the lookout for an experienced Data Modeler to create robust data solutions that enhance financial services.
To serve as trusted advisors to our clients, delivering insights they can act on to achieve meaningful and sustainable outcomes.
139 jobsSubscribe to Rise newsletter