Business Intelligence Data Engineer

Job Title: Business Intelligence Data Engineer

Company Description: IEM (Industrial Electric Mfg) in Fremont, CA is the largest independent full-line manufacturer of custom electrical distribution and power quality equipment in North America. IEM has delivered customer-specific solutions to meet the ever-changing power requirements of growth industries in North America for over half a century. This position offers an exciting opportunity with competitive salary, 401k match, benefits and profit sharing.

Responsibilities:

1. Data Collection and Integration: Responsible for collecting data from various sources, ensuring its accuracy and consistency, and integrating it into a centralized system. This may include working with APIs, databases, and external data sources.
2. Data Warehousing and Database Management: Designing, implementing, and maintaining data warehouses and databases. This includes setting up data storage solutions that are scalable, secure, and optimized for performance.
3. Data Transformation and ETL Processes: Developing and maintaining ETL (Extract, Transform, Load) processes. This involves transforming raw data into a format that is suitable for analysis and loading it into an appropriate data store or warehouse.
4. Data Modeling and Architecture: Designing data models to effectively capture and represent business processes and requirements. This may also include optimizing data architectures for business intelligence and analytics.
5. Data Analysis and Reporting: Assisting in data analysis and creating reports to provide insights and support business decision-making. This could involve using BI tools, SQL, or other technologies to extract insights from data.
6. Performance Tuning and Optimization: Regularly reviewing and optimizing data processes and systems for improved performance and efficiency.
7. Collaboration with Stakeholders: Collaborating with business stakeholders to understand their data needs and requirements, and translating these into technical specifications.
8. Data Quality and Governance: Ensuring high standards of data quality and integrity. Implementing policies and procedures for data governance and compliance with relevant data protection regulations.
9. Technical Support and Training: Providing technical support for BI tools and systems. Training end-users on new reports and dashboards, and assisting them in understanding the data.
10. Staying Current with Industry Trends: Keeping up-to-date with the latest trends and technologies in business intelligence, data engineering, and data analytics.
11. Problem-Solving and Innovation: Identifying and addressing data-related problems, and proposing innovative solutions to improve business intelligence capabilities.

Qualifications:

1. Bachelor’s degree or diploma in a relevant field.
2. Minimum of 3 years of work experience in data engineering.
3. Proficiency in SQL.
4. Proficiency in Python.
5. Experience working with Snowflake and ETL tools.
6. Proficient in Power BI, Tableau, and other visualization tools.
7. Excellent verbal and written communication skills, with experience dealing with internal or external customers being a bonus.

Type of Employment: Full-Time

Benefits And Perks:

• Competitive salary
• Profit Sharing
• Excellent benefits package

Application Process: Interested candidates are invited to apply through the “Apply Now” link at the top of the page.