System Engineer II

Deltek, Inc; Makati; On-site; PHP 900,000 - 1,300,000; Full time

Job summary

Deltek, Inc is seeking a skilled BI/EDW specialist to support end-to-end analytics architecture. You will develop and optimize Power BI dashboards and Cognos reports, translate business requirements into scalable data warehouse solutions, and maintain Snowflake models and ELT pipelines.

The role requires strong analytical skills, hands-on experience with Power BI, Cognos, Snowflake, and SQL, and the ability to work across deployment pipelines in a dynamic environment.

Qualifications

• Strong analytical, problem-solving and troubleshooting skills.
• Experience with Dimensional Data Models, ideally Kimball’s Data Warehouse Lifecycle.
• Advanced experience with Power BI, including DAX measures, calculated columns, and optimization of complex semantic models.
• Hands-on experience with Power Query for data extraction, transformation, cleansing, and shaping from multiple enterprise data sources.
• Experience implementing Power BI Row-Level Security (RLS) and role-based access controls.

Responsibilities

• Develop a strong understanding of current end to end BI/EDW architecture to support deployed solutions.
• Gather data and analytics requirements from business partners and identify architectural solutions.
• Translate business requirements into technical qualifications and data warehouse solutions.
• Develop, design, test, and modify Power BI dashboards, Cognos reports, and SQL to support critical business needs.
• Ensure BI solutions adhere to best practices and remain consistent across data flows and architectures.
• Create or oversee technical documentation throughout project lifecycle.
• Design, develop, and maintain Snowflake data models, schemas, views, and procedures for scalable reporting.
• Build and optimize Snowflake data pipelines and ELT processes with performance tuning and security.
• Under Team Lead guidance, monitor intake items through the IT help desk and close assigned tickets.

Skills

Power BI

SQL

Data modeling

Dimensional modeling

DAX

RLS

Education

Bachelor’s degree in Computer Science/Information Technology or related field

Tools

Snowflake

Cognos Analytics

Power Query

Azure

AWS

SQL Server

Job description

As the recognized global standard for project-based businesses, Deltek delivers software and information solutions to help organizations achieve their purpose. Our market leadership stems from the work of our diverse employees who are united by a passion for learning, growing and making a difference. At Deltek, we take immense pride in creating a balanced, values-driven environment, where every employee feels included and empowered to do their best work. Our employees put our core values into action daily, creating a one-of-a-kind culture that has been recognized globally. Thanks to our incredible team, Deltek has been named one of America's Best Midsize Employers by Forbes, a Best Place to Work by Glassdoor, a Top Workplace by The Washington Post and a Best Place to Work in Asia by World HRD Congress. www.deltek.com

Position Responsibilities

• Develop a strong understanding of current end to end BI/EDW architecture to support deployed solutions

• Gather data and analytics requirements from business partners, application team and other solution/domain architects and identify the appropriate architectural solutions.

• Work with internal business analysts to understand business requirements and translate technical qualifications and data warehouse solutions

• Develop, design, test, and modify Power BI dashboards, Cognos reports, and SQL to support critical business needs

• Ensure that Power BI dashboards, Cognos reports, and all BI solutions adhere to best practices, standards, guidelines and maintain consistency across all data flows, data mappings and technical architecture. Develop and promote data architecture standards, guidelines, procedures and repeatable and scalable frameworks. Contribute to advancing data and analytics architectures and design guidelines.

• Create or oversee technical documentation as required throughout project lifecycle

• Design, develop, and maintain Snowflake data models, schemas, views, and stored procedures to support scalable reporting and analytics solutions.

• Build and optimize Snowflake data pipelines and ELT processes, including performance tuning, workload management, data security, and support for semi-structured data.

• Under Team Lead’s guidance, use internal IT help desk ticketing system to monitor intake items, prioritize, work on, and close out assigned support tickets

Qualifications

• Strong analytical, problem-solving and troubleshooting skills

• Experience working with Dimensional Data Models, ideally Kimball’s Data Warehouse Lifecycle

• Advanced experience with Power BI, including DAX measures, calculated columns, calculated tables, and optimization of complex semantic models for reporting and analytics.

• Strong hands-on experience with Power Query for data extraction, transformation, cleansing, and shaping from multiple enterprise data sources.

• Experience implementing Power BI Row-Level Security (RLS), secure dataset design, and role-based access controls to support governed data access.

• Experience using Power BI Deployment Pipelines and release management best practices to promote content across development, test, and production environments.

• Knowledge of Power BI service administration, workspace governance, gateway connectivity, refresh strategies, and report performance tuning.

• Hands-on experience developing and maintaining Cognos Analytics reports, dashboards, drill-through reports, prompts, and scheduled report distributions.

• Experience with Cognos Framework Manager, data modules, and relational or dimensional modeling to support reusable, scalable enterprise reporting solutions.

• Knowledge of Cognos security, report bursting, scheduling, package deployment, and promotion across development, test, and production environments.

• Strong skills in Cognos report performance tuning, troubleshooting data discrepancies, SQL-based validation, and production support for enterprise BI reporting.

• Hands-on experience with Snowflake architecture, including virtual warehouses, micro-partitioning, query performance tuning, and cost optimization.

• Experience building ELT pipelines in Snowflake using advanced SQL, data modeling, and ingestion of structured and semi-structured data.

• Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

• Self-starter with ability to work independently

• Ability to quickly learn new products and technologies

• Bachelor’s degree in Computer Science, Information Technology, or related technical field.

• Highly proficient in written and spoken English

• Experience in all phases of the Software Development Lifecycle is a plus

• Willing to work on a mid-shift schedule

• Ideally the candidate will have working knowledge of other databases or data warehouse tools, such as Snowflake, SQL server, Azure and AWS.

Applicant Privacy Notice

Deltek is committed to the protection and promotion of your privacy. In connection with your application for employment with us at Deltek, it is necessary for us to collect, store and use information about you ("Personal Data") to administer and evaluate your application. We are the "controller" of the Personal Data you provide us and will process any such Personal Data in accordance with applicable law and the statements contained in this Candidate Privacy Notice. Additionally, we have not sold and do not sell Personal Data you provide to us through the job application process.

Important: Protect Yourself from Recruitment Scams

Bad actors or scammers may try to impersonate Deltek and send fake job offers to people. Messages from Deltek about employment opportunities will be from an @deltek.com account or [e-mail], never from free services like Gmail or Yahoo. Please look carefully at the email address that provides any job offer, as some fake accounts are created to look like a legitimate domain name or email address. We will also never ask you to pay money at any point in the hiring process, whether for training, equipment, background checks, or anything else. If you receive a suspicious offer claiming to be from Deltek, do not share personal or financial information. Report any suspicious communication to [e-mail] and consider reporting it to law enforcement.