Data Modeler, Level 2

Overview

Remote
Depends on Experience
Contract - W2
Contract - 32 week(s)

Skills

ETL

Job Details

Data Modeler, Level 2 (Remote)
Primary Location: Remote

V-Soft Consulting is currently hiring for a Data Modeler, Level 2 (Remote) for our premier client.

WHAT YOULL NEED:
Technical Requirements and Certifications
  • Snowflake Snowpro or Certified Professional Data Modeler or Data Management & Analytics Microsoft Certified Solutions or similar certification.

Education and Experience
  • Strong analytical and problem-solving skills, experience as [Data Architect/Modeler] and [Data Analyst] with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP, and ETL environment: 5+ years.
  • Experience in designing Architecture for Modeling a data warehouse by using tools like DB Schema, SqlDBM, ER/Studio: 5+ years.
  • Experience in Relational Data Modeling (3NF); Work on background processes of Snowflake DB, Snowflake Architecture, drill down to the lowest levels of system design and construction: 3+ years.
  • Experience in Dimensional Data Modeling: Practical understanding of Data Modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Facts & Dimension tables: 3+ years.
  • System Analysis experience in F&D Analytics, ER/Dimensional Data Modeling Database Design and RDBMS specific features: 3+ years.
  • Experience in BI/DW solution (ETL, OLAP, Data mart), Informatica, BI Reporting tool like PowerBI and experience in leading the team of application, ETL, BI developers, Testing Team: 3+ years.
  • Data Warehousing: Full Cycle Project Leadership, business-driven requirements, capacity planning, gathering, feasibility analysis, enterprise and solution architecture, design, construction, data quality, profiling and cleansing, source-target mapping, gap analysis, data integration/ETL, SOA, data marts, Data modeling for OLTP, Dimension Data Modeling for data warehouse star/snowflake design, Facts & Dimension Tables.: 5+ years.
  • Create and optimize data pipelines for business intelligence and analytics purposes: 3+ years.
  • Create data architecture artifacts such as data dictionaries, pipeline topologies, ERD diagrams, and other documents needed to define data pipelines.: 5+ years.
  • Document data architecture, processes, and workflows.: 5+ years.
  • Collaborate with stakeholders to understand data requirements and translate them into technical solutions: 5+ years.
  • Familiarity with GitHub or equivalent version control systems.
  • Knowledgeable of Change Data Capture (CDC) for bulk data movement.
  • Ability to promote code from development environments to production.
  • Ability to provide status reports and project progress reports to stakeholders and project managers.
  • Experience with:
  • Oracle databases.
  • Snowflake databases.
  • SQL Server databases.
  • Database Modeling tools, like DBSchema
  • Mainframe IMS hierarchical databases
  • Knowledge of:
  • Informatica.
  • Microsoft SSIS.

Preferred:
  • Extensive experience in usage of ETL & Reporting tools like PowerBI
  • Collaborate with DBA to improve ETL processes and workflows
  • Participate in code reviews and contribute to best practices for data engineering
  • Experience with version control systems (Git) and CI/CD practices
  • Experience in the Oil and Gas industry as well as general compliance and enforcement-related projects as a Data Modeler.
  • Knowledge of data governance and compliance requirements in Oil & Gas.
  • Proven ability to work compatibly within multifaceted teams resolve conflict and deal with challenging situations.
  • Excellent communication abilities and team collaboration; Strong analytical and problem-solving skills.
  • Bachelors degree in computer science, Business Administration or related discipline or equivalent work experience.

Interested?
Qualified candidates should send their resumes to

V-Soft Consulting Group is recognized among the top 100 fastest growing staffing companies in North America, V-Soft Consulting Group is headquartered in Louisville, KY with strategic locations in India, Canada and the U.S. V-Soft is known as an agile, innovative technology services company holding several awards and distinctions and has a wide variety of partnerships across diverse technology stacks.

As a valued V-Soft Consultant, youre eligible for full benefits (Medical, Dental, Vision), a 401(k) plan, competitive compensation and more. V-Soft is partnered with numerous Fortune 500 companies, exceptionally positioned to advance your career growth.

V-Soft Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

For more information or to view all our open jobs, please visit or call .

#LI-SS3
#MonsterPost
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.