Power BI SME

Position: Power BI Subject Matter Expert

Location: Onsite (Washington, DC)

Clearance: Top Secret (Potential for SCI/CI Poly)

About Us:  

MirLogic Solutions Corporation is a small business founded in 2008 and located in Alexandria, Virginia. MirLogic brings more than 30 years of multidisciplinary IT experience, technical expertise, and genuine leadership to each project.   

We are committed to our clients' successes, and we work closely with each client throughout the life of a project. Our dedication enables us to focus on our client’s need and deliver innovative IT solutions that truly address the challenges they face. MirLogic draws on the significant experience of highly skilled management and information technology consultants who can provide organizations with the ability to grow, adapt and transform to the target state. 

At MirLogic we offer Medical, Dental, Paid Time off, Holiday pay, Short- and Long-Term Disability, Life Insurance, 401K and a Commuter Expense.  

Job Description: 

• Collects and analyzes BI end-user requirements and evaluates the feasibility of these requirements from a technical perspective to derive software designs and performance solutions.
• Design, implement, execute, and debug manual test cases and automated test scripts using a variety of testing techniques.
• Strong data analysis skills and the ability to track a data element from source to transformation to target.
• Designs and develops relational and multidimensional data models and optimizes the data-mining performance function including the use of data modeling tools, preferably Erwin.
• Creates and implements BI reporting solutions, ETL solutions using best practices and methodologies; identifies root causes of issues with data quality and other related issues.
• Designs and codes new software or enhances existing software and integrates into new or modified systems and/or operational environments.
• Works with a reporting team optimizing the ETL/data pipeline process to ensure that business requirements are met.
• Secure sensitive content to align with regulatory and legal requirements.
• Documents all phases of work including gathering requirements, database diagrams, source to target mappings and other program technical specifications using current specified design standards for new or revised solutions.
• Mentors junior staff.
• Provide on-call production support on a rotating basis.

Required Qualifications: 

• Bachelor’s degree in Data Science, Computer Science, or a related field.
• 7 years of related experience as a Power BI Developer with an excellent track record.
• Proficient with Power BI and Power Apps.
• Experienced in writing complex statements, scripts, stored procedures, triggers, and views to implement business intelligence and data warehousing solutions. Experience in extracting data from heterogeneous data sources.
• Solid foundation in, and application of, data warehousing and reporting platform concepts with the ability to recommend solutions and drive best practices.
• Familiarity with Oracle, SQL Server, Cognos & Tableau (or similar) environments is a must.
• Experience with cloud data warehousing or data integration as a service.

Desired Skills:

• Agile/ Scrum Project experience preferred
• Experience working with a variety of stakeholders, from managers to technical resources, including the translation of business requirements into operational measures and reports.
• Natural positive communicator both within the internal team and stakeholders across the business.
• Able to work within a team but also able to drive work independently.