Data Architect

$95,000 - $105,000/Yr

Barron Lighting Group - Glendale, AZ

Full-time

Glendale, AZ

Electrical Equipment, Appliance, and Component Manufacturing

About the position

As a Data Architect at Barron Lighting Group, you will be instrumental in designing and developing data analytics solutions that support business operations. Your role will involve creating efficient reports, dashboards, and visualizations that enable stakeholders to make informed, data-driven decisions. This position requires a blend of technical expertise and an understanding of business requirements to enhance the company's data capabilities.

Responsibilities

• Design and develop application objects to collect, analyze, and present data from various sources.
• Create and maintain data models, schemas, and metadata to ensure data integrity and consistency.
• Develop and optimize SQL queries to extract data efficiently from databases.
• Collaborate with business analysts and stakeholders to understand their requirements and translate them into technical specifications.
• Create and maintain reports, dashboards, and visualizations using MicroStrategy tools.
• Validate and test data to ensure accuracy and quality.
• Optimize environment performance to enhance query response times and system efficiency.

Requirements

• Bachelor's degree is a plus but not required.
• Strong SQL Database query and SQL Server experience.
• Knowledge of database architecture and schema design.
• Familiarity with software development lifecycles (SDLC), such as Agile or Waterfall.
• Experience in report requirements gathering and business analytics.
• Excellent data visualization skills to create meaningful and informative reports.
• Ability to analyze data and translate it into actionable insights.
• Experience with data validation and quality assurance.
• Knowledge of data warehousing concepts and practices.
• Experience in MicroStrategy Developer and Web tools for creating reports, dashboards, and visualizations.
• MicroStrategy Report Developer certifications and MicroStrategy Server Administration experience.
• Experience with OLAP cubes and their creation and tuning.

Benefits

• 401(k) matching
• Dental insurance
• Disability insurance
• Flexible spending account
• Life insurance
• Vision insurance