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

  • 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...

  • Sr. Structural Engineer 3

    3 months ago

    Bethlehem, United States Cyfle Full time

    About the job Sr. Structural Engineer 3 We have partnered with an engineering and construction company in the Bethlehem, PA area to provide them with a Senior Structural Engineer 3. Please review the below description and let us know if you are interested. Prioritized Must Have Skills for the Sr. Structural Engineer: #1. Professional Engineer and/or...

  • 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...

  • Computational Fluid Dynamics Engineer

    1 month ago

    Bethlehem, United States TES Recruiting Solutions Full time

    Sr. Simulation Engineer – CFD and FEADirect hire role with excellent benefits and relocation assistance! Location: Bethlehem, PASummary:The Sr. Simulation Engineer will be responsible for developing, implementing, and maintaining analytic, modeling, and simulation support functions. The role involves supporting design teams to ensure the integrity of...

  • Computational Fluid Dynamics Engineer

    2 months ago

    Bethlehem, United States TES Recruiting Solutions Full time

    Sr. Simulation Engineer – CFD and FEADirect hire role with excellent benefits and relocation assistance! Location: Bethlehem, PASummary:The Sr. Simulation Engineer will be responsible for developing, implementing, and maintaining analytic, modeling, and simulation support functions. The role involves supporting design teams to ensure the integrity of...

  • 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...

  • Financial Analyst/Sr. Financial Analyst

    2 months ago

    Bethlehem, United States Tyber Medical LLC Full time

    Job Type Full-time Description Gather data to understand the trends affecting specific products (medical devices), geographical region or industry to help their clients make important investment decisions. Requirements Analyze financial data and provide forecasting support. Prepare reports and projections based on financial data. Recommend individual and...

  • Senior Principal Mechanical Design Engineer

    3 months ago

    Bethlehem, United States Air Products Full time

    Job Title :Senior Principal Mechanical Design Engineer - TurbomachineryJob Description and Qualifications :At Air Products, our purpose is to bring people together to reimagine what’s possible, collaborate and innovate solutions to the world’s most significant energy and environmental sustainability challenges. Grow with us as we embark on building...

  • 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...

Sr Data Modeler

1 month ago

Bethlehem, United States Smart IT Frame LLC Full time

Job Profile : Data Modeler

Duration: (Fulltime and Contract)

Location: Bethlehem, PA-Hybrid


JD:


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.