Data Modeler Design, develop, and maintain conceptual, logical, and physical data models to support business needs and objectives across various domains. Collaborate with stakeholders, including business analysts, data architects, and application developers, to gather and define data requirements. Create and optimize database schemas and data structures to ensure data consistency, accuracy, and integrity. Implement best practices for data modelling, including normalization, de-normalization, and dimensional modelling, to support efficient data storage and retrieval. Lead the design and implementation of complex data architectures for enterprise-level systems, ensuring scalability and performance. Develop and maintain data dictionaries, data lineage documentation, and metadata repositories to support data governance and standardization efforts. Perform data mapping and data profiling to ensure data quality and consistency across systems and environments. Work closely with ETL developers to design data integration strategies, ensuring seamless data flow between source and target systems. Utilize data modelling tools such as Erwin, PowerDesigner, or similar to create, modify, and maintain data models and data flow diagrams. Provide guidance and mentorship to junior data modelers and data engineers, promoting best practices and methodologies. Ensure compliance with data governance policies, industry standards, and regulatory requirements for data management and privacy. Support data migration efforts by creating detailed data mapping and transformation rules between Legacy and target systems. Experience in modelling for various databases, including relational (SQL Server, Oracle, MySQL) and NoSQL (MongoDB, Cassandra) systems. Collaborate with BI and reporting teams to ensure data models support advanced analytics, reporting, and visualization needs. Analyze and optimize existing data models and database performance, identifying bottlenecks and making recommendations for improvement. Maintain detailed documentation of data models, schemas, and changes to ensure transparency and future scalability.
27/09/2024
Full time
Data Modeler Design, develop, and maintain conceptual, logical, and physical data models to support business needs and objectives across various domains. Collaborate with stakeholders, including business analysts, data architects, and application developers, to gather and define data requirements. Create and optimize database schemas and data structures to ensure data consistency, accuracy, and integrity. Implement best practices for data modelling, including normalization, de-normalization, and dimensional modelling, to support efficient data storage and retrieval. Lead the design and implementation of complex data architectures for enterprise-level systems, ensuring scalability and performance. Develop and maintain data dictionaries, data lineage documentation, and metadata repositories to support data governance and standardization efforts. Perform data mapping and data profiling to ensure data quality and consistency across systems and environments. Work closely with ETL developers to design data integration strategies, ensuring seamless data flow between source and target systems. Utilize data modelling tools such as Erwin, PowerDesigner, or similar to create, modify, and maintain data models and data flow diagrams. Provide guidance and mentorship to junior data modelers and data engineers, promoting best practices and methodologies. Ensure compliance with data governance policies, industry standards, and regulatory requirements for data management and privacy. Support data migration efforts by creating detailed data mapping and transformation rules between Legacy and target systems. Experience in modelling for various databases, including relational (SQL Server, Oracle, MySQL) and NoSQL (MongoDB, Cassandra) systems. Collaborate with BI and reporting teams to ensure data models support advanced analytics, reporting, and visualization needs. Analyze and optimize existing data models and database performance, identifying bottlenecks and making recommendations for improvement. Maintain detailed documentation of data models, schemas, and changes to ensure transparency and future scalability.
Enterprise Data Modeler/Architect Salary: Open + Bonus Location: McLean, VA or NYC, NY Hybrid: 3 days onsite, 2 days remote *We are unable to provide sponsorship for this role* Qualifications Bachelor's degree in computer science, information technology or related field 10+ years' experience in a logical/physical data modelling, data architecture, data analysis, and data management role Experience with data modelling tools like ERwin, ER/Studio or PowerDesigners Experience with different query languages such as PL/SQL, T-SQL, and ANSI SQL Broad understanding of structured, semi-structured, and unstructured data and message formats (such as XML, JSON, etc.) Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, SQL Server, or MySQL Knowledge of data warehousing and Business Intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts Responsibilities Acts as subject matter expert for the Data Architecture team in the plan, design, and delivery of IT data solutions Drive the standardization of technical documentation supporting the Enterprise Business Model including notation, templates, and design of data structures Create appropriate technical documentation as part of work assignments, such as program code, flowcharts, and technical requirements Perform design implementation and support of Enterprise Data Management (EDM) and data structures within all layers of the Enterprise Data Warehouse (EDW) environment
24/09/2024
Full time
Enterprise Data Modeler/Architect Salary: Open + Bonus Location: McLean, VA or NYC, NY Hybrid: 3 days onsite, 2 days remote *We are unable to provide sponsorship for this role* Qualifications Bachelor's degree in computer science, information technology or related field 10+ years' experience in a logical/physical data modelling, data architecture, data analysis, and data management role Experience with data modelling tools like ERwin, ER/Studio or PowerDesigners Experience with different query languages such as PL/SQL, T-SQL, and ANSI SQL Broad understanding of structured, semi-structured, and unstructured data and message formats (such as XML, JSON, etc.) Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, SQL Server, or MySQL Knowledge of data warehousing and Business Intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts Responsibilities Acts as subject matter expert for the Data Architecture team in the plan, design, and delivery of IT data solutions Drive the standardization of technical documentation supporting the Enterprise Business Model including notation, templates, and design of data structures Create appropriate technical documentation as part of work assignments, such as program code, flowcharts, and technical requirements Perform design implementation and support of Enterprise Data Management (EDM) and data structures within all layers of the Enterprise Data Warehouse (EDW) environment
NO SPONSORSHIP Technical Lead, Corporate Technology Strategy, Data Modeler - Enterprise Business Model (Hybrid - 3 Days In Office) SALARY: $200k - $225k plus $30k - $40k bonus LOCATION: MCLEAN, VA SELLING POINTS: leading the data modelling efforts related to enterprise business model data architecture. Data management, data structures within enterprise data warehouse. 10 years logical physical data modelling data analysis Erwin er studio power designers querys PL/SQ/T-SQL/ANSI SQL oracle DB2 Sybase PostgreSQL Snowflake SQL server MySQL data warehousing Business Intelligence data mesh data fabric data lake data marts Acts as subject matter expert for CTS Data Architecture team in the plan, design, and delivery of IT data solutions Drive the standardization of technical documentation supporting the Enterprise Business Model including notation, templates, and design of data structures Your Impact: Create appropriate technical documentation as part of work assignments, such as program code, flowcharts, and technical requirements Perform design implementation and support of Enterprise Data Management (EDM) and data structures within all layers of the Enterprise Data Warehouse (EDW) environment Qualifications: Bachelors degree 10+ years experience in a logical/physical data modelling, data architecture, data analysis, and data management role Experience with data modelling tools like ERwin, ER/Studio or PowerDesigners Experience with different query languages such as PL/SQL, T-SQL, and ANSI SQL Broad understanding of structured, semi-structured, and unstructured data and message formats (such as XML, JSON, etc.) Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, SQL Server, or MySQL Knowledge of data warehousing and Business Intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts
23/09/2024
Full time
NO SPONSORSHIP Technical Lead, Corporate Technology Strategy, Data Modeler - Enterprise Business Model (Hybrid - 3 Days In Office) SALARY: $200k - $225k plus $30k - $40k bonus LOCATION: MCLEAN, VA SELLING POINTS: leading the data modelling efforts related to enterprise business model data architecture. Data management, data structures within enterprise data warehouse. 10 years logical physical data modelling data analysis Erwin er studio power designers querys PL/SQ/T-SQL/ANSI SQL oracle DB2 Sybase PostgreSQL Snowflake SQL server MySQL data warehousing Business Intelligence data mesh data fabric data lake data marts Acts as subject matter expert for CTS Data Architecture team in the plan, design, and delivery of IT data solutions Drive the standardization of technical documentation supporting the Enterprise Business Model including notation, templates, and design of data structures Your Impact: Create appropriate technical documentation as part of work assignments, such as program code, flowcharts, and technical requirements Perform design implementation and support of Enterprise Data Management (EDM) and data structures within all layers of the Enterprise Data Warehouse (EDW) environment Qualifications: Bachelors degree 10+ years experience in a logical/physical data modelling, data architecture, data analysis, and data management role Experience with data modelling tools like ERwin, ER/Studio or PowerDesigners Experience with different query languages such as PL/SQL, T-SQL, and ANSI SQL Broad understanding of structured, semi-structured, and unstructured data and message formats (such as XML, JSON, etc.) Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, SQL Server, or MySQL Knowledge of data warehousing and Business Intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts
NO SPONSORSHIP Technical Lead, Corporate Technology Strategy, Data Modeler - Enterprise Business Model (Hybrid - 3 Days In Office) SALARY: $200k - $225k plus $30k - $40k bonus LOCATION: MCLEAN, VA SELLING POINTS: leading the data modelling efforts related to enterprise business model data architecture. Data management, data structures within enterprise data warehouse. 10 years logical physical data modelling data analysis Erwin er studio power designers querys PL/SQ/T-SQL/ANSI SQL oracle DB2 Sybase PostgreSQL Snowflake SQL server MySQL data warehousing Business Intelligence data mesh data fabric data lake data marts Acts as subject matter expert for CTS Data Architecture team in the plan, design, and delivery of IT data solutions Drive the standardization of technical documentation supporting the Enterprise Business Model including notation, templates, and design of data structures Your Impact: Create appropriate technical documentation as part of work assignments, such as program code, flowcharts, and technical requirements Perform design implementation and support of Enterprise Data Management (EDM) and data structures within all layers of the Enterprise Data Warehouse (EDW) environment Qualifications: Bachelors degree 10+ years experience in a logical/physical data modelling, data architecture, data analysis, and data management role Experience with data modelling tools like ERwin, ER/Studio or PowerDesigners Experience with different query languages such as PL/SQL, T-SQL, and ANSI SQL Broad understanding of structured, semi-structured, and unstructured data and message formats (such as XML, JSON, etc.) Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, SQL Server, or MySQL Knowledge of data warehousing and Business Intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts
23/09/2024
Full time
NO SPONSORSHIP Technical Lead, Corporate Technology Strategy, Data Modeler - Enterprise Business Model (Hybrid - 3 Days In Office) SALARY: $200k - $225k plus $30k - $40k bonus LOCATION: MCLEAN, VA SELLING POINTS: leading the data modelling efforts related to enterprise business model data architecture. Data management, data structures within enterprise data warehouse. 10 years logical physical data modelling data analysis Erwin er studio power designers querys PL/SQ/T-SQL/ANSI SQL oracle DB2 Sybase PostgreSQL Snowflake SQL server MySQL data warehousing Business Intelligence data mesh data fabric data lake data marts Acts as subject matter expert for CTS Data Architecture team in the plan, design, and delivery of IT data solutions Drive the standardization of technical documentation supporting the Enterprise Business Model including notation, templates, and design of data structures Your Impact: Create appropriate technical documentation as part of work assignments, such as program code, flowcharts, and technical requirements Perform design implementation and support of Enterprise Data Management (EDM) and data structures within all layers of the Enterprise Data Warehouse (EDW) environment Qualifications: Bachelors degree 10+ years experience in a logical/physical data modelling, data architecture, data analysis, and data management role Experience with data modelling tools like ERwin, ER/Studio or PowerDesigners Experience with different query languages such as PL/SQL, T-SQL, and ANSI SQL Broad understanding of structured, semi-structured, and unstructured data and message formats (such as XML, JSON, etc.) Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, SQL Server, or MySQL Knowledge of data warehousing and Business Intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts
*Hybrid, 3 days onsite, 2 days remote* *We are unable to sponsor as this is a permanent Full time role* A prestigious company is looking for a Senior Technical Lead, Enterprise Data Modeler. This technical lead will lead the data modelling efforts for the enterprise business model and will focus on data modelling, data architecture, data analysis, data warehousing, and data management. This tech lead will need experience with data modelling tools such as ERwin, ER/Studio or PowerDesigners and languages such as PL/SQL, T-SQL, and ANSI SQL. Responsibilities: Responsible for leading the data modelling efforts related to the Enterprise Business Model (EBM). This role collaborates with the CTS Data Architecture Leads, Enterprise Business Model Leads, and Business-aligned Technology Office (BTO) team members across the company's business to drive the creation of the Enterprise Business Model. Acts as subject matter expert for CTS Data Architecture team in the plan, design, and delivery of IT data solutions Drive the standardization of technical documentation supporting the Enterprise Business Model including notation, templates, and design of data structures Create appropriate technical documentation as part of work assignments, such as program code, flowcharts, and technical requirements Perform design implementation and support of Enterprise Data Management (EDM) and data structures within all layers of the Enterprise Data Warehouse (EDW) environment Qualifications: Bachelor's degree in computer science, information technology or related field 10+ years' experience in a logical/physical data modelling, data architecture, data analysis, and data management role Experience with data modelling tools like ERwin, ER/Studio or PowerDesigners Experience with different query languages such as PL/SQL, T-SQL, and ANSI SQL Broad understanding of structured, semi-structured, and unstructured data and message formats (such as XML, JSON, etc.) Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, SQL Server, or MySQL Knowledge of data warehousing and Business Intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts
23/09/2024
Full time
*Hybrid, 3 days onsite, 2 days remote* *We are unable to sponsor as this is a permanent Full time role* A prestigious company is looking for a Senior Technical Lead, Enterprise Data Modeler. This technical lead will lead the data modelling efforts for the enterprise business model and will focus on data modelling, data architecture, data analysis, data warehousing, and data management. This tech lead will need experience with data modelling tools such as ERwin, ER/Studio or PowerDesigners and languages such as PL/SQL, T-SQL, and ANSI SQL. Responsibilities: Responsible for leading the data modelling efforts related to the Enterprise Business Model (EBM). This role collaborates with the CTS Data Architecture Leads, Enterprise Business Model Leads, and Business-aligned Technology Office (BTO) team members across the company's business to drive the creation of the Enterprise Business Model. Acts as subject matter expert for CTS Data Architecture team in the plan, design, and delivery of IT data solutions Drive the standardization of technical documentation supporting the Enterprise Business Model including notation, templates, and design of data structures Create appropriate technical documentation as part of work assignments, such as program code, flowcharts, and technical requirements Perform design implementation and support of Enterprise Data Management (EDM) and data structures within all layers of the Enterprise Data Warehouse (EDW) environment Qualifications: Bachelor's degree in computer science, information technology or related field 10+ years' experience in a logical/physical data modelling, data architecture, data analysis, and data management role Experience with data modelling tools like ERwin, ER/Studio or PowerDesigners Experience with different query languages such as PL/SQL, T-SQL, and ANSI SQL Broad understanding of structured, semi-structured, and unstructured data and message formats (such as XML, JSON, etc.) Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, SQL Server, or MySQL Knowledge of data warehousing and Business Intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts
Job Title: Senior Data Modeller Location: Full-remote Salary: to £62,000 pa outside London/£67,500 inside M25 + attractive benefits Permanent Full time position The Bridge Technology Partners are working exclusively with a national public sector organisation to help with their searches for an experienced Data Modeller. The primary purpose of the Senior Data Modeler role is to specialise in logical, conceptual and physical Datamodelling and contribute to the development and maintenance of an enterprise data model which is in need of modernisation. This role involves crafting logical data models that accurately represent the organisations data assets, relationships, and business processes. By collaborating closely with stakeholders, the Senior Data Modeler ensures that the enterprise data model aligns with business objectives and requirements. Datamodelling: Develop and maintain logical and conceptual data models that accurately represent the organisations data assets, relationships, and business processes. Enterprise Data Model Development: Contribute to the creation and evolution of an enterprise data model that provides a standardised framework for data management across the organization. Stakeholder Collaboration: Collaborate with business units, data architects, data engineers, and other stakeholders to gather requirements, validate data models, and ensure alignment with business objectives. Documentation: Maintain comprehensive documentation of data models, ensuring they are accessible for reference and promoting a clear understanding of data structures and relationships. This position will suit someone who has specialised in Datamodelling as a career rather than someone who has done Datamodelling as part of a much wider remit. The preferred modelling tool is ER Studio so experience of this or similar is desirable. If this sounds like you - please get in touch for further information.
23/09/2024
Full time
Job Title: Senior Data Modeller Location: Full-remote Salary: to £62,000 pa outside London/£67,500 inside M25 + attractive benefits Permanent Full time position The Bridge Technology Partners are working exclusively with a national public sector organisation to help with their searches for an experienced Data Modeller. The primary purpose of the Senior Data Modeler role is to specialise in logical, conceptual and physical Datamodelling and contribute to the development and maintenance of an enterprise data model which is in need of modernisation. This role involves crafting logical data models that accurately represent the organisations data assets, relationships, and business processes. By collaborating closely with stakeholders, the Senior Data Modeler ensures that the enterprise data model aligns with business objectives and requirements. Datamodelling: Develop and maintain logical and conceptual data models that accurately represent the organisations data assets, relationships, and business processes. Enterprise Data Model Development: Contribute to the creation and evolution of an enterprise data model that provides a standardised framework for data management across the organization. Stakeholder Collaboration: Collaborate with business units, data architects, data engineers, and other stakeholders to gather requirements, validate data models, and ensure alignment with business objectives. Documentation: Maintain comprehensive documentation of data models, ensuring they are accessible for reference and promoting a clear understanding of data structures and relationships. This position will suit someone who has specialised in Datamodelling as a career rather than someone who has done Datamodelling as part of a much wider remit. The preferred modelling tool is ER Studio so experience of this or similar is desirable. If this sounds like you - please get in touch for further information.
Enterprise Data Modeler/Architect Salary: Open + Bonus Location: McLean, VA or NYC, NY Hybrid: 3 days onsite, 2 days remote *We are unable to provide sponsorship for this role* Qualifications Bachelor's degree in computer science, information technology or related field 10+ years' experience in a logical/physical data modelling, data architecture, data analysis, and data management role Experience with data modelling tools like ERwin, ER/Studio or PowerDesigners Experience with different query languages such as PL/SQL, T-SQL, and ANSI SQL Broad understanding of structured, semi-structured, and unstructured data and message formats (such as XML, JSON, etc.) Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, SQL Server, or MySQL Knowledge of data warehousing and Business Intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts Responsibilities Acts as subject matter expert for the Data Architecture team in the plan, design, and delivery of IT data solutions Drive the standardization of technical documentation supporting the Enterprise Business Model including notation, templates, and design of data structures Create appropriate technical documentation as part of work assignments, such as program code, flowcharts, and technical requirements Perform design implementation and support of Enterprise Data Management (EDM) and data structures within all layers of the Enterprise Data Warehouse (EDW) environment
17/09/2024
Full time
Enterprise Data Modeler/Architect Salary: Open + Bonus Location: McLean, VA or NYC, NY Hybrid: 3 days onsite, 2 days remote *We are unable to provide sponsorship for this role* Qualifications Bachelor's degree in computer science, information technology or related field 10+ years' experience in a logical/physical data modelling, data architecture, data analysis, and data management role Experience with data modelling tools like ERwin, ER/Studio or PowerDesigners Experience with different query languages such as PL/SQL, T-SQL, and ANSI SQL Broad understanding of structured, semi-structured, and unstructured data and message formats (such as XML, JSON, etc.) Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, SQL Server, or MySQL Knowledge of data warehousing and Business Intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts Responsibilities Acts as subject matter expert for the Data Architecture team in the plan, design, and delivery of IT data solutions Drive the standardization of technical documentation supporting the Enterprise Business Model including notation, templates, and design of data structures Create appropriate technical documentation as part of work assignments, such as program code, flowcharts, and technical requirements Perform design implementation and support of Enterprise Data Management (EDM) and data structures within all layers of the Enterprise Data Warehouse (EDW) environment