Apexon is a digital-first technology services firm backed by Goldman Sachs Asset Management and Everstone Capital.

Data Modeler at Apexon (Remote)

+2 more | Remote
Sorry, this job was removed at 7:18 a.m. (CST) on Tuesday, June 21, 2022
Find out who’s hiring remotely Nationwide
See all Remote jobs Nationwide
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
We are looking for Data Modeler.

This role is responsible for building Relational and Dimensional Models for Integration Layer, Semantic Layer & Audit Layer. (proficiency in Kimball). Design and Build Conceptual, Logical, Physical Data Models and Create Physical Data Structures (DDLs). Create Source to Target Data Mapping rules with the business transformation rules by discussing with business users. Extensive experience in Solution design, Data architecture, Data modeling, Data integration and Business Analytics design and development.


  • Build RelationalandDimensionalModels for Integration Layer, Semantic Layer & Audit Layer. (proficiency in Kimball) 
  • Building Industry based Reference Data Models for Large Banks 
  • Design and BuildConceptual, Logical, Physical Data Modelsand Create Physical Data Structures (DDLs). 
  • CreateSource to Target Data Mappingrules with the business transformation rules by discussing with business users. 
  • Extensive experience in managing cross functional teams, leading the development, gathering Business Requirements, Analysis, Design, and Implementations of various functionalities of Data Warehouse, Business Intelligence, ERP applications and Big Data- Hadoop Solutions. 
  • Expert in Agile Data Warehouse, Enterprise Architecture using Industry model Framework Methodology, Data Modeling using E/R and Dimension Models, Conceptual, Logical and Physical Models for large scale DW and DL implementations. 
  • Expertise in the design of the Conceptual, Subject area Logical and Physical Data Models using Erwin and/or ER Studio Suite. 
  • Experience in Data model design frameworks and techniques pioneered by Ralph Kimball and Bill Inman. 
  • Experience in Industry Financial or/and Insurance Data Models: Teradata FSLDM and IBM BDW data Model Frame works and Insurance ACORD framework and capability models. 
  • Experience in Master Data management, Metadata Management solutions and Data Governess Policies and Procedures. 
  • Worked on Big data projects involved Hadoop technologies and Data Lake reference architecture and Frameworks. 
  • Optional - Worked on Cassandra Data Modeling, NoSQL Architecture, policies, and procedures. 
  • Experience in understanding the Business requirements and translating them into detailed design along with Technical specifications. 
  • A plus - Exposure to software engineering techniques like Micro services, Event Driven Architecture, using event streaming technologies like Kafka. 
  • Worked closely with cross functional teams to effectively co-ordinate, manage Business user expectations and adhere to organizational architectural standards and policies. 
  • Experience in Data Lake framework, Data Ingestion and Processing – Analyze various sources and develop the code to ingest the data into Hadoop Data Lake. 
  • Good experience in Big Data –Hadoop solution implementation for Operational Reporting and Analytics using HIVE, SPARK & SPARK SQL, Sqoop and other Hadoop eco system projects. 
  • Good exposer and experience on Cloud based data stores- AWS Cloud on Big data specialty – Redshift, S3 etc. 
  • Expert in Agile software development and release management using Scrum Process. Hands on Experience with Agile software development Tools such as JIRA. 
  • Manage stakeholder expectations with continuous engagement through status reports, proactive communication on new opportunities and issues. 
  • Design solution architecture, conducts analysis and development of applications and proof of concepts 
  • Acts as subject matter expert related to the effective use of analytical or BI methodologies, particularly those related to decision tree, time series data, forecasting, or data visualization and dashboard design. 
  • Build different design patterns, data architecture, Cloud technology stack (AWS/Azure) 
  • Continuous learning and keep track of the latest developments in business/ technical advancements 
  • Demonstrate the compassion to lead and bring value to the architecture portfolio 


  • 12 + years IT experience, with focus on Data Modeling, Data solutioning 
  • Deep functional Knowledge in Retail Banking a key requirement 
  • Experience working with Industry Reference Data Models primarily financial data models 
  • 8+ years’ experience with SQL (ability to read/write/manipulate queries) 
  • 8+ years of strong solution architecture experience in variety of IT positions. Recent 5+ years of experience must be on solution/systems/ enterprise architecture with large scale complex IT systems 
  • 5+ years’ experience working in an Agile/Scrum environment 
  • Experience and knowledge in handling Fortune 500 companies.
  • Warehouse architectures including ETL design, staging, transformations 
  • Star-schemas, cubes, dimensional modeling 
  • Database platform layouts and configurations 
  • Demonstrated ability to work in a fast-paced, highly technical environment 
  • Excellent communications skills, both written and verbal 
  • Troubleshooting complex system issues, handle multiple tasks simultaneously and translate user requirements into technical specifications 
  • Excellent written and verbal communication skills. 
  • Conduct current state assessment and map opportunities and organizational goals to target state architecture and roadmap. 
  • Working creatively and analytically in a problem-solving and fast-paced agile development environment. 
  • Experience in knowledge of MapReduce, HBase, Pig, MongoDB, Cassandra, Impala, Oozie, Mahout, Flume, Zookeeper/Sqoop and Hive 
  • Strong database fundamentals including SQL, performance, and schema design. 


