Power BI Developer with Strong SSRS

Title: PowerBI Developer Location: Middletown, CT 06457 Remote / Hybrid Schedule: hybrid – 2 days/week on site (Mondays + Wednesdays) Hours | shift | On Call | Time zone: First shift, EST Team: Application Development Team Size: ~25 Why Open: Moving SSRS Reports to PowerBI Eligibility: USC, GC, GC\_EAD, OPT-EAD H4-EAD & L2S only Duration: 1 year Suggested Pay Rate: $50-$55/hr. on W2 Interview Process: 1 round in person interview References Required upon Submittal: 1 Professional reference (Name, Title, Company, Email, LI, Phone) Must haves: • PowerBI Development 3+ years • SSRS development • Modify changes, work with SSRS reports directly, support + maintain SSRS with PowerBI development • Enterprise Data Warehousing experience • Passionate about complex data structures and problem solving • Ability to pick up new data tools and concepts quickly • Experience in data analysis including structuring data for analysis within Power B • Experience with data modeling, including designing data models within Power BI • Experience using Power BI, including creating reports, dashboards, and data visualizations from scratch • Experience with setting up infrastructure, security, and user management on a Power BI Server • Experience utilizing data security principles including implementing role-level and data-level security in Power BI to control data access • Experience communicating with stakeholders to explain insights derived from data using presentations and trainings • Experience with moderate to complex SSRS reports, Power BI reports, and Data Visualization Dashboards • Local to CT and able to come on site to Middletown Mondays + Fridays Nice to haves: • Tableau experience • Experience developing Reports using Transact Structured Query Language (T-SQL). • Writing ad-hoc SQL queries to support the operational needs of the agency. Req Qualification Notes: • Looking for a local strong PowerBI Developer • Some admin, mostly development • How to set up user groups, add privileges • BUT doesn’t need them setting up servers, has people doing that already • SSRS heavy and some ETL • Moving from Tableau + SSRS reports to PowerBI on prem • while also developing new reports in SSRS + PowerBI • Has SSRS reports (hundreds) • This role is purely long-term goal to get rid of SSRS problems • Support + Maintain SSRS while creating new reports in either SSRS/PowerBI • Has built a lot of SSRS reports which aren’t required - wants to move into PowerBI and when new requirements come, work with business & communicate to understand what they’re looking at • Give them options • Wants this person to be able to explain • This isn’t an SSRS type of report it’s a PowerBI type of report • Then start building them and come up with ideas • Building a lot of public facing/internal dashboards Other: • DMHAS PowerBI is on prem • DMHAS is not moving it to cloud ever • PowerBI comes with multiple levels of security • Viraj built PowerBI architecture layer • Knows how it should work • For every piece of data – they can find out who used it/who built it etc. • Understanding data/data security is very important