Business Intelligence Developer
Business Intelligence Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Design and develop data ETL routines to integrate data from disparate source systems into an integrated business intelligence environment including defining source-to-target mappings business rules and other required data transformations
Develop dashboards and reports using Microsoft Power BI SSRS or other BI technologies.
Ensuring the quality of the data through utilization of process and technology
Participation in actively formulating and maintaining both a data catalog and a data dictionary
Providing data marts and data lakes to support business initiatives
Conduct business analysis to define the required data to fulfill on business requirements
Meet with Customers to understand business problems and questions exploring options to model data driven platforms used for analyzing answers
Become a trusted partner for Customers who translates business problems into analysis; then helps interpret the analysis into actionable steps
Actively participate in the design development and maintenance of complex BI Dashboards Reports Queries and integrated applications
Manage other resources to complete the development work needed to deliver the required product to the client
Analyze and share results with users to ensure content meets business requirements; and train users to facilitate adoption and understanding of BI reports and tools
Proactively initiate projects and analysis targeting opportunities for revenue growth risk mitigation and operational efficiency
Provide technical support of the Microsoft Platform Software
Comprehensive data analysis and design experience with full knowledge of data warehouse & data mart methodologies as well analysis modeling
Lead solution and design sessions for end to end for data integration efforts
Deliver technical innovations in support of business growth; progressing ideas from concepts to full scale implementation with focus on flexibility reuse and overarching extensibility.
Requirements
Qualifications:
5-7 years of experience in the Microsoft business intelligence platform including SQL Server databases SQL Server Integration Services Power BI/SSRS & SSAS and/or Azure Cloud Services
5-7 years of building and maintaining data integration processes
5-7 years supporting large scale data integration and ETL processes including daily monitoring and operational support
Strong experience working in data warehouse architectures
Experience building formatted paginated reports using MS SSRS
Experience with PowerBI dashboard development or experience with one or more BI reporting tools like QlikView/QlikSense Tableau Micro Strategy Open Source reporting is a plus
Experience with the PowerBI Cloud Services
Significant experience in the design and development of data integration solutions and data analysis
Expert in automating data integration routines
Expert in optimization of data integration processing and database design
Expertise in designing and developing dashboards reports analytics and data visualization solutions.
Experience in creating dimensional data models across multiple subject areas is a plus
Strong command of MS Excel
Experience and familiarity with processes platforms and stakeholders
Excellent written and oral communication skills
Excellent technical documentation skills
Ability to work independently in a fast paced environment with minimum over sight. You would own building a future proof integration architecture to solve integration needs across projects.
Balances a variety of competing goals in a design including project time scope and budget constraints and system performance message verbosity and loose coupling.
Optional:
Some experience with advanced analytics tools and languages such as R Python Scala SAS and others
1-2 years experience working in a DevOps environment and understanding of the associated tools and capabilities and value of using this approach
1-2 years of cloud-based data platforms (such as Azure AWS Snowflake )
1-2 years using CI/CD (continuous integration/continuous deployment) methods for deployment
1-2 years using cloud data integration pipelines
Experience setting up and managing Power BI Report server is a plus.
Experience working in data lakes and reference data environments
We strongly believe in the value of diversity and creating supportive inclusive environments where our colleagues can succeed. As such ***** is proud to be an Equal Opportunity Employer. We do not discriminate on the basis of race color ancestry national origin religion or religious creed mental or physical disability medical condition genetic information sex (including pregnancy childbirth and related medical conditions) sexual orientation gender identity gender expression age marital status military or protected veteran status citizenship or other protected characteristics under federal state or local law.
About our Technology Team:
Technology is enhancing the ways we operate at every level of the firm and the ***** Technology team is the driving force for that. Unlike your average IT team you won t find us simply administering technology but serving as strategic advocates to deliver solutions that bring measurable positive change for all our clients.
Because we pivot fast and always embrace new perspectives we re creating a culture of technology across every department based on value and a true understanding of the business. By serving as partners to leaders throughout the organization rather than as a resource our Technology employees are accountable to each other and themselves to create a tangible impact based on results.
The way we see it there is always something new we can start stop doing or reimagine. With this mentality we dont let perfection get in the way of innovation. If you have a theory you ll have the autonomy to innovate iterate and collaborate to see it through. Because to us there are no bad ideas only avenues for us to grow as a team and individuals.
Education
=
Employment Type
Full Time
