Dexian Government Solutions is recruiting for a Microsoft Power BI Developer to support our USPS-OIG contract in Arlington, VA.Position Description:- Primary focus on business intelligence and reporting technologies/methodologies
- Identify data to clean, transform, and load into data models
- Create data models, establish relationship cardinality and cross-filter direction, and build complex measures
- Visualize data models by creating reports and dashboards
- Assist in the delivery of quality solutions using Microsoft Business Intelligence tools (Power BI) and related technologies
- Partner with OIG customers and OCIO technical team members to assist with requirements definitions, solution designs, technical architecture, and delivery
- Work collaboratively with team members including project managers, solution architects, and business analysts
Position Requirements- Implement solutions using Microsoft Power BI tool suite and related technologies
- 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
- 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
- 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
- Author and oversee design documents for approved projects
- 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
- Eager to contribute to a team-oriented environment
- Able to work creatively and analytically in a problem-solving environment
- Excellent communication and interpersonal skills
Experience- Preference given to candidates who have demonstrated experience with medallion architecture, Databricks, and/or experience with sensitive law enforcement and case management data
- 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:
Education and Certifications- 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
BenefitsOur robust benefits package includes 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 and much more!
