Business Intelligence Data Analyst

$80,000 - $90,000/Yr

Jobot - Dallas, TX

Full-time

Dallas, TX

Administrative and Support Services

About the position

The Business Intelligence Developer will play a crucial role in the Manufacturing industry by designing, developing, and maintaining business intelligence solutions. This position is essential for transforming data into actionable insights, supporting decision-making processes, and enhancing business operations through effective data analysis and reporting.

Responsibilities

• Design, develop, and deploy business intelligence systems and large scale data warehouses.
• Create tools to store data, such as OLAP cubes and clusters.
• Conduct troubleshooting on BI models.
• Generate and deliver quality reports to customers and perform regular tests to ensure data integrity and accuracy.
• Develop and manage BI solutions, analytics, and reports.
• Collaborate with teams to integrate systems and design and develop dashboards.
• Translate business needs into technical specifications.
• Develop and update technical documentation for BI systems, data models, and train new users on BI tools and systems.
• Use SSRS, SQL, MS Access, SSIS, Power BI, Tableau, ETL, OLAP, WebFocus, TSQL to perform tasks.
• Maintain and support data analytics platforms and create visualizations and reports for requested projects.

Requirements

• Bachelor's degree in Computer Science, Engineering, or a related field.
• Minimum of 5 years' experience as a Business Intelligence Developer, preferably in the Manufacturing industry or similar environment.
• Proven experience with BI technologies and a strong background in data warehouse design (e.g., dimensional modeling) and data mining.
• In-depth understanding of database management systems, online analytical processing (OLAP), and ETL (Extract, transform, load) framework.
• Proficiency in SQL queries, SSRS, SSIS, and experience with SQL Server Integration Services (SSIS).
• Knowledge of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Experience with BI technologies (Microsoft PowerBI, Oracle BI).
• Experience in data visualization tools like Tableau, Power BI, or similar tools.
• Familiarity with Informatica, WebFocus, and TSQL.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Excellent problem-solving abilities and experience in managing complex business data.
• Exceptional written and verbal communication skills, with the ability to communicate complex data in a simple, understandable way.
• Ability to work in a fast-paced, deadline-driven environment.

Benefits

• Salary range of $80,000 - $90,000 per year