Develop database designs and architecture in Azure, secure data migrations, and conduct data profiling while collaborating with teams on technical designs.
- 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
Top Skills
Azure Data Factory
Azure Data Lake Storage
Azure Data Warehouse
Azure Synapse
Informatica Powercenter
Pl/Sql
SQL
SQL Server
Tsql
Similar Jobs
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Design, build, and maintain scalable data architectures and ETL/ELT pipelines on cloud platforms (Azure). Ensure data quality, security, compliance, and support AI/ML workflows while leading projects and mentoring junior engineers.
Top Skills:
Pyspark,Scala,Apache Spark,Hive,Hadoop,Nosql,Sql,Postgresql,Mysql,Azure,Ci/Cd,Devops,Mlops,Etl,Elt,Data Warehousing,Paas,Python
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Develop and maintain ETL pipelines (ADF) to load claims into the Medicaid reporting system, resolve data quality issues, optimize performance, create and monitor automated data shares and file extracts, and work with state partners on business-driven extracts.
Top Skills:
Azure Data Factory,Snowflake,Oracle Pl/Sql,Sql Server T-Sql,Powershell,Python,Json,Xml,Fixed-Width,Delimited,Etl
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Design and optimize database architectures and data models; build, automate, and maintain ETL/ELT pipelines and large-scale data platforms on Azure; ensure data quality, security, and compliance; collaborate with data scientists to deliver AI/ML solutions; lead projects, mentor junior engineers, and manage vendor and stakeholder relationships.
Top Skills:
Sql,Postgres,Mysql,Azure,Ci/Cd,Devops,Mlops,Etl,Elt,Pyspark,Scala Spark,Hive,Hadoop,Nosql,Python,Scala,Data Warehousing,Paas
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
