CGI is a leading IT and business consulting services firm, and they are seeking a Data Analyst to work in a fast-paced environment with a team of passionate technologists. The role involves analyzing large datasets, developing dashboards, and collaborating with stakeholders to deliver insights using modern BI tools and cloud analytics platforms.
Data Exploration: Analyze, profile, and validate datasets stored in cloud environments to support reporting, dashboarding, and analytical use cases
Data Preparation: Use Databricks and Azure Synapse to prepare, transform, and curate datasets for downstream analytics and self-service BI
Reporting & Visualization: Develop dashboards and visualizations using leading BI tools to support decision-making across business and technical stakeholders
Requirements Gathering: Partner with clients to understand analytical needs, document business requirements, and translate them into data solutions
SQL & Analytics: Write optimized SQL queries and analytical logic across Databricks SQL, Synapse SQL, and cloud databases
Quality Assurance: Perform data validation, testing, and reconciliation to ensure accuracy, completeness, and reliability of delivered insights
Collaboration: Work closely with data engineers to align analytic datasets with data models, ingestion pipelines, and data governance structures
Documentation: Create and maintain documentation for datasets, business rules, KPIs, and reporting processes
Qualification
Required
Bachelor's degree in Analytics, Information Systems, Computer Science, Mathematics, Economics, or a related field
1–4 years of experience in data analysis, BI development, or reporting
An interim Secret clearance is required to begin working onsite with our client in Arlington, VA, and a Secret clearance must be maintained throughout the project duration
Proficiency in SQL for analytics and data querying
2+ Years of experience working on Analytics and Business Intelligence focused initiatives
2+ Years of experience working with self-service business intelligence tools, specifically Power BI, and connecting them to Azure data sources
Experience working in cloud-based data platforms, preferably within Azure
Familiarity with Databricks for data exploration, SQL analytics, or notebook-based analysis
1+ Years of experience using Python (PySpark) or R to build statistical models or analyze data within a distributed computing environment
Understanding of data modeling, KPI definitions, and analytic dataset structures
Ability to work with large datasets and distributed data systems
Strong analytical thinking and problem-solving abilities
Clear communication skills with the ability to convey insights to nontechnical audiences
Ability to manage priorities in a fast-paced, collaborative environment
Preferred
Experience with Databricks SQL, Delta Lake, or Python-based notebooks
Knowledge of Azure Data Lake, Azure Synapse, Azure Data Factory
Experience with BI tools such as Power BI
Exposure to data governance, metadata management, or enterprise data catalog tools
Familiarity with statistical analysis, forecasting, or predictive modeling concepts
Experience working in an Agile-based environment
Benefits
Competitive compensation
Comprehensive insurance options
Matching contributions through the 401(k) plan and the share purchase plan
Paid time off for vacation, holidays, and sick time
Paid parental leave
Learning opportunities and tuition assistance
Wellness and Well-being programs
CGI is an IT and business consulting services firm that offers consulting, cyber security, cloud, and IT services.
