Job Summary:
The Senior Data Analytics Engineer is responsible for designing, developing, and maintaining advanced data analytics solutions to support business decision-making processes. This role focuses on leveraging extensive experience in PowerBI or other analytics tools to transform complex data sets into actionable insights. The Senior Data Analytics Engineer collaborates with cross-functional teams to understand business requirements and translates them into technical specifications. This position plays a critical role in enhancing data-driven strategies and ensuring the integrity and accuracy of data analytics solutions. This role, in collaboration with other data engineers, data architects, and other IT teams, will operationalize and document data extraction and ingestion platforms, including Databricks, Microsoft Fabric, and Azure Data Factory. This role will provide guidance and mentorship to junior data engineers.
Job Duties:
Leads the development of medallion architecture using Microsoft PowerBI and Fabric
Uses tools such as Azure Databricks, Azure Data Factory, and others to extract, transform, and load data into the various layers of our data ecosystem
Works with the data governance team and data architects to define and design data solutions to support the Firm's data initiatives
Understands and locates where data assets exist within the Firm's systems and designs solutions integrating disparate data sources to solve problems and provide business value
Collaborates with project managers to provide effort estimates and provides technical leadership in solution design and requirements
Prepares mock-up solution designs, visualizations, and reports to effectively demonstrate proposed solutions and deliverables
Acts 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 assets
Meets regularly with line of business customers to gain a better understanding of their business processes and of the customer's evolving data needs in order to identify potential data-related projects
Works 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 data
Builds and maintains constructive working relationships with project team members, vendors and other departments involved with projects, systems, and IT strategies
Ensures data governance principles are followed through the course of day-to-day data usage and solution design
Identifies and executes continuous improvement efforts to ensure the Firm's data remains accurate and timely
Works 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 requirements
Collaborates 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 technology
Understands and follows Project Management basics and Project Management Office policies and procedures
Other duties as required
Supervisory Responsibilities:
N/A
Qualifications, Knowledge, Skills, and Abilities:
Education
High School Diploma or GED, required
Bachelor's Degree in Computer Science, Information Management, Mathematics, or Statistics, preferred
Experience
Five (5) or more years working as a data engineer, data analyst or in similar analyst roles, required
Five (5) or more years working with PowerBI, Tableau or similar data visualization products, required
Demonstrable proficiency in developing and understanding custom and ad-hoc SQL queries, required
Three (3) or more years using a modern scripting language such as Python, Scala, R, or JavaScript, required
Experience using version control tools (Azure DevOps, GitHub), required
Three (3) or more years working within commercial cloud platforms such as Microsoft Azure, AWS, or GCP, preferred
Experience working within a large, complex enterprise with significant regulatory and compliance requirements, preferred
Professional service firm experience, preferred
License(s)/Certification(s)
N/A
Software
Strong proficiency in the use of Microsoft Office suite, specifically Excel, required
Strong proficiency in the use of SQL Server Management Studio (SSMS), or similar, required
Strong proficiency in the use of PowerBI, Tableau, Looker, Qlik, or similar, required
Language(s)
NA
Other Knowledge, Skills & Abilities
Strong analytical, organizational, and problem-solving skills
Excellent written communication skills, maintaining accurate documentation and technical authorship of complex documents
Ability to facilitate meetings efficiently and effectively
Ability to follow an issue through to its logical conclusion, and escalate as necessary
Ability to work independently as well as part of a team, including providing technical leadership to less experienced colleagues
Excellent interpersonal and customer relationship skills
Ability to work in a deadline-driven environment, while handling multiple complex projects/tasks simultaneously with a focus on details
Ability to work well under pressure while dealing with unexpected issues in a professional manner
Ability to work after hours and weekends as needed
Ability 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: $110,000 -... For full info follow application link.
All qualified applicants will receive consideration for employment without regard to race, age, color, religion, sex, national origin, disability, protected veteran status, or any other classification protected by law.
