Aprio PH

Work with a nationally ranked CPA and advisory firm that is passionate for what's next. Aprio has 30 U.S. office locations, one in the Philippines and more than 2,100 team members that speak 60+ languages across the globe. By bringing together proven expertise, deep understanding, and strategic foresight for fast-growing industries, Aprio ensures clients are prepared for wherever life or business may take them. Discover a top-rated culture, vast growth opportunities and your next big career move with Aprio. Join Aprio'sInformation Technology team and you will help clients maximize their opportunities. Aprio is a progressive, fast-growing firm looking for a Data Engineer, IT Data Services to join their dynamic team. The Data Engineer is responsible for designing and implementing scalable, reliable, and secure data solutions. This role involves developing data models, data flows, and data integration architectures to meet business requirements and align with best practices. The Data Engineer will create and manage data pipelines utilizing Azure Data Factory and other Azure services to integrate, transform, and load data efficiently. They will also design and implement data storage solutions using Microsoft Fabric, Profisee MDM software, Azure SQL, Azure Data Lake, and Azure Purview, optimizing data processing workflows for efficiency and scalability. Ensuring data quality through validation processes, monitoring data solutions for performance, and troubleshooting data-related issues are key aspects of this role. Additionally, the Data Engineer will collaborate with analysts and business stakeholders to understand data requirements, integrate data solutions with other systems, and provide documentation and training to team members and end-users. Position Responsibilities Data Architecture & StorageDesign scalable, secure, and high-performing data solutions aligned to business needs Create robust data models, flows, and storage using Microsoft Fabric and Azure SQL Manage master data with Profisee and integrate with existing systems Data Integration & TransformationBuild and manage data pipelines using Azure Data Factory and related tools Ingest data from APIs and external systems into the Azure ecosystem Implement ETL/ELT logic to prepare data for consumer use Testing, Monitoring & OptimizationEnsure data quality, consistency, and integrity across all stages Troubleshoot performance issues and fine-tune data pipelines Use Azure monitoring tools and Purview for data estate management Advanced Analytics & ReportingDevelop OLAP cubes and tabular models with SSAS Write complex MDX and DAX queries for data analysis Integrate data models with Power BI, Excel, and SSRS for reporting Collaboration & DocumentationWork closely with analysts, developers, and business leaders to translate needs into data-driven solutions Document architectures, processes, and provide support/training as needed Participate in Agile sprints and contribute to continuous improvement Qualifications MUST HAVE:Data solutions development using SQL, NoSQL, data warehouse and lakehouse concepts; Microsoft Fabric in particular is desirable Familiarity with SSAS Comfortable in/experienced with Python and/or Pyspark Data integration, processing and transformation (ETL, ELT, data pipeline orchestration, real-time data processing, ingesting streaming data); ingesting streaming data, and integrating data from RESTful APIs Data modeling, optimization & tuning Data security and data privacy compliance such as role-based security, access control & identity management, auditing and encryption practices; also API security best practices, including authentication, authorization, and encryption. Related Azure services such as Microsoft Fabric, Azure Data Lake Storage, ADF (Azure Data Factory) or similar technologies Data quality management and monitoring Full data lifecycle management Certifications in Azure, Power BI, or related areas are desirable Project management experience Minimum 5 years of experience in database development, data architecture, data solutioning Bachelor's or master's degree in computer science, data science, information technology, or related fields (or equivalent experience) Nice to Have Familiarity with Power BI Experience with API management tools such as Azure API Management, Postman, or Swagger Master data management using Profisee software (Finder) Management of data estate using Purview software (Data Governance to monitor data quality) Containerization tools, orchestration, deployment AirByte connectors & DBT Familiarity with accounting principles and the financial services industry Basic AI/ML concepts, algorithms, and fundamentals Knowledge and experience with training, validation, and testing datasets Perks/Benefits we offer for full-time team members: Wellness program HMO coverage Rewards and Recognition program Free shuttle service (provided by CDC | for onsite employees) Free lunch meal (For onsite employees) On-demand learning classes Discretionary time off and Holidays Performance-based salary increase Discretionary incentive compensation based on client or individual performance Hybrid set up to selected roles/location, terms and conditions may apply CPA & Certification Assistance and Bonus Program What's in it for you: Working with an industry leader: Be part of a high-growth firm that is passionate for what's next. A great team: Work with a high-energy, passionate, caring, and ambitious team of professionals in a collaborative culture. Growth opportunities: Grow professionally in an environment that fosters continuous learning and advancement. Competitive compensation: You will be rewarded with competitive compensation. EQUAL OPPORTUNITY EMPLOYER Aprio is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race; color; religion; national origin; sex; pregnancy; sexual orientation; gender identity and/or expression; age; disability; genetic information, citizenship status; military service obligations or any other category protected by applicable federal, state, or local law. #J-18808-Ljbffr