Job Overview:
We are looking for a BI Developer to manage SQL databases, develop ETL processes, and build robust BI solutions to support business data analysis. The ideal candidate will be hands-on with database development and data analytics, with a strong background in SQL, ETL tools like SSIS and Alteryx, and the Microsoft Power Platform. This role offers significant growth opportunities and involves heads-down work with minimal meetings.
Key Responsibilities:
- Manage and maintain SQL databases, ensuring optimal performance and data integrity.
- Monitor performance and implement quality control plans to improve data analytics processes.
- Develop ETL processes to acquire, transform, and load data from various sources for analysis.
- Design, develop, and deploy BI solutions, including reports and dashboards, to support business needs.
- Create and optimize data models (e.g., star schema, snowflake schema) to enable efficient reporting and analysis.
- Build and maintain data warehouses to store large datasets for business analytics.
- Automate workflows to streamline manual data integration processes.
- Work as an individual contributor focused on database development with minimal meeting interruptions.
Must-Have Qualifications:
- 4+ years of experience in database development, analytics, or business intelligence.
- Proven experience managing SQL databases with hands-on expertise in programming and writing complex queries.
- Experience with ETL tools like Microsoft SSIS and Alteryx.
- Proficiency in the Microsoft Power Platform, including Power Automate and Power Apps.
- Strong experience in data warehousing, data analytics, and creating effective data models.
- Knowledge of statistics and analytics, with experience using packages for analyzing datasets.
- Soft Skills: Highly analytical, detail-oriented, energetic, and able to write and present findings clearly.
Nice-to-Have Qualifications:
- Experience with Visual Studio, XML, Apex, and JavaScript.
- Familiarity with Salesforce, Tableau, and SharePoint.
- Experience in a highly regulated industry is a plus.
- Relevant certifications or a degree in Computer Science, Data Analytics, or a related field.