Power BI Sr. Developer

Description • Seeking an experienced Power BI Developer with a strong background in semantic data modeling, advanced DAX programming, data visualization, and Power BI administration. • Semantic Modeling & Data Architecture • Design, develop, and optimize Power BI semantic models using best‑practice dimensional modeling techniques (star schema, snowflake, dataflows, shared datasets). • Build enterprise-grade datasets with proper relationships, hierarchies, calculation groups, and incremental refresh. • Collaborate with data engineering teams to define data requirements, improve data quality, and ensure model scalability and maintainability. • Implement data modeling standards that support self-service analytics and governed data access. • Advanced DAX Programming • Develop complex DAX measures, calculated columns, and tables to support business logic, KPIs, and analytical insights. • Optimize DAX for performance, readability, and maintainability across large datasets. • Troubleshoot calculation issues and ensure accuracy and consistency across reports and dashboards. • Implement row-level and object-level security (RLS/OLS) within the semantic model. • Visualization & Dashboard Development • Build intuitive, visually compelling Power BI dashboards that communicate insights clearly and effectively. • Apply data visualization best practices and data storytelling techniques to support decision-making. • Create interactive features such as drill-throughs, bookmarks, custom visuals, and parameterized reports. • Ensure dashboards meet accessibility, usability, and design standards. • SQL Development (Oracle & SQL Server) • Write efficient, well-structured SQL queries, stored procedures, and views to support BI data pipelines. • Perform data profiling, validation, and transformation using SQL in both Oracle and SQL Server environments. • Collaborate with DBAs and data engineers to optimize query performance and ensure data integrity. • Power BI Administration & Governance • Manage Power BI Service components including workspaces, datasets, data gateways, refresh schedules, and capacity utilization. • Support governance initiatives such as dataset certification, naming conventions, documentation, and version control. • Monitor performance, troubleshoot refresh failures, and optimize dataset size and gateway performance. • Assist with tenant-level administration including user access, licensing, and compliance with organizational policies. • Collaboration & Stakeholder Engagement • Work closely with business stakeholders to gather requirements and translate them into scalable BI solutions. • Provide guidance and support to self-service BI users across the organization. • Document data models, DAX logic, SQL scripts, and report specifications. • Participate in Agile or project-based workflows to support continuous improvement of BI capabilities. Qualifications • 4-years Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field. • 5+ years of hands-on Power BI development experience. • Strong expertise in: • Semantic modeling (star schema, dataflows, composite models) • Advanced DAX programming • Power Query (M language) • Power BI Desktop and Power BI Service • Solid SQL development experience in both Oracle and SQL Server. • Experience with Power BI administration, including gateways, RLS/OLS, workspace governance, and capacity management. • Strong understanding of relational and dimensional modeling concepts. • Ability to communicate complex technical concepts to non-technical audiences. Preferred Skills • Familiarity with Oracle Business Intelligence (OBIEE) Semantic model (RPD), interactive reports and dashboard. • Knowledge of enterprise data governance frameworks. • Experience working with large, complex data sets in a multi-system environment. Benefits Healthcare Insurance: Synectics offers eligible employees and their dependents healthcare coverage through BlueCross BlueShield of Illinois. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Premiums are subsidized by Synectics. Dental Insurance: Synectics offers eligible employees and their dependents a dental plan through MetLife. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Vision Insurance: Synectics offers eligible employees vision insurance through VSP. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics.401(k) Plan: The Synectics Inc. Investment Savings Retirement Plan. Synectics offers all employees who are 21 years of age or older the opportunity to invest in the 401(k) Plan on the first enrollment date that is at least 30 days after employment begins. Enrollment dates are each January 1st, April 1st, July 1st, and October 1st. Technical Certification Bonus: Synectics is pleased to award its employees a bonus of up to $500 for an approved professional certification. In determining the bonus amount, Synectics will consider the cost of the test(s) for any certification relating to your current position, achieved during your employment with us. Only one Certification Bonus per calendar year may be awarded per employee. Only current, active employees will be eligible to receive this bonus. It will be awarded 90 days after the Synectics office has received documentation confirming the successful completion of the certification. Synectics is an equal opportunity employer.