Data Analyst - Dallas, United States - Allied Stone Inc

Description

Job Description

We Are Allied Stone Inc.

As a trusted industry leader with over 20 years of experience, Allied Stone provides our clients with high-quality stone fabrication, delivered with exceptional customer service. Along the way we have fostered long-lasting partnerships with major suppliers to ensure that we can provide consistent quality at competitive prices. With a team of trendsetting designers, skilled craftsmen, and cutting-edge technology we create a seamless client experience that results in unrivaled finished spaces.

Location: This is an on-site position requiring the employee to work on-site at their designated office location in Dallas, TX Monday - Friday.

We are looking for.......

A self-starter who can understand the Business Intelligence (BI) platform with strong integration skills of our current state and business objectives.

You will be helping us build, develop, and mature our business intelligence (BI) program.

You will be gathering requirements and feedback, designing scalable best practice solutions, and helping to develop the BI road map. We care about our BI user experience, therefore as a Data Analyst, you should enjoy all aspects of BI development, data connections, data analysis, data integrity, coding, user interface, user testing and BI architecture.

You will be responsible for:

• Working with business stakeholders to deeply understand the 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 will 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.

You need to have.......

Skills, Knowledge, 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 modeling, 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.
• 4+ years of business analysis, business intelligence, or data engineering experience; preferably within the cabinet and counter top 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, date 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.
• Understanding 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.

You can find us at:

Allied Stone Inc. is committed to creating a diverse and inclusive environment. We are proud to be an Equal Opportunity Employer providing opportunities to all employees and applicants without regard to race, sex, national origin, religion, age, disability, veteran status, genetic information, sexual orientation, gender identity and any other protected status in accordance with applicable law.