Report

Data Analytics Architect

Min Experience

5 years

Location

Mumbai, Maharashtra, India

JobType

full-time

About the job

Info This job is sourced from a job board

Overview

About the role

Who We Are

Eide Bailly is one of the top 25 CPA and business advisory firms in the nation. We have over 40 offices in 15 states across the Midwest and western United States and offer our staff and Partners the opportunity to serve a variety of industries. In 2019, we extended our operations to Mumbai, India, and desire to expand our shared services segment there. Founded in 1917, our culture is the foundation of who we are, and we pride ourselves on supporting our employees to help them achieve their goals and pursue their interests both in the office and at home. At Eide Bailly we are passionate about the clients we serve, the work we do, and most importantly, having fun while we do it!

Why You'll Love Working Here

At Eide Bailly we believe respect is how to treat everyone, not just those you want to impress. Our
culture focuses on collaboration to achieve career growth. Innovation is highly encouraged, which is
where programs like our EB Xchange originate. This program allows interested tax and audit employees to complete a rotation into a specialty area. We promote happy employees by making work/life balance a priority along with being actively involved in our communities. Our dedication to service can be seen through the Firm's decision to match charitable donations made by employees, as well as providing opportunities to volunteer throughout the year. Most importantly, we like to have fun! We offer a professional and fun work environment with frequent lunch and learns, socials, contests, outings and other events.

Responsible for supporting clients’ senior management with accurate and timely information. Involved with many different BI processes including Fabric, Snowflake, DBT, Power BI, Tableau, Azure Data Factory, Python, AirFlow, SQL Server, Integration Services (SSIS), Reporting Services, Analysis Services, and SQL. Leading projects with little to no support & supporting other team members effectively.

Take complex data requirements related to specific business problems, stage data, create facts and dimension tables, and build reports. Become an in-house expert on clients’ key business-operating metrics to support senior business leaders in quickly identifying issues and offering strategic recommendations on key programs.

Responsibility:

· Lead analytics projects to successfully meet/exceed client requirements with minimal oversight & support

· Transforms raw data through applying business rules, auditing and staging data.

· Supports senior management with analysis needed to make important decisions.

· Helps identify & source KPIs for departments throughout the company.

· Ensures database administration functions are performed effectively and in accordance with established policies and procedures.

· Builds ETL packages to extract data from multiple sources and load into data warehouse.

· Creates fact and dimension tables to support OLAP cubes & visualization tools.

· Develops visualizations that fit client business needs/requirements & best-practices

· Uses problem solving and creativity to apply appropriate metrics in the creation of compelling and thorough analyses.

· Develops key business operating metrics to help drive business accountability.

· Ensures timely and accurate performance on assigned projects.

· Develops early a reputation of trust & self-sufficiency with leaders who will assign projects

· Maintains compliance with project budgets, turnaround times, and deadlines.

· Maintains proficiency in core analytics tools keeping skills relevant for EB clients’ needs. Widens existing skillsets quickly to enable supporting wider set of clients (learning agility). Leads certain skillsets (supports others including sales; recognized expert) and/or manages people.

· Self-starter/owner – does not require managerial overhead & takes personal responsibility to get engaged on projects, recognize & handle problems, & proactively find/implement solutions.

Qualification:

· Bachelor’s degree and solid background in technology, mathematics, statistics, accounting, finance, or other quantitative discipline preferred.

· 5+ Years of data Modeling with Kimball Method (Star Schema).

· Deep experience & expertise in Cloud Technologies such as: Fabric, Snowflake, DBT, Databricks, Azure, AWS, Python, Modeling data using Kimball Method (Star Schema), Analytical and visualization tools such as Power BI or Tableau, & Training data science/machine learning models Cloud technologies and services.

Skills:

· Must possess intellectual and analytical curiosity -- initiative to dig into the "why" of various results and a desire to grow responsibility and become a domain expert and strategic thought leader.

· Can’t get ‘stuck’ & rely on other data engineers to resolve – must be highly self-sufficient.

· Comfortable with uncertainty. Projects and assignments will change rapidly, so must be flexible enough to accommodate changing priorities and timelines.

· Expert in each of the following analytics processes/languages

o SQL language

o ETL processes

o Kimball data modeling (Star Schema)

o Analytics platform management

· Expert in at least 4 of the following 6 analytics technologies

o Microsoft Fabric

o Snowflake

o Azure Data Factory (ADF)

o DBT

o Power BI

o Tableau

· Experience with Databricks, Airflow, Python, AI, AWS, & data integrations with NetSuite or Salesforce is a plus.

About the company

A certified public accounting and business advisory firm.

Skills

SQL

ETL

Kimball data modeling

Analytics platform management

Microsoft Fabric

Snowflake

Azure Data Factory

DBT

Power BI

Tableau

Databricks

Airflow

Python

AWS

NetSuite

Salesforce