VDart
IT Programmer Analyst- Data Modeling
VDart, Mission, Kansas, United States,
Job Title: IT Programmer Analyst- Data modelingLocation: Juno Beach FL USA 33408
Type: Contract
Job Description:
Responsible for the development and integration of new or existing applications into the technical infrastructure and existing business processes.Provides technical or functional guidance to project or work teams as needed within a specific discipline. Collaborates on an on-going basis with the Business Systems Analyst.Analyzes, designs, develops, tests, debugs, implements, maintains and/or enhances existing or new systems that are reliable and efficient.
Skills:Strong understanding of data modeling concepts and methodologies (e.g. dimensional, relational, semantic)Knowledge of data warehousing design patterns and dimensional modeling techniquesExtensive experience with data warehousing, OLAP (Online Analytical Processing), big data, and cloud technologiesStrong proficiency in SQL and NoSQL databases - Oracle, PostgreSQL and RedshiftAbility to design and implement complex data models to support business requirements that align with reporting and analyticsProficiency in SQL and data modeling tools (e.g. ER Studio, ERWin)Good understanding of data governance and data management best practicesStrong ability to analyze and interpret large amounts of dataExcellent communication skills to effectively collaborate with cross-functional teams and stakeholdersAbility to stay up to date with new trends and technologies in the data modeling fieldStrong understanding of data architecture concepts, models, and frameworksAbility to translate complex technical concepts into business termsKnowledge of ETL (Extract, Transform, Load) processes using TalendStrong knowledge of data security and privacy best practicesUnderstanding of data visualization and reporting tools (e.g. PowerBI, QuickSight)Strong problem-solving and critical thinking skillsJob Duties:
Design and implement optimized data models to support business requirements.Develop and maintain a data dictionary and metadata repository.Collaborate with cross-functional teams to understand business requirements and translate them into data models.Ensure data models are accurate, consistent, and support data governance and data management best practices.Develop and maintain relationships with data owners and stakeholders to ensure data models meet their needs.Perform data profiling and analysis to understand data quality and completeness.Ensure data models are optimized for performance and scalability.Participate in data architecture design and implementation efforts.Stay up to date with new trends and technologies in the data modeling field.Document data models and data architecture artifactsCollaborate with cross-functional teams, such as software engineers, to integrate data solutions into the overall technology stack.Troubleshoot and resolve data-related issues and failures in the production environment.Build Source-To-Target mapping documents to enable data engineers to build data pipelines.Implement data security and privacy controls.Monitor and optimize the performance of data pipelines.
Type: Contract
Job Description:
Responsible for the development and integration of new or existing applications into the technical infrastructure and existing business processes.Provides technical or functional guidance to project or work teams as needed within a specific discipline. Collaborates on an on-going basis with the Business Systems Analyst.Analyzes, designs, develops, tests, debugs, implements, maintains and/or enhances existing or new systems that are reliable and efficient.
Skills:Strong understanding of data modeling concepts and methodologies (e.g. dimensional, relational, semantic)Knowledge of data warehousing design patterns and dimensional modeling techniquesExtensive experience with data warehousing, OLAP (Online Analytical Processing), big data, and cloud technologiesStrong proficiency in SQL and NoSQL databases - Oracle, PostgreSQL and RedshiftAbility to design and implement complex data models to support business requirements that align with reporting and analyticsProficiency in SQL and data modeling tools (e.g. ER Studio, ERWin)Good understanding of data governance and data management best practicesStrong ability to analyze and interpret large amounts of dataExcellent communication skills to effectively collaborate with cross-functional teams and stakeholdersAbility to stay up to date with new trends and technologies in the data modeling fieldStrong understanding of data architecture concepts, models, and frameworksAbility to translate complex technical concepts into business termsKnowledge of ETL (Extract, Transform, Load) processes using TalendStrong knowledge of data security and privacy best practicesUnderstanding of data visualization and reporting tools (e.g. PowerBI, QuickSight)Strong problem-solving and critical thinking skillsJob Duties:
Design and implement optimized data models to support business requirements.Develop and maintain a data dictionary and metadata repository.Collaborate with cross-functional teams to understand business requirements and translate them into data models.Ensure data models are accurate, consistent, and support data governance and data management best practices.Develop and maintain relationships with data owners and stakeholders to ensure data models meet their needs.Perform data profiling and analysis to understand data quality and completeness.Ensure data models are optimized for performance and scalability.Participate in data architecture design and implementation efforts.Stay up to date with new trends and technologies in the data modeling field.Document data models and data architecture artifactsCollaborate with cross-functional teams, such as software engineers, to integrate data solutions into the overall technology stack.Troubleshoot and resolve data-related issues and failures in the production environment.Build Source-To-Target mapping documents to enable data engineers to build data pipelines.Implement data security and privacy controls.Monitor and optimize the performance of data pipelines.