US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( -1 )
Post :- 22nd Mar 2024
Title:Sr. Power BI Developer
Location 100 Cambridge Street, Boston, MA- 100% ONISTE
Visa: No H1B
Start: ASAP
Duration: 6 Month possible extension
Interview Process: 1 Tech phone screens 1 Skype or face to face if local.
This position is with the Massachusetts Executive Office of Energy and Environmental Affairs (EOEEA). EOEEA is seeking a highly skilled Senior Power BI Developer with a basic understanding of data analytics concepts to join our team. The ideal candidate will be responsible for designing, developing, and maintaining Power BI solutions that support data-driven decision-making across the organization. This role requires high degree of expertise in Power BI development and a willingness to learn and grow in the field of data analytics and reporting.
This contract is a hybrid position and may have the opportunity to renew starting next fiscal year, July 1, 2024
Responsibilities/Experience/Qualifications:
Primary Responsibilities
Design and Develop Power BI Solutions:
• Design, develop, and maintain Power BI dashboards and reports to visualize data and provide actionable insights.
• Utilize Power BI features such as Power Query, DAX, and M language to manipulate and transform data for visualization.
• Optimize Power BI solutions for performance and usability, considering factors such as data volume and user requirements.
Data Analysis and Visualization:
• Use statistical methods and data visualization tools to analyze data, identify trends, and patterns.
• Create reports, graphs, and other visualizations to present and explain data to business stakeholders.
• Recommend new tools or technologies that can help streamline data analysis.
Data Management, SQL and Integration:
• Work closely with data engineers and analysts to ensure data accuracy, completeness, and consistency.
• Maintain data integration between systems, creating automated data feeds, and structuring data for use by the data warehouse.
• Develop and execute SQL queries to extract, transform, and load data from various sources.
• Utilize advanced SQL techniques, including complex queries, stored procedures, and functions, to manipulate and analyze data.
• Work with various database technologies, including T-SQL, PL/SQL, and others, to manage and manipulate data effectively.
Predictive Modeling and Analysis:
• Develop and refine predictive models that can be used to make informed decisions.
• Implement row-level security on data and understand application security layer models in Power BI.
• Hands-on experience in creating and deploying Power BI reports, analytics, and dashboard solutions, including design, development, deployment, data engineering, and data management projects and practices.
• Ability to work with machine learning algorithms to analyze data is a plus.
• Collaboration and Stakeholder Management:
• Collaborate with business stakeholders to understand their data requirements and translate them into effective Power BI solutions.
• Work with business users and technical teams to research, understand, and document technical specifications.
Continuous Learning and Development:
• Stay updated on the latest Power BI developments, best practices, and emerging trends in data analytics.
• Act as Power BI administration, manage, and troubleshoot premium capacity environment.
• Create, compile, and prepare management reports, graphs, and charts, including highly complex internally developed custom reports utilizing TSQL, Excel, Access, VBA, SSRS, and Power BI.
Adaptability and Team Collaboration:
• Ability to work independently as well as part of a data team in a fast-paced and dynamic environment.
Qualifications
• BS/MS in Computer Science, Data Engineering, Mathematics, Statistics, or related field.
• 5+ years of expert-level experience in Power BI development and administration.
• 4+ years of experience in SQL and T-SQL or PL/SQL programming.
• 3+ years of experience working with SSRS reports.
• 8+ years of relevant hands-on experience in the Business Intelligence domain, specializing in data analytics and reporting.
• Proficient in Power BI Desktop, with extensive hands-on experience in creating and deploying Power BI reports, analytics, and dashboard solutions, covering design, development, deployment, data engineering, and data management projects and practices.
• Proficiency in data modeling principles and techniques, statistical analysis, and predictive modeling techniques.
• Knowledgeable about data visualization best practices and design principles.
• Strong analytical skills, capable of utilizing statistical and data analysis tools to interpret data and identify trends and patterns.
• Deep understanding of relational database structures, advanced data concepts, theories, principles, and practices, including experience with various database platforms such as SQL Server, Oracle, Mongo, or No-SQL.
• Excellent communication skills for effectively conveying findings to both technical teams and business stakeholders.
• Attention to detail and ability to identify patterns in large and complex datasets.
• Preferred certification in Power BI or Tableau, with additional experience in QlikView or Looker considered advantageous.
• Ability to understand the perspectives of both the business and end-users and apply that understanding to solution proposals.
• Proficient in utilizing IT best practices and tools related to application support, implementation, and documentation.
• Experience working in an Agile development environment.
Top requirements
• 5+ years of expert-level experience in Power BI development and administration.
• 4+ years of experience in SQL and T-SQL or PL/SQL programming.
• Skilled in Power BI Desktop, adept at crafting and deploying reports, analytics, and dashboards, encompassing design, development, deployment, and data management.
• Proficient in data modeling, statistical analysis, and predictive modeling techniques, alongside a strong understanding of data visualization best practices and design principles