About the Firm R.F. Wilkins Consultants, Inc. is a New York-based Business Development and Management Consulting firm. We partner with non-profits, small businesses, government agencies, and corporations to meet their development and expansion needs. Services under our umbrella include fundraising and capital sourcing, project management and technical assistance, marketing and branding, stakeholder engagement, and compliance. We are a growing and nimble firm working strategically to meet our clients’ goals. We have a close-knit team working in a fast-paced environment. Our staff are our greatest asset, and we encourage flexible work and continuous growth opportunities. About the Role Our client is looking for a freelance Power BI developer to create and update BI reports and communicate actionable insights to improve corporate decision-making. You should be able to manage data, evaluate its results, and display them strategically by using visualization tools, DAX queries, charts, and relationships. The role calls for part-time and as-needed development support, generally ~3-5 hours per week but could be more from time to time as the need arises. ‍This role requires an extensive understanding of modeling, databases, data warehousing, data integration, and the technical elements of business intelligence technologies. You should also be able to read and evaluate product, market, and share trends and have a strong technical understanding of business trends. Strong communication, organizational, and analytical abilities are required. Roles and Responsibilities • Formulate automated reports and dashboards using Power BI and other reporting tools • Understand business requirements to set functional specifications for reporting applications • Exhibit a foundational understanding of database concepts such relational database architecture, multidimensional database design, and more • Design data models that transform raw data into insights by understanding business requirements in the context of BI • Develop technical specifications from business needs and choose a deadline for work completion • Make charts and data documentation that include descriptions of the techniques, parameters, models, and relationships • Developing Power BI desktop to create dashboards, KPI scorecards, and visual reports • Establish row-level security on data and comprehend Power BI's application security layer models • Examine, comprehend, and study business needs as they relate to business intelligence • Design and map data models to transform raw data into insightful information • Create dynamic and eye-catching dashboards and reports using Power BI • Make necessary tactical and technical adjustments to enhance current business intelligence systems • Integrate and alter data and connect to data sources for business intelligence ‍ Requirements and Skills • BS in computer science or information systems along with 2-5 years of relevant work experience • Strong communication skills and ability to effectively explain requirements to internal and external teams • Exceptional analytical thinking skills for converting data into illuminating reports • Knowledge of data warehousing, data gateway, and data preparation projects • Ability to articulate, represent, and analyze solutions with the team while documenting, creating, and modeling them • Familiarity with the tools and technologies used by the Microsoft SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX • Detailed knowledge and understanding of database management systems, OLAP, and the ETL (Extract, Transform, Load) framework • Awareness of BI technologies (e.g., Microsoft Power BI, Oracle BI) • Expertise of SQL queries, SSRS, and SQL Server Integration Services (SSIS) • Knowledge of executing DAX queries on the Power BI desktop • Comprehensive understanding of data modeling, administration, and visualization • Capacity to perform in an atmosphere where agility and continual development are prioritized