CGI US is looking for a Data Analyst to support the implementation of a client-specific business intelligence solution for their Federal client, to improve client-reporting capabilities and provide customized solutions.
Requirements
- 4 Years of experience with hands-on SQL development, including creating complex SQL queries and functions, and data structures.
- 4 years of Business Intelligence (BI) experience.
- Experience using scripting languages (e.g. Python, PowerShell, Perl) to extract data.
- Experience working in an Agile based environment.
- Knowledge of data warehousing best-practices including ETL and/or EII tools, database architecture, and SDLC methodologies.
- Big Data
- Big Data & Analytics Operation
Responsibilities
- Evaluate quality of complex, disparate financial data using SQL and perform data analysis techniques that improve client-reporting capabilities.
- Understand data needs and construct data pipelines for automating data preparation.
- Understand functional reporting requirements and translate into technical requirements for a Business Intelligence application.
- Identify database elements (tables, views, etc.), and business logic to build report design specifications to the client’s requirements.
- Create report prototypes through functions, scripts, and stored procedures.
- Improve and refine SQL queries.
- Troubleshoot and validate data as required.
Other
- US Citizen or GC Holder
- Bachelor’s degree or Master’s degree in Computer Science, Mathematics, Information Technology or STEM related discipline, or the equivalent combination of education, training, or work experience.
- Must be able to work in a hybrid working model, with locations in Arlington, VA, Lafayette, LA, Knoxville, TN, Belton, TX, Lebanon, VA.
- Competitive compensation and benefits package, including comprehensive insurance options, matching contributions through the 401(k) plan and the share purchase plan, paid time off, and learning opportunities.
- Ability to demonstrate in-depth technical capabilities and support multiple work streams
