Job Details
Power BI Data EngineerEY is a global leader in assurance, tax, transaction and advisory services Technology is at the heart of what we do and deliver at EY Technology solutions are integrated in the client services we deliver and are key to our innovation as an organizationFueled by strategic investment in technology and innovation, Client Technology seeks to drive growth opportunities and solve complex business problems for our clients through building a robust platform for business and powerful product engine that are vital to innovation at scale As part of Client Technology, you'll work with technologists and business experts, blending EY's deep industry knowledge and innovative ideas with our platforms, capabilities, and technical expertise.
As a catalyst for change and growth, you'll be at the forefront of integrating emerging technologies from AI to Data Analytics into every corner of what we do at EY That means more growth for you, exciting learning opportunities, career choices, and the chance to make a real impactThe selected candidateLeads the delivery of processes to extract, transform and load data from disparate sources into Power BI reporting that is consumable by end users, for projects with moderate complexity, using strong technical capabilities Designs, develops and produces data models of relatively high complexity, leveraging a sound understanding of data modelling standards to ensure high quality Builds networks with project teams across EY to help define and deliver business valueYour key responsibilities includeLeading the production of high-quality data engineering deliverables, helping to ensure project timelines are met, and providing informal mentoring / training to junior members of the team Leading the delivery of data quality reviews including data cleansing where required to ensure integrity and quality Leading the delivery of complex reporting solutions based on composite models to manage data within the organization, for a small to medium-d project Resolving escalated design and implementation issues with moderate to high complexity Providing technical expertise to maximize value from current applications, solutions, infrastructure and emerging technologies and seek to continuously improve internal processes Developing working relationships with peers across other engineering teams and beginning to collaborate to develop leading data engineering solutions Driving adherence to the relevant data engineering and data modelling processes, procedures and standardsSkills and attributes for successData Visualization - ability to design and implement informative reporting that translates data into business value, strong analytical skills; Ability to write complex stored procedures to prepare data for reports, version control(preferably git) Data Integration (Sourcing, Storage and Migration) - capability to design and implement models, capabilities and solutions to manage data within the enterprise (structured and unstructured, data archiving principles, data warehousing, data sourcing, etc) This includes the data models, storage requirements and migration of data from one system to another; Creating interactive and paginated reports(PBIX,RDL), Data Quality, Profiling and Cleansing - capability to review (profile) a data set to establish its quality against a defined set of parameters and to highlight data where corrective action (cleansing) is required to remediate the data Preferred candidate will have good understanding of the following tools and technologies, and will be able to prove how to apply them to solve business problemsMust have: Data Visualization Power BI, SQL Server Reporting Services, Power BI Report Server, Power BI Report Builder; Experience using Power BI with very large data volumes Data Access Tools MS SQL Server Management Studio Workspace Management Power BI App, Permissions, Pro vs Premium ETL / ELT / Data Fabric Tools Power BI Dataflows, Power Query M, Composite Models Programming Languages SQL, T-SQL, DAX Source Control / Release Pipelines Azure DevOpsNice to have: Big Data Distributed Systems Azure Synapse Analytics Data Visualization SQL Server Reporting Services, Tableau, Spotfire Data Warehousing Platforms Azure SQL Warehouse / Azure Synapse Document Database SharePoint, MongoDB ETL / ELT / Data Fabric Tools Alteryx, Azure Data Factory, SQL Server Integration Services Low Code Apps Power Automate, Power Apps Programming Languages Node.
js, Reactjs, Java, Python (big plus), R (big plus)EducationBS in Actuarial, Behavior Economics, Computer Science, Data Analytics, Data Science, Econometrics, Engineering, IT, Cyber Security, or related field preferredWhat we look forStrong analytical skills and problem-solving ability A self-starter, independent-thinker, curious and creative person with ambition and passion Excellent inter-personal, communication, collaboration, and presentation skills Customer focused Excellent time management skills Positive and constructive minded Takes responsibility for continuous self-learning Takes the lead and makes decisions in critical times and tough circumstances Attention to detail High levels of integrity and honestyWhat working at EY offersWe offer a competitive remuneration package where you'll be rewarded for your individual and team performance Our comprehensive Total Rewards package includes support for flexible working and career development, and with FlexEY you can select benefits that suit your needs, covering holidays, health and well-being, insurance, savings and a wide range of discounts, offers and promotions.
Plus, we offer:Support, coaching and feedback from some of the most engaging colleagues around Opportunities to develop new skills and progress your career The freedom and flexibility to handle your role in a way that's right for you EY is committed to being an inclusive employer and we are happy to consider flexible working arrangements We strive to achieve the right balance for our people, enabling us to deliver excellent client service whilst allowing you to build your career without sacrificing your personal priorities