Job Title: Power BI Developer
Experience Level: 5-10 years
Skills & Job Responsibilities
Mid-Level Power BI Developer Local to MI and willing to come to office 3 times a week.
The Power BI resource will generally provide the following services at the direction of Flagstar:
- Collaborate with business SMEs and understand business requirements on business intelligence and design optimal solutions. Develop Power BI Reports.
- Design effective and efficient data warehouse (DW) schema in Oracle. Methodically develop extract-transform-load (ETL) processes utilizing Informatica Intelligent Cloud Services (IICS) tools by connecting to different data sources to populate the DW per the requirements.
- Design, develop, and build mockups, reports, and dashboards using business intelligence and data visualization tools, such as Microsoft Power BI.
- Develop the building of Analysis Services reporting models.
- Developing visually appealing reports, key performance indicators / key risk indicator (KPI/ KRI) scorecards, and dashboards using Microsoft Power BI desktop.
- Connecting data sources, importing data, and transforming data for Business intelligence. Thinking analytically for the translation of data into informative reports and visuals.
- Implementing row-level security on data along with an understanding of application security layer models in Microsoft Power BI.
- Making DAX queries in Power BI desktop using SQL.
- Using advanced-level calculations on the data set.
- Developing supporting documentation.
- Developing tabular and multidimensional models that are compatible with data warehouse standards; and
- Conduct code reviews by the team processes and standards.
- Providing very good communication skills will allow for discussions around the requirements gathering and communicating with the project team.
Required Power BI developer requirements, qualifications & skills:
- Proficiency in Power BI development, including report and dashboard creation (7+ years).
- Strong understanding of data modeling and data visualization concepts (7+ years)
- Experience with SQL for data manipulation and extraction.
- Knowledge of Data Analysis Expressions (DAX) for creating calculations. Creating complex DAX calculations and measures to support data analysis.
- Familiarity with data warehouse concepts. Troubleshooting and resolving issues in Power BI reports.
- Strong technical writing skills.
- Strong Excel skills, including visual basic, Power Query, pivot tables, pivot charts, and advanced formulas
Our Commitment to Diversity & Inclusion:
Did you know that Apexon has been Certified™ by Great Place To Work®, the global authority on workplace culture, in each of the three regions in which it operates: USA (for the fourth time in 2023), India (seven consecutive certifications as of 2023), and the UK.Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law. You can read about our Job Applicant Privacy policy here Job Applicant Privacy Policy (apexon.com)
Our Perks and Benefits:
Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience and provide care and support for you and your loved ones. As an Apexer, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well-being benefits and assistance.
We also offer:
o Health Insurance with Dental & Vision
o 401K Plan
o Life Insurance, STD & LTD
o Paid Vacations & Holidays
o Paid Parental Leave
o FSA Dependent & Limited Purpose care
