- Responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
- Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
- Implement business and DT data requirements through designing across all data platforms (relational, dimensional, and NoSQL).
- Experience in writing SQL queries to perform data analysis, data profiling and ensuring referential integrity is maintained.
- Understands core concepts of metadata management, data lakes, data warehouse and data lineage.
- Work with business and application/solution teams to build data flows and develop conceptual/logical/physical data models.
- Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
- Work proactively and independently to address business requirements and articulate issues/challenges to reduce risks
- Erwin, Power BI, SQL are some must have
- AWS, Databricks, Informatica & Denodo
- Power BI , Tableau & SAP Datasphere
Why Choose Cogent? Cogent Infotech stands at the forefront of technology consulting and is recognized globally for its award-winning services. With our headquarters in Pittsburgh, PA, USA, we specialize in guiding enterprises through digital transformation, leveraging the power of emerging technologies such as Cloud Computing, Cybersecurity, Data Analytics, and AI. Our mission is to provide innovative workforce solutions that address the complex challenges faced by today’s businesses.
As an ISO-certified firm and appraised at CMMI level 3, our reputation for excellence is well-established. We are proud to collaborate with over 70 Fortune 500 companies and more than 150 Federal C State agencies, delivering cutting-edge technology solutions that drive success.
Cogent is an equal opportunity employer. Cogent will not discriminate against applicants or employees based on race, color, religion, national origin, age, sex, pregnancy (including childbirth or related medical condition), genetic information, sexual orientation, gender identity, military status, citizenship, or any other class protected by applicable law.
Never miss an opportunity! Create an alert based on the job you applied for.
