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
- 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
Bitful is a new kind of technology consulting firm: One that puts humans first.
Together, we build future-proof, open, explorable data systems and perform cloud-computing marvels. We profoundly solve app challenges, and engineer game-changing digital products. And we do all of the above to create and fund opportunities for underserved communities who deserve to be every bit as supported, connected, and inspired as we are at Bitful.
Better tech for the greater good: That’s Bitful.
Bitful is a new kind of technology consulting firm: One that puts humans first.
Together, we build future-proof, open, explorable data systems and perform cloud-computing marvels. We profoundly solve app challenges, and engineer game-changing digital products. And we do all of the above to create and fund opportunities for underserved communities who deserve to be every bit as supported, connected, and inspired as we are at Bitful.
Better tech for the greater good: That’s Bitful.
