• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 15th Feb 2024

Responsibilities:

We are looking to fill a Senior Power BI/SQL Developer role for the District of Columbia Government.

The ideal candidate is a DC Resident with 11+ years of hands-on Report Development and SQL Query experience, 11+ years of Software Development Lifecycle experience, and 4+ years of hands-on skill developing complex reports using PowerBI.

Executive Summary: 

Senior Power BI/SQL Developer with extensive experience in designing and developing reports using PowerBI and creating complex SQL queries. The Candidate must be able to work onsite 3 days a week.

Position Description: The Developer will be a member of the DevOps team that will be implementing a new comprehensive child welfare information system (CCWIS).

· The candidate must have excellent communication skills, both written and verbal.

· The candidate will work closely with social workers and system developers to identify contributing factors to data quality issues and design processes to eliminate them.

· The candidate will also be a critical resource for overseeing data conversion from the legacy system to its new system according to the project schedule.

Position Responsibilities:

· Conduct analysis of data maintained in multiple different sources and identify processes to validate the information.

· Coordinate the CFSA data management governance structure, perform required analysis task and support CFSA staff in implementing recommendations.

· Gather and translate business requirements into detailed, production-level technical specifications, creating robust data models, data analysis features and enhancements.

· Collect requirements for reports from program staff, prototype reports and work with other vendors to deploy reports using the CFSA 365Dynamics platform.

· Write complex data joins to establish data measures across multiple tables.

· Modify existing reports and/or develop new reports by analyzing databases, data sources, and structures for the benefit of Users. Perform QA analysis on reports for accuracy and reports meets the intended business needs.

· Manage Azure Data Services including Synapse/Synapse Links, Azure SQL Pool, Data Lake

· Deployment of reports

 
General skills (must have):

11-15 yrs. Hands on Report Development and SQL Query 10+ years of experience

11-15 yrs. Software Development Lifecycle experience 10+ years of experience

Hands-on skill developing complex reports using PowerBI 4 year(s) of experience

11-15 yrs. MS Office/PowerPoint experience 10+ years of experience

Azure Data Services Experience 2 year(s) of experience

Agile Process Environment 2 year(s) of experience

 
General skills (nice to have):

PL/SQL hands on experience 2 year(s) of experience

BUSINESS INTELLIGENCE (CLOUD BASE) 2 year(s) of experience

 
Language skills (must have):

English Native or bilingual proficiency
Experience required:

- **Skill/ Required/ Desired/ Amount of Experience** 11-15 yrs. Hands on Report Development and SQL Query/ Required/ 11 Years 11-15 yrs. Software Development Lifecycle experience/ Required/ 11 Years Hands-on skill developing complex reports using PowerBI/ Required/ 4 Years 11-15 yrs. MS Office/PowerPoint experience/ Required/ 11 Years Bachelor’s degree in IT or related field or equivalent experience/ Required/ 15 Years Azure Data Services Experience/ Required/ 2 Years PL/SQL hands on experience/ Highly desired/ 2 Years BUSINESS INTELLIGENCE (CLOUD BASE)/ Highly desired/ 2 Years Agile Process Environment/ Required/ 2 Years

 
Additional job information:

- **Minimum Education/Certification Requirements:** Bachelor’s degree in IT or related field or equivalent experience