Lorven Technologies
Senior Power BI/SQL Developer - Washington, DC - Hybrid
Lorven Technologies, Washington, District of Columbia, us, 20022
Job Title: Senior Power BI/SQL DeveloperLocation: Washington, DC - HybridDuration: 12+ Months contract
Position Responsibilities:Conduct analysis of data maintained in multiple different sources and identify processes to validate the information.Coordinate the CFSA data management 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 LakeDeployment of reportsMust have:
11-15 years Hands on Report Development and SQL Query11-15 years Software Development Lifecycle experienceHands-on skill developing complex reports using PowerBI11-15 years MS Office/PowerPoint experienceAzure Data Services ExperienceAgile Process EnvironmentBachelor's degree in IT or related field or equivalent experienceNice to have:
PL/SQL hands on experienceBusiness Intelligence (Cloud Base)
Position Responsibilities:Conduct analysis of data maintained in multiple different sources and identify processes to validate the information.Coordinate the CFSA data management 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 LakeDeployment of reportsMust have:
11-15 years Hands on Report Development and SQL Query11-15 years Software Development Lifecycle experienceHands-on skill developing complex reports using PowerBI11-15 years MS Office/PowerPoint experienceAzure Data Services ExperienceAgile Process EnvironmentBachelor's degree in IT or related field or equivalent experienceNice to have:
PL/SQL hands on experienceBusiness Intelligence (Cloud Base)