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
Similar Jobs
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Design, develop, test, and maintain large-scale healthcare data pipelines and AWS data warehouse solutions. Build Redshift and EMR ETL processes, monitor pipeline performance, resolve data discrepancies, support deployments, conduct code reviews, and document database designs and testing. Collaborate with engineers, analysts, consultants, and cross-functional teams to improve data quality, scalability, and processing efficiency.
Top Skills:
Amazon EmrAmazon RedshiftAmazon S3Automated Testing FrameworksAWSCi/CdETLOraclePythonSQLSQL Server
Financial Services
Build and operate scalable Databricks-on-AWS data pipelines using PySpark, Delta Lake, and lakehouse patterns. Optimize performance, implement data quality, monitoring, alerting, and automated remediation, and deliver curated datasets for BI and analytics partners. Collaborate with stakeholders on architecture and design while applying secure software engineering, CI/CD, agile, and operational stability practices. The role also uses AI-assisted development tools and supports workforce data analytics.
Top Skills:
AlteryxAmazon AthenaAmazon EmrAmazon S3Apache AirflowApache IcebergSparkAutosysAWSAws CloudwatchAws GlueAws LambdaBitbucketClaudeDatabricksDatabricks WorkflowsDelta LakeDelta Live TablesGitGithub CopilotJavaJenkinsOracleParquetPysparkPythonScalaSigmaSpinnakerSQLTableau
Artificial Intelligence • Information Technology • Professional Services • Software • Analytics • Generative AI • Big Data Analytics
Lead enterprise-scale Akeneo PIM implementations, including solution architecture, platform configuration, data architecture, API development, and third-party integrations. Collaborate with developers, architects, clients, and stakeholders to deliver digital transformation projects. Ensure data privacy, security, and lifecycle protection while documenting technical solutions, gathering requirements, managing expectations, and mentoring junior team members.
Top Skills:
Adobe CommerceAkeneo PimAmazon DynamodbAws AppsyncAws LambdaCcpaDamGdprGraphQLMagentoMdmPimRest ApisShopify
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
