BI Developer (SSIS / ETL, T-SQL, Power BI)
The scope of work includes small system enhancements to major system projects. Applications may include custom developed software, commercial packaged software, or open-source software. Software may consist of on premise applications, cloud-based software and services, hybrid configurations, integration tools, or business workflow tools.
Create and maintain documentation of all development activity. Act as a key contributor in a complex team environment with multiple departments, vendors and functions. May lead teams or projects while sharing your expertise
Responsibilities: -
Produce intelligence reports (obtain information from internal and external sources, assess the value and provide actionable insight). -Work on ad-hoc requests and produce the required deliverables as mandated by the requests.-Responsible for data quality both for the raw data as well as the integrity of the calculations used for Measures-Analyze and troubleshoot complex data cleansing, data integration, and data warehouse system issues, identify the reasons for problems, failures and malfunctions and develop optimal solutions.-Monitor data integration and reporting anomalies and make adjustments as required.-
Analyze requirements/ user stories and collaborate with internal teams to produce software design and architecture-Perform all technical aspects of software development for assigned applications including, developing prototypes, writing new code / API's, test and deploy applications, revise, refactor and debug existing applications-
Function as an active member of an agile team through consistent development practices (tools, common components, and documentation)-
Conduct integration tests as defined in the test specifications, including event logging and reporting of results-
Perform unit and assembly testing of software components including the design, implementation, evaluation, and execution of unit and assembly test scripts-
Conduct code reviews and tests of automated build scripts-
Debug software components, identifies, fixes and verifies remediation of code defects