Senior Data Warehouse Engineer POST NUMBER: 458201
Key Responsibilities:
- Design, develop and maintain robust and scalable data warehouse solutions in the Microsoft Azure platform.
- Create, optimize and manage ETL/ELT data pipelines using ADF to ingest data from diverse sources, to include on-premises, cloud and API sources in multiple formats.
- Maintain and deploy SSIS packages that handle data integration and transformation, including migrating existing on-premises SSIS packages to Azure.
- Design and create tables, views, queries, stored procedures for optimized performance, ensuring data integrity and security.
- Rewrite Legacy SSIS packages using ADF and Fabric services.
- Leverage Azure Synapse Analytics for data storage, processing and serving. This includes building and managing dedicated SQL pools, serverless SQL and Spark pools.
- Design and implement data models (e.g. star schema, snowflake schema) that are optimized for performance and reporting.
- Ensure data quality, integrity and security by implementing validation rules and quality checks, as well as access controls within the data pipelines and data warehouse.
- Monitor, troubleshoot and tune data loads and query performance to ensure the efficiency and reliability of the DW environment.
- Work with CI/CD pipelines and version control (e.g., Azure DevOps, Git) for continuous integration and automated deployment of data solutions.
- Document data warehouse architecture, ETL processes, and data models to maintain a clear and up-to-date knowledge base.
- Monitor Azure resources and implement logging, alerting, and incident response mechanisms.
- Stay updated with emerging technologies and trends to continuously improve data architecture, engineering and analytics capabilities.
- Collaborate with cross-functional teams (DevOps, Security, Networking, Applications) to ensure smooth cloud transitions.
- Adhere to established database standards.
- Ensure compliance with corporate and industry security policies.
Required Qualifications:
- Bachelor’s or Master’s degree in Computer Science, Information Technology or related field
- 7 years of hands-on experience in data modeling/data warehouse design.
- 5 years of experience with Microsoft Azure, including deployments, administration, and migrations.
- SSIS Expertise: Proven hands-on experience designing, developing, and deploying SSIS packages in a Microsoft SQL Server environment.
- Azure Data Factory (ADF): Extensive experience building and managing complex data pipelines in ADF, including linked services, datasets, activities, and triggers.
- Azure Synapse Analytics: Strong experience with Azure Synapse for data warehousing, including serverless and dedicated SQL pools.
- T-SQL: Advanced proficiency in T-SQL for querying, stored procedures, functions, and performance optimization.
- Data Modeling: Expertise in dimensional modeling, schema design (star), and creating fact and dimension tables.
- Cloud Services: Strong understanding of the Azure data ecosystem, including services like Azure Data Lake Storage (ADLS), Azure SQL Database, and Azure Logic Apps.
- Problem-Solving: Excellent analytical and problem-solving skills with the ability to troubleshoot complex data issues.
Preferred Qualifications:
- Industry certifications related to Microsoft Azure Data and Data Engineering.
- Experience with scripting languages like Python.
- Experience with other Azure data services, such as Azure Databricks or Power BI.
Soft Skills:
- Strong analytical and problem-solving skills.
- Excellent communication & interpersonal skills.
- Ability to manage multiple projects & stakeholders
- Team player
Vaco by Highspring values a diverse workplace and strongly encourages women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply.
EEO Notice
Vaco by Highspring is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.
Vaco by Highspring and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals. As part of this commitment, Vaco by Highspring and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact HR@vaco.com .
Vaco by Highspring also wants all applicants to know their rights that workplace discrimination is illegal.
By submitting to this position, you agree that you will be giving Vaco by Highspring the exclusive right to present your as a candidate for the foregoing employment opportunity. You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications. You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco by Highspring about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application. In exchange, Vaco by Highspring agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.
Privacy Notice
Vaco by Highspring and its parents, affiliates, and subsidiaries (“we,” “our,” or “Vaco by Highspring”) respects your privacy and are committed to providing transparent notice of our policies.
- California residents may access Vaco by Highspring HR Notice at Collection for California Applicants and Employees here.
- Virginia residents may access our state specific policies here.
- Residents of all other states may access our policies here.
- Canadian residents may access our policies in English here and in French here.
- Residents of countries governed by GDPR may access our policies here.
Pay Transparency Notice
Determining compensation for this role (and others) at Vaco by Highspring depends upon a wide array of factors including but not limited to:
- the individual’s skill sets, experience and training;
- licensure and certification requirements;
- office location and other geographic considerations;
- other business and organizational needs.
With that said, as required by local law, Vaco by Highspring believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure. The individual may also be eligible for discretionary bonuses.