Lead Power BI Engineer/Architect at InfoVision

Job Title: Lead BI Engineer/Architect

Location: Dallas, TX

Duration: Long-term

Location: Dallas, Texas a must, Tuesday/Wednesday in the office- no exceptions

Qualifications:

1. 15+ years of experience in BI & Data Warehousing
2. Should have in depth knowledge on Power BI and atleast 6+ years of Power BI experience
3. Should have expertise in DAX language, T-SQL
4. Should have work experience in developing reports in Power BI report Builder
5. Should have experience in analyzing the M-language
6. Should have Microsoft Power BI Certification
7. Should have executed atleast 6+ Power BI projects
8. Should be proactive in client engagement and demonstrate excellent communication skills
9. Should have led a team of 15+ members and done business stakeholder management
10. Should have worked atleast 4 projects using Agile/SAFe methodology
11. Should have working experience on any DevOps tools like GitHub, Jenkins, etc
12. Should have written complex SQL queries for data analysis and visualization
13. Should have in depth understanding on Data Warehousing, Data Analysis, Data Profiling, Data Quality & Data Mapping
14. Should have cross global location experience and been part of a team of atleast 20+ members in a global delivery model
15. Should have experience in working with product managers, project managers, business users, applications development team members, DBA teams and Data Governance team on a daily basis to analyze requirements, design, development and deployment technical solutions

Responsibilities:

1. Analyze the requirements, data sources, profile data, segregate types of reports, understand & document any Data Quality issues
2. Analyze and map report functionality, visualization & metrics in order to visualize the reports and data in Power BI
3. Analyze and document schedule, triggers/events and row level security
4. Write complex SQLs to extract & format data for Power BI Dashboards
5. Analyze the existing user, user groups and access levels and create Power BI Workspaces and configure accesses
6. Perform dataflow, system and data analysis and develop meaningful and useful presentation of data in Power BI
7. Create design documents, Source to Target Mapping documents and any supporting documents needed for deployment/migration
8. Design, Develop and Test BI Dashboards & Reports
9. Build the reporting data model and help the data engineering team with creating views, SQL scripts
10. Write Unit Test cases, execute Unit Testing and document Unit Test results
11. Deploy BI Dashboards & Reports
12. Monitor & support the BI Dashboards/Reports post deployment
13. Use DevOps tools to version, push/pull code and deploy across environments
14. Support team during troubleshooting & debugging defects & bug fixes, business requests, environment migrations & other adhoc requests
15. Maintain and improve already existing processes
16. Ensure that the BI Dashboards & Reports are stable, secure, maintainable and highly available
17. Work with business in designing and delivering correct, high-quality data