What are the responsibilities and job description for the Microsoft Power BI Developer position at Sligo Software Solutions Inc.?
Mandatory Skills
Candidates with prior state experience will be a great pick.
Education
Bachelor's Degree in a field of study related to technology or finance. Work experience can substitute on a year for year basis for the degree
Experience
This resource will primarily be tasked with performing Database (DB2, SQL Server, Oracle) planning and operational activities
- 14 Years of Total work experience.
- 7-8 Years of Relevant Experience as a Microsoft Power BI Developer.
Candidates with prior state experience will be a great pick.
Education
Bachelor's Degree in a field of study related to technology or finance. Work experience can substitute on a year for year basis for the degree
Experience
- Experience building dashboards and reports leveraging Microsoft Power BI
- Experience developing paginated reports in Power BI
- Strong SQL skills.
- Well versed in data governance best practices
- Familiarity with data management concepts such as Data Warehousing, Operational Data
- Stores, Data Lakes, and Master Data Management
- Experience creating reports presenting financial data such as general ledger data, purchasing, data, or revenue data.
- Familiarity with advanced data structures such as OLAP cubes and Star/Snowflake Schema.
- Knowledge of how Power BI integrates with other Microsoft tools such as Power Automate, Power Apps, Power Point, and Teams.
- Analytical thinking for converting data into relevant reports and graphics.
- Understanding of how to implement solutions with multiple data sources.
- Experience with IBM DB2 databases.
- Knowledge of Mainframe flat files.
- Knowledge of the SCRUM Framework.
- Experience with Oracle Datawarehouse
- Knowledge of mainframe programming languages, computer systems and supporting software.
- Knowledge of financial systems such as an ERP.
- Experience with WebFOCUS.
This resource will primarily be tasked with performing Database (DB2, SQL Server, Oracle) planning and operational activities
- Analyze the current data environment and data structures to determine if there is any transformation
- needs to occur prior to developing dashboards.
- Work with management to develop an overall reporting roadmap for the organization.
- Analyze existing reports and work with business users to determine how these reports can be
- improved based on current business needs.
- Work with developers and end users to automate data transformation, reducing the reliance
- on pivot tables and analysis in Microsoft Excel
- Read and document WebFOCUS and Mainframe FOCUS queries and convert them to T-SQL queries.
- Work with database administrators from the Office of Information Technology to create database views and stored procedures that will facilitate the creation of Power BI reports.
- Create dataflows in Power BI.
- Analyze financial data and make recommendations to improve the data model of financial systems.
- Provide administration of the Power BI dedicated workspace.
- Train staff from the office of the comptroller on using Power BI reports.