Job Title: IT Lead Data Engineer

Company Name: BDO USA

Job Details: $138k-$170k/yrRemoteFull,Time

Job Url: https://hiring.cafe/viewjob/850kdxg2gcnu58oy

Job Description: Posted 4d agoIT Lead Data Engineer@ BDO USAView All JobsWebsiteDetroit or Kalamazoo or Chicago or Oak Brook or Rosemont or Huntsville or Stamford or Wilmington or Washington or Miami or Fort Lauderdale or Orlando or West Palm Beach or Jacksonville or Tampa or Tallahassee or Atlanta or Indianapolis or Boston or Baltimore or Columbia or Woodbridge or Cherry Hill or New York or Charlotte or Raleigh or Cleveland or Akron or Cincinnati or Columbus or Pittsburgh or Philadelphia or Greenville or Norfolk or Richmond or McLean$138k-$170k/yrRemoteFull TimeResponsibilities:lead design, collaborate governance, build pipelinesRequirements Summary:Eight+ years data engineering experience; SQL; PowerBI/Tableau; cloud (Azure/AWS/GCP); version control; Python/Scala/R/Java; Bachelor’s preferred; strong communication.Technical Tools Mentioned:PowerBI, Tableau, Looker, Qlik, SQL, SSMS, Azure DevOps, GitHub, SQL Server, Python, Scala, R, Java
Job Summary:The Lead Data Engineer is expected to be an expert at effectively working with business partners to understand their data needs and develop technical designs and requirements to meet those needs. This role is the team leader in helping extract, transform, and store the Firm’s valuable data assets to achieve better operational efficiencies and provide better services to its clients through modern data movement pipelines. This role, in collaboration with other data engineers, data architects, and other IT teams, will operationalize and document data extraction and ingestion platforms. This role is the team’s leader for developing strategies, policies, and governance models to ensure the Firm’s data remains accurate, timely and relevant to the Firm’s goals. This role will provide guidance and mentorship to junior data engineers, as well as helping delegate work items and tickets across the Data Engineering team.Job Duties:Works with stakeholders and data architects to define and design data solutions to support the Firm’s data initiativesUnderstands and locates where data assets exist within the Firm’s systems and design solutions integrating disparate data sources to solve problems and provide business valueCollaborates with project managers to provide effort estimates and provides technical leadership in solution design and requirementsWorks closely with data governance to ensure principles are followed through the course of day-to-day data usage and solution designPrepares mock-up solution designs, visualizations and reports to effectively demonstrate proposed solutions and deliverablesActs as a subject matter expert, evangelist and catalyst to educate on the Firm’s data platforms and best practices as they relate to the usage and hygiene of the Firm’s data assetsMeets regularly with business line customers to gain a better understanding of their business processes and of the customer's evolving data needs to help identify potential data-related projectsWorks with data scientists and developers to use emerging and advanced technologies such as artificial intelligence and machine learning to identify and extrapolate hidden patterns and trends, increasing the value of the Firm’s dataBuilds and maintains constructive working relationships with project team members, vendors and other departments involved with projects, systems, and IT strategiesServes as a technical expert and lead to other team members, reviewing proposed solution designs, conducting code reviews, and troubleshooting advanced technical issuesIdentifies and executes continuous improvement efforts to ensure the Firm’s data remains accurate and timelyWorks closely with the Information Security and Compliance teams to ensure the firm’s data strategy and technologies meet or exceed both internal policies and external regulatory requirementsCollaborates with BDO Global and other BDO member firms to ensure standards between organizations are followed in support of reusable models and rapid deployment of shared technologyUnderstands and follows Project Management basics and Project Management Office policies and proceduresOther duties as requiredSupervisory Responsibilities:N/AQualifications, Knowledge, Skills, and Abilities:Education:High School Diploma or GED, requiredBachelor’s Degree in Computer Science, Information Management, Mathematics, or Statistics, preferredExperience:Eight (8) or more years working as a data engineer, data analyst or similar analyst/engineer roles, requiredEight (8) or more years working with PowerBI, Tableau or similar data visualization products, requiredFive (5) or more years working within commercial cloud platforms such as Microsoft Azure, AWS, or GCP, requiredThree (3) or more years using version control tools (Azure DevOps, GitHub), requiredDemonstrable proficiency in developing and understanding custom and ad-hoc SQL queries, requiredExperience working within a large, complex enterprise with significant regulatory and compliance requirements, preferredExperience using a modern scripting language such as Python, Scala, R, or Java, preferredProfessional service firm experience, preferredSoftware:Strong proficiency in the use of Microsoft Office suite, specifically Excel, requiredStrong proficiency in the use of SQL Server Management Studio (SSMS), or similar, requiredStrong proficiency in the use of PowerBI, Tableau, Looker, Qlik, or similar, requiredOther Knowledge, Skills & AbilitiesStrong analytical, organizational and problem-solving skillsExcellent written communication skills, maintaining accurate documentation and technical authorship of complex documentsAbility to facilitate meetings efficiently and effectivelyAbility to follow an issue through to its logical conclusion, and escalate as necessaryAbility to work independently as well as part of a team, including providing technical leadership to less experienced colleaguesExcellent interpersonal and customer relationship skillsCapable of working in a deadline-driven environment, while handling multiple complex projects/tasks simultaneously with a focus on detailsCapable of working well under pressure while dealing with unexpected issues in a professional mannerAbility to work after hours and weekends as neededCapacity to travel as needed Individual salaries that are offered to a candidate are determined after consideration of numerous factors including but not limited to the candidate’s qualifications, experience, skills, and geography.National Range: $138,000 - $170,000 Maryland Range: $138,000 - $170,000 NYC/Long Island/Westchester Range: $138,000 - $170,000 #RemoteCompanyJoin us at BDO, where you will find more than a career, you’ll find a place where your work is impactful, and you are valued for your individuality. We offer flexibility and opportunities for advancement. Our culture is centered around making meaningful connections, approaching interactions with curiosity, and being true to yourself, all while making a positive difference in the world. At BDO, our purpose of helping people thrive every day is at the heart of everything we do. Together, we are focused on delivering exceptional and sustainable outcomes and value for our people, our clients, and our communities. BDO is proud to be an ESOP company, reflecting a culture that puts people first, by sharing financially in our growth in value with our U.S. team.  BDO professionals provide assurance, tax and advisory services for a diverse range of clients across the U.S. and in over 160 countries through our global organization.BDO is the first large accounting and advisory organization to implement an Employee Stock Ownership Plan (ESOP). A qualified retirement plan, the ESOP offers participants a stake in the firm’s success through beneficial ownership and a unique opportunity to enhance their financial well-being. The ESOP stands as a compelling addition to our comprehensive compensation and Total Rewards benefits* offerings. The annual allocation to the ESOP is fully funded by BDO through investments in company stock and grants employees the chance to grow their wealth over time as their shares vest and grow in value with the firm’s success, with no employee contributions. We are committed to delivering exceptional experiences to middle market leaders by sharing insight-driven perspectives, helping companies take business as usual to better than usual. With industry knowledge and experience, a breadth and depth of resources, and unwavering commitment to quality, we pride ourselves on:Welcoming diverse perspectives and understanding the experience of our professionals and clientsEmpowering team members to explore their full potentialOur talented team who brings varying skills, knowledge and experience to proactively help our clients navigate an expanding array of complex challenges and opportunitiesCelebrating ingenuity and innovation to transform our business and help our clients transform theirsFocus on resilience and sustainability to positively impact our people, clients, and communitiesBDO Total Rewards that encompass so much more than traditional “benefits.”  Click here to find out more!*Benefits may be subject to eligibility requirements.Equal Opportunity Employer, including disability/vetsClick here to find out more!