You have opted out of job matches in .
To undo this, go to the 'Skills and Interests' section of your preferences.
Posted 5 months ago
Requirements and responsibilities
Job DescriptionWork 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's Information 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 ResponsibilitiesData Architecture & StorageDesign scalable, secure, and high-performing data solutions aligned to business needsCreate robust data models, flows, and storage using Microsoft Fabric and Azure SQLManage master data with Profisee and integrate with existing systemsData Integration & TransformationBuild and manage data pipelines using Azure Data Factory and related toolsIngest data from APIs and external systems into the Azure ecosystemImplement ETL/ELT logic to prepare data for consumer useTesting, Monitoring & OptimizationEnsure data quality, consistency, and integrity across all stagesTroubleshoot performance issues and fine-tune data pipelinesUse Azure monitoring tools and Purview for data estate managementAdvanced Analytics & ReportingDevelop OLAP cubes and tabular models with SSASWrite complex MDX and DAX queries for data analysisIntegrate data models with Power BI, Excel, and SSRS for reportingCollaboration & DocumentationWork closely with analysts, developers, and business leaders to translate needs into data-driven solutionsDocument architectures, processes, and provide support/training as neededParticipate in Agile sprints and contribute to continuous improvementQualificationsMUST HAVE:Data solutions development using SQL, NoSQL, data warehouse and lakehouse concepts; Microsoft Fabric in particular is desirableFamiliarity with SSASComfortable in/experienced with Python and/or PysparkData integration, processing and transformation (ETL, ELT, data pipeline orchestration, real-time data processing, ingesting streaming data); ingesting streaming data, and integrating data from RESTful APIsData modeling, optimization & tuningData 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 technologiesData quality management and monitoringFull data lifecycle managementCertifications in Azure, Power BI, or related areas are desirableProject management experienceMinimum 5 years of experience in database development, data architecture, data solutioningBachelor's or master's degree in computer science, data science, information technology, or related fields (or equivalent experience)Nice to HaveFamiliarity with Power BIExperience with API management tools such as Azure API Management, Postman, or SwaggerMaster data management using Profisee software (Finder)Managment of data estate using Purview software (Data Governance to monitor data quality)Containerization tools, orchestration, deploymentAirByte connectors & DBTFamiliarity with accounting principles and the financial services industryBasic AI/ML concepts, algorithms, and fundamentalsKnowledge and experience with training, validation, and testing datasetsPerks/Benefits we offer for full-time team members:Wellness programHMO coverageRewards and Recognition programFree shuttle service (provided by CDC | for onsite employees)Free lunch meal (For onsite employees)On-demand learning classesDiscretionary time off and HolidaysPerformance-based salary increaseDiscretionary incentive compensation based on client or individual performanceHybrid set up to selected roles/location, terms and conditions may applyCPA & Certification Assistance and Bonus ProgramWhat'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 EMPLOYERAprio 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.
Optionally, you can add more information later (benefits, pre-screening questions, etc.)