[Hiring] Data Analytics Architect @Eide Bailly LLP

Role Description

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
• 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.

Responsibilities:

• 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.
• Wides 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.

Qualifications

• 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.

Requirements

• 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:
• SQL language
• ETL processes
• Kimball data modeling (Star Schema)
• Analytics platform management
• Expert in at least 4 of the following 6 analytics technologies:
• Microsoft Fabric
• Snowflake
• Azure Data Factory (ADF)
• DBT
• Power BI
• Tableau
• Experience with Databricks, Airflow, Python, AI, AWS, & data integrations with NetSuite or Salesforce is a plus.