BI Developer

RCN Capital is looking for a Data Engineer to join our Business Intelligence team. As a BI Developer, you will be responsible for designing, developing, and maintaining data pipelines and systems that support our business intelligence and analytics initiatives. You will work closely with cross-functional teams to ensure data is accessible, reliable, and optimized for performance. You will also collaborate with other Bl team members and stakeholders to provide data-driven insights and solutions for our business.

Job Responsibilities

-Design, develop, and maintain data pipelines and ETL processes using Python and SSIS to extract, transform, and load data from various sources, such as SQL Server, MySQL, Excel, Sm.

- Implement and manage data integration solutions using Microsoft Bl tools such as Power

BI, Azure Data Factory, and SQL Server Integration Services (SSIS).

- Develop and optimize data models and databases to support reporting and analytics

- Collaborate with business stakeholders to understand data requirements and deliver solutions that meet their needs.

- Ensure data quality, integrity, and security across all data systems

- Monitor and troubleshoot data systems to ensure optimal performance

- Creating and optimizing queries, views, stored procedures, and functions to support reporting and analysis needs

- Exploring and evaluating new data sources and technologies to enhance our data capabilities and improve our data efficiency

- Stay up-to-date with the latest trends and technologies in data engineering and business intelligence.

Required Experience</p&gt;

- Proficient in Python and SQL

- Experience with ETL tools, such as SSIS or similar

- Experience with Tableau or Power BI

- Experience with Power Bl or other reporting tools

- Experience with SQL Server and MySQL databases

- Experience with Excel and Smartsheets data sources

- Strong analytical and problem-solving skills

Required Skills:

- At least 3 years of experience in data engineering or related roles

- Experience with Tableau or Power BI

Preferred Skills:

- Experience with Al or machine learning applications in BI

- Experience with cloud platforms, such as Azure or AWS

- Experience with data warehousing and dimensional modeling techniques.

Preferred Experience:

- Experience with Power BI

- Microsoft Certified:

Azure Data Fundamentals

Azure Al Engineer Associate

Azure Data Scientist Associate

Working hours: Monday to Friday 8:30am - 5:30pm EST