Cloud Data Engineer Senior Consultant

Job Summary:This position will work with cutting edge technology, deliver high quality solutions across various industries, and oversee team(s) on engagements that range in size and scope. This position will receive continuous career development opportunities, given the size and potential of client engagements. This role will perform hands-on delivery of data analytics projects, contributing to the development and unit testing of solutions. Job Duties:Designs and implements best in class data ingestion strategies, data warehouse and data mart structures, semantic layers and models, visualizations, streaming processes, API integrations, and automation (RPA) solutions for end-to-end data analytics solutions on primarily, but not limited to, cloud analytics platforms such as Azure and AWSListens to client needs to align solution with business requirements and delivery scheduleCreates written functional and technical designsParticipates in project status and stand meetings, and assists with providing aggregated project status for project and program managersAssists with SLA compliance of solutions, and performs performance tuning and optimization efforts of end-to-end solutionsWrites code using multiple languages and correctly applies frameworks, architectural patterns, and software development principlesDelivers high-performance, scalable, repeatable, and secure deliverables with broad impact (high throughput and low latency)Assists with implementation of data governance programs and best practicesPerforms the cleaning and transforming of data from source systems into analytics modelsImplements models to support data visualizations and integrationsAssists with implementing DevOps, DataOps and MLOps methodologies on projectsWrites custom integration logic in applicable programming languagesAssists project managers with work breakdown structure creation, project estimation, resource staffing, workload planning and adjustments throughout the project lifecycleAssists clients with licensing, security, and cost estimation of solutionsPerforms code reviews to ensure adherence to standardsWorks directly with clients and team members to establish secure data analytics platforms and infrastructure Contributes to successful deployments of developed solutions and integration of DevOps toolsMaintains a broad and current understanding of data analytics and business intelligence strategies, cloud platforms, methodologies, and toolsBuilds client relationships during project execution, effectively becoming a trusted advisor of the clientParticipates in support activities for existing software solutionsOther duties as assignedSupervisory Responsibilities:Supervises the day-to-day workload of Associates on assigned engagements to ensure that timelines and deliverables are met, and reviews work productQualifications, Knowledge, Skills and Abilities:Education:High School Diploma or GED equivalent, requiredBachelor’s degree, preferred; focus in Information Systems, Data Science or Computer Science, preferredExperience:Five (5) or more years of experience within Data Analytics, Business Intelligence, Artificial Intelligence, or Application Development, requiredOne (1) or more years of experience technically leading development projects, preferredOne (1) or more years of consulting experience or implementation of cloud-based data analytics solutions, preferredSoftware:Strong SQL skills including Data Definition Language (DDL), Data Manipulation Language (DML), views, functions, stored procedures, or performance tuning, requiredExperience with Data Warehousing, Data Modeling, Semantic Model Definition or Star Schema Construction, requiredHands on delivery experience of end-to-end cloud data analytics solutions within Azure or AWS, preferredExperience with one (1) or more of the following computer languages, preferred:C#PythonJavaScalaExperience with tabular modeling within Microsoft Fabric, Power BI, or Azure Analysis Services, preferredExperience with Git and DevOps deployment technologies, preferredExperience with Linux, preferredExperience with one (1) or more of the following, preferred:Data Lake Medallion ArchitectureBatch and/or streaming data ingestion into a data lakeAI Algorithms/Machine LearningAutomation tools such as UiPath, Alteryx, etc. Computer Vision based AI technologiesOther Knowledge, Skills & Abilities:Ability to work with a high degree of professionalism and autonomyExcellent verbal and written communication skillsSolid organizational skills, especially the ability to meet project deadlines with a focus on detailsAbility to successfully multi-task while working independently or within a group environmentAbility to work in a deadline-driven environment, and handle multiple projects simultaneously Ability to interact effectively with people at all organizational levels of the FirmAbility to effectively interact with a team of professionals and delegating work assignments, as neededAbility to build and maintain strong relationships with internal and client personnel Ability to encourage a team environment on engagements, and contribute to the professional development of assigned personnelKeywords:  Data Analytics, Business Intelligence, BI, Synapse, IoT, Machine Learning, Data Lake, Stream, Cube, Microsoft, SQL Server, Tableau, .Net, C#, Qlik, Power BI, Machine Learning, Azure Data Factory, RedShift, UiPath, Cloud, RPA, AWS, Redshift, Kinesis, QuickSight, SageMaker, S3, Databricks, AWS Lake Formation, Snowflake, Python, Qlik, Athena, Data Pipeline, Glue, Star Schema, Data Modeling, SQL, SSIS, SSAS, SSRS, PySpark, Microsoft Fabric, dbt, Linux, Terraform, Bicep, Data Ops, Purview, Git, Delta, Pandas, Spark SQLIndividual 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.California Range:  $111,000 - $152,000Colorado Range:  $111,000 - $152,000New York City/ Valhalla Range:  $111,000 - $152,000Washington Range:  $111,000 - $152,000Join 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 communities*Benefits may be subject to eligibility requirements.Equal Opportunity Employer, including disability/vetsClick here to find out moreFull timePosting Date: 2024-05-06