SQL Data Warehouse Engineer

SQL Data Warehouse Engineer

Category:

Information Technology

Employment Type:

Contract

Reference:

BH-383519

SQL Data Warehouse Consultant
6+ month contract (W2 ONLY - NO C-C)
Irving, TX (Hybrid)

Seeking an energetic and talented Data Warehouse Engineer in our Irving, TX Service Center to optimize and enhance the existing data cube solution for our Dynamics 365 Finance implementation. This position will work closely with the scrum team (including developers and business analysts), infrastructure team, DBAs, end users, and stakeholders to ensure reliable, high-quality solutions. This position will require occasional after-hours support during deployments and for critical issue resolution.

Responsibilities
Evaluate and enhance the performance of existing data warehouse solutions by applying techniques such as partitioning, indexing, and query optimization.
Identify bottlenecks and inefficiencies in current data systems and work on solutions to improve performance and scalability.
Design, develop, and maintain SSIS packages to process and integrate data efficiently.
Work with ETL processes, ensuring data flows smoothly through the system.
Leverage Microsoft Azure tools like Azure Synapse Analytics to enhance and manage data movement.
Work with Azure Data Factory for orchestrating data workflows and transformations.
Utilize Azure-based data lakes to ensure seamless integration with data warehousing solutions.
Work closely with cross-functional teams to understand business requirements and optimize data solutions.
Troubleshoot and resolve issues related to performance, data quality, and ETL pipelines.
Support production deployments or emergencies outside of normal business hours
Document existing data processes, optimizations, and any changes made to improve system performance.
Adhere to best practices for data warehousing, ETL development, and Azure solutions.
Advise on potential system changes and enhancements

Qualifications
Bachelor's degree in MIS, Computer Science, or a related field
5+ years of experience with data warehousing, including performance optimization techniques and processing data cubes through SSIS packages
Experience with SQL Server 2019, including writing stored procedures, indexes, query optimization, and execution plan analysis
Experience working with Microsoft Azure and data lakes
Proficiency in version control using Git, with a solid understanding of branching strategies
Experience using CI/CD tools such as Azure Pipelines to deploy database solutions
Familiarity with Azure Synapse Analytics and Dynamics 365 Finance and Operations preferred
Excellent oral and written communication skills to interact effectively with accountants/system users, team members, and stakeholders

Estimated Min Rate: $60.00
Estimated Max Rate: $65.00

Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.

Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Visit

to contact us if you are an individual with a disability and require accommodation in the application process.

For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.