Job location : Fort Mills SC
Key Responsibilities
- Collaborate with business stakeholders to understand data requirements and translate them into comprehensive logical and physical data models using ERWIN.
- Design and implement dimensional, snowflake, and relational data models for data warehousing and analytics purposes.
- Utilize best practices for data normalization, denormalization, and data partitioning to optimize query performance.
- Create detailed data model documentation, including entity-relationship diagrams (ERDs), data dictionary, and data lineage.
- Leverage Snowflake features like stages, variants, and data sharing to manage data ingestion, transformation, and distribution efficiently.
- Optimize Snowflake queries for high performance and scalability within the cloud environment.
- Implement data governance policies within Snowflake to ensure data quality and security.
- Design and build data warehouse structures on Snowflake, considering data loading strategies and data refresh schedules.
- Collaborate with data engineers to implement data pipelines for ETL/ELT processes, ensuring data quality and consistency.
Want more jobs like this?
Get Data and Analytics jobs in Atlanta, GA delivered to your inbox every week.
Required Skills
- Utilize ERWIN to create, manage, and maintain complex data models, leveraging its features for data validation and impact analysis.
- Ensure alignment between logical and physical data models across different environments.
- Write complex SQL queries for data manipulation, data cleansing, and data analysis.
- Optimize SQL queries to improve query performance and scalability.
- Collaboration and Communication:
- Work closely with cross-functional teams including data analysts, data engineers, and business users to gather requirements, present data models, and address data-related challenges.
- Communicate complex technical concepts clearly to both technical and non-technical stakeholders.
- Expert proficiency in data modeling concepts (dimensional, star schema, snowflake schema, etc.)
- In-depth knowledge of ERWIN data modeling tool.
- Advanced SQL skills with experience in optimizing complex queries.
- Strong understanding of Snowflake architecture and features.
- Experience with data warehousing concepts and best practices
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