Power BI Developer (Financial Reporting)

TECKpert seeks to hire a Power BI Developer to support our client, a state government agency in Tallahassee, FL. The role involves building Microsoft Power BI dashboards and paginated reports to replace legacy financial data extract reports as the agency prepares to transition to a modernized statewide accounting system. The developer will work directly with IBM DB2 data sources, convert legacy mainframe and WebFOCUS queries to T-SQL, design dataflows, and partner with business users and database administrators to turn raw financial transaction data into actionable management decision support.

Job duties include, but are not limited to:

• Analyze the current data environment and data structures to determine necessary transformations prior to developing dashboards.
• Partner with management to develop an overall reporting roadmap for the organization.
• Analyze existing reports and work with business users to determine how reports can be improved based on current business needs.
• Work with developers and end users to automate data transformation, reducing reliance on pivot tables and analysis in Microsoft Excel.
• Read and document WebFOCUS and Mainframe FOCUS queries and convert them to T-SQL queries.
• Collaborate with database administrators to create database views and stored procedures that facilitate Power BI report development.
• Create dataflows in Power BI and provide administration of the Power BI dedicated workspace.
• Analyze financial data and make recommendations to improve the data model of financial systems.
• Train comptroller office staff on using Power BI reports., To ensure the integrity of our recruitment process, please note the following requirements:
• Resume Formatting: Ensure your resume is clearly formatted and includes all relevant details. Applications with poorly formatted resumes or missing critical information will be rejected without review.
• Verification Information: To help verify your identity, please include a link to your LinkedIn profile, GitHub repository (for technical roles), or other professional profiles that can substantiate your experience and verify your identity.
• Fraudulent Submissions: We take candidate verification seriously. Submitting fraudulent information, fake resumes, or any attempt to deceive will result in immediate disqualification from the process. Fraudulent applications may also be referred to the appropriate authorities for further action.

Important Application Notice:

To ensure the integrity of our recruitment process, please note the following requirements:

• Resume Formatting: Ensure your resume is clearly formatted and includes all relevant details. Applications with poorly formatted resumes or missing critical information will be rejected without review.
• Verification Information: To help verify your identity, please include a link to your LinkedIn profile, GitHub repository (for technical roles), or other professional profiles that can substantiate your experience and verify your identity.
• Fraudulent Submissions: We take candidate verification seriously. Submitting fraudulent information, fake resumes, or any attempt to deceive will result in immediate disqualification from the process. Fraudulent applications may also be referred to the appropriate authorities for further action.

Do you have experience in Scrum?, Do you have a Bachelor's degree?, * 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.

• Minimum of 3 years of experience in Business Intelligence.
• At least 2 years of experience developing dashboards and reports in Microsoft Power BI.
• Experience developing paginated reports in Power BI.
• Experience with IBM DB2 databases.
• 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, purchasing, 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, PowerPoint, and Teams.
• Understanding of how to implement solutions with multiple data sources.
• Knowledge of mainframe flat files.
• Knowledge of the Scrum framework.
• Preferred: Experience with Oracle Data Warehouse, knowledge of mainframe programming languages, knowledge of financial systems such as an ERP, and experience with WebFOCUS.

Working with us

Pulled from the full job description

• Vision insurance
• Dental insurance
• Life insurance
• Flexible schedule, This opportunity is for a full-time position with possible extensions and pay commensurate with experience up to $145,000 per year. Medical, dental, vision and life insurance available after 30 days of hire.

Founded in 2009 and headquartered in beautiful Miami, FL, TECKpert is a tech consulting and staff augmentation firm. At TECKpert, we offer a contingent workforce built for any size digital transformation project. Experts in design, development, IT, analytics and marketing, provide innovative digital solutions to achieve success in our new economy. Our leaders identify the technical talent best suited to bolster our client's capabilities, across all industries, including, healthcare, government, finance, legal, real estate, and startups.