DBA Web Technologies

Data Modeler (Data Engineering, Data Architecture, Data Modeling, ER Studio, ERwin, SSIS, Talend, Snowflake, Data Stewardship) - 100% Remote

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: Remote
  • Experience: NA
  • No. of Positions: 1
  • Primary Skills: Data Architecture Data Modeling ER Studio ERwin SQL ETL ELT normalization star schemas data integration relational DBMS data vault modeling DBT SSIS
  • Secondary Skills: Talend Snowflake Synapse Big Query Redshift EMR Data bricks Data Analysis master data management Data Stewardship Python Spark Data Engineering
  • Job Location: Remote, Remote
  • Posted Date: Posted today
Job Description
Data Modeler (Data Engineering, Data Architecture, Data Modeling, ER Studio, ERwin, SSIS, Talend, Snowflake, Data Stewardship) - 100% Remote
Position: Data Modeler (Data Engineering, Data Architecture, Data Modeling, ER Studio, ERwin, SSIS, Talend, Snowflake, Data Stewardship) - 100% Remote
Location: 100 % Remote
Duration: Full-Time REMOTE position (no contracts, no corp to corp)
Salary: Excellent Compensation with benefits + 401K
SKILLS: Data Engineering, Data Architecture, Data Modeling, ER Studio, ERwin, SQL, ETL, ELT, normalization, star schemas, data integration, relational DBMS, data vault modeling, DBT, SSIS, Talend, Snowflake, Synapse, Big Query, Redshift, EMR, Data bricks, Data Analysis, master data management, Data Stewardship, Python, Spark

DESCRIPTION

Data Modeler position will be responsible for architecting, designing and developing data solutions in the department. The position requires extensive hands-on experience working with different businesses SMEs and technical peers to uncover requirements and real world concepts and translate them into robust data models that development teams can build on.

RESPONSIBILITIES:

  • Collaboratively work with functional experts and conduct interviews to understand and document the domain requirements and issues.
  • Understand industry practices and tools to extract the entities, attributes and underlying rules, and to document them.
  • Design conceptual, logical and physical data models that support business objectives.
  • Document source to target mapping specifications including any necessary transformation, translation or business rules.
  • Contribute to the data catalogs for the enterprise.
  • Propose architecture that enables integration of disparate enterprise data assets.
  • Objectively review/analyze data models, and propose replacement models with clear pros/cons.
  • Able to adjust models for operational performance and reusability.
  • Lead efforts to research, identify, and profile data sources to uncover data anomalies and potential data quality concerns.
  • Develop and document the data modeling standards, best practices and evangelize them across department.
  • Conduct data model reviews to ensure data related standards and best practices are met.
  • Proactively educate others on basic data management concepts such as data governance, master data management, data warehousing, big data, reporting, data quality, and database performance.
  • Drive long-term data architecture roadmaps in alignment with corporate strategic objectives.
  • Pursue learning about new technologies and industry data management trends and, if appropriate, recommend their possible use within the company.
  • Foster collaborative work culture and mentor other team members to be more effective.

REQUIREMENTS:

  • Minimum of 8+ years of experience as Data Engineer, Data Architect, and Data Modeler.
  • Bachelors or Masters in Computer Science, Information Systems, or an engineering discipline.
  • Related experience in developing data solutions and models that support data lifecycle.
  • Expertise in industry standard patterns and practices for data modeling, process modeling, and metadata management.
  • Strong SQL skills and understanding of ETL, ELT processes.

REQUIRED SKILLS:

  • Modeling tools (ER/Studio, ERwin etc.) and techniques (normalization, star schemas).
  • Experience in data modeling for big data and establishing data integration between disparate systems.
  • Hands on experience with relational DBMS.
  • Experience with data vault modeling is preferred.
  • Experience with a Data Integration/Transformation tools (DBT, SSIS, Talend, etc.)
  • Production delivery experience in Big Data related technologies (Snowflake, Synapse, Big Query, Redshift, EMR, Data bricks, etc.).
  • Strong analytical / debugging / troubleshooting skills.
  • Familiar with master data management and data stewardship.
  • Programming experience is a plus - Python / Spark etc.

ADDITIONAL REQUIREMENTS:

  • Strong listening skills and ability to communicate clearly (verbally and in writing).
  • Self-motivated, engaged and accountable for your own actions.
  • Effective multi-tasking skills.
  • Understands who the customers are and strives to consistently meet their needs and SLAs.
  • Demonstrate flexibility to quickly learn and adopt new technologies.
  • Strong consultative, facilitation and consensus-building skills.

-------------------------------------------

Please click the Apply Now button below to send your resume.

Relevant Job Openings
Mobile or API tester
.Net Core Developers
Tableau developer
Jira Developer
Java Developer
Azure Data Architect with Talend