Georgia IT, Inc. · 21 hours ago
Sr. Power BI Architect – 100% Remote
Maximize your interview chances
Insider Connection @Georgia IT, Inc.
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
BI Infrastructure Review: Assess the existing Power BI setup to determine if augmentation or a fresh implementation is required. Evaluate data pipelines, connectivity, and current reporting performance for optimization opportunities.
Architecture Planning: Draft detailed physical and logical architecture diagrams integrating multiple systems (ERP, MES, Oracle Fusion, SQL databases). Configure Power BI Data Gateways for secure access to on-prem and hybrid data sources.
Develop workspace strategies and naming conventions to manage content efficiently across departments. Implement role-based access controls (RBAC) and row-level security (RLS) for governance and data protection.
Integration with ERP and Other Systems: Build data pipelines to extract, transform, and load data from Infor Visual ERP, Oracle Fusion, MES, SQL databases, and spreadsheets. Resolve on-premise integration challenges using ETL/ELT tools, APIs, or custom connectors. Develop dashboards that combine data from ERP, MES, Oracle Fusion, and operational systems to support decision-making. Best Practices & Governance: Establish version control processes for managing BI assets throughout their lifecycle.
Define and implement a data governance framework to ensure data accuracy, security, and consistency.
Optimize Power BI queries using DAX and Power Query (M) for high-performance and large dataset management.
Environment Setup & Security: Stand up a scalable Power BI environment following the approved architecture plan. Enforce RLS, data encryption, and user authentication policies to ensure compliance with security standards. Configure refresh schedules aligned with ERP, Oracle Fusion, and MES system data availability.
Knowledge Transfer & Team Mentorship: Deliver training sessions and documentation to empower the current BI team to manage the environment. Mentor the team on advanced data modeling, DAX scripting, and collaboration workflows. Lead the establishment of a Power BI Center of Excellence (CoE) to promote best practices and innovation.
Advanced Analytics & Reporting Roadmap: Design and deliver KPI dashboards combining ERP, MES, Oracle Fusion, and financial data for strategic insights. Collaborate with business units to develop a reporting roadmap aligned with organizational goals. Explore and implement predictive analytics capabilities for proactive decision-making.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
10+ years of experience with Power BI in enterprise environments.
Strong Power Apps, Power Automate and Fabric expertise.
Strong proficiency in DAX, Power Query (M), and ETL/ELT tools (e.g., SSIS, Azure Data Factory).
Proven expertise in on premise data integration, including Infor Visual ERP, Oracle Fusion, and MES systems.
Extensive experience designing BI architectures with Power BI Gateways and workspaces for hybrid and on-prem environments.
Expertise in data modeling, governance frameworks, security (RLS), and version control.
Familiarity with SQL databases, APIs, JSON/XML data integration, and Excel automation.
Strong understanding of network security, encryption practices, and user authentication within BI environments.
Excellent communication and leadership skills with the ability to mentor teams and collaborate with non-technical stakeholders.
Company
Georgia IT, Inc.
Georgia IT, Inc. provides IT Consulting for a wide range of IT services and custom build turn-key enterprise solutions.
H1B Sponsorship
Georgia IT, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (2)
2022 (14)
2021 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase