Job Description
We are looking for a Data Modeler/ Data Analyst to work for a leader in the technology consulting space. This person will be responsible for hands on data modeling leveraging the ER/Studio data architect modeling application. This person will need to be able to perform business and systems analysis and documentation, as well as develop conceptual, logical, and physical relational data models for the enterprise data warehouse. Responsibilities will also include the ability to perform data modeling in relational and dimensional models. This person will need exposure to large data warehouse implementation projects, ensuring they can develop and design requirement specifications. The ability to document data flow diagrams in existing and future reports will also be required.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
- 10+ years of experience within the data management space
- 5+ years’ experience within database design
- 5+ years experience leveraging ER/ Studio data modeling application
- 5+ years experience as a data analyst, data engineer, or data researcher
- 5+ years experience within data modeling and dimensional data modeling, statistical analysis, and machine learning
- 2+ years experience working on Star, Snowflake, or Hybrid Schemas
Nice to Have Skills & Experience
- 2+ years experience working on oracle Autonomous Data Warehouse (ADW) specifically within an OCI environment
- Expert level experience with Kimball Dimensional Data Modeling
- Expert level experience with 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 PLL SQL/ SQL
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.