The Data Engineer will develop and architect data solutions in Azure, manage data migrations, and consult on database administration while collaborating with various teams.
- 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
- 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.)
- 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 Synapse
Informatica Powercenter
Pl/Sql
SQL
Tsql
Similar Jobs
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Lead Atlassian's Data Engineering Team in building scalable data solutions, ensuring operational data quality, architecting data systems, and mentoring engineers.
Top Skills:
AirflowAWSDatabricksFlinkHiveKafkaRedshiftSparkSQL
Big Data • Fitness • Healthtech • Software • Analytics • Energy
As a Data Engineer at Arcadia, you will design and develop data pipelines, support data integrations, and contribute to team processes while working within a Scrum setup.
Top Skills:
Cloud ArchitectureNoSQLSparkSQL
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
As a Data Engineer at Atlassian, you'll design data models, build scalable pipelines, and improve data quality by collaborating with various teams. Your role involves leading data projects, employing modern practices, and utilizing a range of data processing tools.
Top Skills:
AirflowApache FlinkApache HiveApache KafkaAws AthenaAws EmrAws RedshiftJavaPythonSparkSQL
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
