Amtex System Inc.
Amtex Systems Inc is an information technology and talent solutions company offering talent and BI consulting to the companies in US for over 25 years.
Our solutions are designed to fill resource gaps, by providing the right candidates who deliver value to the organization. Our propensity to nurture and build strong relationships with our clients helps us better understand their business demands and gives us the ability to provide services that are on time and rise above the rest.
Job Title: Data Modeler Location: Sacramento, CA / Hybrid Project Duration: 12+ Months Mode of Interview: Video / Face to Face Job Description We are seeking a Data Modeler in the Sacramento, California area. This position requires you to be able to work on-site in Sacramento, California, on Mondays and Wednesdays each week. Candidates must currently live within 60 miles of Sacramento, CA
Key Duties/Responsibilities
Performs business and systems analysis and documentation
Develops conceptual, logical, and physical relational data models for the enterprise data warehouse
Experience with large data warehouse implementation projects
Performs data modeling in relational and dimensional models
Develops physical data model and/or works with architect to develop physical data model
Ability to expertly develop Data Facts and Dimensions in the EDW
Provides documentation to support the Kimball Dimensional Data Modeling Framework, as necessary
Visualizes and designs the enterprise data management framework: specifies processes used to plan, acquire, maintain, use, archive, retrieve, control, and purge data
Documents data flow diagrams in existing and future reports to use as input in report design and optimization
Development Requirements Specifications
Develop Design Specifications
Performs data analysis/predictive data modeling
Mentors and Education team members on best practices and industry standards
Qualifications: Mandatory
Minimum of ten (10) years’ demonstrable experience in the data management space, with at least 5 years specializing in database design and at least 5 years data modeling.
Minimum of five (5) years of experience as a data analyst or in other quantitative analysis or related disciplines, such as researcher or data engineer, supportive of key duties/responsibilities identified above.
Minimum of five (5) years of demonstrated experience with ER/Studio data modeling application.
Minimum of five (5) years of relevant experience in relational data modeling and dimensional data modeling, statistical analysis, and machine learning, supportive of key duties/responsibilities identified above.
Excellent communication and collaboration skills to work effectively with stakeholders and team members.
At least 2 years of experience working on Star, Snowflake, and/or Hybrid schemas.
Oracle/ODI/OCI/ADW experience required.
Desired
At least 2 years of experience working on Oracle Autonomous Data Warehouse (ADW), specifically installed in an OCI environment.
Expert-level Kimball Dimensional Data Modeling experience.
Expert-level experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle.
Ability to develop and perform Extract, Transform, and Load (ETL) activities using Oracle tools and PL/SQL with at least 2 years of experience. Ability to perform technical leadership of an Oracle data warehouse team, including but not limited to ETL, requirements solicitation, DBA, data warehouse administration, and data analysis on a hands‑on basis.
#J-18808-Ljbffr
Our solutions are designed to fill resource gaps, by providing the right candidates who deliver value to the organization. Our propensity to nurture and build strong relationships with our clients helps us better understand their business demands and gives us the ability to provide services that are on time and rise above the rest.
Job Title: Data Modeler Location: Sacramento, CA / Hybrid Project Duration: 12+ Months Mode of Interview: Video / Face to Face Job Description We are seeking a Data Modeler in the Sacramento, California area. This position requires you to be able to work on-site in Sacramento, California, on Mondays and Wednesdays each week. Candidates must currently live within 60 miles of Sacramento, CA
Key Duties/Responsibilities
Performs business and systems analysis and documentation
Develops conceptual, logical, and physical relational data models for the enterprise data warehouse
Experience with large data warehouse implementation projects
Performs data modeling in relational and dimensional models
Develops physical data model and/or works with architect to develop physical data model
Ability to expertly develop Data Facts and Dimensions in the EDW
Provides documentation to support the Kimball Dimensional Data Modeling Framework, as necessary
Visualizes and designs the enterprise data management framework: specifies processes used to plan, acquire, maintain, use, archive, retrieve, control, and purge data
Documents data flow diagrams in existing and future reports to use as input in report design and optimization
Development Requirements Specifications
Develop Design Specifications
Performs data analysis/predictive data modeling
Mentors and Education team members on best practices and industry standards
Qualifications: Mandatory
Minimum of ten (10) years’ demonstrable experience in the data management space, with at least 5 years specializing in database design and at least 5 years data modeling.
Minimum of five (5) years of experience as a data analyst or in other quantitative analysis or related disciplines, such as researcher or data engineer, supportive of key duties/responsibilities identified above.
Minimum of five (5) years of demonstrated experience with ER/Studio data modeling application.
Minimum of five (5) years of relevant experience in relational data modeling and dimensional data modeling, statistical analysis, and machine learning, supportive of key duties/responsibilities identified above.
Excellent communication and collaboration skills to work effectively with stakeholders and team members.
At least 2 years of experience working on Star, Snowflake, and/or Hybrid schemas.
Oracle/ODI/OCI/ADW experience required.
Desired
At least 2 years of experience working on Oracle Autonomous Data Warehouse (ADW), specifically installed in an OCI environment.
Expert-level Kimball Dimensional Data Modeling experience.
Expert-level experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle.
Ability to develop and perform Extract, Transform, and Load (ETL) activities using Oracle tools and PL/SQL with at least 2 years of experience. Ability to perform technical leadership of an Oracle data warehouse team, including but not limited to ETL, requirements solicitation, DBA, data warehouse administration, and data analysis on a hands‑on basis.
#J-18808-Ljbffr