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
.png){kind=logo}
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
The Principal Data Engineer develops and maintains advertising technology, architecting backend services using microservices and cloud technologies, integrating AI capabilities, and guiding the team in best practices.
Top Skills:
SparkAWSDockerFlinkJavaKafkaKinesisNoSQLPythonRest ApiScalaSQL
AdTech • Automotive • Big Data • Consumer Web
As a Data Engineer at Edmunds, you will architect and maintain data platforms for analytics and AI/ML, ensuring scalable, reliable data processing and supporting cross-functional collaboration.
Top Skills:
AirflowAWSDatabricksPythonScalaSparkSQL
.png)
Artificial Intelligence • Fintech • Information Technology • Machine Learning • Financial Services
The Data Engineer will design and build scalable data systems, contribute to the architecture of the data platform, and collaborate with AI/ML engineers to enhance automation and intelligence in Canoe's systems.
Top Skills:
AirflowAWSDbtKafkaPostgresRedshiftSnowflakeSQL
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