Preferred Qualification  

  • Background in Data Warehouse and Business Intelligence 
  • Strong understanding of programming languages like Java, Scala, or Python. 
  • 6+ years of strong ETL experience on either Information, Ab-Initio, Talend, DataStage, Syncsort. 
  • Designing and implementing Data security and privacy controls. 
  • Experience with version control tools like Git, SVN 
  • 10+ years of experience building large scale data models using ERWIN or equivalent tool for larger and medium enterprise. 
  • Experience in Spark, Hive, Hadoop, Kafka, Columnar Databases. 
  • Experience in designing solutions for multiple large data warehouses with a good understanding of cluster and parallel architecture as well as high-scale or distributed RDBMS and/or knowledge on NoSQL platforms. 


Bachelor’s degree in Computer Science, Information Technology, or related field preferred but equivalent experience may be substituted
See More
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • C#Languages
    • C++Languages
    • dotnetLanguages
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PerlLanguages
    • PHPLanguages
    • PythonLanguages
    • RLanguages
    • ScalaLanguages
    • SqlLanguages
    • We are technology agnostic but these are a few of our languagesLanguages
    • D3JSLibraries
    • FluxLibraries
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • ReduxLibraries
    • Twitter BootstrapLibraries
    • Angular.JSFrameworks
    • ASP.NETFrameworks
    • Backbone.jsFrameworks
    • DjangoFrameworks
    • Ember.jsFrameworks
    • HadoopFrameworks
    • LaravelFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • TensorFlowFrameworks
    • CassandraDatabases
    • DB2Databases
    • HBaseDatabases
    • HiveDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • Neo4jDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • SAP HANADatabases
    • SnowflakeDatabases
    • TeradataDatabases
    • AWS (Amazon Web Services)Services
    • Google CloudServices
    • Google AnalyticsAnalytics
    • DrupalCMS
    • Joomla!CMS
    • WordpressCMS
    • SalesforceCRM

What are Apexon Perks + Benefits

Volunteer in local community
Partners with Nonprofits
Saggezza Inc. is partnered with the Chicago non-profit organization Lumity.
Friends outside of work
Eat lunch together
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Documented equal pay policy
Mean gender pay gap below 10%
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Mental Health Benefits
Retirement & Stock Options Benefits
401(K) Matching
5% of employee's yearly dollar contribution
Match charitable contributions
Child Care & Parental Leave Benefits
Child Care Benefits
Saggezza Inc. provides Subsidized child care.
Flexible Work Schedule
Saggezza provides employees with a flexible work schedule that includes Flexible start and end times.
Remote Work Program
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
PTO includes sick, personal, and vacation time
Paid Holidays
Paid Sick Days
Perks & Discounts
Commuter Benefits
Company Outings
Stocked Kitchen
Some Meals Provided
We provide free breakfast on Friday.
Happy Hours
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Time allotted for learning
Online course subscriptions available
Customized development tracks
Paid industry certifications

An Insider's view of Apexon

What are some social events your company does?

We are a hybrid company, but when we are in the office, we love to get together for after-work happy hours! We also enjoy throwing holiday parties and a summer bash when the weather is nice. This time really allows us to connect with each other outside of work.


Digital Marketing Specialist

How has your career grown since starting at the company?

I started here 4 years ago as an associate business analyst. I immersed myself in the culture and studied my mentors, who encouraged me to take on difficult projects. My career progressed to senior level, then project lead, and now a delivery and client success manager. The support system here has helped me quickly adapt and succeed in my career.


Senior Client Solutions Manager

How does the company support your career growth?

This company has provided me the ability to take charge of my career trajectory by affording me an opportunity to actively collaborate with team members about the projects to which I contribute. This has allowed me to continue growing in the latest technologies and to remain engaged in areas which I am passionate about.


UI Practice Lead

More Jobs at Apexon