Join Cognizant as a Dimensional Data Modeler – Hybrid Role for SQL & Insurance Data Experts
Dimensional Data Modeler – Join Cognizant’s Analytics and Data Excellence Team
Are you a data professional with a strong command of dimensional data modeling and SQL expertise, particularly in the insurance domain? Cognizant invites you to explore an exciting opportunity as a Dimensional Data Modeler. This role is designed for seasoned data architects who can seamlessly blend technical proficiency with business insight to create scalable, high-performance data solutions that power decision-making across the enterprise.
This full-time hybrid position allows you to work both remotely and on-site, offering the flexibility today’s professionals value, while providing the resources and exposure of a globally recognized technology leader.
About the Role
As a Dimensional Data Modeler at Cognizant, you will lead efforts to design and build dimensional data structures that drive business intelligence, analytics, and data warehousing initiatives. You will collaborate with stakeholders, business analysts, and developers to ensure the delivery of accurate, consistent, and timely data assets that align with organizational objectives.
Your responsibilities will span the full spectrum of data modeling and data architecture—from requirement gathering to implementation—ensuring high-quality, scalable solutions tailored for the insurance industry and beyond.
Key Responsibilities
-
Design and Development of Dimensional Models: Architect and implement dimensional data models optimized for performance and analytics, ensuring they support business reporting and dashboard requirements.
-
Stakeholder Collaboration: Engage with business users, analysts, and project managers to translate business requirements into technical specifications and data structures.
-
SQL Development: Write and optimize PL/SQL and ANSI SQL queries that facilitate efficient data processing, transformation, and retrieval.
-
Data Quality and Governance: Conduct data validation, profiling, and cleansing processes to ensure data consistency, integrity, and quality across platforms.
-
Performance Monitoring: Evaluate and improve system performance through tuning techniques, ensuring adherence to service-level agreements (SLAs).
-
Documentation and Best Practices: Maintain comprehensive documentation of data models, dictionaries, and design decisions. Contribute to the organization’s data governance standards.
-
Data Integration: Design ETL strategies for integrating data from multiple sources into a unified, scalable data warehouse environment.
-
Mentorship and Technical Leadership: Provide guidance and support to junior developers and cross-functional team members on best practices in dimensional modeling and data handling.
-
Technology Evolution Support: Assist in the transition to newer data platforms and architectures, ensuring minimal disruption and optimal performance.
-
Industry Engagement: Stay updated with emerging trends and tools in data architecture, cloud platforms, and the evolving needs of the insurance sector.
Ideal Candidate Profile
To thrive in this role, you should bring a balance of deep technical expertise and industry-specific knowledge. Candidates with a strong foundation in the insurance domain and the ability to work in agile environments will be best suited for this opportunity.
Core Qualifications:
-
Proven hands-on experience in Dimensional Data Modeling, especially within BI and analytics environments.
-
Advanced skills in PL/SQL and ANSI SQL for data query, transformation, and optimization.
-
Familiarity with Data Vault methodologies and how to convert Data Vault to dimensional structures.
-
Proficient in developing Bus Matrices and aligning technical data models with specific business requirements to ensure seamless integration between business goals and data architecture.
-
Expertise in data modeling tools like Erwin or similar platforms.
-
Exposure to iterative and agile data modeling approaches.
-
Sound understanding of the insurance domain, including industry-specific data needs and regulatory considerations.
Why Join Cognizant?
Cognizant is a globally respected IT services and consulting company, known for driving digital transformation across industries. As a Dimensional Data Modeler, you will be at the forefront of innovation, helping clients unlock the value of their data through advanced analytics and modern architecture.
Key Benefits and Opportunities:
-
Career Growth: Explore multiple career tracks and leadership development programs tailored to your goals.
-
Continuous Learning: Gain access to Cognizant’s world-class training platforms and certifications in cloud, analytics, and emerging technologies.
-
Inclusive Work Culture: Thrive in a collaborative environment where diversity and individuality are celebrated.
-
Health and Wellness Support: Comprehensive health, wellness, and financial planning programs to help you stay focused and healthy.
-
Innovation Environment: Work with industry leaders and cutting-edge technologies to build impactful solutions that shape the future of data and business intelligence.
About Cognizant
Cognizant (Nasdaq: CTSH) is one of the world’s leading professional services firms, transforming clients’ business, operating, and technology models for the digital era. With more than 300,000 professionals around the globe, Cognizant offers deep domain expertise, innovation capabilities, and a commitment to excellence that empowers organizations to stay ahead in a rapidly changing world.
At Cognizant, we design and build innovative business solutions that enhance everyday experiences and drive meaningful impact. Our mission is clear—modernize technology, reimagine processes, and transform experiences. We are proud to be recognized as one of Forbes World’s Best Employers 2024 and as a NASDAQ-100 listed company.
Visit us at www.cognizant.com or follow us on social media @Cognizant.
Work Authorization and Equal Opportunity Statement
Applicants must be legally authorized to work in the United States without the need for employer sponsorship, both now and in the future.
Cognizant is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by law.
If you require a reasonable accommodation to search for a job or submit an application due to a disability, please email Ca********@*******nt.com with your contact information and request details.
Application Process
Ready to take the next step in your career as a Dimensional Data Modeler with our innovative and collaborative team?
Please reach out to our recruitment team and share your application today. You’ll be part of a collaborative, innovative, and supportive environment where you can make a meaningful impact on the future of data-driven decision-making.