Dynamics 365 Reporting & ETL Developer
Job Description
Job title: Dynamics 365 Reporting & ETL Developer
Company: KBR
Job description: Title: Dynamics 365 Reporting & ETL Developer
KBR is a global provider of differentiated, professional services and technologies delivered across a wide government, defense and industrial base. Drawing from its rich 100-year history and culture of innovation and mission focus, KBR creates sustainable value by combining engineering, technical and scientific expertise with its full life cycle capabilities to help our clients meet their most pressing challenges today and into the future.
KBR employs approximately 29,000 people worldwide (including our joint ventures), with customers in more than 80 countries, and operations in 40 countries, across two synergistic global businesses.
- Government Solutions, serving government customers globally, including capabilities that cover the full lifecycle of defence, space, aviation and other government programs and missions from research and development, through systems engineering, test and evaluation, program management, to operations, maintenance, and field logistics.
- Sustainable Technology Solutions (‘STS’), featuring proprietary technology, equipment, catalysts, digital solutions and related technical services for the monetization of hydrocarbons, including refining, petrochemicals, ammonia and specialty chemicals, as well as inorganics. It also incorporates the energy transition offerings including onshore and offshore oil and gas; LNG/GTL; oil refining; petrochemicals; chemicals; fertilizers; differentiated EPC; maintenance services; floating solutions; program management and consulting services.
KBR is looking for a Dynamics 365 Reporting & ETL Developer based in our Leatherhead office.
Duties and Responsibilities
- Perform data analysis and modeling for development and maintenance projects; participate in the development of standards and procedures affecting Dynamics reporting.
- Provide development, support, maintenance, governance and technical architecture for the enterprise reporting tools which are currently Microsoft Power BI, Microsoft SSRS.
- Participate in the full life-cycle development process.
- Participate in walkthroughs of BI solutions including design, coding, testing and documentation reviews ensuring standards and quality are met; able to work independently or in a team setting; assist in the development of task lists, project plans, workload estimates and manages to these plans.
As a Technical Resource, you will play a pivotal role in supporting our analytics and reporting efforts within Dynamics 365, including but not limited to:
- Dynamics Specific Development, Maintenance, and Support: Developing, maintaining, and providing support for custom analytics and reporting solutions within the Dynamics 365 F&O environment.
- Supporting Overall Analytics and Reporting: Collaborating with cross-functional teams to identify reporting requirements, design dashboards, and generate insights that drive business decisions.
- SQL Experience for ETL: Designing and executing Extract, Transform, Load (ETL) processes using SQL to facilitate data integration and reporting.
- Azure Resource Procurement: Procuring resources in Azure Portal to support data storage, processing, and analytics.
- Azure Synapse Serverless Leveraging Azure Synapse Serverless for scalable and cost-effective data analytics.
- Data Lake, Lake House and Delta Lake Experience
- Familiarity with Data Lake and Delta Lake technologies for storing and processing large volumes of data.
- Experience with Data Verse
- Utilizing Data Verse to manage and integrate data within the Dynamics 365 ecosystem.
- Power BI and Paginated Report Builder
- Creating interactive Power BI reports and using Paginated Report Builder to design and deliver paginated reports.
- Supporting Consolidated Analytics: Aggregating and consolidating data from diverse sources to provide a unified and coherent view for comprehensive analysis.
- Data Migration: Assisting in data migration projects, ensuring seamless data transfer between systems, and maintaining data integrity.
- Additional duties and responsibilities may be added.
Other areas of responsibility:
- Performing and overseeing programming, quality assurance reviews, documentation, system deployment, training, and project setup/support
- Researching and recommending software technology direction
- Analysis and debugging of program errors for Production Incident tickets.
- Prepares development hours and cost estimates.
- Provides input to development project plans.
- Familiarity with and adherence to IT Development standards
- Provide administrative/user support for the reporting environments.
- Develop and maintain reports on as-needed basis.
- Provide after-hours support as needed.
- Participate in and lead quality assurance reviews.
- Define and recommend BI reporting standards, processes and technologies.
- Support technology evaluations and proof-of-concepts of reporting solutions.
- Support the installation and patching of reporting environments.
Qualifications & Skill Requirements
- Bachelor’s degree in computer science / computer information systems or related field or extensive applicable experience (master’s degree preferred)
- A relevant number of years of experience working with Microsoft Dynamics 365 Finance Operations and Project Operations
- A relevant number of years’ experience working with Microsoft Power BI
- A relevant number of years’ experience working with enterprise data warehouse / BI projects.
- A relevant number of years’ experience working with Data Analysis Expressions (DAX)
- Extensive experience with SQL
- Experience with Data Verse
- Data Lake Experience
Following Tools Experience:
- Microsoft Power BI
- Synapse
- Paginated Report Builder
- Power Platform
KBR Company Information
When you become part of the KBR team, your opportunities are endless. Through collaboration with our customers, we’re defining tomorrow’s challenges, then providing the solutions and services to overcome those challenges, always maintaining our commitment to total safety and reliability.
At KBR, we partner with government and industry clients to provide purposeful and comprehensive solutions with an emphasis on efficiency and safety. With a full portfolio of services, proprietary technologies and expertise, our employees are ready to handle projects and missions throughout their entire lifecycle, from planning and design to sustainability and maintenance. Whether at the bottom of the ocean or in outer space, our clients trust us to deliver the impossible on a daily basis.
Working at KBR means being rewarded for your contributions. In addition to competitive benefits and professional development, our people are empowered to use all their potential, creating meaningful change for themselves and our clients. We attract the best minds in the world because our expertise thrives on creativity, resourcefulness and collaboration. That is how we supply our clients with cutting-edge solutions and services.
As the needs of the world change, we’re ready to respond and guide the way forward with strategic, sustainable, and technological advancements grounded in more than a century of practical application and execution.
KBR is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, disability, sex, sexual orientation, gender identity or expression, age, national origin, veteran status, genetic information, union status and/or beliefs, or any other characteristic protected by federal, state, or local law.
