Leverages all aspects of BI technologies and architecture such as delivery mechanisms (i.e. portals, dashboards, OLAP), data model/architecture, data integration/ETL and reporting tools
Integrates data from various sources including on system and off system sources
Analyzes data, design and develop complex custom reports and dashboards using in-house reporting platform with little or no supervision
Validates report results against requirements for consistency and accuracy
Troubleshoots and analyzes data issues within reports
Responsible for the efficient, accurate, and secure acquisition, integration, provision, and exchange of the enterprise data
Develops and maintain other BI and analytics standards for BMI including data sources and a data dictionary
Monitors and administers automated and manual data integration and ETL jobs to verify execution and measure performance
Provides technical leadership on all assigned projects to ensure delivery of valuable solutions in alignment with BMI’s business needs, technological platform architecture, and overall SDLC. This includes understanding business requirements, adhering to technical architecture standards, recommending technical design, monitoring development and testing efforts, resolving technical issues, making technical decisions, and supporting deployment of the product
Participate in all phases of managing the Application Lifecycle Management: requirements analysis, development, testing, and implementation. Participate in technical logic and design discussions
Identify the appropriate software architecture based on the requirements and on Enterprise Architecture guidelines
Lead the review process for software architecture documents
Contribute to the review and analysis of business requirements
Integrate internal and external product design into a cohesive user experience
Work with UX/UI to improve and refine product visual design and consistency
Create, maintain, and present technical documentation to different audiences and levels
Perform resource, technical and risk assessments
Work with other development, architecture, and product development teams to ensure delivery of product
Work with 3rd party vendor on technical design/specifications, development, testing and deployment to ensure the product meets the requirements
Assist in the timely completion of assigned development projects
Prepare required documentation, including project plans, software program, system architectural design, and user documentation
Assist in the estimation of personnel requirements, cost, and time for development projects
Regularly updates management of status
Regular attendance
Other duties as assigned
Supports our BMI Core Values and cultivates a culture of diversity and inclusion
Experience in designing, developing, testing, and implementing ETL solutions using enterprise ETL tools preferred. Data Bricks and Azure Data Factory preferred
Experince with Power BI preferred
Proficient with Data Warehouse technologies and concepts such as dimensional modeling, aggregating and cube development
Proficiency in Team Foundation Server/VSTS is preferred
Experience with industry standard communication protocols; REST, JSON, XML, and SOAP
Prefer experience in Azure Data Factory, Databricks, Azure Hyperscale SQL Database, Azure Blob Storage, and Power BI from the Microsoft Power Platform
Experience with Agile software development methodologies
Must possess ability to work independently in a fast-paced, dynamic environment
Must be a self-motivated team player who understands the importance of teamwork, collaboration, and open communication, including a willingness to occasionally work in a pair-programming environment
Must possess the ability to create and maintain artifacts including use cases, data flow charts, process flow diagrams, software requirements document, functional specifications document, etc.
Must possess strong analytical, problem solving and technical documentation skills
Must possess ability to effectively present information and respond to questions
Experience with distributed systems or a large enterprise background is preferred
Must have an excellent understanding and hands-on experience with design and development best practices
Detail orientation and strong attention to detail
Must have progressive achievement in job history
Must be willing to work overtime, including weekends, when required
Understanding of SDLC automation concepts such as continuous integration
Must possess ability to implement strong unit and service-level tests