Job Details Extractor

Input:
1. Email Subject: Re:Data Modeler
2. Job Description:"Data ModelerChicago, illinois(Onsite)Â Please reach me at Diwakar@fpmtechnologies.comÂ Phone: 973-381-5547Â Job Summary:Â We are seeking a highly skilled and detail-oriented Data Modeler to join our team. The Data Modeler will be responsible for designing, implementing, and optimizing data models to support our organizationâ€™s business processes and decision-making. This role involves working closely with business stakeholders, data engineers, and analysts to ensure that data structures are aligned with business requirements and performance goals.Key Responsibilities:Data Modeling:Â Design and develop conceptual, logical, and physical data models for relational databases, data warehouses, and data lakes that meet the organizationâ€™s needs.Data Analysis:Â Collaborate with business analysts and stakeholders to gather and analyze requirements, translating them into data models that align with business processes.Database Design:Â Create and optimize database schemas, including tables, views, indexes, and stored procedures, ensuring efficient data storage and retrieval.Data Governance:Â Ensure data integrity, consistency, and accuracy across all data models and implement best practices for data management and governance.Documentation:Â Document data models, data dictionaries, and data flow diagrams, ensuring they are easily accessible and understandable by both technical and non-technical stakeholders.Collaboration:Â Work closely with data engineers, ETL developers, and BI teams to implement data models and support data integration, transformation, and reporting processes.Performance Tuning:Â Monitor and optimize data models and database performance, identifying and resolving bottlenecks and improving query performance.Technology Evaluation:Â Stay updated with the latest trends, tools, and technologies in data modeling and database design, recommending and implementing improvements as needed.Training and Support:Â Provide guidance and training to team members and stakeholders on data modeling best practices and data model usage.Qualifications:Education:Â Bachelorâ€™s degree in Computer Science, Information Technology, Data Science, or a related field. A Masterâ€™s degree is a plus.Experience:Minimum of 3-5 years of experience in data modeling, database design, or a related role.Proven experience with data modeling tools (e.g., ER/Studio, ERwin, or similar).Strong understanding of relational databases, SQL, and database design principles.Technical Skills:Proficiency in SQL and experience with one or more database management systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL).Experience with data warehousing concepts and technologies (e.g., Snowflake, Redshift, BigQuery).Familiarity with ETL processes and data integration tools.Knowledge of big data platforms (e.g., Hadoop, Spark) and NoSQL databases is a plus.Soft Skills:Excellent analytical and problem-solving skills.Strong communication skills, with the ability to translate complex technical concepts into understandable terms for non-technical stakeholders.Ability to work independently as well as collaboratively in a team environment.Attention to detail and commitment to delivering high-quality work.Preferred Qualifications:Experience in agile or iterative development methodologies.Certifications in data modeling, database management, or related areas.Experience with cloud-based data solutions (e.g., AWS, Azure, Google Cloud).

Output: JSON object with the following structure:

{
  "status": 200,
  "data": {
    "job_title": "",
    "location": {"city": "", "state": "", "country": "", "remote": null},
    "job_details": {
      "employment_type": "",
      "job_code": "",
      "experience_required": "",
      "degree_required": "",
      "visa_sponsorship": "",
      "notice_period": "",
      "duration": "",
      "rate": ""
    },
    "candidate_info": {"client_name": ""},
    "skills": {
      "core": [],
      "primary": [],
      "secondary": [],
      "all": [],
      "with_experience": []
    },
    "job_description_full": ""
  }
}

Guidelines:
- Extract all relevant info from input
- Use "" for unknown text, null for unknown numeric/boolean, [] for unknown lists
- Include all skills in "all" array
- Only include explicitly stated or reasonably inferred information