Current jobs related to Data Modeler - Bethlehem - Smart IT Frame LLC

  • Data Engineer

    2 weeks ago

    Bethlehem, United States Smart IT Frame LLC Full time

    Title: Data EngineerLocation: Bethlehem, PAType: ContractRole & Responsibilities:10+ Years of experience as a Data EngineerStrong technical expertise in SQL is mustStrong knowledge of joins and common table expressions (CTEs)Strong experience with PythonStrong expertise in ETL process and with various data model conceptsKnowledge of star schema and a...

  • Data Engineer

    3 weeks ago

    Bethlehem, United States Smart IT Frame LLC Full time

    Title: Data EngineerLocation: Bethlehem, PAType: ContractRole & Responsibilities:10+ Years of experience as a Data EngineerStrong technical expertise in SQL is mustStrong knowledge of joins and common table expressions (CTEs)Strong experience with PythonStrong expertise in ETL process and with various data model conceptsKnowledge of star schema and a...

  • Data Engineer

    3 weeks ago

    Bethlehem, United States Lorven technologies Full time

    Job DescriptionJob DescriptionHi,Our client is looking Data Engineer for Contract project in Bethlehem, PA Opportunity below is the detailed requirements.Job Title : Data EngineerLocation : Bethlehem, PA Type : Contract Job description:Bachelor's degree in Computer science or equivalent, with minimum 9+ Years of relevant experience.5+ Years of experience...

  • Data Engineer Machine Learning

    3 months ago

    Bethlehem, United States PRI Technology Full time

    Job DescriptionJob DescriptionData Engineer Machine Learning My name is Bill Stevens and I have a new six month plus Data Engineer Machine Learning opportunity available for a major firm located in Bethlehem, Pennsylvania that could be of interest to you, please review my specification below. The work schedule will be a hybrid one, three days a week in the...

  • Data Engineer Machine Learning

    2 weeks ago

    Bethlehem, United States PRI Technology Full time $90 - $100

    Job DescriptionJob DescriptionData Engineer Machine LearningMy name is Bill Stevens, and I have a new six month plus Data Engineer Machine Learning opportunity available for a major firm located in Bethlehem, Pennsylvania that could be of interest to you, please review my specification below. The work schedule will be a hybrid, two days a week in the firms...

  • Lead Data Engineer

    1 month ago

    Bethlehem, United States Smart IT Frame LLC Full time

    Title: Lead Data EngineerLocation: Bethlehem, PAType: ContractRole & Responsibilities: Be accountable for the delivery of the project within the defined timelines with good quality. Working with the clients and Offshore leads to understanding requirements, coming up with high-level designs, and completing development, and unit testing activities. Keep all...

  • Lead Data Engineer

    1 month ago

    Bethlehem, United States Smart IT Frame LLC Full time

    Title: Lead Data EngineerLocation: Bethlehem, PAType: ContractRole & Responsibilities: Be accountable for the delivery of the project within the defined timelines with good quality. Working with the clients and Offshore leads to understanding requirements, coming up with high-level designs, and completing development, and unit testing activities. Keep all...

  • Data Engineer

    3 weeks ago

    Bethlehem, United States Acunor Inc Full time

    Job DescriptionJob DescriptionTitle: AWS Data Engineer Location: Bethlehem, PAContracting opportunity.5+ Years of experience as a Data Engineer Strong technical expertise in SQL is must Strong knowledge of joins and common table expressions (CTEs) Strong experience with Python Strong expertise in ETL process and with various data model concepts Knowledge of...

  • Sr. AWS Data Engineer

    4 weeks ago

    Bethlehem, United States Smart IT Frame LLC Full time

    Job Title: Sr. AWS Data Engineer Location: RemoteWork Type: Contract/ Full TimeJob Description:-We are expanding our Data Engineering toolset and need an experienced AWS, Kafka streams, Python and SQL Data Engineer. This role will be required to design and implement our new data pipelines using AWS and Kafka streams, and train other team members. As a member...

  • Sr. AWS Data Engineer

    4 weeks ago

    Bethlehem, United States Smart IT Frame LLC Full time

    Job Title: Sr. AWS Data Engineer Location: RemoteWork Type: Contract/ Full TimeJob Description:-We are expanding our Data Engineering toolset and need an experienced AWS, Kafka streams, Python and SQL Data Engineer. This role will be required to design and implement our new data pipelines using AWS and Kafka streams, and train other team members. As a member...

  • Strategic Data Analyst for Academic Excellence

    2 days ago

    Bethlehem, Pennsylvania, United States InsideHigherEd Full time

    About the Role:InsideHigherEd is seeking a visionary leader to shape the future of data-driven decision-making in higher education. As the Director of Educational Analytics, you will play a pivotal role in establishing a comprehensive and strategic analysis plan to evaluate the success of pedagogical initiatives across the institution.Key...

  • Senior CFD Engineer

    1 week ago

    Bethlehem, Pennsylvania, United States TES Recruiting Solutions Full time

    Position: Senior Simulation Engineer – CFD and FEAOverview:The Senior Simulation Engineer will play a pivotal role in the development, execution, and maintenance of analytical, modeling, and simulation support functions. This position is essential in assisting design teams to uphold the accuracy of models, advocating for the utilization of cutting-edge...

  • Senior CFD Engineer

    5 days ago

    Bethlehem, Pennsylvania, United States TES Recruiting Solutions Full time

    Position: Senior Simulation Engineer – CFD and FEACompany: TES Recruiting SolutionsOverview:The Senior Simulation Engineer will play a pivotal role in the development, execution, and maintenance of analytical, modeling, and simulation support functions. This position is essential in collaborating with design teams to ensure the accuracy of models,...

  • Senior CFD Engineer

    6 days ago

    Bethlehem, Pennsylvania, United States TES Recruiting Solutions Full time

    Position: Senior Simulation Engineer – CFD and FEACompany: TES Recruiting SolutionsOverview:The Senior Simulation Engineer will play a crucial role in the development, execution, and upkeep of analytical, modeling, and simulation support functions. This position is integral in assisting design teams to uphold the accuracy of models, advocating for the...

  • Senior CFD Engineer

    5 days ago

    Bethlehem, Pennsylvania, United States TES Recruiting Solutions Full time

    Position: Senior Simulation Engineer – CFD and FEAThis is a direct hire opportunity that offers comprehensive benefits and relocation support.Overview:The Senior Simulation Engineer will play a pivotal role in the development, execution, and maintenance of analytical, modeling, and simulation support services. This position entails collaborating with...

  • Senior CFD Engineer

    7 days ago

    Bethlehem, Pennsylvania, United States TES Recruiting Solutions Full time

    Position: Senior Simulation Engineer – CFD and FEAThis is a direct hire opportunity that offers competitive benefits and support for relocation.Overview:The Senior Simulation Engineer will take charge of the development, execution, and upkeep of analytic, modeling, and simulation support services. This role is crucial in assisting design teams to uphold...

  • Senior CFD Engineer

    1 week ago

    Bethlehem, Pennsylvania, United States TES Recruiting Solutions Full time

    Position: Senior Simulation Engineer – CFD and FEACompany: TES Recruiting SolutionsOverview:The Senior Simulation Engineer will play a crucial role in the development, execution, and upkeep of analytical, modeling, and simulation support functions. This position requires collaboration with design teams to ensure the reliability of models, advocating for...

  • School Services

    1 month ago

    Bethlehem, United States Therapy Staff EDU Full time

    Therapy Staff EDU is seeking a School Services Speech Language Pathologist for a local contract job in Bethlehem, Pennsylvania. Job Description & Requirements Specialty: Speech Language Pathologist Discipline: School Services Start Date: 08/15/2024 Duration: 36 weeks 40 hours per week Shift: 8 hours, days Employment Type: Local Contract Aequor is now...

  • School Services

    2 months ago

    Bethlehem, United States Hiring Now! Full time

    Therapy Staff EDU is seeking a School Services Speech Language Pathologist for a local contract job in Bethlehem, Pennsylvania. Job Description & Requirements Specialty: Speech Language Pathologist Discipline: School Services Start Date: 07/31/2024 Duration: 36 weeks 40 hours per week Shift: 8 hours, days Employment Type: Local Contract Aequor is now...

  • School Services

    3 months ago

    Bethlehem, United States Therapy Staff EDU Full time

    Therapy Staff EDU is seeking a School Services Speech Language Pathologist for a local contract job in Bethlehem, New York.Job Description & RequirementsSpecialty: Speech Language PathologistDiscipline: School ServicesStart Date: 07/31/2024Duration: 36 weeks40 hours per weekShift: 8 hours, daysEmployment Type: Local ContractAequor is now hiring a full-time...

