What are the responsibilities and job description for the Database - Power BI SME (Sr.) position at Quadrant, Inc.?
Power BI SME
Washington, DC
Pay From: $160,000 per year
MUST:
Active Top Secret
Potential for SCI/Poly
12 years professional experience
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.
Agile/ Scrum Project experience preferred
Bachelor's degree in Data Science, Computer Science, or a related field.
DUTIES:
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.
Quadrant is an affirmative action/equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, status as a protected veteran, or status as an individual with a disability. "Healthcare benefits are offered to all eligible employees according to compliance mandated by the Affordable Care Act".
Quadrant, Inc. is an equal opportunity and affirmative action employer. Quadrant is committed to administering all employment and personnel actions on the basis of merit and free of discrimination based on race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or status as an individual with a disability. Consistent with this commitment, we are dedicated to the employment and advancement of qualified minorities, women, individuals with disabilities, protected veterans, persons of all ethnic backgrounds and religions according to their abilities.
Washington, DC
Pay From: $160,000 per year
MUST:
Active Top Secret
Potential for SCI/Poly
12 years professional experience
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.
Agile/ Scrum Project experience preferred
Bachelor's degree in Data Science, Computer Science, or a related field.
DUTIES:
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.
Quadrant, Inc. is an equal opportunity and affirmative action employer. Quadrant is committed to administering all employment and personnel actions on the basis of merit and free of discrimination based on race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or status as an individual with a disability. Consistent with this commitment, we are dedicated to the employment and advancement of qualified minorities, women, individuals with disabilities, protected veterans, persons of all ethnic backgrounds and religions according to their abilities.
Salary : $160,000
