Data Modeler Architect

Posted Yesterday
Be an Early Applicant
Minneapolis, MN, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
Design and architect DW/BI solutions; create conceptual, logical and physical data models; implement ETL/ELT frameworks; generate DDLs and data dictionaries; collaborate with enterprise architects and business users; support developers and QA; ensure metadata standards, performance, and compliance. Requires Cards & Payments domain knowledge and Unix/Linux familiarity.
Summary Generated by Built In
Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

  • At least 7 years of experience in DW/BI related technologies and tools – MUST
  • At least 6 years of experience in Design and Architecture review
  • At least 6 years of experience in Data Modelling/Data Architect
  • Architecting BI solutions in consultation with the architecture group/IT team/users which are best suited to solve a specific business needs..
  • Collaborating with the enterprise architects for periodic assessment of the AS-IS system and if required recommending the improvements to BI IT stakeholders..
  • Collaborating with the enterprise architects to define and regularly revisit BI best practices/guidelines in accordance to the industry.
  • Interacting with the business users to understand the challenges faced by the users and documenting/communicating the same to the BI IT stakeholders.
  • Understanding of Unix/Linux system, file systems, shell scripting
  • Experience with design and implementation of ETL/ELT framework for complex warehouses/marts
  • Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
  • Ability to work in team in diverse/ multiple stakeholder environment
  • Experience in Cards and Payments domain.
  • Experience and desire to work in a Global delivery environment.
  • Hands on working exp in understanding business requirements, business rules and data requirements from Data modeling perspective.
  • Analyze the requirements; construct the conceptual/logical model to support the requirements.
  • Experience in meta data practices, standards and procedures.
  • Experience in creating high-level data flow diagram.
  • Hands on exp with conceptual, logical, & physical model development.
  • Generate the DDLs and deploy them in the respective environments.
  • Publish database change log, data model diagram and data dictionary reports to project team.
  • Guide and support developers while they are developing against the development database.
  • Support developers and QS resources while they are performing tests against the QA environment.
  • Review actual table usage against physical data models to insure compliance with established standards, policies, and performance guidelines..

Qualifications

  • Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
  • Minimum of 7 years of work experience in the Information Technology Field.
  • At least 7 years of experience with DW/BI and related tools, Data modelling, Data Architect..

Additional Information

** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Note:-

  1. This is a Full-Time Permanent job opportunity for you.
  2. Only US Citizen, Green Card Holder, TN Visa, GC-EADH4-EAD & L2-EAD can apply.
  3. No OPT-EAD & H1B Consultants please.
  4. Please mention your Visa Status in your email or resume.

Skills Required

  • At least 7 years of experience in DW/BI related technologies and tools
  • At least 6 years of experience in Design and Architecture review
  • At least 6 years of experience in Data Modelling/Data Architect
  • Architecting BI solutions in consultation with architecture group/IT team/users
  • Collaborating with enterprise architects to define BI best practices/guidelines
  • Interacting with business users to understand and document requirements
  • Understanding of Unix/Linux system, file systems, shell scripting
  • Experience with design and implementation of ETL/ELT framework for complex warehouses/marts
  • Hands-on development mentality with willingness to troubleshoot complex problems
  • Ability to work in a team with diverse/multiple stakeholders
  • Experience in Cards and Payments domain
  • Experience and desire to work in a Global delivery environment
  • Hands on experience understanding business requirements, business rules and data requirements from Data modeling perspective
  • Construct conceptual/logical model to support requirements
  • Experience in metadata practices, standards and procedures
  • Experience creating high-level data flow diagrams
  • Hands on experience with conceptual, logical, & physical model development
  • Generate DDLs and deploy them in respective environments
  • Publish database change log, data model diagram and data dictionary reports
  • Guide and support developers during development and QA testing
  • Review actual table usage against physical data models for standards, policies, and performance
  • Bachelor's degree or foreign equivalent required (or three years progressive experience per year of education)
  • Minimum of 7 years of work experience in the Information Technology Field
  • Authorized to work in the U.S. (US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD, L2-EAD). No sponsorship available.
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

SonSoft Inc. Logo SonSoft Inc.

Architect

Information Technology • Professional Services • Software • Consulting
In-Office
Minneapolis, MN, USA
87 Employees

MetLife Logo MetLife

Account Executive

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
50K-50K Annually

MetLife Logo MetLife

Customer Care Advocate - Virtual 8.3.26 - 18516

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
42K-42K Annually

MetLife Logo MetLife

Financial Director

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
110K-150K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account