Data Modeler

1 month ago

Bethlehem, United States Smart IT Frame LLC Full time

Title: Data Modeler

Location: Bethlehem, PA

Type: Contract/Fulltime


Job Description:


7-10 Years industry implementation experience with one or more data modelling tools such as Erwin, ERStudio, PowerDesigner etc.

• Minimum of 8 years of data architecture, data modelling or similar experience

• 5-7 years of management experience required

• 5-7 years consulting experience preferred

• Experience working with dimensionally modelled data

• Understanding of cloud (Azure, AWS, GCP, Snowflake preferred) and on premises architectures

• Experience in data analysis and profiling

• Strong data warehousing and OLTP systems from an integration perspective

• Strong understanding of data integration best practices and concepts

• Strong SQL skills required scripting preferred

• Strong Knowledge of all phases of the system development life cycle

• Experience with major database and big data platforms (e.g. RDS, Aurora, Redshift, Databricks, MySQL, Oracle, PostgresSQL, Hadoop, Snowflake, etc.)

• Understanding and experience with major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.)

• Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, Big Data.\


Preferred Skills & Experience:


• Involved in documenting user requirements, business process and translation of business process into technical documents.

• Created Data Architect designs/documents for business processing requirements.

• Prepared Business Matrix diagram to identify business processes, dimensions, facts, conformed dimensions, junk and degenerate dimensions.

• Worked as a part of the review and collaboration sessions regarding business processes, canonical (BOM) modeling.

• Designed/captured the business processes & then mapped them to the conceptual data model.

• Involved in modeling business processes through UML diagrams using Rational Rose.

• Gather accurate data by data analysis and functional analysis.

• Conduct logical data modeling and data analysis.

• Involved in developing SQL queries for extracting data from test and production databases to perform data analysis and data quality checks.

• Worked with tools like TOAD for data analysis, SQL assistant, Tortoise SVN and red gate's SQL compare.

• Developed robust and efficient oracle PL/SQL procedures, packages and functions that were useful for day to day data analysis.

• Performed Data Profiling and Data Analysis using SQL queries looking for Data issues, Data anomalies.

• Generated Logical Data Models for old databases using Reverse engineering and documented in order to implement Forward Engineering procedures.

• Revised and rewrote their design specifications, established internal procedures for product certification.

• Developed business specific custom reports using PL/SQL procedures.

• Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers, cursors and user defined functions.