Software Engineer - BI/Data Analyst

Job description: Data Analyst with advanced SQL skills and experience analyzing large datasets to drive measurement and marketing strategies for a technology client.
You will be working with client data to develop measurement tools and solutions that enable stakeholders to understand the effects of marketing on business goals.
This includes reporting, analytics, and measurement of marketing campaigns, programs, monthly and quarterly revenue performance reviews, projections, and ad hoc deep-dives.
The Data Analyst will deliver highly effective insights and recommendations to accelerate ROI growth for clients.
You must possess strong problem-solving and analytical skills with out-of-the-box thinking, the ability to synthesize massive amounts of data in an efficient and effective manner, and the skills to communicate results to non-technical/non-analytical stakeholders through cohesive storytelling.
You must be able to work collaboratively with cross-functional teams and stakeholders across both CapGemini and the client’s organization to drive strong marketing performance and translating data trends into analytical insights that lead to strategic and actionable recommendations.
Requirements: • 5+ years of data analytics experience, preferably with Big Data (Hadoop, Hive, Spark, etc.
) and/or digital data sources (Facebook, Instagram, Claravine, DV360, etc.
) • Advanced SQL programming skills • Experience with SQL platforms or MPP databases, such as Teradata, Redshift, Snowflake, etc.
• Experience with data warehousing, pipelining, ETL, and data QA • Experience with translating data trends and results into actionable insights and recommendations to drive business outcomes • Experience developing Measurement Plans to guide marketing execution and analytics • Experience with A/B test reads and measuring success using statistical tools • Experience using Marketing Mix Modeling (MMM) and/or Multi-touch Attribution (MTA) tools to understand marketing impact, develop optimization strategies, and drive performance • Strong communication skills, particularly when speaking with stakeholders to gather business requirements • Ability to translate business requirements into actionable next steps to deliver a working solution that meets business needs • Ability to work under pressure in order to meet tight deadlines • Ability to navigate a complex, matrixed organization to gather detailed information about existing processes and any gaps therein • Creative thinking skills to find solutions for complex, multi-layered data problems • Ability to work independently with little guidance, while delivering results in an efficient manner • Strong collaboration skills, particularly in building relationships with stakeholders and partners on the client side • Ability to manage client expectations and concerns with realistic goal-setting, prioritization, and communication of progress • Ability to multi-task, meet tight deadlines, and deliver adequate analytical solutions • Very strong organizational and planning skills with excellent attention to detail • Excellent analytical skills and experience to answer complex business questions from clients • Excellent verbal and writing skills, particularly when communicating with both technical and non-technical client stakeholders KEY RESPONSIBILITIES: Add no more than 5-7 bullet points About the responsibilities for this position Be sure they are actual responsibilities, not skills Text Text Text Text Required Skills: Add no more than 3-5 required skills Focus on the priority skills required for this role Text Text Text Life at Capgemini Capgemini supports all aspects of your well-being throughout the changing stages of your life and career.
For eligible employees, we offer: Flexible work Healthcare including dental, vision, mental health, and well-being programs Financial well-being programs such as 401(k) and Employee Share Ownership Plan Paid time off and paid holidays Paid parental leave Family building benefits like adoption assistance, surrogacy, and cryopreservation Social well-being benefits like subsidized back-up child/elder care and tutoring Mentoring, coaching and learning programs Employee Resource Groups Disaster Relief In a world where change happens in a split second, our clients must master the art of balancing business transformation with operational excellence and cost reduction to protect their market leadership and safeguard their workforce.
They need the best and brightest talent to limit business disruption and foster future growth, all while striving to realize a new normal.
In this context, it’s our people within Insights & Data that are the core enablers to support our clients in their growth journeys.
To give our clients our best and brightest, we pride ourselves on being a fast-paced, fun, ethical place to work, where the “work hard, play hard” mentality holds true.
Even more important is our clear commitment to creating a diverse workforce in all areas.
In fact, for the ninth time in a row, Capgemini has been recognized as one of the World’s Most Ethical Companies by the Ethisphere Institute.
In addition, we’ve been recognized as a top company for women by Working Mother Media.
Capgemini’s Insights & Data Americas practice is comprised of professionals with data, analytics, and AI expertise, covering the full data- and AI-powered transformation lifecycle.
Our people extend into all industries we conduct work with our clients in the areas of; data science, data engineering, data strategy, intelligent process automation, data ecosystems, intelligent industry/IoT, enterprise management, customer-first marketing, and data partnerships/disruptors (such as SAP, Microsoft, Google, AWS, Snowflake, Oracle, Adobe, etc.
).
We do great work at I&D that is at the forefront of innovation.
We pride ourselves as an inclusive, talented, and accomplished workforce, so please contact us to explore your fit with us.
About Capgemini Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology.
The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future.
It is a responsible and diverse organization of over 360,000 team members in more than 50 countries.
With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms.
The Group reported in 2022 global revenues of €22 billion.
Get The Future You Want | www.
capgemini.
com Disclaimer Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace.
All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.
This is a general description of the Duties, Responsibilities and Qualifications required for this position.
Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed.
Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Capgemini is committed to providing reasonable accommodations during our recruitment process.
If you need assistance or accommodation, please reach out to your recruiting contact.
Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by Capgemini.
Capgemini discloses salary range information in compliance with state and local pay transparency obligations.
The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future.
The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs.
At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role.
The base salary range for the tagged location is [recruiter to insert salary range].
This role may be eligible for other compensation including variable compensation, bonus, or commission.
Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.
Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable.
The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.
Job Programmer/Analyst Schedule Full-time Primary Location US-CA-San Francisco Organization I&D