Microsoft Power BI Developer
About The Position
Dexian Government Solutions is recruiting for a Microsoft Power BI Developer to support our USPS-OIG contract in Arlington, VA. The primary focus of this role is on business intelligence and reporting technologies/methodologies. Responsibilities include identifying data to clean, transform, and load into data models, creating data models, establishing relationship cardinality and cross-filter direction, and building complex measures. The developer will visualize data models by creating reports and dashboards, and assist in the delivery of quality solutions using Microsoft Business Intelligence tools (Power BI) and related technologies. This role involves partnering with OIG customers and OCIO technical team members to assist with requirements definitions, solution designs, technical architecture, and delivery, as well as working collaboratively with team members including project managers, solution architects, and business analysts.
Requirements
- Experience with one or more data technologies (e.g., Oracle, SQL Data Warehouse, SQL Server, etc.) and a willingness to learn how to leverage these technologies to improve business intelligence
- Proficient in developing complex of Data Analytics Expressions (DAX) and M (Power) Queries
- Experience with developing interactive dashboards -e.g., parameters, actions, navigation -for ease-of-use
- Experience creating dataflows or datamarts
- Experience with designing composite models
- Experience with applying roles and Row Level Security (RLS) to Reports, Apps and workspaces
- Experience with report builder and developing paginated reports
- 4+ years of progressive experience in business intelligence and/or information management
- 2+ years of experience with data visualization and implementing high-value solutions; experience performing administrative activities across multi-environment infrastructures
- 2+ years of experience working in a client-facing technical role
- Expert knowledge of data management, business intelligence and analytics concepts including: Extract, transform, load (ETL), Data warehousing, data marts, data stores, and cubes, Data quality and profiling, Data governance, data management, and metadata management, Data visualization, dashboard design / implementation, reporting, self-service BI, data KPIs, and scorecards, Predictive, prescriptive, and descriptive analytics
- Proficiency in one or more languages like: SQL, SAS, R, Python
- Degree in Computer Science, Information Technology, Business or related field OR possess a PL-300 Microsoft Power BI Data Analyst Certification or equivalent
- NACLC Public Trust Required to Start
- Customer approval, suitability to hold a public trust and successful completion of a preemployment background screening.
Nice To Haves
- Demonstrated experience with medallion architecture
- Demonstrated experience with Databricks
- Demonstrated experience with sensitive law enforcement and case management data
Responsibilities
- Implement solutions using Microsoft Power BI tool suite and related technologies
- Develop complex Data Analytics Expressions (DAX) and M (Power) Queries
- Develop interactive dashboards (e.g., parameters, actions, navigation) for ease-of-use
- Create dataflows or datamarts
- Design composite models
- Apply roles and Row Level Security (RLS) to Reports, Apps and workspaces
- Use report builder and develop paginated reports
- Leverage database systems including data warehouses, data marts, and models needed for business, financial, and operational analysis and/or reporting
- Develop high performing, reliable, and scalable solutions
- Optimize performance on new and existing data models
- Clearly communicate technical details to business and management staff
- Perform data analysis which supports and enhances OIG information management systems and services
- Develop, publish, and schedule reports, dashboards & scorecards, data exploration, and visual analytics using existing and emerging technologies and tools
- Provide meaningful feedback and coaching of other team members in the use of Microsoft Power BI and related technologies
- Provide insight and recommendations on new and emerging technologies and concepts to OCIO team members
- Contribute to a team-oriented environment
- Work creatively and analytically in a problem-solving environment
- Author and oversee design documents for approved projects
Benefits
- Open Paid Time Off
- 11 Federal Paid Holidays & 5 Paid Sick Days
- Company-paid Life/AD&D
- Company-paid Short Term and Long-Term Disability
- Health Insurance with Company Contribution
- 401k Plan with Company Match
- Employee Recognition Program
- opportunity for Employee Referral Bonus
- opportunity for annual Performance Bonus
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
Associate degree
