The Selected candidate will be responsible for the design development and administration of data management solutions that align with the business needs of the organization.
Design relational databases to support business enterprise applications and physical data modeling according to project requirements for data acquisition and security as well as customer-defined deliverables.
Create build and lead the implementation of strategies and roadmaps for enterprise and department level data projects. Collaborate with internal and external personnel including senior management system architects software developers database administrators design analysts and information modeling experts to determine project requirements and capabilities and strategize development and implementation timelines.
Work alongside data engineers to develop comprehensive automated ELT/ELT workflows that align with database design.
Manage source data access security configure authentication and authorization manage and enforce data policies and standards.
Document and organize findings including data retrieval stand up libraries.
Collaborate with Business Analysts to gather business requirements for Analytics and Reporting.
Build and modify tables views and optimize SQL queries indexes as needed.
Responsible for implementing security on developed Dashboards in accordance with security and access requirements.
Provide guidance to BI developers in the team. Good to have Insurance Domain language understanding.
Required Skills
Has at least 10+ years of relevant experience in Data Engineering especially ADF Python PySpark SparkSql Sql and Databricks programming and cloud data ingestion data pipelines handling structured and semi-structured data formats like JSON XML. Must have experience in building ETL/ELT Data warehouses/lakes for Real time event driven scenarios.
Good to have Insurance Domain language understanding. Experience in development of Power BI backend development includes DAX and Sql relevant experience
Engage in prototyping designing developing publishing Power BI Reports.
Develop Power BI Data models and recommend best practices for report creation and visualizations.
Implement security in reports and dashboards.
Troubleshooting and resolving issues related to performance environments monitoring and operability of Power BI reports
Note -
Candidate should have 10+ years of exp
Mandatory exp in ADB, ADF, Sql, ETL, pyspark, power BI (nice to have), hands on tech lead
If your interested. Please share me your resume on sajid.k.shaikh@capgemini.com
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
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.
Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law