Data Analyst

Allied Stone is a leader in fabrication and installation of natural stone, Allied Stone specializes in unique and customized granite kitchen countertops and bathroom vanities for new homes and remodels. We take pride in crafting our exceptional designs from only the highest quality natural stone such as granite, marble, onyx, and soapstone.  Additionally, square Cabinetry under the Allied Stone family. Square focuses on kitchen cabinets for track homes, apartments, and corporate buildings.

We are currently looking for a Data Analyst to join our growing IT team at our corporate offices in Farmers Branch, TX. As a Data Analyst, you’ll play an integral role at Allied Stone Inc. We are looking for a self-starter that can help us build, develop, and mature our business intelligence (BI) program. Gathering requirements and feedback, designing scalable best practice solutions, and helping to develop the BI road map. Our BI user experience, acceptance and ease of use is of great importance to us, therefore the data analyst should enjoy all aspects of BI development, data connections, data analysis, date integrity, coding, user interface, user testing and BI architecture. 

Additionally, the data analyst will participate in structuring and developing our data warehouse to power timely, impactful business intelligence. This role has a broad scope and requires high autonomy on a small team. You will work closely with the rest of the systems team to build out and interpret that data to drive business decisions. The position is ideal for someone with a few years of relevant experience structuring BI data and offers significant room to grow.

We are looking for someone with not only an understanding of BI platforms but also someone with strong integration skills, who can understand both our current setup and our business objectives, in order to quickly identify areas of improvement. We are looking to continue the growth of our BI program to include data from our suite of applications.  

Position Tasks and Responsibilities:  

• Work with business stakeholders to deeply understand pain points, shape solutions, gather requirements, and ensure result validity
• Design, code, and test, SQL views, tables, and data pipelines to provide scalable, extensible, reusable data assets to reporting users across the business
• Participate in the design, development, and analysis of data architecture and warehousing approaches
• Create technical documents to document database contents, concepts, and mapping between systems and applications
• Expose data for dashboarding by creating and maintaining dashboards in our reporting environment based on requirements gathering
• Identify and propose opportunities for process, tooling, or architecture improvements
• Support enterprise-wide data initiatives 
• Comfortable working across multiple ERP systems with the mindset of automation and cross system analytics, business approaches and data rendering
• Complete requested and ad-hoc BI assignments; Create visualizations and reports for requested projects using BI tools and programs
• Identify and define data sources and data relationships that might require a data warehouse structure to support analysis and reporting
• Define and design database solutions and data models to stage and present BI data for use in reporting
• Deliver timely reporting/dashboards based on agile deployment schedule

Qualifications and Background

Knowledge, Skills, and Abilities

• Strong motivation to create customer satisfaction through the delivery of high-quality end-user reporting
• Self-starter able to work with little supervision
• Proven analytical and problem-solving abilities
• Ability to diagnose and solve problems creatively
• Demonstrated intermediate to advanced knowledge of SQL, SSIS, SSRS, SSAS, other BI software, data modelling, ETL and data warehousing concepts
• Demonstrated knowledge of Microsoft Office products and SQL development 
• Knowledge of Python and other coding languages is a plus

Education, Training and Experience

• Bachelor’s degree required, preferred with a quantitative or technical focus, Mathematics, statistics, Calculus or other related fields of study 
• 2 years of business analysis, business intelligence, or data engineering experience; preferably within the cabinet and countertop industry
• Experience data modeling for data warehousing & reporting
• Experience capturing business requirements and translating into technical needs
• Excellent verbal and written communication skills
• Proven strong critical thinking skills, a track record of innovative thought and analytical abilities
• Strong organizational skills with close attention to detail
• Working knowledge of ETL, ELT, data warehouse, operational data store, bulk data operations, and performance analysis
• Experience with Business Intelligence platform market leaders, e.g., DOMO, Power BI, Tableau, Information Builders
• Ability to write and understand complex SQL queries
• Working understanding of relational databases, business intelligence tools, forecasting and/or statistical models is a plus
• Experience with AWS data is a plus
• Experience with Boomi and other middleware applications is highly desirable 

Work Environment / Schedule 

Work requires willingness to work a flexible schedule, typically 8am to 5pm; Monday-Friday

• Work will require intermittent weekend and/or evening work
• Periodic travel to other office locations in Texas/Oklahoma 
• Flexible Office hours  

This position is located at our corporate headquarters in Dallas, Texas