Power BI Developer/ Architect

Power BI Developer/ Architect

02 Nov 2022
New York, New york city, 10008 New york city USA

Power BI Developer/ Architect



A NYS agency located in New York, NY is looking for a Power BI Developer/ Architect for a 12 month contract.

Please note that this position may initially allow for work to be performed remotely. However, consultant will be required to work on-site/in-office once COVID restrictions are lifted.

Requirements and skills



  • The consultant must be proficient and have hands-on experience with Oracle DB release 9i or higher (5+ years' experience);

  • Must be proficient and have hands-on experience with ERwin development environment (3+ years' experience);

  • Must be proficient and have hands-on experience with Oracle P/L SQL (Oracle 8i, or preferable 9i) with 3+ years' experience;

  • Must be experienced with TOAD (Tool for Oracle Application Development) (3+ years' experience)

  • 6+ years' experience: Data modeling and prototyping, Database search strategies, Human Resources, Computer Science, Data Management, Analyzing and synthesizing qualitative data, PeopleSoft, Power BI, SQL, SQL Query Manager, Data Analysis, Data Cleansing Techniques, Data Entry, Data Integrity, Data Management, Data Modeling, Data Quality Analysis, Data retrieval, customization and archiving of data, Data Storage, Data Warehousing, Database management, Relational database design and management of relational databases, Structured Query Language (SQL), Ability to create accurate math models from scan data, Data Lineage Analysis and PeopleSoft SQR


Responsibilities


  • Design, build and support Oracle DBS using ERwin

  • TOAD and SQL+ development tools

  • Work closely with applications developers on new development of ColdFusion/Oracle systems

  • Expert in building Stored Procedures, DB Packages, Triggers and Views

  • Provide additional technical assistance with custom development and support activities as directed by the designated agency Project Manager. This includes knowledge transfer in the areas of Oracle DBA, Oracle SQL and PL-SQL programming and performance monitoring

  • Assist agency staff with learning how to develop and implement Oracle SQL and Oracle SP

  • Working knowledge of Microsoft Power BI desktop and Online Service

  • Hands-on experience in data preparation, data gateway and data warehousing projects

  • Create dashboards and interactive visual reports using Power BI

  • Experience in building Reports in Power BI Desktop and Power BI Paginated Reports

  • Implementing and supporting embedded Power BI and Power BI services (using .NET or JavaScript)

  • Experience setting up automated data refresh of dashboards

  • Experience implementing row level security on data and have an understanding of application security layer models in Power BI

  • Experience in Power BI Service, managing workspaces, and Power BI Data Flows

  • Cube/PowerBI DAX Developer with cube processing, deployment experience

  • Experience writing complex DAX expressions

  • Proficient in writing SQL, DAX and M. Powershell scripting a plus.

  • Strong understanding of the Vertipaq engine and/or DAX studio and associated storage engine and formula engine queries.

  • Developing visual reports, dashboards and KPI scorecards using Power BI desktop

  • Experience in Microsoft Azure database and data storage technologies, Azure Data Factory

  • Development knowledge on Dynamics platform/Power Apps

  • Analyze current ETL process and Reports in Oracle Discoverer and migrate the report into Power BI

  • Experience in building Custom Visuals using R is a plus

  • Experience with Data bricks, Apache Spark and Python is a plus

  • Seeking a highly skilled Power BI Developer/Architect with strong business intelligence (BI) and modeling skills to support enterprise reporting requirements.


About us: QED National is a leading IT consulting, solutions and staff augmentation firm, serving both the public and private sectors for over 28 years. Headquartered in midtown Manhattan, QED National's team is comprised of the brightest minds in the industry with the skills to solve the most complex technological problems.

Related jobs

Job Details

Jocancy Online Job Portal by jobSearchi.