Overview
Skills
Job Details
Job Title: BI Architect and Developer
Location: Philadelphia, PA (preference for local/surrounding area candidates) Hybrid 1-2 days onsite required
Duration: Contract to hire, 6 months
Must have:
Health Insurance industry
Experience with Power BI architecture and reporting
Experience converting reports and dashboards to Power BI
Job Summary:
We are seeking a highly skilled and experienced BI Architect and Developer to design, develop, and maintain robust business intelligence solutions. This role involves working closely with stakeholders to understand business needs, architecting data models, and delivering insightful dashboards and reports that drive strategic decision-making.
Key Responsibilities:
- Design and implement scalable BI architecture and data models.
- Design, develop and optimize SQL queries.
- Support the conversion of MicroStrategy reports/dashboards to Power BI.
- Being able to create Power BI dashboards, Power Query, and data modeling is a plus.
- Design and develop interactive dashboards and reports using tools like Power BI, Tableau, MicroStrategy.
- Translate business requirements into technical specifications and BI solutions.
- Work with business analysts, data engineers, and stakeholders to gather requirements.
- Provide training and support to end-users on BI tools and data interpretation.
- Monitor and optimize BI system performance.
- Strong understanding of data warehousing concepts.
- Optimize performance of existing reports and dashboards.
- Provide technical leadership and mentorship to BI developers and analysts.
- Stay current with industry trends and emerging technologies in BI and analytics.
Required Qualifications:
- Bachelor s or master s degree in computer science, Information Systems or related field.
- 5+ years of experience in BI development and architecture.
- Strong proficiency in SQL, data modeling.
- Hands-on experience with BI tools (e.g., Power BI, Tableau, Qlik, MicroStrategy).
- Knowledge of data warehousing concepts and dimensional modeling.
- Excellent problem-solving and communication skills.
- Be a team player and get problems solved with collaborative effort.
Preferred Skills:
- Experience with Power BI architecture and reporting
- Familiarity with converting reports and dashboards to Power BI
- Understanding of data governance, security, and compliance standards.
- Familiarity with ETL tools like Informatica.