Are you ready to make an impact with data and automation? Join Otak's innovative IT team as a Microsoft Data & Automation Engineer and help transform how we work! In this role, you’ll be at the forefront of driving our digital transformation efforts. You’ll design and implement innovative data pipelines and reporting solutions that support business intelligence, automation and digital transformation initiatives across the organization.

Your focus will be to integrate critical business systems (Deltek, ADP, Azure, Microsoft 365) into a secure, scalable environment, while ensuring data quality, security and accessibility. If you’re someone who thrives on solving complex problems, optimizing data flow, and creating seamless automation solutions, this is the opportunity for you!

This position is located in our Portland, OR office.

What you’ll do:

Data Integration & ETL

• Develop and maintain ETL pipelines to extract, transform, and load data from Deltek, ADP, and other sources into Azure SQL databases.
• Leverage Azure Data Factory, Power Automate, and other tools to streamline data movement and integration.
• Ensure best practices for data security, governance, and compliance.

Database Management & Development

• Design and maintain Azure SQL databases for reporting and automation.
• Optimize queries and indexing for performance.

Business Intelligence & Reporting

• Develop Power BI dashboards and reports for business insights.
• Integrate Power BI with Azure SQL, ADP, and Deltek for real-time analytics.

Automation & Digital Transformation

• Develop and implement automation solutions using Power Automate, including data workflows, approvals, and Active Directory updates.
• Design, build, and support Power Apps solutions that integrate with Azure databases and other Microsoft systems.
• Assist with the development of a vendor portal syncing with Deltek.
• Ensure automation solutions follow best practices for security, scalability, and efficiency.

What you bring:

• Bachelor’s degree in Computer Science, Information Systems or an equivalent combination of education, certifications and experience may be considered.
• 3+ years of experience in data integration, ETL development, or database administration.
• Experience with Microsoft Power Platform (Power BI, Power Apps, Power Automate, SharePoint) and Azure Storage.
• Strong SQL skills, including stored procedures and query optimization and managing databases.
• Experience with Azure services (Data Factory, SQL Database, Logic Apps, Synapse Analytics is a plus).
• Proficiency in Power BI, Power Apps, and Power Automate.
• Knowledge of security best practices for data management and cloud infrastructure.
• Familiarity with Active Directory, Deltek, and ADP integration is a plus.
• Experience in the AEC industry or professional services firms preferred.

Salaries are based upon candidate experience, qualifications, and work location as well as market and business considerations.

Benefits

At our core, we believe that supporting our communities begins with supporting our employees. No matter what stage you’re at in your career, we have a comprehensive total rewards program to enhance your quality of life, help support your family, and assist you in achieving your personal and professional goals. Otak employees enjoy competitive salaries; discretionary performance bonuses; no-cost medical, dental, vision, life and disability insurance, HRA/HSA; a 401(k)-retirement match that is 100% vested immediately; a hybrid work schedule; Paid Time Off (PTO) accrual based on your industry experience rather than your seniority plus 9 paid holidays per year; a commuter allowance (based on your office location); support for your professional registration and/or certification fees; and much more! If you are out of the area and interested in relocating for this opportunity, relocation assistance may be provided.

Why work at Otak?

We’re not just looking for skills and experience, having shared values is just as important! When you work at Otak, you aren’t just joining a firm — you’re joining a community. We believe our best work happens in a culture of collaboration and inclusion, where the expertise of diverse individuals can thrive in a foundation of teamwork. The work environment we create is built on a simple concept: working on interesting projects with interesting people. However, we don’t just believe in cultivating our own community; we’re also committed to enriching the communities around us with smart, creative solutions. We know our employees make an investment in us, so we’re committed to making an investment in them. Seasoned experts and young professionals work together to encourage personal growth and skill development at all experience levels. Plus, we’re expanding — and we’re dedicated to developing an internal infrastructure with the strength and talent to support that growth.

Equal Opportunity

Otak is proud to be an equal opportunity employer committed to fostering an inclusive, equitable, and respectful workplace. We value diverse perspectives and believe they drive innovation and success.

We are committed to a workplace free from discrimination and harassment, where every individual is valued, included, and treated with dignity and respect. We do not discriminate based on race, color, religion, sex (including pregnancy, childbirth, or related conditions), sexual orientation, gender identity, national origin, age, disability, veteran status, or any other protected status under applicable laws. Our hiring, promotion, compensation, and employment practices are rooted in qualifications, merit, and business needs.

Our Vision for an Inclusive Workplace

We are committed to creating an environment where:

• Diverse identities are embraced, and differences are valued as a source of strength.
• Every employee feels safe to be their authentic self and contribute meaningfully.
• Unique perspectives are encouraged, and open dialogue is welcomed to foster innovation.
• Curiosity replaces judgment, and respectful engagement is prioritized in all interactions.
• Relationships are built on mutual trust, dignity, and respect, forming the foundation of our workplace culture.

We provide reasonable accommodations for individuals with disabilities, including pregnant employees, to ensure an accessible and supportive work environment. If you require assistance or accommodations during the application process or in the workplace, please contact Otak’s People Services Department at GRPHumanResources@Otak.com.

Join us in shaping a more inclusive future!