Back icon

Senior Data Modeler for a Financial Technology Company

Senior Data Modeler for a Financial Technology Company 40 hrs/week, 12+ months

We are currently looking for a remote Senior Data Modeler with 3+ years of experience in Data Integration DB and ETL to join our team.

The customer is a financial technology company founded in 2006 based in Atlanta, Georgia. The company provides technology to banks and merchants to make loans to consumers for home improvement, solar, healthcare, and other purposes.

The project is focused on the migration of DWH from MSSQL Server to Snowflake.

Responsibilities

  • DWH and DataMarts modeling
    • Collect data requirements from business and technical users
      • Develop ELT process to populate new DataMart
        • Improve existing DWH and DataMart design
          • Identify transformation logic from SQL Server stored procedures and be able to reproduce it in Snowflake
            • Report requirements collection and analysis
              • Reproduce reports in the new DataMart
                • Change the DataMart model to correspond new reports requirements
                  • Merge report requirements from different teams to be able to build a common report

                    Requirements

                    • 3+ years of experience in Data Integration DB and ETL
                      • Data Modeling and Database Design for columnar DB (Snowflake is preferable) skills
                        • Experience in reports design and development
                          • Advanced SQL knowledge
                            • ETL/ELT Understanding
                              • Must be able to make and explain design choices to the customer and make recommendations
                                • Able to understand customer’s business needs and see few steps ahead

                                  Benefits in eligible locations

                                  location.svg
                                  ImageImage

                                  For you

                                  • Prepaid Medicine with Colsanitas for you and your legal dependents 
                                  • MetLife Life Insurance for you 
                                  • Thousands of projects for top brands
                                  • Stable income
                                  ImageImage

                                  For your comfortable work

                                  • 100% remote work forever
                                  • Free licensed software
                                  • Possibility to work on your own device (BYOD)
                                  • Stable workload
                                  • Relocation opportunities
                                  • Flexible engagement models
                                  ImageImage

                                  For your growth

                                  • Free trainings for technical and soft skills
                                  • Free access to LinkedIn Learning platform
                                  • Support from a personal Skill Advisor
                                  • Language courses
                                  • Free access to internal and external e-Libraries
                                  • Access to internal communities and competency centers
                                  • Certification opportunities

                                  40 hrs/week

                                  Hours per week

                                  12+ months

                                  Project length

                                  Colombia

                                  Locations eligible for the position