Microsoft Data Automation Engineer
Microsoft Data Automation Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Are you ready to make an impact with data and automation Join Otaks innovative IT team as a Microsoft Data & Automation Engineer and help transform how we work! In this role youll be at the forefront of driving our digital transformation efforts. Youll 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 youre 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 youll 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 realtime 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:
- Bachelors 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 youre 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; nocost 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
Were not just looking for skills and experience having shared values is just as important! When you work at Otak you arent just joining a firm youre 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 dont just believe in cultivating our own community; were also committed to enriching the communities around us with smart creative solutions. We know our employees make an investment in us so were 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 were expanding and were 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 Otaks People Services Department at .
Join us in shaping a more inclusive future!
Employment Type
Full Time
