Logo
BDO USA, LLP

Azure Senior Data Engineer

BDO USA, LLP, Troy, MI


Job Description

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 AWS
  • Listens to client needs to align solution with business requirements and delivery schedule
  • Creates written functional and technical designs
  • Participates in project status and stand meetings, and assists with providing aggregated project status for project and program managers
  • Assists with SLA compliance of solutions, and performs performance tuning and optimization efforts of end-to-end solutions
  • Writes code using multiple languages and correctly applies frameworks, architectural patterns, and software development principles
  • Delivers high-performance, scalable, repeatable, and secure deliverables with broad impact (high throughput and low latency)
  • Assists with implementation of data governance programs and best practices
  • Performs the cleaning and transforming of data from source systems into analytics models
  • Implements models to support data visualizations and integrations
  • Assists with implementing DevOps, DataOps and MLOps methodologies on projects
  • Writes custom integration logic in applicable programming languages
  • Assists project managers with work breakdown structure creation, project estimation, resource staffing, workload planning and adjustments throughout the project lifecycle
  • Assists clients with licensing, security, and cost estimation of solutions
  • Performs code reviews to ensure adherence to standards
  • Works 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 tools
  • Maintains a broad and current understanding of data analytics and business intelligence strategies, cloud platforms, methodologies, and tools
  • Builds client relationships during project execution, effectively becoming a trusted advisor of the client
  • Participates in support activities for existing software solutions
  • Other duties as assigned

Supervisory Responsibilities:
  • Supervises the day-to-day workload of Associates on assigned engagements to ensure that timelines and deliverables are met, and reviews work product


Qualifications, Knowledge, Skills and Abilities:

Education:
  • High School Diploma or GED equivalent, required
  • Bachelor's degree, preferred; focus in Information Systems, Data Science or Computer Science, preferred

Experience:
  • Five (5) or more years of experience within Data Analytics, Business Intelligence, Artificial Intelligence, or Application Development, required
  • One (1) or more years of experience technically leading development projects, preferred
  • One (1) or more years of consulting experience or implementation of cloud-based data analytics solutions, preferred

Software:
  • Strong SQL skills including Data Definition Language (DDL), Data Manipulation Language (DML), views, functions, stored procedures, or performance tuning, required
  • Experience with Data Warehousing, Data Modeling, Semantic Model Definition or Star Schema Construction, required
  • Hands on delivery experience of end-to-end cloud data analytics solutions within Azure or AWS, preferred
  • Experience with one (1) or more of the following computer languages, preferred:
    • C#
    • Python
    • Java
    • Scala
  • Experience with tabular modeling within Microsoft Fabric, Power BI, or Azure Analysis Services, preferred
  • Experience with Git and DevOps deployment technologies, preferred
  • Experience with Linux, preferred
  • Experience with one (1) or more of the following, preferred:
    • Data Lake Medallion Architecture
    • Batch and/or streaming data ingestion into a data lake
    • AI Algorithms/Machine Learning
    • Automation tools such as UiPath, Alteryx, etc.
    • Computer Vision based AI technologies

Other Knowledge, Skills & Abilities:
  • Ability to work with a high degree of professionalism and autonomy
  • Excellent verbal and written communication skills
  • Solid organizational skills, especially the ability to meet project deadlines with a focus on details
  • Ability to successfully multi-task while working independently or within a group environment
  • Ability to work in a deadline-driven environment, and handle multiple projects simultaneously
  • Ability to interact effectively with people at all organizational levels of the Firm
  • Ability to effectively interact with a team of professionals and delegating work assignments, as needed
  • Ability 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 personnel

Keywords: 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 SQL

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.

California Range: $111,000 - $152,000
Colorado Range: $111,000 - $152,000
NYC/Long Island/Westchester Range: $111,000 - $152,000
Washington Range: $111,000 - $152,000
Washington DC Range: $111,000 - $152,000

About Us

Join 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 clients
  • Empowering team members to explore their full potential
  • Our talented team who brings varying skills, knowledge and experience to proactively help our clients navigate an expanding array of complex challenges and opportunities
  • Celebrating ingenuity and innovation to transform our business and help our clients transform theirs
  • Focus on resilience and sustainability to positively impact our people, clients, and communities
  • BDO 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/vets

Click here to find out more!