Bitful Consulting

2 jobs near Columbus, OH

Data Engineer

$117K - $140K/yr

Provides technical database consultation on application development, global infrastructure, and other database administration efforts related to specific DBMS * Conduct data profiling, cataloging ...

Data Architect

$65.25 - $84/hr

* Your team will develop datasets that enable data visualization, machine learning and data driven decision making across client product line * Working with structured and unstructured datasets and ...

$117K - $140K/yr

Full-time

Medical, Life, Retirement

Posted 29 days ago


Job description

  • Work in an Azure data warehouse environment, which includes developing database designs and architecture, data modeling and metadata repository creation
  • Work with Architects, Technical Leads and Business Teams and contributes to the development of technical designs
  • Secure data migrations & transformations to/from clients, customers, and vendors
  • Provides technical database consultation on application development, global infrastructure, and other database administration efforts related to specific DBMS
  • Conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows
  • Migrate current ETL and SSIS packages to Synapse

Requirements
    • 2-3+ Years of proven experience performing large data migration and transformation efforts
    • Strong hands-on experience with Microsoft Azure Data & Analytics including Azure Synapse, Azure Data Factory, & Azure Data Lake Storage
    • Experience in writing complex SQL queries and creating data models
    • Experience or exposure to TSQL, SQL server, PL/SQL
    • Experience or exposure to Informatica PowerCenter, Star Schema, Snowflake Schema
    • Database performance tuning
    • Data warehouse and data mart experience
    • Strong knowledge of various data structures and the ability to extract data from various data sources (such as Cognos, Informatica, Hyperion, etc.)

Benefits
  • Education Assistance/Student Loan Repayment - up to $2400 annually
  • Remote work allowance
  • Internet reimbursement
  • Bench pay
  • Profit share
  • Healthcare reimbursement
  • 401k - 4% match
  • Short-Term disability
  • Long-Term disability
  • Life Insurance