Business Intelligence Data Analyst

$80,000 - $90,000/Yr

Jobot - Dallas, TX

Full-time

Dallas, TX

Administrative and Support Services

About the position

We are seeking a dynamic and experienced Business Intelligence Developer to join our team in the Manufacturing industry. The ideal candidate will be responsible for designing, developing, and maintaining business intelligence solutions. This role will play a critical part in our decision-making process by crafting and managing BI and analytics solutions that turn data into knowledge. If you are passionate about data analysis and have a keen eye for detail, we would like to meet you. As a key contributor to Business Intelligence initiatives, you will provide analysis to clients, involving the reporting of several key business operations including sales activity, analysis, trends, and inventory tracking. You will work closely with various teams to ensure that the BI systems are effectively integrated and that the data is accurately represented in reports and dashboards.

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 Power BI, 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.