Data Engineer

Job Title: Data Engineer

Location: Portland, Oregon - Onsite

Position Type: Direct Hire- Full Time

Compensation: $100-110k Annual Salary

Reports to: CIO

C2C & third party vendors not accepted at this time - MUST currently reside within 30 miles of Portland, OR (relocation is not considered at this time)

Ledgent Technology has once again partnered with an amazing client of ours to fill their open Data Engineer position. If you are interested in joining a fast paced and growing organization, this opportunity is for you!

Overview:

We are seeking a skilled and detail-oriented Data Engineer to join our client's dynamic team in Portland, Oregon. This role involves working with hybrid database environments, optimizing in-house databases, and migrating them to Azure-hosted services. You will collaborate closely with application specialists and senior engineers while reporting directly to the CIO. If you are passionate about database optimization, cloud technologies, and modern data engineering practices, we want to hear from you!

Key Responsibilities:

· Design, optimize, and maintain in-house databases, with a focus on MS-SQL.

· Port and optimize existing databases to Azure-hosted services.

· Utilize Azure Data Factory, Azure Fabric, and other tools to enhance data processes.

· Develop and maintain ETL pipelines; experience with Boomi is a plus.

· Write and optimize complex SQL queries; proficiency in Python is a bonus.

· Collaborate with application specialists and senior engineers to meet data infrastructure needs.

· Ensure database performance, security, and scalability in a hybrid cloud environment.

Required Skills and Qualifications:

· Database Platforms: Extensive experience with MS-SQL is required; exposure to Oracle is a plus.

· Cloud Expertise: Proficiency in Azure-hosted database services is a must.

· Programming Languages: Expert-level proficiency in SQL; Python experience would be great to have.

· ETL Tools: Hands-on experience with Boomi or similar tools is beneficial. Familiarity with Azure Fabric and Data Factory is highly desirable.

· Primary Responsibilities: focus on database design, optimization, maintenance, porting, and optimizing in-house databases to Azure is a key part of the position.

· Ability to troubleshoot and resolve complex database performance issues.

· Experience working in a collaborative, cross-functional team environment.

Why Join Us?

· Be part of a growing, innovative team dedicated to leveraging modern cloud technologies.

· Work in a hybrid environment offering flexibility and opportunities for professional growth.

· Collaborate with passionate professionals in an engaging and supportive workplace.

If you are ready to take on this exciting opportunity as a Data Engineer and contribute to our mission of optimizing data systems, we encourage you to apply!

We look forward to learning more about how your expertise can drive success in this role!

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county, to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.