ETL Developer
Company: CGI Group, Inc.
Location: Burke
Posted on: October 15, 2024
|
|
Job Description:
ETL Developer Position Description CGI Federal is seeking a
motivated and customer-oriented professional to support a large
federal client. This role involves designing, implementing, and
managing ETL processes and data integration to generate valuable
business insights. This position is located in our Fairfax, VA
office; however, a hybrid working model is acceptable. Your future
duties and responsibilities ETL Process Design and Development:
Design and implement ETL processes to extract data from various
sources, transform it according to business requirements, and load
it into target databases or data warehouses. Develop and maintain
ETL scripts, stored procedures, and functions. Data Integration and
Management: Generate new business insights through data extraction,
storage, transformation, analysis, and visualization of diverse
data sets. Analyze data using data mining, machine learning, and
statistical algorithms available in COTS tools (e.g., SAS, SPSS,
and Oracle); build analytical solutions using programming languages
(e.g., R, Python, SAS), and programming libraries (e.g., Python
SciKit, R Caret, PostgreSQL MADlib, Apache Spark MLlib). Ensure
data integrity, consistency, and quality throughout the ETL
process. Collect and transform structured, unstructured,
relational, and NoSQL data using ETL and ELT tools, as well as
develop custom code using programming languages. Understand and use
distributed methods (e.g., MapReduce) that scale to multi-Terabyte
sized data collections. Interpret and evaluate the accuracy of
results through iterative, agile methods. Apply data discovery and
data visualization tools (e.g., Tableau, Trifacta) to develop
compelling, actionable, and useful data stories. Work closely with
data SMEs, business, and management to prioritize business and
information needs. Required qualifications to be successful in this
role 8 years of relevant experience. Experience working directly on
a data science team. Experience with tools, including
object-oriented programming (Python, Java), computational analysis
tools (R, MATLAB), and associated data science libraries
(scikit-learn). Proficiency in data science methods related to data
architecture, data munging, data and feature engineering, and
predictive analytics. Experience creating meaningful data
visualizations and interactive dashboards using platforms such as
Tableau, Qlik, Power BI, RShiny, plotly, and d3.js to communicate
findings and relate them back to how your insights create business
impact. Experience with cloud-based ETL solutions (e.g., AWS Glue,
Azure Data Factory). Knowledge of Big Data technologies (e.g.,
Hadoop, Spark). Certification in relevant ETL or data integration
technologies. Bachelor's Degree in data science, mathematics,
statistics, economics, computer science, engineering, or other
related business or quantitative discipline. Ability to obtain and
maintain a Public Trust. CGI is required by law in some
jurisdictions to include a reasonable estimate of the compensation
range for this role. The determination of this range includes
various factors not limited to skill set, level, experience,
relevant training, and license and certifications. To support the
ability to reward for merit-based performance, CGI typically does
not hire individuals at or near the top of the range for their
role. Compensation decisions are dependent on the facts and
circumstances of each case. A reasonable estimate of the current
range for this role in the U.S. is $85,800.00 - $209,100.00. At CGI
we call our professionals "members" to reinforce that all who join
our team are, as owners, empowered to participate in the challenges
and rewards that come from building a world-class company. CGI's
benefits include: --- 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 maternity and parental leave ---
Learning opportunities and tuition assistance --- Member assistance
and wellness programs Due to the nature of this government
contract, US Citizenship is required. CGIFederalJob LI-DD1
Together, as owners, let's turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and
belonging. Here, you'll reach your full potential because You are
invited to be an owner from day 1 as we work together to bring our
Dream to life. That's why we call ourselves CGI Partners rather
than employees. We benefit from our collective success and actively
shape our company's strategy and direction. Your work creates
value. You'll develop innovative solutions and build relationships
with teammates and clients while accessing global capabilities to
scale your ideas, embrace new opportunities, and benefit from
expansive industry and technology expertise. You'll shape your
career by joining a company built to grow and last. You'll be
supported by leaders who care about your health and well-being and
provide you with opportunities to deepen your skills and broaden
your horizons. Come join our team-one of the largest IT and
business consulting services firms in the world. Qualified
applicants will receive consideration for employment without regard
to their race, ethnicity, ancestry, color, sex, religion, creed,
age, national origin, citizenship status, disability, pregnancy,
medical condition, military and veteran status, marital status,
sexual orientation or perceived sexual orientation, gender, gender
identity, and gender expression, familial status, political
affiliation, genetic information, height, weight, or any other
legally protected status or characteristics. CGI provides
reasonable accommodations to qualified individuals with
disabilities. If you need an accommodation to apply for a job in
the U.S., please email the CGI U.S. Employment Compliance mailbox
at US_Employment_Compliancecgi.com . You will need to reference the
Position ID of the position in which you are interested. Your
message will be routed to the appropriate recruiter who will assist
you. Please note, this email address is only to be used for those
individuals who need an accommodation to apply for a job. Emails
for any other reason or those that do not include a Position ID
will not be returned. We make it easy to translate military
experience and skills Click here to be directed to our site that is
dedicated to veterans and transitioning service members. All CGI
offers of employment in the U.S. are contingent upon the ability to
successfully complete a background investigation. Background
investigation components can vary dependent upon specific
assignment and/or level of US government security clearance held.
Dependent upon role and/or federal government security clearance
requirements, and in accordance with applicable laws, some
background investigations may include a credit check. CGI will
consider for employment qualified applicants with arrests and
conviction records in accordance with all local regulations and
ordinances. CGI will not discharge or in any other manner
discriminate against employees or applicants because they have
inquired about, discussed, or disclosed their own pay or the pay of
another employee or applicant. However, employees who have access
to the compensation information of other employees or applicants as
a part of their essential job functions cannot disclose the pay of
other employees or applicants to individuals who do not otherwise
have access to compensation information, unless the disclosure is
(a) in response to a formal complaint or charge, (b) in furtherance
of an investigation, proceeding, hearing, or action, including an
investigation conducted by the employer, or (c) consistent with
CGI's legal duty to furnish information.
Keywords: CGI Group, Inc., Franconia , ETL Developer, IT / Software / Systems , Burke, Virginia
Click
here to apply!
|