Business intelligence analyst Jobs in Norwalk, CA

About the Company

Ardmore Home Design (AHD), founded in 2008, is a privately owned, fast-paced, founder-led entrepreneurial company where we value people with strong skills to make our products and processes better every day. We design, sell, and distribute luxury home décor globally to interior designers and boutique / luxury retailers. The AHD family of wholesale brands includes Made Goods (flagship furniture made from unique materials), Pigeon & Poodle (home and bath accessories), Blue Pheasant (handcrafted tabletop products) and Burton James (seating home furnishing).

About the Role

We are looking for Business Intelligence Specialist to provide day to day management for the data services organization and building the capabilities needed to effectively manage and continuously improve our data processing, as well as identifying and driving targeted performance tuning and optimization opportunities.

As an integral member of our delivery team, the Business Intelligence (BI) Specialist is responsible for the design, development, implementation, management and support of mission critical enterprise BI reporting and Extract, Transform, Load (ETL) processes and environments. Working with cross-functional teams, you will be required to gather, document, and approve business requirements for data analysis and reporting projects, as well as use BI and database tools to develop reporting solutions to meet business needs. Using your skills and experience as a BI Specialist, you will design, develop and implement ETL processes to transform structured, unstructured and disparate source data into the target data store(s) / data warehouse(s) / data mart(s). This individual embraces and supports our in-person / on-site work culture and embodies our company values of Ownership, Collaboration and Respect .

What you can do for us :

• Understand business requirements in BI context and design data models to transform raw data into meaningful insights
• Create dashboards and interactive visual reports using Power BI
• Identify key performance indicators ( KPIs )with clear objectives and consistently monitor those
• Experience on Migration to AWS or Azure Snowflake platform
• Must have Performance tuning and setting up resource monitors
• Need to have knowledge on conversion of Data ingestion from SQL into Snowflake
• Must have strong experience in Power BI and SSRS / Report Builder
• Should have an Enterprise-level technical exposure to Snowflake applications
• Analyzing data and present data through reports that aid decision-making
• Convert business requirements into technical specifications and decide timeline to accomplish
• Create relationships between data and develop tabular and other multidimensional data models
• Chart creation and data documentation explaining algorithms, parameters, models, and relations
• Design, develop, test, and deploy Power BI scripts and perform detailed analytics
• Perform DAX queries and functions in Power BI
• Analyze current ETL process, define and design new systems
• Data warehouse development and work with SSAS, SSIS, and SSRS
• Redefine and make technical / strategic changes to enhance existing Business Intelligence systems
• Design, develop and deploy business intelligence solutions as per needs
• SQL querying for best results, use of filters and graphs for better understanding of data
• Work with users and team members at all level for performance improvement and suggestions

What we can do for you :

Requirements

o Working with users in a requirements analysis role

o Extensive use of SQL and RDBMS systems (SQL Server, Snowflake etc.)

o Extensive experience with data warehouse implementations

o Strong knowledge of logical and physical data modeling concepts

Physical Requirements :

The physical demands described here are representative of those that are required by an employee to successfully perform the essential functions of this job.

Other Considerations :

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. Reasonable accommodations may be made to qualified individuals with disabilities to enable them to perform the essential functions of the role.

Starting base salary : $85,000 - $93,000 per year. Exact compensation may vary based on skills, experience, and location.